public static UserInformation UpdateRoles(string ID, bool RoleCanView, bool RoleCanEdit, bool RoleAdmin) { UserInformation user = new UserInformation(); bool canview = false; bool canedit = false; bool admin = false; if(RoleAdmin == true) { canview = true; canedit = true; admin = true; } else if(RoleCanEdit == true && RoleAdmin == false) { canedit = true; canview = true; } else if(RoleCanView == true && RoleCanEdit == false && RoleAdmin == false) { canview = true; } user.Userid = ID; user.RoleAdmin = admin; user.RoleCanView = canview; user.RoleCanEdit = canedit; return user; }
public static UserInformation Details(string ID) { string connectionstring = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; UserInformation user = new UserInformation(); SqlConnection dbconnection = new SqlConnection(connectionstring); SqlCommand cmd = new SqlCommand(); cmd.Parameters.AddWithValue("@Userid", ID); SqlDataReader reader; cmd.CommandText = "GetUserRoles"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = dbconnection; dbconnection.Open(); reader = cmd.ExecuteReader(); if (reader.Read()) { user.RoleCanView = reader.GetBoolean(0); user.RoleCanEdit = reader.GetBoolean(1); user.RoleAdmin = reader.GetBoolean(2); } dbconnection.Dispose(); dbconnection.Close(); return user; }
public ActionResult Edit(UserInformation user) { if (ModelState.IsValid) { //UserManipulation.UpdateRoles(user.Userid, user.RoleCanView, user.RoleCanEdit, user.RoleAdmin); var AppUser = new ApplicationUser() { Id = user.Userid }; var userroles = new UserInformation(); userroles = UserManipulation.UpdateRoles(user.Userid, user.RoleCanView, user.RoleCanEdit, user.RoleAdmin); if (userroles.RoleAdmin == true) { UserManager.AddToRole(AppUser.Id, "Admin"); } if(userroles.RoleCanEdit == true) { UserManager.AddToRole(AppUser.Id, "CanEdit"); } if (userroles.RoleCanView == true) { UserManager.AddToRole(AppUser.Id, "CanView"); } if (userroles.RoleAdmin == false) { UserManager.RemoveFromRole(AppUser.Id, "Admin"); } if (userroles.RoleCanEdit == false) { UserManager.RemoveFromRole(AppUser.Id, "CanEdit"); } if (userroles.RoleCanView == false) { UserManager.RemoveFromRole(AppUser.Id, "CanView"); } return RedirectToAction("Index"); } return RedirectToAction("Index"); }