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