public IActionResult Products() { var model = new AdminProductListViewModel(); model.MenuItems = SetupMenu("Products"); model.Products = dbContext.Products.Include(p => p.Category). Select(p => new AdminProductListViewModel.Product { Id = p.ProductId, CategoryName = p.Category.CategoryName, Name = p.ProductName, Price = p.UnitPrice.Value }).ToList(); return(View(model)); }
public ActionResult List(int?searchId, int?id) { IEnumerable <Product> products = (IEnumerable <Product>)Session["products"]; if (products == null) { products = _productRepository.Products.ToList(); } Session["products"] = products; IEnumerable <Product> pageSize = new List <Product>(); if (searchId != null) { pageSize = products.Where(p => p.ProductID == searchId); } else { if (id == null) { pageSize = products.Take(5); ViewBag.navId = pageSize.LastOrDefault().ProductID; Product lastofList = pageSize.LastOrDefault(); Product LastofDb = products.LastOrDefault(); Product firstofDb = products.FirstOrDefault(); Session["current"] = pageSize.LastOrDefault().ProductID; ViewBag.lastofList = lastofList; ViewBag.LastofDb = LastofDb; ViewBag.firstofDb = firstofDb; } else if (id == 0) { int current = (int)Session["current"]; pageSize = products.Skip(((int)current - 5)).Take(5); Session["current"] = pageSize.LastOrDefault().ProductID; Product lastofList = pageSize.LastOrDefault(); Product LastofDb = products.LastOrDefault(); Product firstofDb = products.FirstOrDefault(); ViewBag.navId = pageSize.LastOrDefault().ProductID; ViewBag.lastofList = lastofList; ViewBag.LastofDb = LastofDb; ViewBag.firstofDb = firstofDb; } else if (id == 1) { int current = (int)Session["current"]; pageSize = products.Skip(((int)current)).Take(5); Product lastofList = pageSize.LastOrDefault(); Product LastofDb = products.LastOrDefault(); Product firstofDb = products.FirstOrDefault(); Session["current"] = pageSize.LastOrDefault().ProductID; ViewBag.lastofList = lastofList; ViewBag.LastofDb = LastofDb; ViewBag.firstofDb = firstofDb; } } AdminProductListViewModel model = new AdminProductListViewModel { Products = pageSize, ProductCount = products.Count(), }; searchId = null; return(PartialView("~/Views/Admin/_ProductList.cshtml", model)); }