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