public static void EnsureSeedData(this FoodbuddyContext context)
{
//if (context.AllMigrationsApplied())
{
//if (!context.Unit.Any())
//{
// context
// var clothing = context.Categories.Add(new Category { DisplayName = "Clothing" }).Entity;
// var mensClothing = context.Categories.Add(new Category { DisplayName = "Mens Clothing", ParentCategory = clothing }).Entity;
// var mensShirts = context.Categories.Add(new Category { DisplayName = "Mens Shirts", ParentCategory = mensClothing }).Entity;
// var homeAndGarden = context.Categories.Add(new Category { DisplayName = "Home & Garden" }).Entity;
// var kitchenAndDining = context.Categories.Add(new Category { DisplayName = "Kitchen & Dining", ParentCategory = homeAndGarden }).Entity;
// context.Products.AddRange(
// new Product { SKU = "MUG001", DisplayName = "Unicorn Coffee Mug (Blue)", MSRP = 12.95M, CurrentPrice = 12.95M, Category = kitchenAndDining, ImageUrl = "/images/products/CoffeeMug_Blue.png", Description = "Coffee and unicorns... what else could you need! Our flagship unicorn printed on a high quality coffee mug." },
// new Product { SKU = "MUG002", DisplayName = "Unicorn Coffee Mug (Green)", MSRP = 12.95M, CurrentPrice = 10.95M, Category = kitchenAndDining, ImageUrl = "/images/products/CoffeeMug_Green.png", Description = "Coffee and unicorns... what else could you need! Our flagship unicorn printed on a high quality coffee mug." },
// new Product { SKU = "MUG003", DisplayName = "Unicorn Coffee Mug (Pink)", MSRP = 12.95M, CurrentPrice = 12.95M, Category = kitchenAndDining, ImageUrl = "/images/products/CoffeeMug_Pink.png", Description = "Coffee and unicorns... what else could you need! Our flagship unicorn printed on a high quality coffee mug." },
// new Product { SKU = "TEE201", DisplayName = "Unicorn Coffee Mug (White)", MSRP = 12.95M, CurrentPrice = 12.95M, Category = kitchenAndDining, ImageUrl = "/images/products/CoffeeMug_White.png", Description = "Coffee and unicorns... what else could you need! Our flagship unicorn printed on a high quality coffee mug." },
// new Product { SKU = "TEE202", DisplayName = "Mens Unicorn Tee (Blue)", MSRP = 19.95M, CurrentPrice = 19.95M, Category = mensShirts, ImageUrl = "/images/products/MensTee_Blue.png", Description = "Share your love of unicorns with the world. Quality cotton t-shirt with a long lasting print." },
// new Product { SKU = "TEE203", DisplayName = "Mens Unicorn Tee (Grey)", MSRP = 19.95M, CurrentPrice = 17.95M, Category = mensShirts, ImageUrl = "/images/products/MensTee_Grey.png", Description = "Share your love of unicorns with the world. Quality cotton t-shirt with a long lasting print." },
// new Product { SKU = "TEE204", DisplayName = "Mens Unicorn Tee (Red/Black Stripe)", MSRP = 24.95M, CurrentPrice = 19.95M, Category = mensShirts, ImageUrl = "/images/products/MensTee_RedBlackStripe.png", Description = "Share your love of unicorns with the world. Quality cotton t-shirt with a long lasting print." });
// context.SaveChanges();
//}
}
}
public static void Seed(this FoodbuddyContext context)
{
if (!context.Database.GetPendingMigrations().Any())
{
if (!context.FoodUnit.Any())
{
var foodUnits = from item in context.FoodItem
let unit = context.Unit.Where(u => u.TxtShortName.Equals("pc")).First()
select new FoodUnit {
Rowguid = Guid.NewGuid(),
GnuFoodItem = item.Rowguid,
GnuUnit = unit.Rowguid
};
context.FoodUnit.AddRange(foodUnits);
context.SaveChanges();
}
if (!context.FoodSupply.Any())
{
var supplies = from unit in context.FoodUnit
select new FoodSupply
{
Rowguid = Guid.NewGuid(),
GnuFoodUnit = unit.Rowguid,
DteSuppliedOn = DateTime.UtcNow.AddDays(-(new Random().Next(1, 15))),
IntQuantity = 5
};
context.FoodSupply.AddRange(supplies);
context.SaveChanges();
}
if (!context.Consumption.Any())
{
var consumptions = from unit in context.FoodUnit
select new Consumption
{
Rowguid = Guid.NewGuid(),
GnuFoodUnit = unit.Rowguid,
IntConsumedByPersons = 1,
IntConsumptionDays = 10
};
context.Consumption.AddRange(consumptions);
context.SaveChanges();
}
}
}
public FoodController(FoodbuddyContext db)
{
_db = db;
}
