public ActionResult AddInventory([Bind(Include = "InventoryingredientID,ingredient,Hoeveelheid,Eenheid")] InventoryIngredient inventoryIngredient)
{
using (DBingredient context = new DBingredient())
{
if (ModelState.IsValid)
{
User user = (User)Session["user"];
int UserID = user.UserID;
User indexUser = context.Users.Find(UserID);
//int inventoryID = indexUser.inventory.InventoryID;
//Inventory inventory = context.Inventories.Find(inventoryID);
Ingredient ig = context.Ingredients.Find(inventoryIngredient.ingredient.ingredientID);
inventoryIngredient.ingredient = ig;
context.InventoryIngredients.Add(inventoryIngredient);
context.SaveChanges();
indexUser.inventory.InventoryIngredients.Add(inventoryIngredient);
context.Entry(indexUser.inventory).State = EntityState.Modified;
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(inventoryIngredient));
}
}
public ActionResult DeleteConfirmedEdit(int id)
{
using (DBingredient context = new DBingredient())
{
int?recipeIDInput = (int)TempData["RecipeID"];
if (recipeIDInput == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Recipe recipe = context.Recipes.Find(recipeIDInput);
if (recipe == null)
{
return(HttpNotFound());
}
RecipeIngredient ingredient = context.TotalRecipeIngredients.Find(id);
recipe.RecipeIngredients.Remove(ingredient);
context.Entry(recipe).State = EntityState.Modified;
context.SaveChanges();
context.TotalRecipeIngredients.Remove(ingredient);
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult AddRecipeIngredient([Bind(Include = "RecipeIngredientID,ingredient,Hoeveelheid,Eenheid")] RecipeIngredient recipeIngredient)
{
using (DBingredient context = new DBingredient())
{
if (ModelState.IsValid)
{
//User user = (User)Session["user"];
//int UserID = user.UserID;
//User indexUser = context.Users.Find(UserID);
//int inventoryID = indexUser.inventory.InventoryID;
//Inventory inventory = context.Inventories.Find(inventoryID);
Ingredient ig = context.Ingredients.Find(recipeIngredient.ingredient.ingredientID);
recipeIngredient.ingredient = ig;
context.TotalRecipeIngredients.Add(recipeIngredient);
context.SaveChanges();
Recipe tempRecipe = (Recipe)TempData["recipe"];
int recipeID = tempRecipe.RecipeID;
Recipe recipe = context.Recipes.Find(recipeID);
recipe.RecipeIngredients.Add(recipeIngredient);
//context.Entry(recipe.RecipeIngredients).State = EntityState.Modified;
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(recipeIngredient));
}
}
public ActionResult Create([Bind(Include = "ingredientID,name,merk")] Ingredient ingredient)
{
if (ModelState.IsValid)
{
db.Ingredients.Add(ingredient);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ingredient));
}
public ActionResult Create([Bind(Include = "RecipeID,Naam,Beschrijving,Calorien")] Recipe recipe)
{
if (ModelState.IsValid)
{
db.Recipes.Add(recipe);
db.SaveChanges();
return(RedirectToAction("AddIngredient", recipe));
}
ViewBag.Recipe = recipe;
return(View());
}
public ActionResult AddInventory([Bind(Include = "InventoryingredientID,ingredient,Hoeveelheid,Eenheid")] InventoryIngredient inventoryIngredient)
{
if (ModelState.IsValid)
{
Ingredient ig = db.Ingredients.Find(inventoryIngredient.ingredient.ingredientID);
inventoryIngredient.ingredient = ig;
db.InventoryIngredients.Add(inventoryIngredient);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(inventoryIngredient));
}
public ActionResult DeleteConfirmed(int id)
{
using (DBingredient context = new DBingredient())
{
Ingredient ingredient = context.Ingredients.Find(id);
context.Ingredients.Remove(ingredient);
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Edit([Bind(Include = "ingredientID,name,merk")] Ingredient ingredient)
{
using (DBingredient context = new DBingredient())
{
if (ModelState.IsValid)
{
context.Entry(ingredient).State = EntityState.Modified;
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ingredient));
}
}
public ActionResult Create([Bind(Include = "ingredientID,name,merk")] Ingredient ingredient)
{
using (DBingredient context = new DBingredient())
{
if (ModelState.IsValid)
{
context.Ingredients.Add(ingredient);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ingredient));
}
}
public ActionResult Edit([Bind(Include = "BoodschapIngredientID,Ingredient,Hoeveelheid,Eenheid")] BoodschapIngredient boodschapIngredient)
{
using (DBingredient context = new DBingredient())
{
if (ModelState.IsValid)
{
Ingredient ig = context.Ingredients.Find(boodschapIngredient.ingredient.ingredientID);
boodschapIngredient.ingredient = ig;
context.Entry(boodschapIngredient).State = EntityState.Modified;
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(boodschapIngredient));
}
}
public ActionResult Create([Bind(Include = "RecipeID,Naam,Beschrijving,Calorien")] Recipe recipe)
{
using (DBingredient context = new DBingredient())
{
if (ModelState.IsValid)
{
User user = (User)Session["user"];
int userID = user.UserID;
recipe.user = context.Users.Find(userID);
context.Recipes.Add(recipe);
context.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Recipe = recipe;
return(View());
}
}
public ActionResult Create([Bind(Include = "UserID,inlognaam,wachtwoord")] User user)
{
using (DBingredient context = new DBingredient())
{
if (ModelState.IsValid)
{
Inventory inventory = new Inventory();
BoodschapLijst boodschapLijst = new BoodschapLijst();
user.inventory = inventory;
user.boodschapLijst = boodschapLijst;
context.Users.Add(user);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
}
public ActionResult DeleteConfirmed(int id)
{
using (DBingredient context = new DBingredient())
{
Recipe recipe = context.Recipes.Find(id);
List <RecipeIngredient> lijst = new List <RecipeIngredient>();
lijst = recipe.RecipeIngredients;
foreach (RecipeIngredient recipeIngredient in lijst.ToList())
{
int recipeIngredientID = recipeIngredient.RecipeIngredientID;
RecipeIngredient removeIngredient = context.TotalRecipeIngredients.Find(recipeIngredientID);
context.TotalRecipeIngredients.Remove(removeIngredient);
}
context.Recipes.Remove(recipe);
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult EditRecipe([Bind(Include = "RecipeID,user,Naam,Beschrijving,Calorien")] Recipe recipe)
{
using (DBingredient context = new DBingredient())
{
if (ModelState.IsValid)
{
int recipeID = recipe.RecipeID;
Recipe origineel = context.Recipes.Find(recipeID);
recipe.RecipeIngredients = origineel.RecipeIngredients;
int userID = recipe.user.UserID;
User user = context.Users.Find(userID);
recipe.user = user;
context.Set <Recipe>().AddOrUpdate(recipe);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(recipe));
}
}
public ActionResult Gekocht(int?id)
{
using (DBingredient context = new DBingredient())
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BoodschapIngredient boodschapIngredient = context.BoodschapIngredients.Find(id);
if (boodschapIngredient == null)
{
return(HttpNotFound());
}
User user = (User)Session["user"];
InventoryIngredient inventoryIngredient = new InventoryIngredient();
inventoryIngredient.ingredient = boodschapIngredient.ingredient;
inventoryIngredient.Hoeveelheid = boodschapIngredient.Hoeveelheid;
inventoryIngredient.Eenheid = boodschapIngredient.Eenheid;
int inventoryID = user.inventory.InventoryID;
Inventory inventory = context.Inventories.Find(inventoryID);
int boodschapLijstID = user.boodschapLijst.BoodschapLijstID;
BoodschapLijst boodschapLijst = context.BoodschapLijsts.Find(boodschapLijstID);
inventory.InventoryIngredients.Add(inventoryIngredient);
//context.Entry(inventory.InventoryIngredients).State = EntityState.Modified;
boodschapLijst.BoodschapIngredients.Remove(boodschapIngredient);
//context.Entry(user.boodschapLijst).State = EntityState.Modified;
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
