public ActionResult Chargeback(string year, string month, string category)
{
AnalyticsListVM analytics;
if (Session["Analytics"] == null)
{
UnitOfWork uow = new UnitOfWork();
analytics = new AnalyticsListVM(uow);
Session["Analytics"] = analytics;
}
else
{
analytics = (AnalyticsListVM)Session["Analytics"];
}
//List<AnalyticsDetailsVM> data = analytics.DLSummaryList;
List <AnalyticsDetailsVM> data = (List <AnalyticsDetailsVM>)Session["Data"];
string result = year;
//filter by year
data = AnalyticsService.ApplyFilter(data, "Year", year);
if (month != "all")
{
result = int.Parse(month).ToString($"{0:00}") + "/" + result;
data = AnalyticsService.ApplyFilter(data, "Month", month);
}
if (category != "all")
{
result = " Category " + category + " in " + result;
data = AnalyticsService.ApplyFilter(data, "Category", category);
}
data = AnalyticsService.ApplyGroup(data, "Department");
ViewBag.Result = result;
return(View(data));
}
public ActionResult GenerateChartQty(string t)
{
Debug.WriteLine("Called");
string group = Session["AGroup"] == null ? "Category" : Session["AGroup"].ToString();
string filter1 = Session["AFilter1"] == null ? "" : Session["AFilter1"].ToString();
string filter2 = Session["AFilter2"] == null ? "" : Session["AFilter2"].ToString();
string value1 = Session["AValue1"] == null ? "" : Session["AValue1"].ToString();
string value2 = Session["AValue2"] == null ? "" : Session["AValue2"].ToString();
List <AnalyticsDetailsVM> data = (List <AnalyticsDetailsVM>)Session["Data"];
data = AnalyticsService.ApplyFilter(data, filter1, value1);
data = AnalyticsService.ApplyFilter(data, filter2, value2);
data = AnalyticsService.ApplyGroup(data, group);
ArrayList yValueQty = AnalyticsService.YAxisQty(data);
ArrayList xValue = AnalyticsService.XAxis(data, group);
string titlesub = "";
if (value1 != "")
{
titlesub += " for " + value1;
if (value2 != "")
{
titlesub += " - " + value2;
}
}
int w = xValue.Count * 20 + 500;
string charttype = "Column";
new Chart(width: w, height: 400, themePath: "~/Resources/ChartQty.xml")
.AddTitle("Item Quantity" + titlesub + " by " + group)
.AddSeries("Qty1", chartType: charttype, xValue: xValue, yValues: yValueQty)
.Write("bmp");
return(null);
}
