public ActionResult Edit(tbl_ME_RegisterIndicatorTarget model) { var x = (from c in _db.tbl_ME_RegisterIndicatorTarget where c.TargetID == model.TargetID select c).FirstOrDefault(); x.TargetData = model.TargetData; _db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult AddTargetIndicator(RegisterTargetIndicator 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 RegisterTargetIndicator { IndicatorRegister = x.ToList(), SubComponentId = model.SubComponentId, StateId = model.StateId, CigId = model.CigId, ProductionSeasonId = model.ProductionSeasonId, YearId = model.YearId }; switch (submit) { case "Search": //ViewBag.Message = "Customer saved successfully!"; ViewBag.ProductionSeasonID = new SelectList(_db.tbl_LK_FarmerProductionSeason, "ProductionSeasonID", "ProductionSeasonName", model.ProductionSeasonId); ViewBag.YearID = new SelectList(_db.tbl_LK_Year, "YearID", "Year", model.YearId); 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 ob = new tbl_ME_RegisterIndicatorTarget { RegisterIndicatorsID = item.RegisterIndicatorsID, StateID = model.StateId, CIGID = model.CigId, TargetData = 0m, ProductionSeasonID = model.ProductionSeasonId, YearID = model.YearId, DateCreated = DateTime.Now, Approved = false }; _db.tbl_ME_RegisterIndicatorTarget.Add(ob); _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); ViewBag.ProductionSeasonID = new SelectList(_db.tbl_LK_FarmerProductionSeason, "ProductionSeasonID", "ProductionSeasonName", model.ProductionSeasonId); ViewBag.YearID = new SelectList(_db.tbl_LK_Year, "YearID", "Year", model.YearId); return(RedirectToAction("TargetIndicatorListing", new { id = rex, year = model.YearId })); } return(View()); }