public static void Initialize(CookbookContext context)
{
context.Database.EnsureCreated();
// Look for any ingredients.
if (context.Ingredients.Any())
{
return; // DB has been seeded
}
var ingredients = new Ingredient[]
{
new Ingredient {
Name = "Filet", TypeOfFood = TypeOfFood.drób
},
new Ingredient {
Name = "Penne", TypeOfFood = TypeOfFood.makarony
},
new Ingredient {
Name = "Śmietana 18%", TypeOfFood = TypeOfFood.nabiał
},
new Ingredient {
Name = "Szpinak", TypeOfFood = TypeOfFood.warzywa
},
new Ingredient {
Name = "Czosnek", TypeOfFood = TypeOfFood.warzywa
},
new Ingredient {
Name = "Masło", TypeOfFood = TypeOfFood.nabiał
},
new Ingredient {
Name = "Jajko"
},
new Ingredient {
Name = "Spaghetti", TypeOfFood = TypeOfFood.makarony
},
new Ingredient {
Name = "Jabłko", TypeOfFood = TypeOfFood.owoce
},
new Ingredient {
Name = "Ser Gouda", TypeOfFood = TypeOfFood.nabiał
},
new Ingredient {
Name = "Szynka"
},
new Ingredient {
Name = "Pomarańcza", TypeOfFood = TypeOfFood.owoce
},
new Ingredient {
Name = "Ser Mazur", TypeOfFood = TypeOfFood.nabiał
}
};
foreach (Ingredient i in ingredients)
{
context.Ingredients.Add(i);
}
context.SaveChanges();
var mealtypes = new MealType[]
{
new MealType {
Name = "Śniadania"
},
new MealType {
Name = "Obiady"
},
new MealType {
Name = "Kolacje"
},
new MealType {
Name = "Dania wegetariańskie"
},
new MealType {
Name = "Dania wegańskie"
},
new MealType {
Name = "Dania mięsne"
},
new MealType {
Name = "Dania mączne"
},
new MealType {
Name = "Ryby"
},
new MealType {
Name = "Makarony"
},
new MealType {
Name = "Zupy"
},
new MealType {
Name = "Sałatki"
},
new MealType {
Name = "Desery"
},
new MealType {
Name = "Ciasta"
},
new MealType {
Name = "Pieczywo"
},
new MealType {
Name = "Przetwory"
},
new MealType {
Name = "Sosy"
},
};
foreach (MealType m in mealtypes)
{
context.MealTypes.Add(m);
}
context.SaveChanges();
var recipes = new Recipe[]
{
new Recipe {
Name = "Przepis1", NumberOfServings = 1, LastTimeServed = DateTime.Parse("2020-03-12")
},
new Recipe {
Name = "Przepis2", NumberOfServings = 2, LastTimeServed = DateTime.Parse("2020-03-16")
},
new Recipe {
Name = "Przepis3", NumberOfServings = 3, LastTimeServed = DateTime.Parse("2020-03-08")
},
new Recipe {
Name = "Przepis4", NumberOfServings = 2, LastTimeServed = DateTime.Parse("2020-03-21")
}
};
foreach (Recipe r in recipes)
{
context.Recipes.Add(r);
}
context.SaveChanges();
var recipeAssignments = new RecipeAssignment[]
{
new RecipeAssignment {
RecipeID = recipes.Single(r => r.Name == "Przepis1").RecipeID,
MealTypeID = mealtypes.Single(m => m.Name == "Dania wegetariańskie").ID
},
new RecipeAssignment {
RecipeID = recipes.Single(r => r.Name == "Przepis2").RecipeID,
MealTypeID = mealtypes.Single(m => m.Name == "Dania mięsne").ID
},
new RecipeAssignment {
RecipeID = recipes.Single(r => r.Name == "Przepis3").RecipeID,
MealTypeID = mealtypes.Single(m => m.Name == "Dania mączne").ID
},
new RecipeAssignment {
RecipeID = recipes.Single(r => r.Name == "Przepis4").RecipeID,
MealTypeID = mealtypes.Single(m => m.Name == "Dania wegańskie").ID
},
new RecipeAssignment {
RecipeID = recipes.Single(r => r.Name == "Przepis1").RecipeID,
MealTypeID = mealtypes.Single(m => m.Name == "Śniadania").ID
},
new RecipeAssignment {
RecipeID = recipes.Single(r => r.Name == "Przepis2").RecipeID,
MealTypeID = mealtypes.Single(m => m.Name == "Obiady").ID
},
new RecipeAssignment {
RecipeID = recipes.Single(r => r.Name == "Przepis3").RecipeID,
MealTypeID = mealtypes.Single(m => m.Name == "Kolacje").ID
},
new RecipeAssignment {
RecipeID = recipes.Single(r => r.Name == "Przepis4").RecipeID,
MealTypeID = mealtypes.Single(m => m.Name == "Kolacje").ID
},
new RecipeAssignment {
RecipeID = recipes.Single(r => r.Name == "Przepis1").RecipeID,
MealTypeID = mealtypes.Single(m => m.Name == "Obiady").ID
},
new RecipeAssignment {
RecipeID = recipes.Single(r => r.Name == "Przepis2").RecipeID,
MealTypeID = mealtypes.Single(m => m.Name == "Sałatki").ID
},
new RecipeAssignment {
RecipeID = recipes.Single(r => r.Name == "Przepis3").RecipeID,
MealTypeID = mealtypes.Single(m => m.Name == "Desery").ID
},
new RecipeAssignment {
RecipeID = recipes.Single(r => r.Name == "Przepis4").RecipeID,
MealTypeID = mealtypes.Single(m => m.Name == "Sosy").ID
}
};
foreach (RecipeAssignment ra in recipeAssignments)
{
context.RecipeAssignments.Add(ra);
}
var quantityInRecipes = new QuantityInRecipe[]
{
new QuantityInRecipe {
IngredientID = 1, RecipeID = 1, Quantity = "10 ml"
},
new QuantityInRecipe {
IngredientID = 1, RecipeID = 2, Quantity = "5"
},
new QuantityInRecipe {
IngredientID = 2, RecipeID = 3, Quantity = "80 dag"
},
new QuantityInRecipe {
IngredientID = 2, RecipeID = 2, Quantity = "30 dag"
},
new QuantityInRecipe {
IngredientID = 2, RecipeID = 4, Quantity = "2"
},
new QuantityInRecipe {
IngredientID = 3, RecipeID = 1, Quantity = "50 ml"
},
new QuantityInRecipe {
IngredientID = 4, RecipeID = 2, Quantity = "6"
},
new QuantityInRecipe {
IngredientID = 4, RecipeID = 3, Quantity = "3"
},
new QuantityInRecipe {
IngredientID = 5, RecipeID = 4, Quantity = "50 dag"
},
new QuantityInRecipe {
IngredientID = 6, RecipeID = 2, Quantity = "3 kg"
},
new QuantityInRecipe {
IngredientID = 6, RecipeID = 3, Quantity = "6"
},
new QuantityInRecipe {
IngredientID = 6, RecipeID = 1, Quantity = "3"
},
new QuantityInRecipe {
IngredientID = 7, RecipeID = 2, Quantity = "20 dag"
},
new QuantityInRecipe {
IngredientID = 8, RecipeID = 3, Quantity = "5"
},
new QuantityInRecipe {
IngredientID = 9, RecipeID = 2, Quantity = "1"
},
new QuantityInRecipe {
IngredientID = 10, RecipeID = 1, Quantity = "70 ml"
},
new QuantityInRecipe {
IngredientID = 10, RecipeID = 3, Quantity = "20 ml"
},
new QuantityInRecipe {
IngredientID = 11, RecipeID = 2, Quantity = "2"
},
new QuantityInRecipe {
IngredientID = 11, RecipeID = 4, Quantity = "1"
},
new QuantityInRecipe {
IngredientID = 12, RecipeID = 2, Quantity = "8"
},
new QuantityInRecipe {
IngredientID = 13, RecipeID = 4, Quantity = "4 dag"
},
new QuantityInRecipe {
IngredientID = 13, RecipeID = 1, Quantity = "3"
}
};
foreach (QuantityInRecipe q in quantityInRecipes)
{
context.QuantityInRecipes.Add(q);
}
context.SaveChanges();
}