// GET: Graphing public JsonResult ProduceChartData1() { var myData = new List <MorrisGraphData>(); MorrisGraphData data = null; foreach (var priority in db.Priorities.ToList()) { data = new MorrisGraphData(); data.label = priority.Name; data.value = db.Tickets.Where(t => t.Priority.Name == priority.Name).Count(); myData.Add(data); } return(Json(myData)); }
public JsonResult ProduceChartData2() { var myData = new List <MorrisGraphData>(); MorrisGraphData data = null; foreach (var status in db.Statuses.ToList()) { data = new MorrisGraphData(); data.label = status.Name; data.value = db.Tickets.Where(t => t.Status.Name == status.Name).Count(); myData.Add(data); } return(Json(myData)); }
public JsonResult ProduceBarData() { var userId = User.Identity.GetUserId(); var tickets = db.Tickets.ToList(); var myData = new List <MorrisGraphData>(); MorrisGraphData data = null; if (User.IsInRole("Admin") || User.IsInRole("Manager")) { foreach (var priority in db.Priorities.ToList()) { data = new MorrisGraphData(); data.label = priority.Name; data.value = tickets.Where(t => t.Priority.Name == priority.Name).Count(); myData.Add(data); } } else if (User.IsInRole("Developer")) { foreach (var priority in db.Priorities.ToList()) { data = new MorrisGraphData(); data.label = priority.Name; data.value = tickets.Where(t => t.AssignedToUserId == userId).Where(t => t.Priority.Name == priority.Name).Count(); myData.Add(data); } } else if (User.IsInRole("Submitter")) { foreach (var priority in db.Priorities.ToList()) { data = new MorrisGraphData(); data.label = priority.Name; data.value = tickets.Where(t => t.OwnerId == userId).Where(t => t.Priority.Name == priority.Name).Count(); myData.Add(data); } } return(Json(myData)); }