// GET: ComplianceItems
public ActionResult Index(int?page)
{
int pageSize = 14;
int pageNumber = (page ?? 1);
var viewModel = new ComplianceItems();
var productSubItem = from a in db.ComplianceItems
join s in db.ComplianceItemSubItems on a.ComplianceItemsID equals s.SubItemTo
orderby a.ItemName
// join p in db.ProductCompliance on s.SubItemTo equals p.ComplianceItemsID
//select new SubItemsViewModel { SubItemTo = s.SubItemTo, ItemName = a.ItemName, ComplianceItemsID = s.ComplianceItemID, Checked = p.Checked };
select new SubItemsViewModel {
SubItemTo = s.SubItemTo, ItemName = a.ItemName, ComplianceItemsID = s.ComplianceItemID
};
if (productSubItem.Count() > 1)
{
ViewBag.productSubItem = productSubItem.ToList();
}
decimal totalPages = ((decimal)(productSubItem.Count() / (decimal)pageSize));
ViewBag.TotalPages = Math.Ceiling(totalPages);
//viewModel.Products = viewModel.Products.ToPagedList(pageNumber, pageSize);
ViewBag.OnePageOfProducts = productSubItem.ToPagedList(pageNumber, pageSize);
ViewBag.PageNumber = pageNumber;
return(View(db.ComplianceItems.ToList()));
}
public ActionResult DeleteConfirmed(int id)
{
ComplianceItems complianceItems = db.ComplianceItems.Find(id);
db.ComplianceItems.Remove(complianceItems);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ComplianceItemsID,ItemName,EndItem")] ComplianceItems complianceItems)
{
if (ModelState.IsValid)
{
db.Entry(complianceItems).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(complianceItems));
}
public ActionResult Create([Bind(Include = "ComplianceItemsID,ItemName")] ComplianceItems complianceItems)
{
if (ModelState.IsValid)
{
db.ComplianceItems.Add(complianceItems);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(complianceItems));
}
// GET: ComplianceItems/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ComplianceItems complianceItems = db.ComplianceItems.Find(id);
if (complianceItems == null)
{
return(HttpNotFound());
}
return(View(complianceItems));
}
// GET: ComplianceItems/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ComplianceItems complianceItems = db.ComplianceItems.Find(id);
var ddcontent = from p in db.ComplianceItems orderby p.ItemName select new { p.ComplianceItemsID, p.ItemName };
var x = ddcontent.ToList().Select(c => new SelectListItem {
Text = c.ItemName, Value = c.ComplianceItemsID.ToString()
}).ToList();
ViewBag.ComplianceIts = x;
if (complianceItems == null)
{
return(HttpNotFound());
}
return(View(complianceItems));
}
