/// <summary>
/// Displays Prtial View for Monthly sales
/// </summary>
/// <returns></returns>
public ActionResult MyChartForSalesOfMonth()
{
//string year = Convert.ToString(DateTime.Today.Year);
ReportsController rc = new ReportsController();
var model = rc.MonthlySalesByDate_forCharts(DateTime.Today.Year, DateTime.Today.Month);
var name = model.Select(i => i.Day.ToString()).ToArray();
var count = model.Select(i => new Object[] { i.Total }).ToArray();
var charts2 = new Highcharts("charts").InitChart(new Chart { DefaultSeriesType = ChartTypes.Column })
.SetTitle(new Title { Text = "Graph of Sales in a month" })
.SetSubtitle(new Subtitle { Text = "For year: " + DateTime.Today.Year + ", month: "+DateTime.Today.Month })
.SetXAxis(new XAxis { Categories = name, Title = new XAxisTitle { Text = "Months" } })
.SetYAxis(new YAxis { Title = new YAxisTitle { Text = "Total Sales per Day" } })
.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("MyChartForSalesOfMonthPartialView", charts2);
}
/// <summary>
///
/// </summary>
/// <returns>Json data for Monthly sales for this month</returns>
public JsonResult ForMorris2()
{
ReportsController rc = new ReportsController();
var model = rc.MonthlySalesByDate_forCharts(DateTime.Today.Year, DateTime.Today.Month);
var value = model.Select(i => new Object[] { i.Day.ToString(), i.Total }).ToArray();
return Json(value, JsonRequestBehavior.AllowGet);
}
/// <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);
}
