public async Task <IActionResult> Details(string returnUrl = null) { // get user var user = await _userManager.GetUserAsync(User); // get role var role = _userManager.GetRolesAsync(user).ToAsyncEnumerable(); // if user not found if (user == null) { return(NotFound($"Unable to load user with ID '{_userManager.GetUserId(User)}'.")); } // assign user properties to EditDetails Model EditUserDetails edit = _mapper.Map <EditUserDetails>(user); if (user.Address != null) { string[] address = user.Address.Split(","); edit.FLAddress = address[0]; edit.SLAddress = address[1]; edit.PostCode = address[2]; } if (user.SavedCustomerCard != null) { edit.SavedCardId = user.SavedCustomerCard; } edit.RemoveSavedCard = false; ViewData["ReturnUrl"] = returnUrl; return(View(edit)); }
/// <summary> /// /// </summary> /// <param name="userDetails"></param> /// <returns></returns> public Message UpdateUserDetails(EditUserDetails userDetails) { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter() { ParameterName = "@UserId", Value = userDetails.UserId }); param.Add(new SqlParameter() { ParameterName = "@Email", Value = userDetails.Email }); param.Add(new SqlParameter() { ParameterName = "@Fname", Value = userDetails.FName }); param.Add(new SqlParameter() { ParameterName = "@LName", Value = userDetails.LName }); param.Add(new SqlParameter() { ParameterName = "@Mobile", Value = userDetails.Mobile }); param.Add(new SqlParameter() { ParameterName = "@RoleId", Value = userDetails.RoleId }); param.Add(new SqlParameter() { ParameterName = "@ModifiedBy", Value = userDetails.ModifiedBy }); param.Add(new SqlParameter() { ParameterName = "@MessageCode", Value = userDetails.MessageCode, Direction = ParameterDirection.Output, Size = 10 }); param.Add(new SqlParameter() { ParameterName = "@MessageDescription", Value = userDetails.MessageDescription, Direction = ParameterDirection.Output, Size = 100 }); List <SqlParameter> retParam = new List <SqlParameter>(); int isSuccessful = Update(param, StoredProcedureName.UPDATE_ADMIN_USER_DETAILS, out retParam); return(new Message { MessageCode = (bool)retParam.ElementAtOrDefault(0).Value, MessageDescription = retParam.ElementAtOrDefault(1).Value.ToStringSafe() }); }
public void EditUser(User user, EditUserDetails details) { using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("EditUser", cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", user.Id); cmd.Parameters.AddWithValue("@FullName", user.FullName); cmd.Parameters.AddWithValue("@FirstName", user.FirstName); cmd.Parameters.AddWithValue("@LastName", user.LastName); cmd.Parameters.AddWithValue("@Email", user.Email); cmd.Parameters.AddWithValue("@UserName", user.UserName); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); SqlCommand cmd2 = new SqlCommand("GetRoleID", cn); cmd2.CommandType = CommandType.StoredProcedure; cmd2.Parameters.AddWithValue("@Role", details.Role); cn.Open(); using (SqlDataReader dr2 = cmd2.ExecuteReader()) { if (dr2.Read()) { details.RoleID = dr2["Id"].ToString(); } } cn.Close(); SqlCommand cmd3 = new SqlCommand("UpdateUserRole", cn); cmd3.CommandType = CommandType.StoredProcedure; cmd3.Parameters.AddWithValue("@UserID", user.Id); cmd3.Parameters.AddWithValue("@RoleID", details.RoleID); cn.Open(); cmd3.ExecuteNonQuery(); } }
public EditUserDetails GetByID(string id) { EditUserDetails details = new EditUserDetails(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("GetUserByID", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", id); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { details.FirstName = dr["FirstName"].ToString(); details.LastName = dr["LastName"].ToString(); details.Email = dr["Email"].ToString(); details.Role = dr["Role"].ToString(); } } } return(details); }
public async Task <IActionResult> Details(EditUserDetails model, string returnUrl = null) { // find the user to be updated var user = await _userManager.FindByIdAsync(model.Id); // if not found, send to not gound page if (user == null) { return(NotFound($"Unable to load user with ID '{_userManager.GetUserId(User)}'.")); } // check if model valid if (ModelState.IsValid) { try { // update user details user.AgencyOrClubName = model.AgencyOrClubName; user.DateOfBirth = model.DateOfBirth; user.FirstName = model.FirstName; user.Email = model.Email; user.LastName = model.LastName; user.IdNumber = model.IdNumber; user.UserName = model.Email; if (model.PhoneNumber != null) { user.PhoneNumber = model.PhoneNumber; } user.Address = model.FLAddress + "," + model.SLAddress + "," + model.PostCode; if (model.RemoveSavedCard == true) { user.SavedCustomerCard = null; } //save details await _userManager.UpdateAsync(user); // refresh sign in session await _signInManager.RefreshSignInAsync(user); ViewData["ReturnUrl"] = returnUrl; TempData["UserNotifier"] = new UserNotifier() { CssFormat = "alert-success", MessageType = "Success!", Content = "Details successfully update" }; return(View(model)); } catch (Exception e) { // if exception occurs, let user know TempData["UserNotifier"] = new UserNotifier() { CssFormat = "alert-error", MessageType = "Error!", Content = "Could not update your details,please try again later" }; return(View(model)); } } return(View(model)); }