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