// To protect from overposting attacks, please enable the specific properties you want to bind to, for
// more details see https://aka.ms/RazorPagesCRUD.
/*public async Task<IActionResult> OnPostAsync()
* {
* if (!ModelState.IsValid)
* {
* return Page();
* }
*
* var entry = _context.Add(new Recipe());
* entry.CurrentValues.SetValues(RecipeVM);
* await _context.SaveChangesAsync();
* return RedirectToPage("./Index");
* }*/
public async Task <IActionResult> OnPostAsync(string[] selectedMealTypes)
{
var newRecipe = new Recipe();
if (selectedMealTypes != null)
{
newRecipe.RecipeAssignments = new List <RecipeAssignment>();
foreach (var mealType in selectedMealTypes)
{
var mealTypeToAdd = new RecipeAssignment
{
MealTypeID = int.Parse(mealType)
};
newRecipe.RecipeAssignments.Add(mealTypeToAdd);
}
}
if (await TryUpdateModelAsync <Recipe>(
newRecipe,
"Recipe",
r => r.Name, r => r.NumberOfServings, r => r.LastTimeServed))
{
_context.Recipes.Add(newRecipe);
await _context.SaveChangesAsync();
return(RedirectToPage("./Index"));
}
PopulateAssignedMealTypeData(_context, newRecipe);
return(Page());
}
public void UpdateRecipeMealTypes(CookbookContext context, string[] selectedMealTypes, Recipe recipeToUpdate)
{
if (selectedMealTypes == null)
{
recipeToUpdate.RecipeAssignments = new List <RecipeAssignment>();
return;
}
var selectedMealTypesHS = new HashSet <string>(selectedMealTypes);
var recipeMealTypes = new HashSet <int>(recipeToUpdate.RecipeAssignments.Select(r => r.Recipe.RecipeID));
foreach (var mealType in context.MealTypes)
{
if (!selectedMealTypesHS.Contains(mealType.ID.ToString()))
{
if (!recipeMealTypes.Contains(mealType.ID))
{
recipeToUpdate.RecipeAssignments.Add(
new RecipeAssignment
{
RecipeID = recipeToUpdate.RecipeID,
MealTypeID = mealType.ID
});
}
}
else
{
if (recipeMealTypes.Contains(mealType.ID))
{
RecipeAssignment mealToRemove = recipeToUpdate
.RecipeAssignments
.SingleOrDefault(r => r.MealTypeID == mealType.ID);
context.Remove(mealToRemove);
}
}
}
}
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();
}
