Esempio n. 1
0
        // GET: Categories
        public async Task <IActionResult> Index(int?id, int?productID)
        {
            var viewModel = new CategoryIndexData();

            viewModel.Categories = await _context.Categories
                                   .Include(i => i.PublishedProducts)
                                   .ThenInclude(i => i.Product)
                                   .ThenInclude(i => i.Orders)
                                   .ThenInclude(i => i.Customer)
                                   .AsNoTracking()
                                   .OrderBy(i => i.CategoryName)
                                   .ToListAsync();

            if (id != null)
            {
                ViewData["CategoryID"] = id.Value;
                Category category = viewModel.Categories.Where(i => i.ID == id.Value).Single();
                viewModel.Products = category.PublishedProducts.Select(s => s.Product);
            }
            if (productID != null)
            {
                ViewData["ProductID"] = productID.Value;
                viewModel.Orders      = viewModel.Products.Where(
                    x => x.ID == productID).Single().Orders;
            }
            return(View(viewModel));
        }
        public ActionResult Index(int?id, int?subcatID, int?postID)
        {
            var viewModel = new CategoryIndexData();

            viewModel.Categories = db.Categories.OrderBy(i => i.Name);

            if (id != null)
            {
                ViewBag.ID = id.Value;
                viewModel.SubCategories = viewModel.Categories.FirstOrDefault(c => c.ID == id).SubCategory;
            }

            if (subcatID != null)
            {
                ViewBag.SubCategoryID = subcatID.Value;
                viewModel.Posts       = db.Posts.Include(p => p.FilesPost).Where(x => x.SubCategoryID == subcatID);
            }


            return(View(viewModel));
        }
Esempio n. 3
0
        // GET: Categories
        public async Task <IActionResult> Index(int?id, string sortOrder, string searchString)
        {
            var viewModel = new CategoryIndexData();

            viewModel.Categories = await _context.Categories
                                   .Include(i => i.Products)

                                   // viewModel.Categories = await _context.Categories
                                   //                  .Include(i => i.Products)
                                   //                      .ThenInclude(i => i.InputDetails)
                                   //                    .Include(i => i.Products)
                                   //                      .ThenInclude(i => i.SaleDetails)
                                   //                     .Include(i => i.Provider)
                                   //                       .ThenInclude(i => i.Inputs)
                                   .AsNoTracking()
                                   .OrderBy(i => i.CategoryID)
                                   .ToListAsync();

            //Categories Sort Order begin
            ViewData["CurrentSort"]   = sortOrder;
            ViewData["NameSortParm"]  = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
            ViewData["DateSortParm"]  = sortOrder == "Date" ? "date_desc" : "Date";
            ViewData["CurrentFilter"] = searchString;

            switch (sortOrder)
            {
            case "name_desc":
                viewModel.Categories = viewModel.Categories.OrderByDescending(s => s.CategoryName);
                break;

            case "Date":
                viewModel.Categories = viewModel.Categories.OrderBy(s => s.CategoryID);
                break;

            case "date_desc":
                viewModel.Categories = viewModel.Categories.OrderByDescending(s => s.CategoryID);
                break;

            default:
                viewModel.Categories = viewModel.Categories.OrderBy(s => s.CategoryName);
                break;
            }
            //Categories Sort Order End

            //Categories Search



            //Categories detail selected
            if (id != null)
            {
                ViewData["CategoryID"] = id.Value;
                viewModel.Categories   = await _context.Categories
                                         .Include(i => i.Products)
                                         .OrderBy(i => i.CategoryID)
                                         .ToListAsync();


                Category category = viewModel.Categories
                                    .Where(c => c.CategoryID == id.Value)
                                    .Single();

                viewModel.Products = category.Products.ToList();
            }

            if (!String.IsNullOrEmpty(searchString))
            {
                var category = from s in _context.Categories
                               select s;
                category = category.Where(s => s.Description.Contains(searchString) ||
                                          s.CategoryName.Contains(searchString)
                                          //|| s.CategoryName.ToUpper().Contains(searchString.ToUpper())
                                          );

                viewModel.Categories = category.ToList();
            }
            return(View(viewModel));
            // return View(await category.ToListAsync());
            //return View(await _context.Categories.ToListAsync());
        }