public ActionResult SaveExpectedReport(LMIS_ExpectedReport value, string fc, string productcategory, string startdate, string enddate)
{
DateTime sDate = DateTime.ParseExact(startdate, "dd/MM/yyyy", null);
DateTime eDate = DateTime.ParseExact(enddate, "dd/MM/yyyy", null);
int facility = int.Parse(fc);
int pc = int.Parse(productcategory);
context.Configuration.ProxyCreationEnabled = false;
mascisEntities db_master = new mascisEntities();
LMIS_ExpectedReport table = db_master.LMIS_ExpectedReport.FirstOrDefault(o => o.facility_code == facility && o.product_category == pc && o.start_date == sDate && o.end_date == eDate);
ExpectedReports obj = new ExpectedReports();
if (table == null)
{
//db.Entry(table).CurrentValues.SetValues(value);
obj.facility_code = facility;
obj.product_category = pc;
obj.start_date = sDate;
obj.end_date = eDate;
//db_master.SaveChanges();
}
else
{
//db.Entry(table).CurrentValues.SetValues(value);
obj.facility_code = facility;
obj.product_category = pc;
obj.start_date = sDate;
obj.end_date = eDate;
db_master.Entry(table).State = EntityState.Modified;
context.Entry(table).CurrentValues.SetValues(table);
}
obj.Update();
return(Json(value, JsonRequestBehavior.AllowGet));
//return RedirectToAction("DataSourceRFSO");
}
public ActionResult BatchUpdate(string key, List <LMIS_ExpectedReport> changed, List <LMIS_ExpectedReport> added, List <LMIS_ExpectedReport> deleted)
{
mascisEntities dbCase = new mascisEntities();
ExpectedReports obj = new ExpectedReports();
//Performing insert operation
if (added != null && added.Count() > 0)
{
foreach (var temp in added)
{
//dbCase.A_Facilities.Add(temp);
obj.facility_code = temp.facility_code;
obj.start_date = temp.start_date;
obj.end_date = temp.end_date;
obj.product_category = temp.product_category;
context.SaveChanges();
}
}
obj.Update();
if (changed != null && changed.Count() > 0)
{
foreach (var temp in changed)
{
obj.facility_code = temp.facility_code;
obj.start_date = temp.start_date;
obj.end_date = temp.end_date;
obj.product_category = temp.product_category;
var check = context.LMIS_ExpectedReport.FirstOrDefault(e => e.facility_code == temp.facility_code && e.start_date == temp.start_date && e.end_date == temp.end_date && e.product_category == temp.product_category);
context.Entry(check).CurrentValues.SetValues(check);
context.Entry(check).State = EntityState.Modified;
context.SaveChanges();
}
}
//dbCase.SaveChanges();
obj.Update();
//Performing delete operation
if (deleted != null && deleted.Count() > 0)
{
foreach (var temp in deleted)
{
dbCase.LMIS_ExpectedReport.Remove(dbCase.LMIS_ExpectedReport.FirstOrDefault(e => e.facility_code == temp.facility_code && e.start_date == temp.start_date && e.end_date == temp.end_date && e.product_category == temp.product_category));
}
}
//dbCase.SaveChanges();
obj.Update();
return(RedirectToAction("DataSourceRFSO"));
}
