public static void Seed(SmartHomeAutomationContext dbContext)
{
var deviceCategories = new List <DeviceCategory>
{
new DeviceCategory
{
DeviceCategoryName = "Heating/Cooling"
},
new DeviceCategory
{
DeviceCategoryName = "Lighting"
}
};
dbContext.DeviceCategories.AddRange(deviceCategories);
dbContext.SaveChanges();
}
public static void Seed(SmartHomeAutomationContext dbContext)
{
var deviceCategories = dbContext.DeviceCategories;
var deviceTypes = new List <DeviceType>();
foreach (var deviceCategory in deviceCategories)
{
switch (deviceCategory.DeviceCategoryName)
{
case "Heating/Cooling":
deviceTypes.Add(new DeviceType
{
DeviceTypeName = "Thermostat",
DeviceCategoryId = deviceCategory.DeviceCategoryId
});
deviceTypes.Add(new DeviceType
{
DeviceTypeName = "Temperature Sensor",
DeviceCategoryId = deviceCategory.DeviceCategoryId
});
break;
case "Lighting":
deviceTypes.Add(new DeviceType()
{
DeviceTypeName = "Lightbulb - White",
DeviceCategoryId = deviceCategory.DeviceCategoryId
});
deviceTypes.Add(new DeviceType()
{
DeviceTypeName = "Lightbulb - Color",
DeviceCategoryId = deviceCategory.DeviceCategoryId
});
break;
}
}
dbContext.DeviceTypes.AddRange(deviceTypes);
dbContext.SaveChanges();
}
public static void Seed(SmartHomeAutomationContext dbContext)
{
var manufacturers = new List <Manufacturer>
{
new Manufacturer
{
ManufacturerName = "Philips Hue",
ManufacturerWebsiteAddress = "http://meethue.com"
},
new Manufacturer
{
ManufacturerName = "EcoBee",
ManufacturerWebsiteAddress = "http://www.ecobee.com"
},
new Manufacturer
{
ManufacturerName = "Nest",
ManufacturerWebsiteAddress = "http://nest.com"
}
};
dbContext.Manufacturers.AddRange(manufacturers);
dbContext.SaveChanges();
}
public static void Seed(SmartHomeAutomationContext dbContext)
{
var deviceTypes = dbContext.DeviceTypes;
var manufactures = dbContext.Manufacturers;
var devices = new List <Device>();
foreach (var deviceType in deviceTypes)
{
var ecoBee = manufactures.FirstOrDefault(m => m.ManufacturerName == "EcoBee");
var nest = manufactures.FirstOrDefault(m => m.ManufacturerName == "Nest");
var hue = manufactures.FirstOrDefault(m => m.ManufacturerName == "Philips Hue");
switch (deviceType.DeviceTypeName)
{
case "Thermostat":
if (ecoBee != null)
{
devices.Add(new Device
{
DeviceName = "EcoBee 3",
DeviceTypeId = deviceType.DeviceTypeId,
ManufacturerId = ecoBee.ManufacturerId
});
}
if (nest != null)
{
devices.Add(new Device
{
DeviceName = "Nest Series 4",
DeviceTypeId = deviceType.DeviceTypeId,
ManufacturerId = nest.ManufacturerId
});
}
break;
case "Temperature Sensor":
if (ecoBee != null)
{
devices.Add(new Device
{
DeviceName = "EcoBee Sensor",
DeviceTypeId = deviceType.DeviceTypeId,
ManufacturerId = ecoBee.ManufacturerId
});
}
if (nest != null)
{
devices.Add(new Device
{
DeviceName = "Nest Sensor",
DeviceTypeId = deviceType.DeviceTypeId,
ManufacturerId = nest.ManufacturerId
});
}
break;
case "Lightbulb - White":
if (hue != null)
{
devices.Add(new Device
{
DeviceName = "Hue White Smart LED Bulb - E26",
DeviceTypeId = deviceType.DeviceTypeId,
ManufacturerId = hue.ManufacturerId
});
devices.Add(new Device
{
DeviceName = "Hue White Ambiance Smart LED Bulb - E26",
DeviceTypeId = deviceType.DeviceTypeId,
ManufacturerId = hue.ManufacturerId
});
}
break;
case "LightBulb - Color":
if (hue != null)
{
devices.Add(new Device
{
DeviceName = "Hue White & Color Ambiance Smart LED Bulb - E26",
DeviceTypeId = deviceType.DeviceTypeId,
ManufacturerId = hue.ManufacturerId
});
devices.Add(new Device
{
DeviceName = "Hue White & Color Ambiance Smart LED Bulb - E12",
DeviceTypeId = deviceType.DeviceTypeId,
ManufacturerId = hue.ManufacturerId
});
}
break;
}
}
dbContext.Devices.AddRange(devices);
dbContext.SaveChanges();
}
