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));
}
