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));
        }
Beispiel #2
0
        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));
        }