Hello Team,
In my MVC C# application I want to plot bar graph on my dashboard from sales table, kindly help.
public JsonResult GetSalesPerformance()
{
ASPNETMASTERPOSTEntities db = new ASPNETMASTERPOSTEntities();
var previousYear = (DateTime.Now.Year - 1);
var sales = db.tblSales.ToList();
var salesByMonthAmount = (from a in sales
// Your LINQ query here
);
return Json(salesByMonthAmount, JsonRequestBehavior.AllowGet);
}