public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new HomekitDbContext(
serviceProvider.GetRequiredService <
DbContextOptions <HomekitDbContext> >()))
{
// Look for Categories
if (context.Category.Any())
{
return; // DB has been seeded
}
context.Category.AddRange(
// 1
new Category
{
CategoryName = "Bridges",
},
// 2
new Category
{
CategoryName = "Cameras",
},
// 3
new Category
{
CategoryName = "Lights & Blulbs",
},
// 4
new Category
{
CategoryName = "Locks",
},
// 5
new Category
{
CategoryName = "Outlets",
},
// 6
new Category
{
CategoryName = "Sensors",
},
// 7
new Category
{
CategoryName = "Switches",
},
// 8
new Category
{
CategoryName = "Thermostats",
}
);
context.SaveChanges();
// Look for Brands
if (context.Brand.Any())
{
return; // DB has been seeded
}
context.Brand.AddRange(
// 1
new Brand
{
BrandName = "August",
},
// 2
new Brand
{
BrandName = "Belkin",
},
// 3
new Brand
{
BrandName = "D-Link",
},
// 4
new Brand
{
BrandName = "ecobee",
},
// 5
new Brand
{
BrandName = "Eve",
},
// 6
new Brand
{
BrandName = "FIBARO",
},
// 7
new Brand
{
BrandName = "Honeywell",
},
// 8
new Brand
{
BrandName = "iDevices",
},
// 9
new Brand
{
BrandName = "iHome",
},
// 10
new Brand
{
BrandName = "Incipio",
},
// 11
new Brand
{
BrandName = "Leviton",
},
// 12
new Brand
{
BrandName = "LIFX",
},
// 13
new Brand
{
BrandName = "Logitech",
},
// 14
new Brand
{
BrandName = "Lutron",
},
// 15
new Brand
{
BrandName = "Nanoleaf",
},
// 16
new Brand
{
BrandName = "Netgear",
},
// 17
new Brand
{
BrandName = "Philips",
},
// 18
new Brand
{
BrandName = "Pure Gear",
},
// 19
new Brand
{
BrandName = "Rachio",
},
// 20
new Brand
{
BrandName = "Schlage",
},
// 21
new Brand
{
BrandName = "Sylvania",
},
// 22
new Brand
{
BrandName = "Yale",
}
);
context.SaveChanges();
// Look for Products
if (context.Product.Any())
{
return;
}
context.Product.AddRange(
// Bridges
new Product {
ProductName = "Philips Hue White and Color Wireless Ambiance Starter Kit A19 E26",
ProductPrice = 149.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(1)
},
new Product {
ProductName = "Philips Hue White Starter Kit A19 E26",
ProductPrice = 69.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(1)
},
new Product {
ProductName = "Philips Hue White Ambiance A19 Starter Kit",
ProductPrice = 99.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(1)
},
new Product {
ProductName = "Wemo Bridge",
ProductPrice = 29.95M,
//product image
Brand = context.Brand.Find(2),
Category = context.Category.Find(1)
},
new Product {
ProductName = "Philips HUE HomeKit Upgrade Bridge (for Current HUE Bridge Users)",
ProductPrice = 59.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(1)
},
// Cameras
new Product {
ProductName = "Logitech Circle 2 Indoor/Outdoor Weatherproof Wired Security Camera",
ProductPrice = 179.95M,
//product image
Brand = context.Brand.Find(),
Category = context.Category.Find(2)
},
new Product {
ProductName = "Logitech Circle 2 Window Mount for Circle 2 Wired Security Camera",
ProductPrice = 39.95M,
//product image
Brand = context.Brand.Find(13),
Category = context.Category.Find(2)
},
new Product {
ProductName = "D-Link Omna 180 Cam HD Camera",
ProductPrice = 129.95M,
//product image
Brand = context.Brand.Find(3),
Category = context.Category.Find(2)
},
new Product {
ProductName = "Arlo Baby 1080p HD Monitoring Camera by NETGEAR",
ProductPrice = 189.95M,
//product image
Brand = context.Brand.Find(16),
Category = context.Category.Find(2)
},
// Lights & Blulbs
new Product {
ProductName = "Philips Hue White and Color Wireless Ambiance Starter Kit A19 E26",
ProductPrice = 149.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(3)
},
new Product {
ProductName = "Nanoleaf Canvas Smarter Light Kit",
ProductPrice = 229.95M,
//product image
Brand = context.Brand.Find(15),
Category = context.Category.Find(3)
},
new Product {
ProductName = "Nanoleaf Light Panel Smarter Kits - Rhythm Edition",
ProductPrice = 199.95M,
//product image
Brand = context.Brand.Find(15),
Category = context.Category.Find(3)
},
new Product {
ProductName = "Philips Hue White Starter Kit A19 E26",
ProductPrice = 69.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(3)
},
new Product {
ProductName = "Philips Hue White Ambiance A19 Starter Kit",
ProductPrice = 99.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(3)
},
new Product {
ProductName = "Nanoleaf Remote",
ProductPrice = 49.95M,
//product image
Brand = context.Brand.Find(15),
Category = context.Category.Find(3)
},
new Product {
ProductName = "Incipio CommandKit Smart Light Bulb Adapter with Dimming",
ProductPrice = 39.95M,
//product image
Brand = context.Brand.Find(10),
Category = context.Category.Find(3)
},
new Product {
ProductName = "LIFX Mini White (2700K Warm) A19 E26 Wi-Fi Smart LED Light Bulb",
ProductPrice = 19.95M,
//product image
Brand = context.Brand.Find(12),
Category = context.Category.Find(3)
},
new Product {
ProductName = "Philips Hue Ambiance White and Color Extension Bulb A19 E26",
ProductPrice = 49.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(3)
},
new Product {
ProductName = "Philips Hue White and Color Ambiance LED Flood Light Bulb BR30",
ProductPrice = 49.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(3)
},
new Product {
ProductName = "Philips Hue White Ambiance A19 Bulb",
ProductPrice = 29.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(3)
},
new Product {
ProductName = "Philips Hue White Ambiance Wireless LED Flood Light BR30",
ProductPrice = 29.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(3)
},
new Product {
ProductName = "Philips Hue Lightstrip Plus",
ProductPrice = 89.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(3)
},
new Product {
ProductName = "Philips Hue White Extension Bulb A19 E26",
ProductPrice = 14.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(3)
},
new Product {
ProductName = "LIFX Mini Color and White A19 E26 Wi-Fi Smart LED Light Bulb",
ProductPrice = 44.95M,
//product image
Brand = context.Brand.Find(12),
Category = context.Category.Find(3)
},
new Product {
ProductName = "Philips Hue Lightstrip Plus Extension Set (3 ft./1 m)",
ProductPrice = 29.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(3)
},
new Product {
ProductName = "Philips Hue Go",
ProductPrice = 79.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(3)
},
new Product {
ProductName = "Philips Hue White and Color Ambiance LED Candle Bulb E12/B39",
ProductPrice = 49.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(3)
},
new Product {
ProductName = "LIFX Multicolor A19 E26 Dimmable Wi-Fi Smart LED Light Bulb",
ProductPrice = 59.95M,
//product image
Brand = context.Brand.Find(12),
Category = context.Category.Find(3)
},
new Product {
ProductName = "LIFX Mini Day & Dusk (White to Amber Spectrum) A19 E26 Wi-Fi Smart LED Light Bulb",
ProductPrice = 29.95M,
//product image
Brand = context.Brand.Find(12),
Category = context.Category.Find(3)
},
new Product {
ProductName = "LIFX + Infrared Multicolor A19 E26 Dimmable Wi-Fi Smart LED Light Bulb",
ProductPrice = 79.95M,
//product image
Brand = context.Brand.Find(12),
Category = context.Category.Find(3)
},
new Product {
ProductName = "Philips Hue White Ambiance LED Candle Bulb E12/B39",
ProductPrice = 29.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(3)
},
new Product {
ProductName = "SYLVANIA SMART+ Bluetooth Soft White Filament Bulb A19",
ProductPrice = 34.95M,
//product image
Brand = context.Brand.Find(21),
Category = context.Category.Find(3)
},
// Locks
new Product {
ProductName = "August Smart Lock Pro + Connect",
ProductPrice = 279.95M,
//product image
Brand = context.Brand.Find(1),
Category = context.Category.Find(4)
},
new Product {
ProductName = "Yale Assure Lock SL with iM1",
ProductPrice = 199.95M,
//product image
Brand = context.Brand.Find(22),
Category = context.Category.Find(4)
},
new Product {
ProductName = "Schlage Sense Smart Deadbolt with Century Trim",
ProductPrice = 229.95M,
//product image
Brand = context.Brand.Find(20),
Category = context.Category.Find(4)
},
new Product {
ProductName = "Schlage Sense Smart Deadbolt with Camelot Trim",
ProductPrice = 229.95M,
//product image
Brand = context.Brand.Find(20),
Category = context.Category.Find(4)
},
//Outlets
new Product {
ProductName = "Wemo Mini Smart Plug",
ProductPrice = 29.95M,
//product image
Brand = context.Brand.Find(2),
Category = context.Category.Find(5)
},
new Product {
ProductName = "iDevices Switch",
ProductPrice = 29.95M,
//product image
Brand = context.Brand.Find(8),
Category = context.Category.Find(5)
},
new Product {
ProductName = "Incipio CommandKit Wireless Smart Outlet With Metering",
ProductPrice = 39.95M,
//product image
Brand = context.Brand.Find(10),
Category = context.Category.Find(5)
},
new Product {
ProductName = "iDevices Socket",
ProductPrice = 49.95M,
//product image
Brand = context.Brand.Find(8),
Category = context.Category.Find(5)
},
new Product {
ProductName = "iHome | control iSP6 SmartPlug",
ProductPrice = 39.95M,
//product image
Brand = context.Brand.Find(9),
Category = context.Category.Find(5)
},
new Product {
ProductName = "iHome | control iSP8 SmartPlug with Remote Control",
ProductPrice = 49.95M,
//product image
Brand = context.Brand.Find(9),
Category = context.Category.Find(5)
},
new Product {
ProductName = "Eve Energy",
ProductPrice = 39.95M,
//product image
Brand = context.Brand.Find(5),
Category = context.Category.Find(5)
},
new Product {
ProductName = "Pure Gear PureSwitch Wireless Smart Plug Apple HomeKit",
ProductPrice = 49.95M,
//product image
Brand = context.Brand.Find(18),
Category = context.Category.Find(5)
},
//Sensors
new Product {
ProductName = "FIBARO Flood Sensor (HomeKit Enabled)",
ProductPrice = 69.95M,
//product image
Brand = context.Brand.Find(6),
Category = context.Category.Find(6)
},
new Product {
ProductName = "iHome | control iSS50 5-in-1 Smart Monitor",
ProductPrice = 49.95M,
//product image
Brand = context.Brand.Find(9),
Category = context.Category.Find(6)
},
new Product {
ProductName = "Eve Aqua Smart Water Controller",
ProductPrice = 99.95M,
//product image
Brand = context.Brand.Find(5),
Category = context.Category.Find(6)
},
new Product {
ProductName = "Eve Degree Connected Weather Station",
ProductPrice = 69.95M,
//product image
Brand = context.Brand.Find(5),
Category = context.Category.Find(6)
},
new Product {
ProductName = "Eve Room Indoor Air Quality Monitor",
ProductPrice = 99.95M,
//product image
Brand = context.Brand.Find(5),
Category = context.Category.Find(6)
},
new Product {
ProductName = "Eve Door & Window Wireless Contact Sensor",
ProductPrice = 39.95M,
//product image
Brand = context.Brand.Find(5),
Category = context.Category.Find(6)
},
new Product {
ProductName = "Eve Motion Wireless Motion Sensor",
ProductPrice = 49.95M,
//product image
Brand = context.Brand.Find(5),
Category = context.Category.Find(6)
},
new Product {
ProductName = "Eve Button - Connected Home Remote",
ProductPrice = 49.95M,
//product image
Brand = context.Brand.Find(5),
Category = context.Category.Find(6)
},
//Switches
new Product {
ProductName = "Eve Light Switch",
ProductPrice = 49.95M,
//product image
Brand = context.Brand.Find(5),
Category = context.Category.Find(8)
},
new Product {
ProductName = "Leviton Decora Smart 600W Dimmer",
ProductPrice = 49.95M,
//product image
Brand = context.Brand.Find(11),
Category = context.Category.Find(8)
},
new Product {
ProductName = "Leviton Decora Smart 15 Amp Switch",
ProductPrice = 44.95M,
//product image
Brand = context.Brand.Find(11),
Category = context.Category.Find(8)
},
new Product {
ProductName = "Lutron Caséta Wireless In-Wall Light Dimmer with Remote",
ProductPrice = 59.95M,
//product image
Brand = context.Brand.Find(14),
Category = context.Category.Find(8)
},
new Product {
ProductName = "Lutron Caséta Wireless Smart Lighting Dimmer Switch Starter Kit",
ProductPrice = 99.95M,
//product image
Brand = context.Brand.Find(14),
Category = context.Category.Find(8)
},
new Product {
ProductName = "Philips Hue tap Switch",
ProductPrice = 49.95M,
//product image
Brand = context.Brand.Find(17),
Category = context.Category.Find(8)
},
new Product {
ProductName = "iDevices Outdoor Switch",
ProductPrice = 79.95M,
//product image
Brand = context.Brand.Find(8),
Category = context.Category.Find(8)
},
new Product {
ProductName = "FIBARO Button Multicontroller",
ProductPrice = 59.95M,
//product image
Brand = context.Brand.Find(6),
Category = context.Category.Find(8)
},
new Product {
ProductName = "Leviton Decora Smart 1000W Dimmer",
ProductPrice = 54.95M,
//product image
Brand = context.Brand.Find(11),
Category = context.Category.Find(8)
},
//Thermostats
new Product {
ProductName = "iDevices Thermostat",
ProductPrice = 129.95M,
//product image
Brand = context.Brand.Find(8),
Category = context.Category.Find(9)
},
new Product {
ProductName = "ecobee3 lite Smart Thermostat",
ProductPrice = 169.95M,
//product image
Brand = context.Brand.Find(4),
Category = context.Category.Find(9)
},
new Product {
ProductName = "Honeywell T5+ Smart Thermostat",
ProductPrice = 149.95M,
//product image
Brand = context.Brand.Find(7),
Category = context.Category.Find(9)
}
);
context.SaveChanges();
}
}
public DeleteModel(Final_Project_Homekit_2.Models.HomekitDbContext context)
{
_context = context;
}
