public ColorsController(FireFlyFireworksContext context) { _context = context; }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new FireFlyFireworksContext( serviceProvider.GetRequiredService < DbContextOptions <FireFlyFireworksContext> >())) { // Look for any movies. if (context.Customer.Any()) { return; // DB has been seeded } context.Customer.AddRange( new Customer { FirstMidName = "Reba", LastName = "McEntire", OrderDate = DateTime.Parse("2020-12-11") }, new Customer { FirstMidName = "Buddy", LastName = "Holly", OrderDate = DateTime.Parse("2020-12-01") }, new Customer { FirstMidName = "Dolly", LastName = "Parton", OrderDate = DateTime.Parse("2020-11-01") }, new Customer { FirstMidName = "Megan", LastName = "TheeStallion", OrderDate = DateTime.Parse("2020-11-01") }, new Customer { FirstMidName = "Johnny", LastName = "Cash", OrderDate = DateTime.Parse("2020-12-01") }, new Customer { FirstMidName = "Tammy", LastName = "Wynette", OrderDate = DateTime.Parse("2020-11-01") }, new Customer { FirstMidName = "Doja", LastName = "Cat", OrderDate = DateTime.Parse("2020-12-01") }, new Customer { FirstMidName = "Stevie", LastName = "Nicks", OrderDate = DateTime.Parse("2020-09-01") }, new Customer { FirstMidName = "Cardi", LastName = "B", OrderDate = DateTime.Parse("2020-09-01") } ); context.SaveChanges(); context.Color.AddRange( new Color { ColorID = 6002, ColorName = "Rose Pink", Price = 25.55, ColorFamID = 1, ColorFamName = "Red" }, new Color { ColorID = 6121, ColorName = "Saturn Orange", Price = 14.18, ColorFamID = 2, ColorFamName = "Orange" }, new Color { ColorID = 6404, ColorName = "Vanadium", Price = 32.27, ColorFamID = 3, ColorFamName = "Yellow" }, new Color { ColorID = 6166, ColorName = "Camel Beige", Price = 14.00, ColorFamID = 2, ColorFamName = "Orange" }, new Color { ColorID = 6006, ColorName = "Deep Crimson", Price = 25.00, ColorFamID = 1, ColorFamName = "Red" }, new Color { ColorID = 6020, ColorName = "Alumina Pink", Price = 14.45, ColorFamID = 1, ColorFamName = "Red" }, new Color { ColorID = 6126, ColorName = "Hazelnut", Price = 17.27, ColorFamID = 2, ColorFamName = "Orange" } ); context.SaveChanges(); context.Order.AddRange( new Order { ColorID = 6002, CustomerID = 0001 }, new Order { ColorID = 6121, CustomerID = 0002 }, new Order { ColorID = 6404, CustomerID = 0003 }, new Order { ColorID = 6002, CustomerID = 0004 }, new Order { ColorID = 6166, CustomerID = 0005 }, new Order { ColorID = 6006, CustomerID = 0006 }, new Order { ColorID = 6166, CustomerID = 0007 }, new Order { ColorID = 6006, CustomerID = 0008 }, new Order { ColorID = 6006, CustomerID = 0009 } ); context.SaveChanges(); context.Chem.AddRange( new Chem { ChemID = 101, ChemComp = "Chromium, Strontium", ChemAbbrev = "CrSn", ColorID = 6002, WarehouseLocationID = 1 }, new Chem { ChemID = 102, ChemComp = "Chromium, Iron, Zinc, Aluminum, Silicon", ChemAbbrev = "CrFeZnAlSi", ColorID = 6404, WarehouseLocationID = 2 }, new Chem { ChemID = 103, ChemComp = "Strontium, Vanadium", ChemAbbrev = "SnV", ColorID = 6404, WarehouseLocationID = 2 }, new Chem { ChemID = 104, ChemComp = "Chromium, Iron, Zinc, Aluminum, Cobalt, Manganese", ChemAbbrev = "CrFeZnAlCoMn", ColorID = 6166, WarehouseLocationID = 3 }, new Chem { ChemID = 105, ChemComp = "Manganese, Aluminum", ChemAbbrev = "MnAl", ColorID = 6020, WarehouseLocationID = 1 }, new Chem { ChemID = 106, ChemComp = "Chromium, Iron, Zinc, Aluminum", ChemAbbrev = "CrFeZnAl", ColorID = 6126, WarehouseLocationID = 3 }, new Chem { ChemID = 107, ChemComp = "Chromium, Strontium", ChemAbbrev = "CrSn", ColorID = 6006, WarehouseLocationID = 2 } ); context.SaveChanges(); } }
public CustomersController(FireFlyFireworksContext context) { _context = context; }
public OrdersController(FireFlyFireworksContext context) { _context = context; }