public JsonResult AnnualRequisitionData(RequisitionChartModel rm)
{
Chartjs _chart = new Chartjs();
_chart.labels = new string[] { };
if (rm.SelectedYear == "All")
{
List <string> years = new List <string>();
for (int i = 3; i >= 1; i--)
{
years.Add(rm.YearSelection[i].Value);
}
_chart.labels = years.ToArray();
_chart.datasets = new List <Datasets>();
List <Datasets> _dataSet = new List <Datasets>();
_dataSet.Add(new Datasets()
{
label = "Stationery Request Quantity",
data = rBL.GetItems(),
backgroundColor = new string[] { "#6B7ABB", "#6B7ABB", "#6B7ABB" },
borderColor = new string[] { "#6B7ABB", "#6B7ABB", "#6B7ABB" },
borderWidth = "1"
});
_chart.datasets = _dataSet;
}
else
{
_chart.labels = months;
_chart.datasets = new List <Datasets>();
List <Datasets> _dataSet = new List <Datasets>();
List <string> colors = new List <string>();
List <string> borders = new List <string>();
for (int i = 0; i < 13; i++)
{
colors.Add("#1A5276");
borders.Add("#1A5276");
}
_dataSet.Add(new Datasets()
{
label = "Stationery Request Quantity",
data = rBL.GetItemsMonthly(rm.SelectedYear),
backgroundColor = colors.ToArray(),
borderColor = borders.ToArray(),
borderWidth = "1"
});
_chart.datasets = _dataSet;
}
return(Json(_chart, JsonRequestBehavior.AllowGet));
}
public JsonResult RequisitionDataByDept(RequisitionChartModel rm)
{
Chartjs _chart = new Chartjs();
_chart.datasets = new List <Datasets>();
List <Datasets> _dataSet = new List <Datasets>();
_chart.labels = new string[] { };
List <string> labels = new List <string>();
List <string> selectedDept = new List <string>();
for (int i = 0; i < rm.Departments.Count; i++)
{
if (rm.Departments[i].Selected)
{
selectedDept.Add(rm.Departments[i].Value);
}
}
rm.YearSelection = rBL.DisplayYears();
List <string> years = new List <string>();
for (int i = 3; i >= 1; i--)
{
years.Add(rm.YearSelection[i].Value);
}
if (rm.Months[0].Selected)
{
_chart.labels = years.ToArray();
if (rm.SelectedItem == "All")
{
for (int i = 0; i < selectedDept.Count; i++)
{
List <string> colors = new List <string>();
List <string> borders = new List <string>();
Dictionary <string, int> deptReq = rBL.GetTotalByDept(selectedDept[i], years);
List <int> listData = new List <int>();
foreach (KeyValuePair <string, int> pair in deptReq)
{
for (int j = 0; j < years.Count; j++)
{
if (pair.Key == years[j])
{
listData.Add(pair.Value);
colors.Add(color[i]);
borders.Add(color[i]);
}
}
}
_dataSet.Add(new Datasets()
{
label = selectedDept[i],
data = listData.ToArray(),
backgroundColor = colors.ToArray(),
borderColor = borders.ToArray(),
borderWidth = "1"
});
}
}
else
{
for (int i = 0; i < selectedDept.Count; i++)
{
Dictionary <string, int> deptReq = rBL.GetTotalByDept(selectedDept[i], rm.SelectedItem, years);
List <int> listData = new List <int>();
List <string> colors = new List <string>();
List <string> borders = new List <string>();
foreach (KeyValuePair <string, int> pair in deptReq)
{
for (int j = 0; j < years.Count; j++)
{
if (pair.Key == years[j])
{
listData.Add(pair.Value);
colors.Add(color[i]);
borders.Add(border[i]);
}
}
}
_dataSet.Add(new Datasets()
{
label = selectedDept[i],
data = listData.ToArray(),
backgroundColor = colors.ToArray(),
borderColor = borders.ToArray(),
borderWidth = "1"
});
}
}
}
else
{
List <int> currentYear = new List <int>();
List <int> lastYear = new List <int>();
List <int> previousYear = new List <int>();
for (int i = 25; i <= 36; i++)
{
if (rm.Months[i].Selected)
{
previousYear.Add(i - 24);
labels.Add(months[i - 25] + " " + years[0]);
}
}
for (int i = 13; i <= 24; i++)
{
if (rm.Months[i].Selected)
{
lastYear.Add(i - 12);
labels.Add(months[i - 13] + " " + years[1]);
}
}
for (int i = 1; i <= 12; i++)
{
if (rm.Months[i].Selected)
{
currentYear.Add(i);
labels.Add(months[i - 1] + " " + years[2]);
}
}
if (rm.SelectedItem == "All")
{
for (int i = 0; i < selectedDept.Count; i++)
{
List <int> listData = new List <int>();
List <string> colors = new List <string>();
List <string> borders = new List <string>();
Dictionary <int, int> deptReqPreviousYear = rBL.GetTotalByDeptAndYear(selectedDept[i], years[0], previousYear);
foreach (KeyValuePair <int, int> pair in deptReqPreviousYear)
{
listData.Add(pair.Value);
colors.Add(color[i]);
borders.Add(border[i]);
}
Dictionary <int, int> deptReqLastYear = rBL.GetTotalByDeptAndYear(selectedDept[i], years[1], lastYear);
foreach (KeyValuePair <int, int> pair in deptReqLastYear)
{
listData.Add(pair.Value);
colors.Add(color[i]);
borders.Add(border[i]);
}
Dictionary <int, int> deptReqCurrentYear = rBL.GetTotalByDeptAndYear(selectedDept[i], years[2], currentYear);
foreach (KeyValuePair <int, int> pair in deptReqCurrentYear)
{
listData.Add(pair.Value);
colors.Add(color[i]);
borders.Add(border[i]);
}
_chart.labels = labels.ToArray();
_dataSet.Add(new Datasets()
{
label = selectedDept[i],
data = listData.ToArray(),
backgroundColor = colors.ToArray(),
borderColor = borders.ToArray(),
borderWidth = "1"
});
}
}
else
{
for (int i = 0; i < selectedDept.Count; i++)
{
List <int> listData = new List <int>();
List <string> colors = new List <string>();
List <string> borders = new List <string>();
Dictionary <int, int> deptReqPreviousYear = rBL.GetTotalByDeptAndYear(selectedDept[i], years[0], previousYear, rm.SelectedItem);
foreach (KeyValuePair <int, int> pair in deptReqPreviousYear)
{
listData.Add(pair.Value);
colors.Add(color[i]);
borders.Add(border[i]);
}
Dictionary <int, int> deptReqLastYear = rBL.GetTotalByDeptAndYear(selectedDept[i], years[1], lastYear, rm.SelectedItem);
foreach (KeyValuePair <int, int> pair in deptReqLastYear)
{
listData.Add(pair.Value);
colors.Add(color[i]);
borders.Add(border[i]);
}
Dictionary <int, int> deptReqCurrentYear = rBL.GetTotalByDeptAndYear(selectedDept[i], years[2], currentYear, rm.SelectedItem);
foreach (KeyValuePair <int, int> pair in deptReqCurrentYear)
{
listData.Add(pair.Value);
colors.Add(color[i]);
borders.Add(border[i]);
}
_chart.labels = labels.ToArray();
_dataSet.Add(new Datasets()
{
label = selectedDept[i],
data = listData.ToArray(),
backgroundColor = colors.ToArray(),
borderColor = borders.ToArray(),
borderWidth = "1"
});
}
}
}
_chart.datasets = _dataSet;
return(Json(_chart, JsonRequestBehavior.AllowGet));
}