public async Task InitializerBaseOrderStatus() { try { var oldOrderStatuses = _storeContext.OrderStatuses.ToList(); List <OrderStatus> newOrderStatuses = new List <OrderStatus>(); if (oldOrderStatuses.Where(os => os.Id == 1).FirstOrDefault() == null) { newOrderStatuses.Add(new OrderStatus() { Id = 1, Status = "Бронь" }); } if (oldOrderStatuses.Where(os => os.Id == 2).FirstOrDefault() == null) { newOrderStatuses.Add(new OrderStatus() { Id = 2, Status = "Поставлен" }); } if (oldOrderStatuses.Where(os => os.Id == 3).FirstOrDefault() == null) { newOrderStatuses.Add(new OrderStatus() { Id = 3, Status = "Выдан" }); } if (oldOrderStatuses.Where(os => os.Id == 4).FirstOrDefault() == null) { newOrderStatuses.Add(new OrderStatus() { Id = 4, Status = "Отменен" }); } if (newOrderStatuses.Count() > 0) { _storeContext.AddRange(newOrderStatuses); _storeContext.Database.OpenConnection(); _storeContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.OrderStatuses ON"); await _storeContext.SaveChangesAsync(); _storeContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.OrderStatuses OFF"); _storeContext.Database.CloseConnection(); } } catch (Exception ex) { _logger.LogError(ex, "Fail initialize order statuses"); } }
//Adding Diffrent Objects private static void AddDiffrentObjects() { var p6 = new Product { ProductName = "iPhone 6", UnitPrice = 3399 }; var c1 = new Customer { FirstName = "Marinel", LastName = "Dimitrije", Adress = "Gamla Göteborgsv. 18" }; using (var context = new StoreContext()) { context.AddRange(p6, c1); context.SaveChanges(); } }
public static void Initialize(StoreContext context) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); var categories = new Category[] { new Category { Code = "C01", Description = "Home" }, new Category { Code = "C02", Description = "Kitchen" }, new Category { Code = "C03", Description = "Bathroom" }, new Category { Code = "C04", Description = "Garden" }, new Category { Code = "C05", Description = "Decoration" }, new Category { Code = "C06", Description = "Furniture" } }; foreach (Category c in categories) { context.Categories.Add(c); } context.SaveChanges(); var types = new Type[] { new Type { Code = "S", Description = "small" }, new Type { Code = "L", Description = "large" } }; foreach (Type c in types) { context.Types.Add(c); } context.SaveChanges(); var units = new Unit[] { new Unit { Code = "ucc", Description = "USA" }, new Unit { Code = "add", Description = "Afrika" } }; foreach (Unit c in units) { context.Units.Add(c); } context.SaveChanges(); var products = new Product[] { new Product { Code = "001", Description = "Picture", DeliveryDate = DateTime.Parse("2018-09-01"), IsAvailable = true, Price = 12.0652M, Type = types[0], Unit = units[0] }, new Product { Code = "002", Description = "Mixer", DeliveryDate = DateTime.Parse("2003-09-01"), IsAvailable = true, Price = 222.210456456M, Type = types[0], Unit = units[1] }, new Product { Code = "003", Description = "chair", DeliveryDate = DateTime.Parse("2002-09-01"), IsAvailable = true, Price = 102.23454M, Type = types[0], Unit = units[0] }, new Product { Code = "004", Description = "chair2", DeliveryDate = DateTime.Parse("2002-09-01"), IsAvailable = true, Price = 512.5442M, Type = types[1], Unit = units[0] }, new Product { Code = "005", Description = "sofa", DeliveryDate = DateTime.Parse("2018-02-21"), IsAvailable = false, Price = 12.72M, Type = types[1], Unit = units[0] }, new Product { Code = "006", Description = "Capucinator", DeliveryDate = DateTime.Parse("2013-09-01"), IsAvailable = true, Price = 222.22M, Type = types[0], Unit = units[1] }, new Product { Code = "007", Description = "Light", DeliveryDate = DateTime.Parse("2012-09-01"), IsAvailable = true, Price = 102.12M, Type = types[0], Unit = units[0] }, new Product { Code = "008", Description = "Flower", DeliveryDate = DateTime.Parse("2002-06-01"), IsAvailable = true, Price = 52.24M, Type = types[1], Unit = units[0] }, }; foreach (Product s in products) { context.Products.Add(s); } context.SaveChanges(); context.AddRange( new ProductCategory { Product = products[0], Category = categories[0] }, new ProductCategory { Product = products[0], Category = categories[1] }, new ProductCategory { Product = products[0], Category = categories[2] }, new ProductCategory { Product = products[1], Category = categories[0] }, new ProductCategory { Product = products[1], Category = categories[1] }, new ProductCategory { Product = products[2], Category = categories[2] }, new ProductCategory { Product = products[3], Category = categories[3] }, new ProductCategory { Product = products[4], Category = categories[0] }, new ProductCategory { Product = products[5], Category = categories[5] }, new ProductCategory { Product = products[5], Category = categories[0] }, new ProductCategory { Product = products[5], Category = categories[1] }, new ProductCategory { Product = products[6], Category = categories[0] }, new ProductCategory { Product = products[6], Category = categories[1] }, new ProductCategory { Product = products[6], Category = categories[2] }, new ProductCategory { Product = products[6], Category = categories[3] }, new ProductCategory { Product = products[6], Category = categories[5] }, new ProductCategory { Product = products[7], Category = categories[0] }, new ProductCategory { Product = products[7], Category = categories[3] }, new ProductCategory { Product = products[7], Category = categories[4] } ); context.SaveChanges(); }