static void Main(string[] args)
{
var db = new CompetitionDbContext();
Console.WriteLine(db.Events.Count());
Console.ReadKey();
}
private static List <EventKanbanViewModel> GetEventKanbanData(CompetitionDbContext db)
{
List <EventKanbanViewModel> kanban = new List <EventKanbanViewModel>();
int id = 0;
foreach (Event item in db.Events.ToList())
{
EventKanbanViewModel kanbanitem = new EventKanbanViewModel();
kanbanitem.Id = id;
kanbanitem.EventId = item.Id;
kanbanitem.Event = item;
kanbanitem.Name = item.Name;
kanbanitem.Schedules_Registered = db.Schedules.Where(s => s.EventId == kanbanitem.EventId && s.Status == SchedulStatus.Registered).OrderBy(o => o.PlanBeginTime).ToList();
kanbanitem.Schedules_Waiting = db.Schedules.Where(s => s.EventId == kanbanitem.EventId && s.Status == SchedulStatus.Waiting).OrderBy(o => o.PlanBeginTime).Take(4).ToList();
kanbanitem.Schedules_Calling = db.Schedules.Where(s => s.EventId == kanbanitem.EventId && s.Status == SchedulStatus.Calling).OrderBy(o => o.PlanBeginTime).ToList();
kanbanitem.Schedules_InProgress = db.Schedules.Where(s => s.EventId == kanbanitem.EventId && s.Status == SchedulStatus.Inprogress).OrderBy(o => o.PlanBeginTime).ToList();
kanban.Add(kanbanitem);
id++;
}
return(kanban);
}
