public async Task <IActionResult> OnGetAsync(int?id /*, string returnUrl = null/*/)
{
if (id == null)
{
return(NotFound());
}
QuantityInRecipe = await _context.QuantityInRecipes
.Include(q => q.Ingredient)
.Include(q => q.Recipe).FirstOrDefaultAsync(m => m.QuantityInRecipeID == id);
if (QuantityInRecipe == null)
{
return(NotFound());
}
var ingredientsQuery = from i in _context.Ingredients
orderby i.Name
select i;
var recipesQuery = from r in _context.Recipes
orderby r.Name
select r;
ViewData["IngredientID"] = new SelectList(ingredientsQuery, "ID", "Name");
ViewData["RecipeID"] = new SelectList(recipesQuery, "RecipeID", "Name");
return(Page());
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
QuantityInRecipe = await _context.QuantityInRecipes
.Include(q => q.Ingredient)
.Include(q => q.Recipe).FirstOrDefaultAsync(m => m.QuantityInRecipeID == id);
if (QuantityInRecipe == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
QuantityInRecipe = await _context.QuantityInRecipes.FindAsync(id);
if (QuantityInRecipe != null)
{
_context.QuantityInRecipes.Remove(QuantityInRecipe);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
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();
}
