public ActionResult ManageRoles() { var users = (from user in dbContext.Users select user).ToList(); var model = new MenageRolesVM(); var usersFromDb = from u in dbContext.Users from ur in u.Roles.DefaultIfEmpty() join ro in dbContext.Roles.DefaultIfEmpty() on ur.RoleId equals ro.Id into newTable from r in newTable.DefaultIfEmpty() select new UserVM { Id = u.Id, Name = u.UserName, LockoutEnabled = u.LockoutEnabled, Banned = u.Banned, BannEndDate = u.BannEndDate, Rola = new RolaVM { Name = r.Name, Id = r.Id }, }; model.Users = usersFromDb.ToList(); return(View(model)); }
public ActionResult LockoutUser(string userId, bool lockout) { var result = UserManager.SetLockoutEnabled(userId, lockout); var model = new MenageRolesVM(); var usersFromDb = from u in dbContext.Users from ur in u.Roles.DefaultIfEmpty() join ro in dbContext.Roles.DefaultIfEmpty() on ur.RoleId equals ro.Id into newTable from r in newTable.DefaultIfEmpty() select new UserVM { Id = u.Id, Name = u.UserName, LockoutEnabled = u.LockoutEnabled, Rola = new RolaVM { Name = r.Name, Id = r.Id }, }; model.Users = usersFromDb.ToList(); return(View("ManageRoles", model)); }