protected void Page_Load(object sender, EventArgs e) { var AllUser = from p in db.Users select p; var q = (from p in usm.aspnet_Roles where p.RoleName == "Professor" select p.RoleId).First(); var h = (from p in usm.aspnet_Roles where p.RoleName == "Header" select p.RoleId).First(); var d = (from p in usm.aspnet_Roles where p.RoleName == "Dean" select p.RoleId).First(); foreach (var item in AllUser) { var uName = (from p in usm.aspnet_Users where p.UserName == item.UserName select p.UserId).First(); try { var inRole = (from p in usm.aspnet_UsersInRoles where p.UserId == uName select p).First(); } catch (Exception) { aspnet_UsersInRole ro = new aspnet_UsersInRole(); if (item.UserLevelId == 2) { ro.RoleId = q; } else if (item.UserLevelId == 1) { ro.RoleId = h; } else { ro.RoleId = d; } ro.UserId = uName; usm.aspnet_UsersInRoles.InsertOnSubmit(ro); usm.SubmitChanges(); } } }
protected void RegisterUser_CreatedUser(object sender, EventArgs e) { FormsAuthentication.SetAuthCookie(RegisterUser.UserName, createPersistentCookie: false); string email = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("Email")).Text; int dept = Convert.ToInt32(((DropDownList)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("Dept")).SelectedValue); int prefix = Convert.ToInt32(((DropDownList)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("Prefix")).SelectedValue); string firstName = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("FirstName")).Text; string lastName = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("LastName")).Text; User x = new User(); x.UserName = RegisterUser.UserName; x.Email = email; x.DeptId = dept; x.PrefixId = prefix; x.FirstName = firstName; x.LastName = lastName; x.StatusId = 0; x.UserLevelId = 2; db.Users.InsertOnSubmit(x); db.SubmitChanges(); var q = (from p in usm.aspnet_Roles where p.RoleName == "Professor" select p.RoleId).First(); var uName = (from p in usm.aspnet_Users where p.UserName == RegisterUser.UserName select p.UserId).First(); aspnet_UsersInRole ro = new aspnet_UsersInRole(); ro.RoleId = q; ro.UserId = uName; usm.aspnet_UsersInRoles.InsertOnSubmit(ro); usm.SubmitChanges(); string continueUrl = RegisterUser.ContinueDestinationPageUrl; if (!OpenAuth.IsLocalUrl(continueUrl)) { continueUrl = "~/"; } Response.Redirect(continueUrl); }
private void detach_aspnet_UsersInRoles(aspnet_UsersInRole entity) { this.SendPropertyChanging(); entity.aspnet_Role = null; }
partial void Deleteaspnet_UsersInRole(aspnet_UsersInRole instance);
partial void Updateaspnet_UsersInRole(aspnet_UsersInRole instance);
partial void Insertaspnet_UsersInRole(aspnet_UsersInRole instance);
private void attach_aspnet_UsersInRoles(aspnet_UsersInRole entity) { this.SendPropertyChanging(); entity.aspnet_User = this; }