public static async Task InitializeAsync(ShoppingContext context)
{
if (await context.Database.EnsureCreatedAsync())
{
return;
}
if (context.Customers.Any())
{
return;
}
CustomerModel[] customers = new CustomerModel[]
{
new CustomerModel {
FirstName = "Carson", LastName = "Alexander", Address = "Lviv", Discount = "5"
},
new CustomerModel {
FirstName = "Meredith", LastName = "Alonso", Address = "Kyiv", Discount = "65"
},
new CustomerModel {
FirstName = "Arturo", LastName = "Anand", Address = "Mykolaiv", Discount = "3"
},
new CustomerModel {
FirstName = "Gytis", LastName = "Barzdukas", Address = "Odessa", Discount = "56"
},
new CustomerModel {
FirstName = "Yan", LastName = "Li", Address = "Lviv", Discount = "22"
},
new CustomerModel {
FirstName = "Peggy", LastName = "Justice", Address = "Lviv", Discount = "15"
},
new CustomerModel {
FirstName = "Laura", LastName = "Norman", Address = "Kyiv", Discount = "15"
},
new CustomerModel {
FirstName = "Nino", LastName = "Olivetto", Address = "London", Discount = "10"
}
};
await context.Customers.AddRangeAsync(customers);
await context.SaveChangesAsync();
ProductModel[] products = new ProductModel[]
{
new ProductModel {
Name = "iPhone X", Price = 1250
},
new ProductModel {
Name = "iPhone Xr", Price = 1350
},
new ProductModel {
Name = "iPhone XS", Price = 1450
},
new ProductModel {
Name = "iPhone 5", Price = 350
},
new ProductModel {
Name = "iPhone 6", Price = 400
},
new ProductModel {
Name = "iPhone 7", Price = 500
},
new ProductModel {
Name = "iPhone 8", Price = 600
},
new ProductModel {
Name = "iPhone 4", Price = 250
}
};
await context.Products.AddRangeAsync(products);
await context.SaveChangesAsync();
SupermarketModel[] supermarkets = new SupermarketModel[]
{
new SupermarketModel {
Address = "Lviv", Name = "Silpo"
},
new SupermarketModel {
Address = "Kyiv", Name = "Silpo"
},
new SupermarketModel {
Address = "Lviv", Name = "Metro"
},
new SupermarketModel {
Address = "Mykolaiv", Name = "Nash Kray"
},
new SupermarketModel {
Address = "Lviv", Name = "Rukavychka"
},
new SupermarketModel {
Address = "Mykolaiv", Name = "Rukavychka"
},
new SupermarketModel {
Address = "Kyiv", Name = "Rukavychka"
}
};
await context.Supermarkets.AddRangeAsync(supermarkets);
await context.SaveChangesAsync();
List <Object>[] orders = new List <Object>[]
{
new List <Object>
{
new OrderModel {
CustomerModelId = 2, SupermarketModelId = 3, OrderDate = new DateTime(2012, 6, 3)
},
new OrderDetailsModel {
ProductModel = products[0], Quantity = 2
},
new OrderDetailsModel {
ProductModel = products[1], Quantity = 2
}
},
new List <Object>
{
new OrderModel {
CustomerModelId = 1, SupermarketModelId = 6, OrderDate = new DateTime(2015, 7, 3)
},
new OrderDetailsModel {
ProductModel = products[1], Quantity = 1
},
new OrderDetailsModel {
ProductModel = products[3], Quantity = 13
}
},
new List <Object>
{
new OrderModel {
CustomerModelId = 5, SupermarketModelId = 2, OrderDate = new DateTime(2011, 4, 3)
},
new OrderDetailsModel {
ProductModel = products[3], Quantity = 9
},
new OrderDetailsModel {
ProductModel = products[4], Quantity = 4
}
},
new List <Object>
{
new OrderModel {
CustomerModelId = 4, SupermarketModelId = 3, OrderDate = new DateTime(2016, 2, 3)
},
new OrderDetailsModel {
ProductModel = products[4], Quantity = 15
},
new OrderDetailsModel {
ProductModel = products[5], Quantity = 3
},
},
new List <Object>
{
new OrderModel {
CustomerModelId = 4, SupermarketModelId = 5, OrderDate = new DateTime(2018, 8, 3)
},
new OrderDetailsModel {
ProductModel = products[6], Quantity = 7
},
new OrderDetailsModel {
ProductModel = products[1], Quantity = 17
}
}
};
foreach (List <Object> item in orders)
{
OrderModel order = (OrderModel)item[0];
context.Orders.Add(order);
await context.SaveChangesAsync();
OrderDetailsModel details1 = ((OrderDetailsModel)item[1]);
details1.OrderId = order.Id;
details1.Order = order;
context.OrderDetails.Add(details1);
await context.SaveChangesAsync();
OrderDetailsModel details2 = ((OrderDetailsModel)item[2]);
details2.OrderId = order.Id;
details2.Order = order;
context.OrderDetails.Add(details2);
await context.SaveChangesAsync();
}
}
public static void Initialize(ShoppingContext context)
{
context.Database.EnsureCreated();
if (context.Customers.Any())
{
return;
}
Customer[] customers = new Customer[]
{
new Customer {
Id = 1, FirstName = "Ramil", LastName = "Naum", Address = "Los-Ang", Discount = "5"
},
new Customer {
Id = 2, FirstName = "Bob", LastName = "Dillan", Address = "Berlin", Discount = "7"
},
new Customer {
Id = 3, FirstName = "Kile", LastName = "Rise", Address = "London", Discount = "0"
},
new Customer {
Id = 4, FirstName = "John", LastName = "Konor", Address = "Vashington", Discount = "3"
},
new Customer {
Id = 5, FirstName = "Tony", LastName = "Stark", Address = "Florida", Discount = "5"
},
new Customer {
Id = 6, FirstName = "Jamie", LastName = "Lanister", Address = "Westerros", Discount = "10"
},
};
foreach (Customer customer in customers)
{
context.Customers.Add(customer);
}
context.SaveChanges();
Product[] products = new Product[]
{
new Product {
Name = "Asus laptop x550", Price = 880
},
new Product {
Name = "Iphone X", Price = 1200
},
new Product {
Name = "Samsung Galaxy X9", Price = 1100
},
new Product {
Name = "Mouse Loditec", Price = 100
},
new Product {
Name = "Keyboard Logitec", Price = 200
},
new Product {
Name = "Monitor Dell", Price = 320
},
new Product {
Name = "TV LG", Price = 1300
},
};
foreach (Product product in products)
{
context.Products.Add(product);
}
context.SaveChanges();
Supermarket[] supermarkets = new Supermarket[]
{
new Supermarket {
Name = "Rozetka", Address = "Petrovka district"
},
new Supermarket {
Name = "Comfy", Address = "Obolonsky district"
},
new Supermarket {
Name = "Foxtrot", Address = "Pechercka district"
},
new Supermarket {
Name = "Allo", Address = "Shevchenka district"
},
new Supermarket {
Name = "Citrus", Address = "Obolon, Drea Town"
},
new Supermarket {
Name = "Moyo", Address = "Skymall Troeshina"
},
new Supermarket {
Name = "Stilus", Address = "Svyatosino"
},
};
foreach (Supermarket supermarket in supermarkets)
{
context.Supermarkets.Add(supermarket);
}
context.SaveChanges();
Order[] orders = new Order[]
{
new Order {
CustomerId = 1, SupermarketId = 1, OrderDate = DateTime.Parse("4-11-2019")
},
new Order {
CustomerId = 1, SupermarketId = 2, OrderDate = DateTime.Parse("5-6-2020")
},
new Order {
CustomerId = 2, SupermarketId = 3, OrderDate = DateTime.Parse("2-11-2018")
},
new Order {
CustomerId = 3, SupermarketId = 4, OrderDate = DateTime.Parse("7-7-2020")
},
new Order {
CustomerId = 4, SupermarketId = 2, OrderDate = DateTime.Parse("1-8-2020")
},
new Order {
CustomerId = 5, SupermarketId = 3, OrderDate = DateTime.Parse("9-3-2019")
},
new Order {
CustomerId = 6, SupermarketId = 3, OrderDate = DateTime.Parse("12-12-2020")
},
};
foreach (Order order in orders)
{
context.Orders.Add(order);
}
context.SaveChanges();
OrderDetails[] ordersDetails = new OrderDetails[]
{
new OrderDetails {
OrderId = 1, ProductId = 1, Quantity = 2
},
new OrderDetails {
OrderId = 1, ProductId = 4, Quantity = 9
},
new OrderDetails {
OrderId = 1, ProductId = 5, Quantity = 7
},
new OrderDetails {
OrderId = 2, ProductId = 2, Quantity = 1
},
new OrderDetails {
OrderId = 3, ProductId = 3, Quantity = 2
},
new OrderDetails {
OrderId = 4, ProductId = 4, Quantity = 5
},
new OrderDetails {
OrderId = 5, ProductId = 5, Quantity = 11
},
new OrderDetails {
OrderId = 5, ProductId = 7, Quantity = 2
},
new OrderDetails {
OrderId = 6, ProductId = 6, Quantity = 4
},
new OrderDetails {
OrderId = 7, ProductId = 3, Quantity = 6
},
new OrderDetails {
OrderId = 7, ProductId = 7, Quantity = 2
},
};
foreach (OrderDetails orderDetails in ordersDetails)
{
context.OrdersDetails.Add(orderDetails);
}
context.SaveChanges();
}
public static void Initialize(ShoppingContext context)
{
if (context.Products.Any())
{
return;
}
context.Products.AddRange(
new Product
{
Name = "Butter",
Price = 30.0
},
new Product
{
Name = "Bread",
Price = 18.5
},
new Product
{
Name = "Milk",
Price = 20.0
},
new Product
{
Name = "Chocolate",
Price = 25.5
},
new Product
{
Name = "Apples",
Price = 15.0
}
);
context.SaveChanges();
context.Customers.AddRange(
new Customer
{
FirstName = "Oksana",
LastName = "Ivaniuk",
Address = "Ivano-Frankivsk",
Discount = 5
},
new Customer
{
FirstName = "Ivan",
LastName = "Slobodian",
Address = "Lviv",
Discount = 10
},
new Customer
{
FirstName = "Ivanna",
LastName = "Tomyn",
Address = "Chernivtsi",
Discount = 15
}
);
context.SaveChanges();
context.SuperMarkets.AddRange(
new SuperMarket
{
Name = "Silpo",
Address = "Ivano-Frankivsk, Golovna,254 str."
},
new SuperMarket
{
Name = "ATB",
Address = "Chernivtsy, Komarova,3 str."
},
new SuperMarket
{
Name = "Metro",
Address = "Lviv, Vilshunu,10 str."
},
new SuperMarket
{
Name = "Epicentr",
Address = "Nadvirna, Xotunska,15 str."
}
);
context.SaveChanges();
context.Orders.AddRange(
new Order
{
CustomerId = 1,
SuperMarketId = 1,
OrderDate = DateTime.Parse("2020-08-24")
},
new Order
{
CustomerId = 2,
SuperMarketId = 2,
OrderDate = DateTime.Parse("2020-08-25")
}
);
context.SaveChanges();
context.OrderDetails.AddRange(
new OrderDetail
{
OrderId = 1,
ProductId = 1,
Quantity = 2
},
new OrderDetail
{
OrderId = 1,
ProductId = 2,
Quantity = 5
},
new OrderDetail
{
OrderId = 1,
ProductId = 4,
Quantity = 1
}
);
context.SaveChanges();
}
