public void TestInsertIngredientToIngredientDatabase() { var t = new DatabaseAccess(); var dbR = new DatabaseAccessRecipe(); var dbI = new DatabaseAccessIngredient(); var r = new Recipe("Cranberry Swirl Bread") { id = 1 }; var i = new Ingredient("Cranberries", "2 cups") { recipeId = r.id }; t.initializeDatabase(); dbR.InsertRecipe(r); dbI.insertIngredient(i, r); var myRecipeBox = dbR.queryRecipes(); var myIngredientBox = dbI.queryAllIngredientsFromIngredientTable(); var myRecipe = dbR.GetFullRecipeAndFullIngredientsForRecipe(r); Assert.AreEqual(r.name, myRecipeBox[0].name); Assert.AreEqual(i.name, myIngredientBox[0].name); Assert.AreEqual(i.measurement, myIngredientBox[0].measurement); Assert.AreEqual(i.name, myRecipe.ingredients[0].name); Assert.AreEqual(i.measurement, myRecipe.ingredients[0].measurement); }
public void TestHersheysUnsweetenedCocoa() { var t = new DatabaseAccess(); var dbR = new DatabaseAccessRecipe(); var dbI = new DatabaseAccessIngredient(); var r = new Recipe("Chocolate Something") { id = 1 }; var i = new Ingredient("Hershey's Special Dark Cocoa") { recipeId = 1, ingredientId = 1, sellingWeight = "8 oz", measurement = "1/2 cup", density = 4.16m }; t.initializeDatabase(); dbR.InsertRecipe(r); t.insertIngredientIntoAllTables(i, r); dbI.getIngredientMeasuredPrice(i, r); var myIngInfo = dbI.queryAllIngredientsFromIngredientTable(); var myRecipesInfo = dbR.queryRecipes(); Assert.AreEqual(1, myRecipesInfo.Count()); Assert.AreEqual(.87m, myIngInfo[0].priceOfMeasuredConsumption); }
public void TestIngredientTable() { var t = new DatabaseAccess(); var dbR = new DatabaseAccessRecipe(); var dbI = new DatabaseAccessIngredient(); var i = new Ingredient("all-purpose flour", "2 1/2 cups") { recipeId = 1 }; var i2 = new Ingredient("butter", "1/2 cup") { recipeId = 1 }; var r = new Recipe("White Cake") { id = 1 }; t.initializeDatabase(); dbR.InsertRecipe(r); dbI.insertIngredient(i, r); dbI.insertIngredient(i2, r); var recipes = dbR.queryRecipes(); var ingredients = dbI.queryAllIngredientsFromIngredientTable(); var myIngredientBox = dbI.queryAllIngredientsFromIngredientTable(); Assert.AreEqual("all-purpose flour", ingredients[0].name); Assert.AreEqual("butter", ingredients[1].name); }
public ActionResult DeleteRecipe(string recipeTitle) { recipeTitle = recipeTitle.Trim(); var db = new DatabaseAccessRecipe(); var recipes = db.queryRecipes(); foreach (var recipe in recipes) { if (recipe.name == recipeTitle) { currentRecipe = recipe; } db.DeleteRecipeAndRecipeIngredients(currentRecipe); } return(Redirect("/home/RecipeBox")); }
public void TestQueryListOfIngredientsDensityCostTableAdded() { var t = new DatabaseAccess(); var dbR = new DatabaseAccessRecipe(); var cocnutMacaroons = new Recipe("Coconut Macaroons") { id = 1 }; var i = new Ingredient("Baker's Coconut Flakes") { recipeId = 1, measurement = "1 cup", sellingWeight = "14 oz", density = 2.5m, ingredientId = 1 //2.6, .46 }; var i2 = new Ingredient("All Purpose Flour") { recipeId = 1, measurement = "1/2 cup", sellingWeight = "5 lb", density = 5m, ingredientId = 2 //3.65 }; var cocnutMcaroonsIngredients = new List <Ingredient> { i, i2 }; t.initializeDatabase(); t.insertListOfIngredientsIntoAllTables(cocnutMcaroonsIngredients, cocnutMacaroons); var myIngredients = t.queryAllTablesForAllIngredients(cocnutMcaroonsIngredients); var myRecipes = dbR.queryRecipes(); Assert.AreEqual(1, myRecipes.Count()); Assert.AreEqual(2, myIngredients.Count()); Assert.AreEqual(2.60m, myIngredients[0].sellingPrice); Assert.AreEqual(.46m, myIngredients[0].priceOfMeasuredConsumption); Assert.AreEqual(.1857m, myIngredients[0].pricePerOunce); Assert.AreEqual(2.5m, myIngredients[0].density); Assert.AreEqual(3.65m, myIngredients[1].sellingPrice); Assert.AreEqual(.11m, myIngredients[1].priceOfMeasuredConsumption); Assert.AreEqual(.0456m, myIngredients[1].pricePerOunce); Assert.AreEqual(5m, myIngredients[1].density); }