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));
}
