public void AddRole(string aspNetUserId, string roleName) { LMSUserUpdateRequest user = new LMSUserUpdateRequest(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { var cmd = new SqlCommand("AspNetUserAddRole", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserId", aspNetUserId); cmd.Parameters.AddWithValue("@Name", roleName); cn.Open(); cmd.ExecuteNonQuery(); } }
public void UpdateRoles(LMSUserUpdateRequest request) { using (var transactionScope = new System.Transactions.TransactionScope()) { _lmsRoleRepository.RemoveRoles(request.ID); foreach (var role in request.RoleNames) { _lmsRoleRepository.AddRole(request.ID, role); } transactionScope.Complete(); } }
public ActionResult GetUserDetails(UserDetailsToEditVM user) { var request = new LMSUserUpdateRequest(); request.UserID = user.UserDetailsToEdit.UserID; request.ID = user.UserDetailsToEdit.ID; request.FirstName = user.UserDetailsToEdit.FirstName; request.LastName = user.UserDetailsToEdit.LastName; request.GradeLevelID = user.UserDetailsToEdit.GradeLevelID; foreach (var roleSelection in user.SelectedRoles) { if (roleSelection.CheckedStatus) { request.RoleNames.Add(roleSelection.RoleName); } } _lmsRoleManager.UpdateRoles(request); _lmsUserManager.UpdateUserDetails(request); return RedirectToAction("Index", "Admin"); }
public List<LMSUserUpdateRequest> UserGetAllRoles(int UserID) { List<LMSUserUpdateRequest> users = new List<LMSUserUpdateRequest>(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { var cmd = new SqlCommand("UserViewDetails", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserID", UserID); cn.Open(); using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { var user = new LMSUserUpdateRequest(); user.UserID = (int) dr["UserID"]; user.ID = dr["ID"].ToString(); user.FirstName = dr["FirstName"].ToString(); user.LastName = dr["LastName"].ToString(); user.UserId = dr["LastName"].ToString(); user.RoleID = dr["RoleId"].ToString(); user.RoleName = dr["Name"].ToString(); users.Add(user); } } } return users; }
public LmsUser UpdateUserDetails(LMSUserUpdateRequest user) { LmsUser user1 = new LmsUser(); return user1; }
public LmsUser UpdateUserDetails(LMSUserUpdateRequest user) { LmsUser user1 = new LmsUser(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { var cmd = new SqlCommand("UserUpdateDetails", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserID", user.UserID); cmd.Parameters.AddWithValue("@ID", user.ID); cmd.Parameters.AddWithValue("@FirstName", user.FirstName); cmd.Parameters.AddWithValue("@LastName", user.LastName); cmd.Parameters.AddWithValue("@GradeLevelID", user.GradeLevelID); cn.Open(); cmd.ExecuteNonQuery(); } return user1; }
//public DataResponse<LmsUser> UpdateUserDetails(LmsUser user) public DataResponse<LmsUser> UpdateUserDetails(LMSUserUpdateRequest user) { var response = new DataResponse<LmsUser>(); try { response.Data = _lmsUserRepository.UpdateUserDetails(user); response.Success = true; } catch (Exception ex) { response.Message = "User not updated"; } return response; }