public ActionResult trendExpenditureReport(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("trenAnalysisByExpenditure")); }
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 ActionResult spendingHistory(DateTime date1, DateTime date2) { string userId = User.Identity.GetUserId(); AspNetUsers user1 = i.AspNetUsers.Where(x => x.Id == userId).First <AspNetUsers>(); ViewBag.usertype = user1.UserType; ViewBag.Department = user1.DepartmentID.Substring(0, 4); ReportsController rep = new ReportsController(); List <Order> spendings = BL.getDepSpendingHistory(date1, date2, userId); List <Object> secondmonths = new List <Object>(); List <String> jui = new List <string>(); List <Object> xaxis = new List <object>(); List <Object> years = new List <object>(); List <decimal> datapoints2 = new List <decimal>(); int da = rep.GetMonthDifference(date1, date2); DateTime temp = new DateTime(); temp = date1; for (int i = 0; i < da; i++) { jui.Add(temp.Year.ToString() + temp.Month.ToString()); xaxis.Add(temp.ToString("MMM") + temp.Year.ToString().Substring(2, 2)); temp = temp.AddMonths(1); datapoints2.Add(0); } for (int i = 0; i < spendings.Count; i++) { DateTime myval = (DateTime)spendings[i].OrderDate; string month = myval.Month.ToString(); string year = myval.Year.ToString(); if (month == "1") { if (!(secondmonths.Contains(month + year))) { secondmonths.Add(month + year); datapoints2.RemoveAt(jui.IndexOf(year + month)); datapoints2.Insert(jui.IndexOf(year + month), (decimal)spendings[i].TotalPrice); } else { datapoints2[jui.IndexOf(year + month)] += (decimal)spendings[i].TotalPrice; } } else if (month == "2") { if (!(secondmonths.Contains(month + year))) { secondmonths.Add(month + year); datapoints2.RemoveAt(jui.IndexOf(year + month)); datapoints2.Insert(jui.IndexOf(year + month), (decimal)spendings[i].TotalPrice); } else { datapoints2[jui.IndexOf(year + month)] += (decimal)spendings[i].TotalPrice; } } else if (month == "3") { if (!(secondmonths.Contains(month + year))) { secondmonths.Add(month + year); datapoints2.RemoveAt(jui.IndexOf(year + month)); datapoints2.Insert(jui.IndexOf(year + month), (decimal)spendings[i].TotalPrice); } else { datapoints2[jui.IndexOf(year + month)] += (decimal)spendings[i].TotalPrice; } } else if (month == "4") { if (!(secondmonths.Contains(month + year))) { secondmonths.Add(month + year); datapoints2.RemoveAt(jui.IndexOf(year + month)); datapoints2.Insert(jui.IndexOf(year + month), (decimal)spendings[i].TotalPrice); } else { datapoints2[jui.IndexOf(year + month)] += (decimal)spendings[i].TotalPrice; } } else if (month == "5") { if (!(secondmonths.Contains(month + year))) { secondmonths.Add(month + year); datapoints2.RemoveAt(jui.IndexOf(year + month)); datapoints2.Insert(jui.IndexOf(year + month), (decimal)spendings[i].TotalPrice); } else { datapoints2[jui.IndexOf(year + month)] += (decimal)spendings[i].TotalPrice; } } else if (month == "6") { if (!(secondmonths.Contains(month + year))) { secondmonths.Add(month + year); datapoints2.RemoveAt(jui.IndexOf(year + month)); datapoints2.Insert(jui.IndexOf(year + month), (decimal)spendings[i].TotalPrice); } else { datapoints2[jui.IndexOf(year + month)] += (decimal)spendings[i].TotalPrice; } } else if (month == "7") { if (!(secondmonths.Contains(month + year))) { secondmonths.Add(month + year); datapoints2.RemoveAt(jui.IndexOf(year + month)); datapoints2.Insert(jui.IndexOf(year + month), (decimal)spendings[i].TotalPrice); } else { datapoints2[jui.IndexOf(year + month)] += (decimal)spendings[i].TotalPrice; } } else if (month == "8") { if (!(secondmonths.Contains(month + year))) { secondmonths.Add(month + year); datapoints2.RemoveAt(jui.IndexOf(year + month)); datapoints2.Insert(jui.IndexOf(year + month), (decimal)spendings[i].TotalPrice); } else { datapoints2[jui.IndexOf(year + month)] += (decimal)spendings[i].TotalPrice; } } else if (month == "9") { if (!(secondmonths.Contains(month + year))) { secondmonths.Add(month + year); datapoints2.RemoveAt(jui.IndexOf(year + month)); datapoints2.Insert(jui.IndexOf(year + month), (decimal)spendings[i].TotalPrice); } else { datapoints2[jui.IndexOf(year + month)] += (decimal)spendings[i].TotalPrice; } } else if (month == "10") { if (!(secondmonths.Contains(month + year))) { secondmonths.Add(month + year); datapoints2.RemoveAt(jui.IndexOf(year + month)); datapoints2.Insert(jui.IndexOf(year + month), (decimal)spendings[i].TotalPrice); } else { datapoints2[jui.IndexOf(year + month)] += (decimal)spendings[i].TotalPrice; } } else if (month == "11") { if (!(secondmonths.Contains(month + year))) { secondmonths.Add(month + year); datapoints2.RemoveAt(jui.IndexOf(year + month)); datapoints2.Insert(jui.IndexOf(year + month), (decimal)spendings[i].TotalPrice); } else { datapoints2[jui.IndexOf(year + month)] += (decimal)spendings[i].TotalPrice; } } else { if (!(secondmonths.Contains(month + year))) { secondmonths.Add(month + year); datapoints2.RemoveAt(jui.IndexOf(year + month)); datapoints2.Insert(jui.IndexOf(year + month), (decimal)spendings[i].TotalPrice); } else { datapoints2[jui.IndexOf(year + month)] += (decimal)spendings[i].TotalPrice; } } } ViewBag.datapoints2 = JsonConvert.SerializeObject(datapoints2); ViewBag.datapoints3 = JsonConvert.SerializeObject(xaxis); return(View("DepSpendingHistory")); }