public ActionResult Inventory(DateTime min, DateTime max, int dayReq, int categoryId)
        {
            InventoryByCategoryModel ibcm = new InventoryByCategoryModel();
            CakesPosRepository       cpr  = new CakesPosRepository(_connectionString);

            ibcm.inventory   = cpr.GetInventory(min, max).Where(c => c.product.CategoryId == categoryId);
            ibcm.categories  = cpr.GetAllCategories();
            ViewBag.category = categoryId;
            ViewBag.minDate  = min;
            ViewBag.maxDate  = max;
            ViewBag.dayReq   = dayReq;
            return(View(ibcm));
        }
        public ActionResult Inventory()
        {
            DateTime min = DateTime.Now.Date.AddMonths(-1);
            DateTime max = DateTime.Now.Date.AddDays(3);
            InventoryByCategoryModel ibcm = new InventoryByCategoryModel();
            CakesPosRepository       cpr  = new CakesPosRepository(_connectionString);

            ibcm.inventory   = cpr.GetInventory(min, max);
            ibcm.categories  = cpr.GetAllCategories();
            ViewBag.category = 1;
            ViewBag.minDate  = min;
            ViewBag.maxDate  = max;
            ViewBag.dayReq   = 4;
            return(View(ibcm));
        }