public ActionResult AdminProfile(UsermasterEditView usermasterEditView) { try { if (ModelState.IsValid) { var result = _iProfile.UpdateUserMasterDetails(Convert.ToInt64(_sessionHandler.UserId), usermasterEditView); if (result != 0) { TempData["MessageProfileUpdate"] = CommonMessages.UserDetailsUpdateSuccessMessages; return(RedirectToAction("AdminProfile")); } else { return(View(usermasterEditView)); } } else { return(View(usermasterEditView)); } } catch (Exception) { throw; } }
public int UpdateUserMasterDetails(long userId, UsermasterEditView usermasterEditView) { try { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DatabaseConnection"].ConnectionString)) { con.Open(); SqlTransaction transaction = con.BeginTransaction(); var param = new DynamicParameters(); param.Add("@UserId", userId); param.Add("@FirstName", usermasterEditView.FirstName); param.Add("@LastName", usermasterEditView.LastName); param.Add("@EmailId", usermasterEditView.EmailId); param.Add("@MobileNo", usermasterEditView.MobileNo); param.Add("@Gender", usermasterEditView.Gender); var result = con.Execute("Usp_Usermasters_UpdateUserMasterDetails", param, transaction, 0, CommandType.StoredProcedure); if (result > 0) { transaction.Commit(); return(result); } else { transaction.Rollback(); return(0); } } } catch (Exception) { throw; } }