public override void LoadData()
{
base.LoadData();
TableOrderItems = BistroDatabase.Instance.Get <TableOrderItems>(DBQuery.GET_TABLE_ORDER_ITEMS).ToObservableCollection();
IEnumerable <Tables> tables = BistroDatabase.Instance.Get <Tables>(DBQuery.GET_TABLES);
IEnumerable <OrderItem> orderItems = BistroDatabase.Instance.Get <OrderItem>(DBQuery.GET_ORDER_ITEMS);
Tables.AddRange(tables);
OrderItems.AddRange(orderItems);
}
private static OrderItems PopulateOrderItems(IEnumerable <OrderInvoiceItem> orderItems)
{
var items = new OrderItems();
items.AddRange(orderItems.Select(item => new ServiceProvider.OrderSvc.OnlineOrderItem
{
SKU = item.Sku,
Quantity = item.Quantity,
Description = item.Description
}));
return(items);
}
public DataContext(DbContextOptions <DataContext> options) : base(options)
{
List <Customer> customers = new List <Customer>
{
new Customer
{
CustomerId = Guid.Parse("D066AFA6-1F64-4EBC-9EBD-71CE77C86171"),
Name = "Bob Smith",
Orders = new List <Order>
{
new Order
{
OrderId = Guid.Parse("690114E8-1107-492A-BEDD-19F3137757D2"),
Name = "Order One",
CustomerId = Guid.Parse("D066AFA6-1F64-4EBC-9EBD-71CE77C86171"),
OrderItems = new List <OrderItem>
{
new OrderItem
{
OrderItemId = Guid.NewGuid(),
Product = "Product 1",
OrderId = Guid.Parse("690114E8-1107-492A-BEDD-19F3137757D2")
},
new OrderItem
{
OrderItemId = Guid.NewGuid(),
Product = "Product 2",
OrderId = Guid.Parse("690114E8-1107-492A-BEDD-19F3137757D2")
}
}
},
new Order
{
OrderId = Guid.Parse("25E82EC3-F544-4F9D-B102-31C9EBBB2C60"),
Name = "Order Two",
CustomerId = Guid.Parse("D066AFA6-1F64-4EBC-9EBD-71CE77C86171"),
OrderItems = new List <OrderItem>
{
new OrderItem
{
OrderItemId = Guid.NewGuid(),
Product = "Product 1",
OrderId = Guid.Parse("25E82EC3-F544-4F9D-B102-31C9EBBB2C60")
},
new OrderItem
{
OrderItemId = Guid.NewGuid(),
Product = "Product 2",
OrderId = Guid.Parse("25E82EC3-F544-4F9D-B102-31C9EBBB2C60")
}
}
}
}
},
new Customer
{
CustomerId = Guid.Parse("CD5C3E08-76B9-4B51-B913-253CC16EF37C"), Name = "Jane Dough"
}
};
Customers.AddRange(customers);
Orders.AddRange(customers.SelectMany(c => c.Orders));
OrderItems.AddRange(customers.SelectMany(customer => customer.Orders)
.SelectMany(order => order.OrderItems));
SaveChanges();
}