public ViewResult List(string currentCategoryParam, int page = 1)
        {
            //return View(repository.Products.OrderBy(p=>p.ProductID).Skip(((page-1)*PageSize)).Take(PageSize));

            ProductsListViewModel model = new ProductsListViewModel()
            {
                Products= repository.Products.Where(p => p.Category == currentCategoryParam || currentCategoryParam == null)
                    .OrderBy(p => p.ProductID)
                    .Skip(((page - 1) * PageSize))
                    .Take(PageSize),
                PagingInfo = new PagingInfo()
                {
                    CurrentPage = page,
                    ItemsPerPage = PageSize,
                    TotalItems = repository.Products.Where(p => p.Category == currentCategoryParam || currentCategoryParam == null).Count()
                },
                CurrentCategory = currentCategoryParam
            };
            return View(model);
        }
Example #2
0
 public ViewResult List(string category, int page = 1)
 {
     var model = new ProductsListViewModel
     {
         Products = repository.Products
             .Where(p => category == null || p.Category == category)
             .OrderBy(p => p.ProductID)
             .Skip((page - 1) * PageSize)
             .Take(PageSize),
         PagingInfo = new PagingInfo
         {
             CurrentPage = page,
             ItemsPerPage = PageSize,
             TotalItems = category == null ?
                 repository.Products.Count() :
                 repository.Products.Count(e => e.Category == category)
         },
         CurrentCategory = category
     };
     return View(model);
 }
Example #3
0
        public ViewResult List(string sortOrder, string currentFilterName, string currentFilterMinCost, string currentFilterMaxCost, string searchString, string minCost, string maxCost, string category, int page = 1)
        {
            var products = _repository.Products.Where(x => x.SellEndDate == null).ToList();

            ViewBag.CurrentSort = sortOrder;
            ViewBag.NameSortParam = String.IsNullOrEmpty(sortOrder) ? "Name desc" : "";
            ViewBag.CostSortParam = sortOrder == "Cost" ? "Cost desc" : "Cost";
            if (Request != null && Request.HttpMethod == "GET")
            {
                searchString = currentFilterName;
                minCost = currentFilterMinCost;
                maxCost = currentFilterMaxCost;
            }
            else
            {
                page = 1;
            }
            ViewBag.CurrentFilterName = searchString;
            ViewBag.CurrentFilterMinCost = minCost;
            ViewBag.CurrentFilterMaxCost = maxCost;

            //

            if (!String.IsNullOrEmpty(searchString))
            {
                products = products.Where(s => s.Name.ToUpper().Contains(searchString.ToUpper())).ToList();
            }

            decimal dminCost;
            decimal dmaxCost;

            if (!String.IsNullOrEmpty(minCost) && !String.IsNullOrEmpty(maxCost) && decimal.TryParse(minCost, out dminCost) && decimal.TryParse(maxCost, out dmaxCost))
            {

                products =
                    products.Where(
                        s => s.StandardCost >= dminCost && s.StandardCost <= dmaxCost)
                        .ToList();
            }

            switch (sortOrder)
            {
                case "Name desc":
                    products = products.OrderByDescending(s => s.Name).ToList();
                    break;
                case "Cost":
                    products = products.OrderBy(s => s.StandardCost).ToList();
                    break;
                case "Cost desc":
                    products = products.OrderByDescending(s => s.StandardCost).ToList();
                    break;
                case "Name":
                    products = products.OrderBy(s => s.Name).ToList();
                    break;
            }

            var viewModel = new ProductsListViewModel
            {
                Products = products
                .Where(p => category == null || p.ProductCategory.Name == category)
                    //   .OrderBy(p => p.ProductID)
                    .Skip((page - 1) * PageSize)
                    .Take(PageSize),
                PagingInfo = new PagingInfo
                {
                    CurrentPage = page,
                    ItemsPerPage = PageSize,
                    TotalItems = category == null ? products.Count() : products.Count(p => p.ProductCategory.Name == category)
                },
                CurrentCategory = category,
            };

            return View(viewModel);
        }