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