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")); }
public ActionResult ChargeBackReport(DateTime date1, DateTime date2) { CatalogueBusinessLogic bl = new CatalogueBusinessLogic(); List <Department> dep = bl.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")); }
public JsonResult GetDisbursementList() { disbursementList = new List <Department>(); DisbursementList disbursement = new DisbursementList(); CatalogueBusinessLogic catalogue = new CatalogueBusinessLogic(); reqBackup = requestBackup; if (disbursementListBackup.Count != 0) { foreach (Department dep in disbursementListBackup) { disbursementList.Add(dep); } } if (updateRequest.Count != 0) { foreach (int req1 in updateRequest) { List <Department> dep = disbursement.GetDisbursements(req1); disbursementList.AddRange(dep); disbursementListBackup.AddRange(dep); } } if (disbursementList.Count != 0) { var data = disbursementList.Select(p => new { departmentName = p.DepartmentName, representative = p.AspNetUsers.UserName, collectionPoint = p.CollectionPoint }).Distinct().ToList(); return(Json(data, JsonRequestBehavior.AllowGet)); } return(new JsonResult()); }