public JsonResult Chart4Data()
{
var myData = new List <MorrisBarData>();
MorrisBarData data = null;
foreach (var user in roleHelp.UsersInRole("Developer").ToList().Union(roleHelp.UsersInRole("Demo_Developer").ToList()))
{
data = new MorrisBarData();
data.label = user.FullName;
data.value = db.Tickets.Where(t => t.AssignedToUserId == user.Id).Count();
myData.Add(data);
}
return(Json(myData));
}
public JsonResult Chart3Data()
{
var myData = new List <MorrisBarData>();
MorrisBarData data = null;
foreach (var types in db.TicketTypes.ToList())
{
data = new MorrisBarData();
data.label = types.Name;
data.value = db.Tickets.Where(t => t.TicketType.Name == types.Name).Count();
myData.Add(data);
}
return(Json(myData));
}
// GET: Graphing
public JsonResult Chart1Data()
{
var myData = new List <MorrisBarData>();
MorrisBarData data = null;
foreach (var priority in db.TicketPriorities.ToList())
{
data = new MorrisBarData();
data.label = priority.Name;
data.value = db.Tickets.Where(t => t.TicketPriority.Name == priority.Name).Count();
myData.Add(data);
}
return(Json(myData));
}
public JsonResult ProduceChart3Data()
{
var myData = new List <MorrisBarData>();
MorrisBarData data = null;
var userTickets = ticketHelper.ListMyTickets();
foreach (var type in db.TicketTypes.ToList())
{
data = new MorrisBarData();
data.label = type.TypeName;
data.value = userTickets.Where(t => t.TicketType.TypeName == type.TypeName).Count();
myData.Add(data);
}
return(Json(myData));
}
public JsonResult ProduceChart2Data()
{
var myData = new List <MorrisBarData>();
MorrisBarData data = null;
foreach (var status in db.TicketStatus.ToList())
{
myData.Add(new MorrisBarData
{
label = status.StatusName,
value = db.Tickets.Where(t => t.TicketStatus.StatusName == status.StatusName).Count()
});
}
return(Json(myData));
}
public JsonResult PMTicketPriorityChartData()
{
var myData = new List <MorrisBarData>();
MorrisBarData data = null;
var user = User.Identity.GetUserId();
foreach (var priority in db.TicketPriorities.ToList())
{
data = new MorrisBarData();
data.label = priority.PriorityName;
data.value = db.Tickets.Where(t => t.TicketPriority.PriorityName == priority.PriorityName).Count();
myData.Add(data);
}
return(Json(myData));
}
public JsonResult ProduceChart1Data()
{
var myData = new List <MorrisBarData>();
MorrisBarData data = null;
foreach (var priority in db.TicketPriorities.ToList())
{
data = new MorrisBarData();
data.label = priority.PriorityName;
var userTickets = ticketHelper.ListMyTickets();
data.value = userTickets.Where(t => t.TicketPriority.PriorityName == priority.PriorityName).Count();
myData.Add(data);
}
return(Json(myData));
}
public JsonResult ProduceChart1Data()
{
var userId = User.Identity.GetUserId();
var myData = new List <MorrisBarData>();
MorrisBarData data = null;
foreach (var account in db.BankAccounts.Where(bA => bA.OwnerId == userId).ToList())
{
data = new MorrisBarData();
data.label = account.Name;
data.value = account.CurrentBalance;
myData.Add(data);
}
return(Json(myData));
}
public JsonResult ProduceChart2Data()
{
var userId = User.Identity.GetUserId();
var user = db.Users.Find(userId);
var houseId = user.HouseholdId;
var myData = new List <MorrisBarData>();
MorrisBarData data = null;
foreach (var budget in db.Budgets.Where(b => b.HouseholdId == houseId).ToList())
{
data = new MorrisBarData();
data.label = budget.Name;
data.value = budget.TargetAmount;
myData.Add(data);
}
return(Json(myData));
}
