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));
        }
Example #7
0
        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));
        }