public CustomersController(HaberdasheryContext context) { _context = context; }
public HomeController(HaberdasheryContext context) { _context = context; }
public FabricsController(HaberdasheryContext context) { _context = context; }
public static void Initialize(HaberdasheryContext context) { context.Database.EnsureCreated(); if (context.Fabrics.Any()) { return; // BD a fost creata anterior } var fabrics = new Fabric[] { new Fabric { Type = "Wool", Color = "white", Price = Decimal.Parse("21") }, new Fabric { Type = "Wool", Color = "red", Price = Decimal.Parse("25") }, new Fabric { Type = "Silk", Color = "purple", Price = Decimal.Parse("40") }, new Fabric { Type = "Silk", Color = "gold", Price = Decimal.Parse("45") }, new Fabric { Type = "Cotton", Color = "green", Price = Decimal.Parse("15") }, new Fabric { Type = "Cotton", Color = "yeloow", Price = Decimal.Parse("13") }, }; foreach (Fabric f in fabrics) { context.Fabrics.Add(f); } context.SaveChanges(); var customers = new Customer[] { new Customer { CustomerID = 1050, Name = "Ionescu Mirela", BirthDate = DateTime.Parse("1979-09-01") }, new Customer { CustomerID = 1045, Name = "Pricope Stefan", BirthDate = DateTime.Parse("1998-01-02") }, }; foreach (Customer c in customers) { context.Customers.Add(c); } context.SaveChanges(); var orders = new Order[] { new Order { FabricID = 1, CustomerID = 1050, OrderDate = DateTime.Parse("02-10-2020") }, new Order { FabricID = 3, CustomerID = 1045, OrderDate = DateTime.Parse("09-05-2020") }, new Order { FabricID = 1, CustomerID = 1045, OrderDate = DateTime.Parse("10-03-2020") }, new Order { FabricID = 2, CustomerID = 1050, OrderDate = DateTime.Parse("09-12-2020") }, new Order { FabricID = 4, CustomerID = 1050, OrderDate = DateTime.Parse("09-06-2020") }, new Order { FabricID = 6, CustomerID = 1050, OrderDate = DateTime.Parse("10-09-2020") }, }; foreach (Order o in orders) { context.Orders.Add(o); } context.SaveChanges(); var weavers = new Weaver[] { new Weaver { WeaverName = "Anghelescu Raluca", Specialty = "Wool" }, new Weaver { WeaverName = "Ionescu Voileta", Specialty = "Silk" }, new Weaver { WeaverName = "Marin Rica", Specialty = "Cotton" }, }; foreach (Weaver w in weavers) { context.Weavers.Add(w); } context.SaveChanges(); var fabricsweaved = new FabricWeaved[] { new FabricWeaved { FabricID = fabrics.Single(c => c.Type == "Wool").ID, WeaverID = weavers.Single(i => i.WeaverName == "Anghelescu Raluca").ID }, new FabricWeaved { FabricID = fabrics.Single(c => c.Type == "Silk").ID, WeaverID = weavers.Single(i => i.WeaverName == "Ionescu Voileta").ID }, new FabricWeaved { FabricID = fabrics.Single(c => c.Type == "Cotton").ID, WeaverID = weavers.Single(i => i.WeaverName == "Marin Rica").ID }, }; foreach (FabricWeaved fw in fabricsweaved) { context.FabricWeaved.Add(fw); } context.SaveChanges(); }
public WeaversController(HaberdasheryContext context) { _context = context; }