private static IEnumerable <Chart> GetChartData(WMTestDbContext db, int idUser)
{
var emails = db.Emails.Include(x => x.Sender).Where(x => x.Sender.ID == idUser).ToList();
var lstChart = new List <Chart>()
{
new Chart("Monday", emails.Count(e => e.SentDate.DayOfWeek == DayOfWeek.Monday))
{
Color = "Green"
},
new Chart("Tuesday", emails.Count(e => e.SentDate.DayOfWeek == DayOfWeek.Tuesday))
{
Color = "Yellow"
},
new Chart("Wednesday", emails.Count(e => e.SentDate.DayOfWeek == DayOfWeek.Wednesday))
{
Color = "Red"
},
new Chart("Thursday", emails.Count(e => e.SentDate.DayOfWeek == DayOfWeek.Thursday))
{
Color = "Blue"
},
new Chart("Friday", emails.Count(e => e.SentDate.DayOfWeek == DayOfWeek.Friday))
{
Color = "Black"
},
new Chart("Saturday", emails.Count(e => e.SentDate.DayOfWeek == DayOfWeek.Saturday))
{
Color = "Orange"
},
new Chart("Sunday", emails.Count(e => e.SentDate.DayOfWeek == DayOfWeek.Sunday))
{
Color = "Gray"
}
};
return(lstChart);
}
private static IEnumerable <Email> GetEmails(WMTestDbContext db, int idUser)
{
return(db.Emails.Include(x => x.Sender).Where(x => x.Sender.ID == idUser).ToList());
}
