public ActionResult ChargeBackReport(DateTime Date1, DateTime Date2)
        {
            List <Department> dep        = catalogueBusinessLogic.getDepartments();
            ReportsController depManager = new ReportsController();


            foreach (Department d in dep)
            {
                depManager.spendingHistorytwo(Date1, Date2, d.DepartmentID);
            }

            ViewBag.dataSCI   = JsonConvert.SerializeObject(depManager.dataSCI);
            ViewBag.dataCOMM  = JsonConvert.SerializeObject(depManager.dataCOMM);
            ViewBag.dataCPSC  = JsonConvert.SerializeObject(depManager.dataCPSC);
            ViewBag.dataENGL  = JsonConvert.SerializeObject(depManager.dataENGL);
            ViewBag.dataREGR  = JsonConvert.SerializeObject(depManager.dataREGR);
            ViewBag.dataSTORE = JsonConvert.SerializeObject(depManager.dataSTORE);
            ViewBag.dataZOOL  = JsonConvert.SerializeObject(depManager.dataZOOL);
            ViewBag.months    = JsonConvert.SerializeObject(depManager.datamonths);
            return(View("generateChargeBack"));
        }
Beispiel #2
0
        public ActionResult trenAnalysis(string dropDown1, DateTime date1, DateTime date2)
        {
            CatalogueBusinessLogic bl         = new CatalogueBusinessLogic();
            List <Department>      dep        = bl.getDepartments();
            ReportsController      depManager = new ReportsController();


            foreach (Department d in dep)
            {
                depManager.itemsDepSpendings(date1, date2, d.DepartmentID, dropDown1);
            }

            ViewBag.dataSCI   = JsonConvert.SerializeObject(depManager.dataSCI);
            ViewBag.dataCOMM  = JsonConvert.SerializeObject(depManager.dataCOMM);
            ViewBag.dataCPSC  = JsonConvert.SerializeObject(depManager.dataCPSC);
            ViewBag.dataENGL  = JsonConvert.SerializeObject(depManager.dataENGL);
            ViewBag.dataREGR  = JsonConvert.SerializeObject(depManager.dataREGR);
            ViewBag.dataSTORE = JsonConvert.SerializeObject(depManager.dataSTORE);
            ViewBag.dataZOOL  = JsonConvert.SerializeObject(depManager.dataZOOL);
            ViewBag.months    = JsonConvert.SerializeObject(depManager.datamonths);
            return(View("ChargeBackReport"));
        }