How to add google chart api data asp.net?
How to add google chart api data asp.net?
this is code in controller looks like:
public ActionResult ListOrder()
{
var result = from s in db.Orders.ToList()
group s by
new { Year = s.dateCreated.Year, Month = s.dateCreated.Month, Day = 1 }
into g
select new OrderViewModel
{
dateCreated = new DateTime(g.Key.Year, g.Key.Month, g.Key.Day),
TotalPrice = g.Sum(x => x.totalPrice)
};
return Json(result, JsonRequestBehavior.AllowGet);
// change column data type to 'date'
data.addColumn('date', 'Month');
data.addColumn('number', 'Total sum order for month');
for (var i = 0; i < chartData.length; i++) {
var rowDate;
// convert dateCreated
rowDate = chartData[i].dateCreated;
// replace first forward slash (/) with 'new'
rowDate = rowDate.replace('/', 'new ');
// remove second forward slash (/)
rowDate = rowDate.replace('/', '');
// evaluate the string to an actual date
rowDate = eval(rowDate);
data.addRow([rowDate, chartData[i].TotalPrice]);
}
Comments
Post a Comment