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); }