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