public ActionResult Edit(tbl_ME_Baseline model) { var x = (from c in _db.tbl_ME_Baseline where c.BaseLineID == model.BaseLineID select c).FirstOrDefault(); x.BaseData = model.BaseData; _db.SaveChanges(); return(RedirectToAction("BaselineList")); }
public ActionResult AddNewBaseline(RegisterBaseLineViewModel model, string submit) { var rex = 0; var x = (from c in _db.tbl_ME_LK_IndicatorRegister where c.SubComponentID == model.SubComponentId select c).ToList(); var obj = new RegisterBaseLineViewModel { IndicatorRegister = x.Take(10), SubComponentId = model.SubComponentId, StateId = model.StateId, CigId = model.CigId }; switch (submit) { case "Search": //ViewBag.Message = "Customer saved successfully!"; ViewBag.SubComponentID = new SelectList(_db.tbl_LK_ME_SubComponent, "SubComponentID", "SubComponentName", model.SubComponentId); ViewBag.StateID = new SelectList(_db.tbl_LK_State, "StateID", "StateName", model.StateId); ViewBag.CIGID = new SelectList(_db.tbl_LK_FarmerCIG, "CIGID", "CIGName", model.CigId); return(View(obj)); case "Process": foreach (var item in x) { var baseline = new tbl_ME_Baseline { RegisterIndicatorsID = item.RegisterIndicatorsID, StateID = model.StateId, CIGID = model.CigId, BaseData = 0m }; _db.tbl_ME_Baseline.Add(baseline); _db.SaveChanges(); rex = model.CigId; } ViewBag.SubComponentID = new SelectList(_db.tbl_LK_ME_SubComponent, "SubComponentID", "SubComponentName", model.SubComponentId); ViewBag.StateID = new SelectList(_db.tbl_LK_State, "StateID", "StateName", model.StateId); ViewBag.CIGID = new SelectList(_db.tbl_LK_FarmerCIG, "CIGID", "CIGName", model.CigId); return(RedirectToAction("BaseLineListing", new { id = rex })); } return(View()); }