public JsonResult CreateMasterSetting(MasterSettingModel objSettingModel) { List <MasterSettingModel> MasterSettingModellist = new List <MasterSettingModel>(); MasterSettingModellist.Add(objSettingModel); ListtoDataTableConverter converter = new ListtoDataTableConverter(); DataTable dt = new DataTable(); dt = converter.ToDataTable(MasterSettingModellist); homeModel hm = new homeModel(); string res = ""; try { res = admin_layer.CreateMasterSetting(dt); string[] response = res.Split(','); if (response[0] == "Success") { hm.SuccessMsg = response[1]; } else if (response[0] == "Error") { hm.ErrorMsg = response[1]; } } catch (Exception ex) { hm.ErrorMsg = ex.Message; } return(Json(hm, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Insert or Update MasterSetting /// </summary> /// <param name="objMasterSettingModel"></param> /// <returns></returns> public MasterSettingModel InsertUpdateMasterSetting(MasterSettingModel objMasterSettingModel) { try { objMasterSettingModel.VatTax = objMasterSettingModel.VatTax.ToString().Trim(); int ErrorCode = 0; string ErrorMessage = ""; SqlParameter pErrorCode = new SqlParameter("@ErrorCode", ErrorCode); pErrorCode.Direction = ParameterDirection.Output; SqlParameter pErrorMessage = new SqlParameter("@ErrorMessage", ErrorMessage); pErrorMessage.Direction = ParameterDirection.Output; SqlParameter[] parmList = { new SqlParameter("@MasterSettingID", objMasterSettingModel.MasterSettingID) , new SqlParameter("@MasterSettingText", objMasterSettingModel.VatTax) , new SqlParameter("@IsActive", objMasterSettingModel.IsActive) , new SqlParameter("@CreatedBy", objMasterSettingModel.CreatedBy) , pErrorCode , pErrorMessage }; //If MasterSettingId is 0 Than Insert MasterSetting else Update MasterSetting SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.Admin_InsertUpdateMasterSetting, parmList); //set error code and message objMasterSettingModel.ErrorCode = Convert.ToInt32(pErrorCode.Value); objMasterSettingModel.Message = Convert.ToString(pErrorMessage.Value); return(objMasterSettingModel); } catch (Exception ex) { throw ex; } }
/// <summary> /// Get MasterSetting By Id /// </summary> /// <param name="MasterSettingId"></param> /// <returns>MasterSetting Model</returns> public MasterSettingModel GetMasterSettingById(int MasterSettingId) { //Call GetMasterSettingBYId method of dataLayer which will return Datatable. DataTable dt = objDLMasterSetting.GetMasterSettingById(MasterSettingId); MasterSettingModel objMasterSettingModel = new MasterSettingModel(); // if datatable has row than set object parameters if (dt.Rows.Count > 0) { objMasterSettingModel = GetDataRowToEntity <MasterSettingModel>(dt.Rows[0]); } return(objMasterSettingModel); }
public ActionResult SaveMasterSetting(MasterSettingModel objMasterSettingModel) { try { objMasterSettingModel.IsActive = true; objMasterSettingModel.CreatedBy = LoggedInUserID; //Insert or Update MasterSetting serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.MasterSetting + "/InsertUpdateMasterSetting", objMasterSettingModel); objMasterSettingModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <MasterSettingModel>().Result : null; //if error code is 0 means MasterSetting saved successfully if (Convert.ToInt32(objMasterSettingModel.ErrorCode) == 0) { // Set success message TempData["SucessMessage"] = "MasterSetting Saved Successfully"; return(RedirectToAction("Index", "Home")); } else if (Convert.ToInt32(objMasterSettingModel.ErrorCode) == 52) { //If Errorcode is 52 means MasterSetting Name is duplicate set duplicate MasterSetting error message. objMasterSettingModel.Message = "MasterSetting Duplicate not allowed"; objMasterSettingModel.MessageType = CommonUtils.MessageType.Error.ToString().ToLower(); } else { //set Error Message if error code is greater than 0 but not 52 (duplicate) objMasterSettingModel.Message = "Error while adding record"; objMasterSettingModel.MessageType = CommonUtils.MessageType.Error.ToString().ToLower(); } } catch (Exception ex) { ErrorLog(ex, "MasterSetting", "SaveMasterSetting POST"); } return(RedirectToAction("Index", "Home")); }
public ActionResult SaveMasterSetting(string prm = "") { MasterSettingModel objMasterSettingModel = new MasterSettingModel(); try { //if prm(Paramter) is empty means Add condition else edit condition if (!String.IsNullOrEmpty(prm)) { int MasterSettingId; //decrypt parameter and set in MasterSettingId variable int.TryParse(CommonUtils.Decrypt(prm), out MasterSettingId); //Get MasterSetting detail by MasterSetting Id serviceResponse = objUtilityWeb.GetAsync(WebApiURL.MasterSetting + "/GetMasterSettingById?MasterSettingId=" + MasterSettingId.ToString()); objMasterSettingModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <MasterSettingModel>().Result : null; } } catch (Exception ex) { ErrorLog(ex, "MasterSetting", "SaveMasterSetting Get"); } return(View("SaveMasterSetting", objMasterSettingModel)); }
public MasterSettingModel InsertUpdateMasterSetting(MasterSettingModel objMasterSettingModel) { return(objBLMasterSetting.InsertUpdateMasterSetting(objMasterSettingModel)); }
/// <summary> /// Insert or Update MasterSetting /// </summary> /// <param name="objMasterSettingModel">object of MasterSetting Model</param> /// <param name="ErrorCode"></param> /// <param name="ErrorMessage"></param> /// <returns></returns> public MasterSettingModel InsertUpdateMasterSetting(MasterSettingModel objMasterSettingModel) { //call InsertUpdateMasterSetting Method of dataLayer and return MasterSettingModel return(objDLMasterSetting.InsertUpdateMasterSetting(objMasterSettingModel)); }