public JsonResult ProduceChart1Data() { var myData = new List <MorrisBarCharts>(); MorrisBarCharts data = null; foreach (var priority in db.TicketPriorities.ToList()) { data = new MorrisBarCharts(); data.label = priority.PriorityName; data.value = db.Tickets.Where(t => t.TicketPriority.PriorityName == priority.PriorityName).Count(); myData.Add(data); } return(Json(myData)); }
public JsonResult ProduceChart2Data() { var myData = new List <MorrisBarCharts>(); MorrisBarCharts data = null; foreach (var status in db.TicketStatus.ToList()) { myData.Add(new MorrisBarCharts { label = status.StatusName, value = db.Tickets.Where(t => t.TicketStatus.StatusName == status.StatusName).Count() }); } return(Json(myData)); }