public ActionResult DeleteRoleForUser() { var objvm = new AssignRoleVM(); var lirole = new List<SelectListItem> {new SelectListItem {Text = "Select", Value = "0"}}; lirole.AddRange(Roles.GetAllRoles().Select(item => new SelectListItem {Text = item, Value = item})); objvm.RolesList = lirole; using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["TechMixtureConnection"].ToString())) { var userlist = con.Query("SELECT * FROM Users").ToList(); var listuser = new List<SelectListItem> {new SelectListItem {Text = "Select", Value = "0"}}; listuser.AddRange(userlist.Select(item => new SelectListItem {Text = item.UserName, Value = item.UserName})); objvm.Userlist = listuser; } return View(objvm); }
public ActionResult RoleAddToUser(AssignRoleVM objvm) { if (objvm.RoleName == "0") { ModelState.AddModelError("RoleName", "Please select RoleName"); } if (objvm.UserName == "0") { ModelState.AddModelError("UserName", "Please select Username"); } if (ModelState.IsValid) { if (Roles.IsUserInRole(objvm.UserName, objvm.RoleName)) { ViewBag.ResultMessage = "This user already has the role specified !"; } else { Roles.AddUserToRole(objvm.UserName, objvm.RoleName); ViewBag.ResultMessage = "Username added to the role successfully !"; } var lirole = new List<SelectListItem> {new SelectListItem {Text = "Select", Value = "0"}}; lirole.AddRange(Roles.GetAllRoles().Select(item => new SelectListItem {Text = item, Value = item})); objvm.RolesList = lirole; using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ToString())) { var userlist = con.Query("SELECT * FROM Users").ToList(); var listuser = new List<SelectListItem> {new SelectListItem {Text = "Select", Value = "0"}}; listuser.AddRange( userlist.Select(item => new SelectListItem {Text = item.UserName, Value = item.UserName})); objvm.Userlist = listuser; } return View(objvm); } else { var lirole = new List<SelectListItem> {new SelectListItem {Text = "Select", Value = "0"}}; lirole.AddRange(Roles.GetAllRoles().Select(item => new SelectListItem {Text = item, Value = item})); objvm.RolesList = lirole; using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ToString())) { var userlist = con.Query("SELECT * FROM Users").ToList(); var listuser = new List<SelectListItem> {new SelectListItem {Text = "Select", Value = "0"}}; listuser.AddRange( userlist.Select(item => new SelectListItem {Text = item.UserName, Value = item.UserName})); objvm.Userlist = listuser; } ModelState.AddModelError("Error", "Please enter Username and Password"); } return View(objvm); }