public ActionResult Edit(int id)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"].ToString().ToUpper();
ViewBag.roleid = Session["RoleID"];
String Username = Session["Username"].ToString();
using (i_facility_unimechEntities condb = new i_facility_unimechEntities())
{
var pmd = condb.configuration_tblpmchecklist.Where(m => m.pmcid == id).Select(m => m.pmcpID).FirstOrDefault();
var tblpm = condb.configuration_tblpmchecklist.Where(m => m.pmcid == id).FirstOrDefault();
var tbl = condb.configuration_tblpmchecklist.Where(m => m.pmcid == id || m.pmcpID == pmd && m.Isdeleted == 0).ToList();
if (tbl == null)
{
return(HttpNotFound());
}
List <PmCheckList> obj = new List <PmCheckList>();
foreach (var item in tbl)
{
PmCheckList pm1 = new PmCheckList();
ViewBag.plant = new SelectList(condb.tblplants.ToList().Where(p => p.IsDeleted == 0), "PlantID", "PlantName", item.PlantID).ToList();
ViewBag.shop = new SelectList(condb.tblshops.ToList().Where(d => d.IsDeleted == 0), "ShopId", "ShopName", item.ShopID).ToList();
ViewBag.cell = new SelectList(condb.tblcells.ToList().Where(d => d.IsDeleted == 0), "CellID", "CellName", item.CellID).ToList();
ViewBag.TypeOfCheckPoint = new SelectList(condb.configuration_tblpmcheckpoint.ToList().Where(d => d.Isdeleted == 0), "pmcpID", "TypeOfCheckPoint", item.pmcpID).ToList();
pm1.pmchecklist = item;
obj.Add(pm1);
}
return(View(obj));
}
}
public ActionResult Index()
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"].ToString().ToUpper();
ViewBag.roleid = Session["RoleID"];
PmCheckList tblpm = new PmCheckList();
tblpm.pmchecklistlist = condb.configuration_tblpmchecklist.Where(m => m.Isdeleted == 0).ToList();
return(View(tblpm));
}
