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());
}
