About that scenario (Many branches,many mangers)

Question

Greeting all I had build an asp.net webform project I greated project roles by ASP.Net configuration: AS below: -Manger roles (containe one user) -Brunch Role(has 3 users, beacuse I created three branches, each branch it got one mangers. -Editor Role . -Kitchen role. you can see below my hand diagram, which explain what i need. Here you can see a two created database First (Asp.net database) Second (my project creted database) If example my compny it got three branches , each manger will login to comany site by using (login.aspx)page this page redirerct user depends on his roles like code below: { Login chocLogin = (Login)sender; //Int32 Id; if (System.Web.Security.Roles.IsUserInRole(chocLogin.UserName, "Manager" )) { Response.Redirect( "~/admin/Default.aspx" ); } if (System.Web.Security.Roles.IsUserInRole(chocLogin.UserName, "Branch" )) { Response.Redirect( "~/branch/Default.aspx" ); } } This point here so hard for me, taked long time in thinking to resolve it. how to show message (welcome"username" depends on branch code). Thanks if you catch my point.

Jignesh Kumar · Answer

Hey, You can store username && branch code in session and retrive same session in default page. How to set session value and retrive in another page. Take reference from below links https://www.c-sharpcorner.com/UploadFile/009464/how-to-make-a-login-form-using-session-in-Asp-Net-C-Sharp/ https://www.aspforums.net/Threads/974360/Solved-Display-Username-after-Login-using-Session-variable-in-ASPNet/

Aktham Mahmoud · Answer

I have query why you want to use two seperate databases ? Actually I depends on ASP.net configuration as you can see from photo attached there's two databases so I depends on it. I don't know if thes method correct or no.. thanks

Jignesh Kumar · Answer

Hi, Yes you can manage by your connection string to connect differnt database but, I have query why you want to use two seperate databases ? You can create seperate connection string and get connection string which you need as per your requrement. Based on condition you can change your connection string. https://stackoverflow.com/questions/46029189/change-connection-string-on-button-click-for-that-specific-user

Aktham Mahmoud · Answer

Just I need to explain about this point: can I work with multiple databases Default asp.net data base (for Roles, users) and my own databast (products, categories .etc.) That's what I need to explain about it. thanks

Aktham Mahmoud · Answer

Thanks I'll try