public JsonResult GetCostSetting(int chosenMonth)
{
_cmcOmtSqlDb.Configuration.ProxyCreationEnabled = false;
CostSetting costSetting = _cmcOmtSqlDb.CostSettings.Where(s => s.MonthID == chosenMonth).FirstOrDefault();
return(Json(costSetting, JsonRequestBehavior.AllowGet));
}
// GET: Cost
public ActionResult Setting()
{
if (Session["user"] == null)
{
Response.Redirect("/Reports/Login", true);
}
int currentMonth = System.DateTime.Now.Month;
CostSetting curCostSetting = _cmcOmtSqlDb.CostSettings.Where(s => s.MonthID == currentMonth).FirstOrDefault();
return(View(curCostSetting));
}
public ActionResult Setting(int?month, string productionCost, string bargeCost, string totalSiteCost)
{
if (Session["user"] == null)
{
Response.Redirect("/Reports/Login", true);
}
CostSetting updatedSetting = _cmcOmtSqlDb.CostSettings.Where(s => s.MonthID == month).FirstOrDefault();;
if (updatedSetting != null)
{
System.Diagnostics.Debug.WriteLine("Raw: " + productionCost + " | Converted: " + Convert.ToDecimal(productionCost.Replace(",", "")));
updatedSetting.ProductionCost = Convert.ToDecimal(productionCost.Replace(",", ""));
updatedSetting.BargeloadingCost = Convert.ToDecimal(bargeCost.Replace(",", ""));
updatedSetting.TotalSiteCost = Convert.ToDecimal(totalSiteCost.Replace(",", ""));
_cmcOmtSqlDb.Entry(updatedSetting).State = System.Data.Entity.EntityState.Modified;
_cmcOmtSqlDb.SaveChanges();
}
return(View(updatedSetting));
}
