redirect to another page according to user in asp.net Entity framewrk

Question

I am new to entity framework...i want redirect to another page according to user role in asp.net Entity Framework... and role based authentication is beyond limits. i want do it another way

Laxmidhar Sahoo · Answer

hi The value of dropdown as admin or not if if cluse .I edited my post .Please look the before post Thanks and regards

Guest User · Answer

hi Laxmidhar Sahoo My code will look like this.. but on the select of "user" as well as "admin".. It goes to next page..i want it go to next page when i select "admin" only.. public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load( object sender, EventArgs e) { bindUsingEntityFrameWork(); } public void bindUsingEntityFrameWork() { using (WallpaperEntities4 context = new WallpaperEntities4()) { ddlTest3.DataSource = (from r in context.Users select new { Id = r.Id, UserName = r.UserName, User_Role = r.User_Role,Password = r.Password }).ToList(); ddlTest3.DataTextField = "User_Role" ; ddlTest3.DataValueField = "Id" ; ddlTest3.DataBind(); ddlTest3.Items.Insert(0, new System.Web.UI.WebControls.ListItem( "Select Option" , "0" )); } } protected void Button1_Click( object sender, EventArgs e) { WallpaperEntities4 db = new WallpaperEntities4(); string sc = ddlTest3.SelectedItem.Value; int scl = Convert.ToInt32(sc); var query = (from r in db.Users select new { Id = r.Id, UserName = r.UserName, User_Role = r.User_Role, Password = r.Password }).ToList(); var lst = query.ToList(); ddlTest3.DataSource = lst; ddlTest3.DataTextField = "User_Role" ; ddlTest3.DataValueField = "Id" ; ddlTest3.DataBind(); Session[ "UserRole" ] = ddlTest3.SelectedValue; //if the page is in same directory Response.Redirect( "Admin.aspx" ); } protected void ddlTest3_SelectedIndexChanged( object sender, EventArgs e) { WallpaperEntities4 context = new WallpaperEntities4(); var ddlvalue = ddlTest3.SelectedItem.Value; var querycount = (from c in context.Users where c.User_Role == ddlvalue select c.User_Role).Count(); if (querycount > 0) Response.Redirect( "Admin.aspx" ); } }

Laxmidhar Sahoo · Answer

Hi protected void ddlTest3_SelectedIndexChanged( object sender, EventArgs e) { WallpaperEntities4 context = new WallpaperEntities4(); var ddlvalue = ddlTest3.SelectedItem.Value; if(ddlvalue == "Admin") { var querycount = (from c in context.Users where c.User_Role == ddlvalue select c.User_Role).count(); if (querycount > 0) Response.Redirect( "Admin.aspx" ); } } Thanks and regards

Guest User · Answer

hi Laxmidhar Sahoo. its only goes to next page when i select admin otherwise its show message "not authorized".. Can u please help me out

Laxmidhar Sahoo · Answer

Hi //This is for pageload dropdownbind if (!IsPostBack) { using (WallpaperEntities4 context = new WallpaperEntities4()) { ddlTest3.DataSource = (from r in context.Users select new { Id = r.Id,User_Role = r.User_Role }).ToList(); ddlTest3.DataTextField = "User_Role" ; ddlTest3.DataValueField = "Id" ; ddlTest3.DataBind(); ddlTest3.Items.Insert(0, new System.Web.UI.WebControls.ListItem( "Select Option" , "0" )); } } From which event you want to redirect You redirect from ddlTest3 SelectedIndexChanged event I think you neet to redirect rom sumbit button click event Store your data in session if need to take from current page to another page Session[ "UserRole" ] = ddlTest3.SelectedValue; //if the page is in same directory Response.Redirect( "Admin.aspx" ); Thanks and regards

Guest User · Answer

hi Laxmidhar Sahoo.. can u help me out

Guest User · Answer

class = "container main-section" > class = "row" > class = "col-md-4 col-sm-8 col-xs-12 col-md-offset-4 col-sm-offset-2 login-image-main text-center" > class = "row" > class = "col-md-12 col-sm-12 col-xs-12 user-image-section" > "img/businessman.png" /> class = "col-md-12 col-sm-12 col-xs-12 user-login-box" > class = "style1" > Image: "TxtImg" runat= "server" > Name: "TxtName" runat= "server" > "RequiredFieldValidator1" runat= "server" Style= "top:182px; left: 774px; position: absolute; height: 26px; width: 162px" ControlToValidate= "TxtName" ErrorMessage= "Name required**" font-size= "Small" ForeColor = "Red" > UserName: "TxtUserName" runat= "server" > "RequiredFieldValidator2" runat= "server" Style= "top: 224px; left: 774px; position: absolute; height: 26px; width: 162px" ControlToValidate= "TxtUserName" ErrorMessage= "Username required** " font-size= "Small" ForeColor= "Red" > EmailID: "TxtEmailID" runat= "server" > "RequiredFieldValidator3" runat= "server" Style= "top:271px; left: 774px; position: absolute; height: 26px; width: 162px" ControlToValidate= "TxtEmailID" ErrorMessage= "Valid EmailID required" font-size= "Small" ForeColor= "Red" > UserRole: "server" id= "ddlTest3" OnSelectedIndexChanged= "ddlTest3_SelectedIndexChanged" > UserTypeId: "TxtUserTypeId" runat= "server" > "RequiredFieldValidator4" runat= "server" Style= "top:321px; left: 774px; position: absolute; height: 26px; width: 162px" ControlToValidate= "TxtUserTypeId" ErrorMessage= "It contains 1-special character and 0-9 numbers required" font-size= "Small" ForeColor= "Red" > Password: "TxtPassword" runat= "server" TextMode= "Password" > "RequiredFieldValidator5" runat= "server" TextMode= "Password" Style= "top:321px; left: 774px; position: absolute; height: 26px; width: 162px" ControlToValidate= "TxtPassword" ErrorMessage= "It contains 1-special character and 0-9 numbers required" font-size= "Small" ForeColor= "Red" > "LblMesge" runat= "server" > "lblSelect" runat = "server" > "Button1" runat= "server" Text= "Login" OnClick= "Button1_Click" /> public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load( object sender, EventArgs e) { bindUsingEntityFrameWork(); } public void bindUsingEntityFrameWork() { using (WallpaperEntities4 context = new WallpaperEntities4()) { ddlTest3.DataSource = (from r in context.Users select r).ToList(); ddlTest3.DataTextField = "User_Role" ; ddlTest3.DataValueField = "Id" ; ddlTest3.DataBind(); } } protected void Button1_Click( object sender, EventArgs e) { Model.User newusermodel = new Model.User(); newusermodel.Image = TxtImg.ToString(); newusermodel.Name = TxtName.Text; newusermodel.UserName = TxtUserName.Text; newusermodel.EmailID = TxtEmailID.Text; newusermodel.User_Role = ddlTest3.SelectedValue.ToString(); newusermodel.Created_Date = DateTime.Now; newusermodel.User_Type_Id = Convert.ToInt32(TxtUserTypeId.Text); newusermodel.Password = TxtPassword.Text; using (WallpaperEntities4 context = new WallpaperEntities4()) { User user = new User(); { string str = TxtImg.FileName; TxtImg.PostedFile.SaveAs(Server.MapPath( "~/Upload/" + str)); string Image = "~/Upload/" + str.ToString(); string name = TxtImg.ToString(); user.Image = newusermodel.Image; user.Name = newusermodel.Name; user.UserName = newusermodel.UserName; user.EmailID = newusermodel.EmailID; user.Id = newusermodel.Id; user.User_Role = newusermodel.User_Role; user.Created_Date = newusermodel.Created_Date; user.User_Type_Id = newusermodel.User_Type_Id; user.Password = newusermodel.Password; } } } protected void ddlTest3_SelectedIndexChanged( object sender, EventArgs e) { WallpaperEntities4 context = new WallpaperEntities4(); string query = (from c in context.Users where c.User_Role == ddlTest3.SelectedValue select c.User_Role).FirstOrDefault(); Response.Redirect( "/Admin.aspx?UserRole=" +); } } }

Laxmidhar Sahoo · Answer

Hi Can display some code ? Thanks and regards