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 Boolean Save() { try { if (GetRecordByKey(mfacility_code, mproduct_category, mstart_date, mend_date) == null) { var x = new LMIS_ExpectedReport { facility_code = mfacility_code, start_date = mstart_date, end_date = mend_date, product_category = mproduct_category }; context.LMIS_ExpectedReport.Add(x); context.SaveChanges(); return(true); } else { return(false); } } catch (Exception x) { throw (x); } }