public async Task <IActionResult> Create([Required] ApplicationUserRoleViewModel obj)
{
if (ModelState.IsValid)
{
ApplicationUser user = await userManager.FindByNameAsync(obj.UserName);
IList <string> listRoles = await userManager.GetRolesAsync(user);
if (!await userManager.IsInRoleAsync(user, obj.RoleName))
{
IdentityResult result = await userManager.AddToRoleAsync(user, obj.RoleName);
if (result.Succeeded)
{
return(RedirectToAction("Index"));
}
else
{
AddErrors(result);
}
}
else
{
ModelState.AddModelError("", "User already assigned to this role");
}
}
return(View(obj));
}
// GET: ApplicationUsers
public ActionResult Index()
{
var viewModel = new ApplicationUserRoleViewModel();
viewModel.AppUsers = db.Users.OrderBy(u => u.LastName).ToList();
viewModel.UserRoles = db.Roles.OrderBy(r => r.Name).ToList();
return(View(viewModel));
}
public async Task <ActionResult> AddUserToRole(ApplicationUserRoleViewModel model)
{
var dbCon = new ApplicationDbContext();
var role = dbCon.Roles.Find(model.RoleId);
if (role != null)
{
await _userManager.AddToRoleAsync(model.UserId, role.Name);
}
return(RedirectToAction("AddUserToRole"));
}
public async Task <ActionResult> AddUserToRole()
{
ApplicationUserRoleViewModel vm = new ApplicationUserRoleViewModel();
var Users = await db.Users.ToListAsync();
var roles = await db.Roles.ToListAsync();
ViewBag.UserId = new SelectList(Users, "Id", "UserName");
ViewBag.RoleId = new SelectList(roles, "Id", "Name");
return(View(vm));
}
public ActionResult AddUserToRole(ApplicationUserRoleViewModel model)
{
var role = db.Roles.Find(model.RoleId);
if (role != null)
{
//await UserManager.AddToRoleAsync(model.UserId, role.Name);
// SQL Insert into Inline query db.database.execute query
var query = "INSERT INTO ASPNetUserRoles (UserId, RoleId) VALUES (\'" + model.UserId + "\',\'" + role.Id + "\')";
try
{
db.Database.ExecuteSqlCommand(query);
db.SaveChanges();
TempData["SuccessMsg"] = "Assigned the role!";
}
catch (System.Data.SqlClient.SqlException)
{
TempData["ErrorMsg"] = "User already has role.";
}
return(RedirectToAction("viewUsers"));
}
return(RedirectToAction("AddUserToRole"));
}
