public ActionResult Create([Bind(Include = "UserName,Password,IsLockedOut,Comment,RoleId,ApplicationId")] aspnet_Membership aspnet_Membership) { if (ModelState.IsValid) { MembershipUser user = Membership.CreateUser ( aspnet_Membership.UserName, aspnet_Membership.Password ); db.SaveChanges(); user.Comment = aspnet_Membership.Comment.ToString(); aspnet_UsersInRoles addRoleToUser = new aspnet_UsersInRoles { UserId = (Guid)user.ProviderUserKey, RoleId = aspnet_Membership.RoleId }; db.aspnet_UsersInRoles.Add(addRoleToUser); db.SaveChanges(); return(RedirectToAction("Index")); } var roles = db.aspnet_Roles.ToList(); aspnet_Membership.UserRoles = roles.Select(role => new SelectListItem() { Selected = false, Text = role.RoleName, Value = role.RoleId.ToString() }).ToList(); aspnet_Membership.ApplicationId = db.aspnet_Applications.Where(a => a.ApplicationName == "Hubbard House Survey Analysis System").SingleOrDefault().ApplicationId; return(View(aspnet_Membership)); }
public ActionResult DeleteConfirmed(Guid?UserId, Guid?RoleId) { aspnet_UsersInRoles aspnet_usersinroles = db.aspnet_UsersInRoles.Where(usrl => usrl.UserId == UserId && usrl.RoleId == RoleId).FirstOrDefault <aspnet_UsersInRoles>(); db.aspnet_UsersInRoles.Remove(aspnet_usersinroles); db.SaveChanges(); return(RedirectToAction("Index")); }
// // GET: /aspnet_UsersInRolesAdmin/Details/5 public ActionResult Details(Guid?id) { aspnet_UsersInRoles aspnet_usersinroles = db.aspnet_UsersInRoles.Find(id); if (aspnet_usersinroles == null) { return(HttpNotFound()); } return(View(aspnet_usersinroles)); }
// // GET: /aspnet_UsersInRolesAdmin/Delete/5 public ActionResult Delete(Guid?UserId, Guid?RoleId) { aspnet_UsersInRoles aspnet_usersinroles = db.aspnet_UsersInRoles.Where(usrl => usrl.UserId == UserId && usrl.RoleId == RoleId).FirstOrDefault <aspnet_UsersInRoles>(); if (aspnet_usersinroles == null) { return(HttpNotFound()); } return(View(aspnet_usersinroles)); }
public ActionResult Edit(aspnet_UsersInRoles aspnet_usersinroles) { if (ModelState.IsValid) { db.Entry(aspnet_usersinroles).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aspnet_usersinroles)); }
public ActionResult Create(aspnet_UsersInRoles aspnet_usersinroles) { if (ModelState.IsValid) { //aspnet_usersinroles.UserId = Guid.NewGuid(); db.aspnet_UsersInRoles.Add(aspnet_usersinroles); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aspnet_usersinroles)); }
protected void gvUser_RowDeleting(object sender, GridViewDeleteEventArgs e) { string username = gvUser.Rows[e.RowIndex].Cells[1].Text; string query = "SELECT DISTINCT UserId FROM aspnet_Users WHERE UserName = '******'"; con = new SqlConnection(conStr); SqlDataAdapter adapter = new SqlDataAdapter(query, con); DataTable dt = new DataTable(); adapter.Fill(dt); //DataSet dataset = new DataSet(); //adapter.Fill(dataset); Guid userId = Guid.Parse(dt.Rows[0][0].ToString()); using (QuizEntities context = new QuizEntities()) { QHSEQuiz.Model.Hub hub = context.Hubs.Where(x => x.UserName == username).First(); context.Hubs.Remove(hub); //aspnet_Profile profile = context.aspnet_Profile.Where(x => x.PropertyValuesString == username).First(); //context.aspnet_Profile.Remove(profile); aspnet_Users user = context.aspnet_Users.Where(x => x.UserName == username).First(); context.aspnet_Users.Remove(user); aspnet_Membership mem = context.aspnet_Membership.Where(x => x.UserId == userId).First(); context.aspnet_Membership.Remove(mem); aspnet_UsersInRoles userInRole = context.aspnet_UsersInRoles.Where(x => x.UserId == userId).First(); context.aspnet_UsersInRoles.Remove(userInRole); context.SaveChanges(); Response.Redirect("~/Admin/ManageUsers.aspx"); } }
/// <summary> /// There are no comments for aspnet_UsersInRoles in the schema. /// </summary> public void AddToaspnet_UsersInRoles(aspnet_UsersInRoles aspnet_UsersInRoles) { base.AddObject("aspnet_UsersInRoles", aspnet_UsersInRoles); }
/// <summary> /// Create a new aspnet_UsersInRoles object. /// </summary> /// <param name="userId">Initial value of UserId.</param> /// <param name="roleId">Initial value of RoleId.</param> public static aspnet_UsersInRoles Createaspnet_UsersInRoles(string userId, string roleId) { aspnet_UsersInRoles aspnet_UsersInRoles = new aspnet_UsersInRoles(); aspnet_UsersInRoles.UserId = userId; aspnet_UsersInRoles.RoleId = roleId; return aspnet_UsersInRoles; }
public ActionResult Edit([Bind(Include = "UserName,Password,PasswordFormat,PasswordSalt,CreateDate,ApplicationId,UserId,LastLoginDate,LoweredEmail,passwordChange,IsApproved,IsLockedOut,Comment,LastLockoutDate,FailedPasswordAttemptCount,FailedPasswordAttemptWindowStart,FailedPasswordAnswerAttemptCount,FailedPasswordAnswerAttemptWindowStart,RoleId, LastPasswordChangedDate")] aspnet_Membership aspnet_Membership) { if (ModelState.IsValid) { if (!String.IsNullOrWhiteSpace(aspnet_Membership.passwordChange)) { var member = Membership.GetUser(aspnet_Membership.UserName.ToString()); if (member != null) { var passwordReset = Membership.EnablePasswordReset; var result = member.ChangePassword(member.ResetPassword(), aspnet_Membership.passwordChange); aspnet_Membership.LastPasswordChangedDate = DateTime.Now; } else { ModelState.AddModelError(string.Empty, "Error occured updating user password."); } } //If Role selected in dropdown, Add or Change Users var user = db.aspnet_Users.Where(a => a.UserId == aspnet_Membership.UserId).FirstOrDefault(); if (aspnet_Membership.RoleId != Guid.Empty) { var userCurrentRole = db.aspnet_UsersInRoles.Where(e => e.UserId == user.UserId).FirstOrDefault(); var addRole = db.aspnet_Roles.Where(e => e.RoleId == aspnet_Membership.RoleId).FirstOrDefault(); var application = db.aspnet_Applications.Where(p => p.ApplicationId == user.ApplicationId).FirstOrDefault(); if (addRole != null) { aspnet_UsersInRoles addRoleToUser = new aspnet_UsersInRoles { UserId = user.UserId, RoleId = addRole.RoleId }; //If the User already had a role and they do not already have the role selected if (userCurrentRole == null) { db.aspnet_UsersInRoles.Add(addRoleToUser); } else { if (!db.aspnet_UsersInRoles.Any(r => r.RoleId == addRoleToUser.RoleId && r.UserId == addRoleToUser.UserId)) { var userCurrentRoleName = (db.aspnet_Roles.Where(e => e.RoleId == userCurrentRole.RoleId).FirstOrDefault()).RoleName; if (userCurrentRole.RoleId != aspnet_Membership.RoleId) { db.aspnet_UsersInRoles.Remove(userCurrentRole); db.aspnet_UsersInRoles.Add(addRoleToUser); } } } } } db.Entry(aspnet_Membership).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } var roles = db.aspnet_Roles.ToList(); aspnet_Membership.UserRoles = roles.Select(role => new SelectListItem() { Selected = false, Text = role.RoleName, Value = role.RoleId.ToString() }).ToList(); aspnet_Membership.ApplicationId = db.aspnet_Applications.Where(a => a.ApplicationName == "Hubbard House Survey Analysis System").SingleOrDefault().ApplicationId; return(View(aspnet_Membership)); }