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