private IEnumerable <Workorder> LoadFilledWorkorders() { using (var context = new ExampleOrderIntegration.WorkorderContext()) { return(context.Workorders .Where(w => w.FilledUTC != null) .Include(w => w.Parts) .AsNoTracking() .ToList()); } }
public SqliteWorkorderTest() { using (var context = new ExampleOrderIntegration.WorkorderContext()) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); } initialWorkorders = new List <Workorder>(); using (var context = new ExampleOrderIntegration.WorkorderContext()) { initialWorkorders.Add(new Workorder { WorkorderId = "work1", Priority = 100, DueDate = DateTime.Today.AddDays(5), Parts = new List <WorkorderDemand> { new WorkorderDemand { WorkorderId = "work1", Part = "part1", Quantity = 44 }, new WorkorderDemand { WorkorderId = "work1", Part = "part2", Quantity = 66 } } }); initialWorkorders.Add(new Workorder { WorkorderId = "work2", Priority = 200, DueDate = DateTime.Today.AddDays(15), Parts = new List <WorkorderDemand> { new WorkorderDemand { WorkorderId = "work2", Part = "part1", Quantity = 55 }, new WorkorderDemand { WorkorderId = "work2", Part = "part2", Quantity = 77 } } }); initialWorkorders.Add(new Workorder { WorkorderId = "work3", Priority = 300, DueDate = DateTime.Today.AddDays(30), Parts = new List <WorkorderDemand> { new WorkorderDemand { WorkorderId = "work3", Part = "part1", Quantity = 111 }, new WorkorderDemand { WorkorderId = "work3", Part = "part3", Quantity = 222 } } }); foreach (var w in initialWorkorders) { context.Workorders.Add(w); } context.SaveChanges(); } }