public ActionResult AddUpdate(int?id)
{
var model = new etblMasterTaxMap();
if (id.HasValue)
{
var dbModel = BL_tblMasterTaxMap.GetMasterTaxMapById(id.Value);
if (dbModel != null)
{
model = dbModel;
model.sStayFrom = string.Format("{0:dd/MM/yyyy}", dbModel.dtStayFrom);
model.sStayTo = string.Format("{0:dd/MM/yyyy}", dbModel.dtStayTo);
model.iStateIds = dbModel.iStateIdList.ToArray();
}
}
else
{
//model.ListTaxes = BL_Tax.GetAllTax().Where(x => x.sTaxName.ToLower() == "sgst" || x.sTaxName.ToLower() == "cgst").ToList();
model.ListTaxes = BL_Tax.GetAllTax().Where(x => x.cStatus.ToUpper() == "A").ToList();
}
model.ListRoomRateRange = BL_tblMasterTaxMap.GetRoomRateRange();
return(PartialView("_AddUpdate", model));
}
public ActionResult AddUpdate(etblMasterTaxMap model)
{
try
{
if (ModelState.IsValid)
{
model.dtActionDate = DateTime.Now;
model.iActionBy = ((BL_Login.UserDetails)Session["UserDetails"]).iUserId;
model.dtStayFrom = DateTime.ParseExact(model.sStayFrom, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
model.dtStayTo = DateTime.ParseExact(model.sStayTo, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
var result = BL_tblMasterTaxMap.AddUpdateMasterTaxMapping(model);
if (result.Key == 1 || result.Key == 2)
{
return(Json(new { status = true, Msg = result.Value, statusCode = result.Key }, JsonRequestBehavior.AllowGet));
}
return(Json(new { status = false, Msg = result.Value }, JsonRequestBehavior.AllowGet));
}
var message = string.Join(" | ", ModelState.Values.SelectMany(v => v.Errors).Select(e => e.ErrorMessage));
return(Json(new { status = false, Msg = message }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { status = false, Msg = "An error occured while adding the record, Kindly try after some time." }, JsonRequestBehavior.AllowGet));
}
}
public static KeyValuePair <int, string> AddUpdateMasterTaxMapping(etblMasterTaxMap model)
{
try
{
var result = new KeyValuePair <int, string>();
using (OneFineRateEntities db = new OneFineRateEntities())
{
#region RoomOccupancySearch
DataTable dtStateIds = new DataTable("Ids");
dtStateIds.Columns.AddRange(new DataColumn[1]
{
new DataColumn("ID", typeof(int))
});
DataTable dtTaxes = new DataTable("Tax");
dtTaxes.Columns.AddRange(new DataColumn[3]
{
new DataColumn("iTaxId", typeof(int)),
new DataColumn("bIsPercent", typeof(int)),
new DataColumn("dValue", typeof(decimal))
});
for (int i = 0; i < model.iStateIds.Count(); i++)
{
DataRow stateRow = dtStateIds.NewRow();
stateRow["ID"] = model.iStateIds[i];
dtStateIds.Rows.Add(stateRow);
}
foreach (var item in model.ListTaxes)
{
DataRow taxRow = dtTaxes.NewRow();
taxRow["iTaxId"] = item.iTaxId;
taxRow["bIsPercent"] = item.Type == "p" ? true : false;
taxRow["dValue"] = item.value;
dtTaxes.Rows.Add(taxRow);
}
#endregion
SqlParameter[] MyParam = new SqlParameter[8];
MyParam[0] = new SqlParameter("@iMasterTaxId", model.iMasterTaxId);
MyParam[1] = new SqlParameter("@iRangeId", model.iRangeId);
MyParam[2] = new SqlParameter("@dtStayFrom", model.dtStayFrom);
MyParam[3] = new SqlParameter("@dtStayTo", model.dtStayTo);
MyParam[4] = new SqlParameter("@bAllStates", model.IsAllStates);
MyParam[5] = new SqlParameter("@Ids", dtStateIds);
MyParam[6] = new SqlParameter("@iActionBy", model.iActionBy);
MyParam[7] = new SqlParameter("@Tax", dtTaxes);
var ds = SqlHelper.ExecuteDataset(db.Database.Connection.ConnectionString, CommandType.StoredProcedure, "[dbo].[uspSetMasterTax]", MyParam);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
result = new KeyValuePair <int, string>(Convert.ToInt32(ds.Tables[0].Rows[0]["status"].ToString()), ds.Tables[0].Rows[0]["errmsg"].ToString());
}
return(result);
}
}
catch (Exception ex)
{
return(new KeyValuePair <int, string>(-1, "An error occured, Details : " + ex.Message));
}
}
