public ActionResult AddAchievement(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 RegisterAchievement
{
IndicatorRegister = x.ToList(),
SubComponentId = model.SubComponentId,
StateID = model.StateId,
CIGID = model.CigId,
ProductionSeasonID = model.ProductionSeasonId,
YearID = model.YearId,
Approved = false,
DateCreated = DateTime.Now
};
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_RegisterIndicatorAchievement
{
RegisterIndicatorsID = item.RegisterIndicatorsID,
StateID = model.StateId,
CIGID = model.CigId,
AchievementData = 0m,
ProductionSeasonID = model.ProductionSeasonId,
YearID = model.YearId,
DateCreated = DateTime.Now,
Approved = false,
//Remarks = item.Remark,
Quarter = 1
};
_db.tbl_ME_RegisterIndicatorAchievement.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("AchievementListing", new { id = rex, year = model.YearId }));
}
return(View());
}
public ActionResult AddTargetIndicator()
{
var obj = new RegisterTargetIndicator
{
IndicatorRegister = _db.tbl_ME_LK_IndicatorRegister.Take(10)
};
ViewBag.SubComponentID = new SelectList(_db.tbl_LK_ME_SubComponent, "SubComponentID", "SubComponentName");
ViewBag.StateID = new SelectList(_db.tbl_LK_State, "StateID", "StateName");
ViewBag.CIGID = new SelectList(_db.tbl_LK_FarmerCIG, "CIGID", "CIGName");
ViewBag.ProductionSeasonID = new SelectList(_db.tbl_LK_FarmerProductionSeason, "ProductionSeasonID", "ProductionSeasonName");
ViewBag.YearID = new SelectList(_db.tbl_LK_Year, "YearID", "Year");
return(View(obj));
}
