Exemple #1
0
 public DetailsModel(RecipeWebsite.Data.CookbookContext context)
 {
     _context = context;
 }
Exemple #2
0
 public CreateModel(RecipeWebsite.Data.CookbookContext context)
 {
     _context = context;
 }
 public IndexModel(RecipeWebsite.Data.CookbookContext context)
 {
     _context = context;
 }
Exemple #4
0
        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();
        }