public static bool SaveProfileDetails(MyProfileMDL user, int businessId, int userId) { try { using (DBSqlCommand cmd = new DBSqlCommand()) { cmd.AddParameters(userId, CommonConstants.UserId, System.Data.SqlDbType.Int); cmd.AddParameters(businessId, CommonConstants.BusinessID, System.Data.SqlDbType.Int); cmd.AddParameters(user.UserFirstName, CommonConstants.FirstName, System.Data.SqlDbType.VarChar); cmd.AddParameters(user.UserLastName, CommonConstants.LastName, System.Data.SqlDbType.VarChar); cmd.AddParameters(user.BusinessName, CommonConstants.BusinessName, System.Data.SqlDbType.VarChar); cmd.AddParameters(user.Email, CommonConstants.Email, System.Data.SqlDbType.VarChar); cmd.AddParameters(user.Fax, CommonConstants.BusinessFax, System.Data.SqlDbType.VarChar); cmd.AddParameters(user.AddressLine1, CommonConstants.BusinessAddress, System.Data.SqlDbType.VarChar); cmd.AddParameters(user.City, CommonConstants.City, System.Data.SqlDbType.VarChar); cmd.AddParameters(1, CommonConstants.CityId, System.Data.SqlDbType.Int); cmd.AddParameters(user.StateId, CommonConstants.StateId, System.Data.SqlDbType.Int); cmd.AddParameters(user.CountryId, CommonConstants.CountryId, System.Data.SqlDbType.Int); //cmd.AddParameters(user.LogMeOut, "@LogMeOut", System.Data.SqlDbType.Int); cmd.AddParameters(user.LogMeOutId, "@LogMeOutId", System.Data.SqlDbType.Int); cmd.AddParameters(user.Licences, "@Licences", System.Data.SqlDbType.Int); cmd.ExecuteNonQuery(SqlProcedures.Update_MyAccountDetails); return(true); } } catch (Exception ex) { throw new ArgumentException("Exception in SaveProfileDetails. Exception :" + ex.Message); } }
public ActionResult MyProfile(MyProfileMDL users) { string Message = string.Empty; try { bool saveFlag = false; //int userId = 16; saveFlag = BAL.Users.SaveProfileDetails(users, BusinessId, UserId); var user = BAL.Users.GetProfileDetails(UserId, BusinessId); ViewBag.RenewalDate = user.EndDate.ToPreferenceDateTime((string)ViewBag.PreferenceDt); ViewBag.LogmeOut = new SelectList(BAL.Users.Get_LogmeOut(), "key", "value"); ViewBag.Success = "SavedSuccessfully"; // MyPorfileImage(UploadImage); ViewBag.UserId = UserId; if (saveFlag) { Message = "Success"; } else { Message = "Failed"; } return(Json(Message, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ViewBag.Success = "Errorwhilesavingyourprofile"; ErrorSignal.FromCurrentContext().Raise(ex); } ViewBag.LogmeOut = new SelectList(BAL.Users.Get_LogmeOut(), "key", "value"); return(View("MyProfile", users)); }