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