/// <summary>
/// Displays Partial View for Yearly Sales
/// </summary>
/// <returns></returns>
public PartialViewResult MyChart()
{
string year = Convert.ToString(DateTime.Today.Year);
ReportsController rc = new ReportsController();
var model = rc.YearlySalesByMonth_forCharts(year).ToList();
var name = model.Select(i => i.Month.ToString()).ToArray();
var count = model.Select(i => new Object[] { i.GrandTotal }).ToArray();
String[] arr = {"Jan"," Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"};
var charts = new Highcharts("charts").InitChart(new Chart { DefaultSeriesType = ChartTypes.Line })
.SetTitle(new Title { Text = "Graph of Yearly sales" })
.SetSubtitle(new Subtitle { Text = "For year 2015" })
// .SetXAxis(new XAxis { Categories = name, Title = new XAxisTitle{Text = "Months"} })
.SetXAxis(new XAxis { Categories = arr, Title = new XAxisTitle { Text = "Months"} })
.SetYAxis(new YAxis { Title = new YAxisTitle { Text = "Total Sales/Month" } })
.SetPlotOptions(new PlotOptions
{
Line = new PlotOptionsLine
{
DataLabels = new PlotOptionsLineDataLabels
{
Enabled = true
},
EnableMouseTracking = false
}
})
.SetSeries(new[]
{
new Series{Name= "Total sales", Data = new Data(count)}
});
return PartialView("MyChartPartialView",charts);
}
//*******************************************
//****************Charts ********************
/// <summary>
/// Returns Json data for yearly sales.
/// </summary>
/// <returns></returns>
public JsonResult ForMorris()
{
string year = Convert.ToString(DateTime.Today.Year);
ReportsController rc = new ReportsController();
var model = rc.YearlySalesByMonth_forCharts(year).ToList();
var count = model.Select(i => new Object[] {i.GrandTotal}).ToList();
return Json(count, JsonRequestBehavior.AllowGet);
}