public ActionResult UserDetails(string userId) { var rolesList = _context.Roles.ToList(); List <SelectListItem> roles = new List <SelectListItem>(); foreach (var role in rolesList) { roles.Add(new SelectListItem { Text = role.Name, Value = role.Id }); } var userWithRoles = (from user in _context.Users from userRole in user.Roles join role in _context.Roles on userRole.RoleId equals role.Id where user.Id == userId select new AdminUserDetailsViewModel() { userId = user.Id, userName = user.UserName, email = user.Email, RoleId = role.Id, }).Single(); AdminUserDetailsViewModel userDetails = new AdminUserDetailsViewModel(); userDetails = userWithRoles; userDetails.RoleList = roles; return(View(userDetails)); }
public ActionResult UpdateUserRole(/*string userId, string roleId*/ AdminUserDetailsViewModel userDetails) { string query = String.Format(@"UPDATE aspnetuserroles SET RoleId='{0}' WHERE UserId LIKE '{1}'", userDetails.RoleId, userDetails.userId); MySqlConnection conn = new MySqlConnection("SERVER=localhost;DATABASE=rentalisv2;UID=root;PASSWORD=;"); try { using (MySqlCommand cmdDatabase = new MySqlCommand(query, conn)) { conn.Open(); cmdDatabase.ExecuteNonQuery(); return(RedirectToAction("Users")); } } catch { return(HttpNotFound()); } }
public async Task <IActionResult> Details(int?id) { if (id == null) { return(NotFound()); } var user = await userService.GetByIDAsync((int)id); if (user == null) { return(NotFound()); } AdminUserDetailsViewModel viewModel = new AdminUserDetailsViewModel { User = user, UserRole = await userRoleService.GetByIDAsync(user.UserRoleID), UserStatus = await userStatusService.GetByIDAsync(user.UserStatusID) }; return(View(viewModel)); }