public void TestChocolateChips()
{
var dbD = new DatabaseAccessDensityInformation();
var dbR = new DatabaseAccessRecipe();
var t = new DatabaseAccess();
var r = new Recipe("Chooalte Chip Cookies")
{
id = 1
};
var i = new Ingredient("Semi Sweet Morsels")
{
ingredientId = 1, recipeId = 1, sellingWeight = "36 oz", density = 5.35m, measurement = "1 cup"
};
//6.98 1.04
t.initializeDatabase();
//var filename = @"C:\Users\Rachel\Documents\Visual Studio 2015\Projects\RachelsRosesWebPages\RachelsRosesWebPages\densityTxtDatabase.txt";
dbD.insertDensityTextFileIntoDensityInfoDatabase();
t.insertIngredientIntoAllTables(i, r);
var mydensityDataInformation = dbD.queryDensityInfoTable();
var semiSweetMorsels = t.queryAllRelevantTablesSQLByIngredientName(i);
var myRecipes = dbR.MyRecipeBox();
Assert.AreEqual("all purpose flour", mydensityDataInformation[0].name);
Assert.AreEqual(1, myRecipes.Count());
Assert.AreEqual(6.98m, semiSweetMorsels.sellingPrice);
Assert.AreEqual(6.98m, myRecipes[0].ingredients[0].sellingPrice);
Assert.AreEqual(1.04m, semiSweetMorsels.priceOfMeasuredConsumption);
Assert.AreEqual(1.04m, myRecipes[0].ingredients[0].priceOfMeasuredConsumption);
}
public void TestOverwritingTheCostTable()
{
var t = new DatabaseAccess();
var dbC = new DatabaseAccessCosts();
var dbR = new DatabaseAccessRecipe();
var yellowCake = new Recipe("Yellow Cake")
{
id = 1, yield = 12
};
var milk = new Ingredient("Whole Milk")
{
ingredientId = 1, recipeId = 1, measurement = "1 cup", sellingWeight = "1 gallon", typeOfIngredient = "milk", classification = "dairy"
};
t.initializeDatabase();
t.insertIngredientIntoAllTables(milk, yellowCake);
var myIngredient = t.queryAllRelevantTablesSQLByIngredientName(milk);
milk.sellingPrice = 2.98m;
dbC.updateCostDataTable(milk);
var myCostIngredient = dbC.queryCostTable();
t.updateAllTables(milk, yellowCake);
var myUpdatedIngredient = t.queryAllRelevantTablesSQLByIngredientName(milk);
var myRecipeBox = dbR.MyRecipeBox();
Assert.AreEqual(1, myRecipeBox[0].ingredients.Count());
Assert.AreEqual(2.98m, myUpdatedIngredient.sellingPrice);
Assert.AreEqual(8.2m, myIngredient.density);
Assert.AreEqual(.19m, myUpdatedIngredient.priceOfMeasuredConsumption);
Assert.AreEqual(.0233m, myUpdatedIngredient.pricePerOunce);
}
public void TestDeleteIngredientFromCostTable()
{
var t = new DatabaseAccess();
var dbC = new DatabaseAccessCosts();
var dbR = new DatabaseAccessRecipe();
var bread = new Recipe("Bread")
{
id = 1
};
var honey = new Ingredient("Honey")
{
ingredientId = 1, recipeId = 1, typeOfIngredient = "honey", measurement = "1/3 cup", sellingWeight = "32 oz"
};
t.initializeDatabase();
t.insertIngredientIntoAllTables(honey, bread);
var myRecipes = dbR.MyRecipeBox();
var myIngredients = t.queryAllRelevantTablesSQLByIngredientName(honey);
dbC.DeleteIngredientFromCostTable(honey);
var myCostIngredients = dbC.queryCostTable();
Assert.AreEqual(1, myRecipes.Count());
Assert.AreEqual(1, myRecipes[0].ingredients.Count());
Assert.AreEqual(0, myCostIngredients.Count());
}
public void TestOverwritingTheCostTable3()
{
var t = new DatabaseAccess();
var dbC = new DatabaseAccessCosts();
var dbR = new DatabaseAccessRecipe();
var chocolateCake = new Recipe("Chocolate Cake")
{
id = 1, yield = 16
};
var softasilk = new Ingredient("Softasilk Flour")
{
recipeId = 1, ingredientId = 1, sellingWeight = "32 oz", measurement = "3 cups", typeOfIngredient = "cake flour", classification = "flour"
};
t.initializeDatabase();
t.insertIngredientIntoAllTables(softasilk, chocolateCake);
var myIngredient = t.queryAllRelevantTablesSQLByIngredientName(softasilk);
softasilk.sellingPrice = 5m;
var costTable = dbC.queryCostTable();
t.updateAllTables(softasilk, chocolateCake);
var myUpdatedIngredient = t.queryAllRelevantTablesSQLByIngredientName(softasilk);
var myRecipeBox = dbR.MyRecipeBox();
Assert.AreEqual(1.26m, myIngredient.priceOfMeasuredConsumption);
Assert.AreEqual(2.11m, myUpdatedIngredient.priceOfMeasuredConsumption);
Assert.AreEqual(2.11m, myRecipeBox[0].aggregatedPrice);
}
public void TestGettingUniqueEntriesINIngredientTable()
{
var t = new DatabaseAccess();
var dbR = new DatabaseAccessRecipe();
var dbI = new DatabaseAccessIngredient();
var fluffyWhiteCake = new Recipe("Fluffy White Cake")
{
id = 1, yield = 12
};
var chocolateCake = new Recipe("My Favorite Chocolat Cake")
{
id = 2, yield = 18
};
var yellowCake = new Recipe("Yellow Cake")
{
id = 3, yield = 16
};
var softasilk = new Ingredient("Softasilk Cake Flour")
{
ingredientId = 1, recipeId = 1, measurement = "2 cups 2 tablespoons", typeOfIngredient = "cake flour", sellingWeight = "32 oz"
};
var softasilk2 = new Ingredient("Softasilk Cake Flour")
{
ingredientId = 2, recipeId = 2, measurement = "3 cups", typeOfIngredient = "cake flour", sellingWeight = "32 oz"
};
var softasilk3 = new Ingredient("Softasilk Cake Flour")
{
ingredientId = 3, recipeId = 3, measurement = "1 1/2 cups", typeOfIngredient = "cake flour", sellingWeight = "32 oz"
};
var bakingPowder = new Ingredient("Baking Powder")
{
ingredientId = 4, recipeId = 3, measurement = "2 teaspoons", typeOfIngredient = "baking powder", sellingWeight = "10 oz"
};
var yellowCakeIngredients = new List <Ingredient> {
softasilk3, bakingPowder
};
var myIngredientBox = new List <Ingredient> {
softasilk, softasilk2, softasilk3, bakingPowder
};
t.initializeDatabase();
t.insertIngredientIntoAllTables(softasilk, fluffyWhiteCake);
t.insertIngredientIntoAllTables(softasilk2, chocolateCake);
t.insertListOfIngredientsIntoAllTables(yellowCakeIngredients, yellowCake);
var myIngredientsTable = dbI.queryAllIngredientsFromIngredientTable();
var myRecipeBox = dbR.MyRecipeBox();
var myDistictIngredientTable = dbI.myDistinctIngredientNamesSorted();
var myIngredientBoxFilled = t.queryAllTablesForAllIngredients(myIngredientBox);
Assert.AreEqual(4, myIngredientsTable.Count());
Assert.AreEqual(2, myDistictIngredientTable.Count());
Assert.AreEqual("Softasilk Cake Flour", myDistictIngredientTable[0]);
Assert.AreEqual("Baking Powder", myDistictIngredientTable[1]);
Assert.AreEqual(.89m, softasilk.priceOfMeasuredConsumption);
Assert.AreEqual(1.26m, softasilk2.priceOfMeasuredConsumption);
Assert.AreEqual(.63m, softasilk3.priceOfMeasuredConsumption);
Assert.AreEqual(.10m, bakingPowder.priceOfMeasuredConsumption);
}
public void TestOverwritingTheCostTable2()
{
var t = new DatabaseAccess();
var dbC = new DatabaseAccessCosts();
var dbR = new DatabaseAccessRecipe();
var chocolateCake = new Recipe("Chocolate Cake")
{
id = 1, yield = 24
};
var yellowCake = new Recipe("Yellow Cake")
{
id = 2, yield = 24
};
var honeyButtermilkBread = new Recipe("Honey Buttermilk Bread")
{
id = 3, yield = 24
};
var sourCream = new Ingredient("Sour Cream")
{
ingredientId = 1, recipeId = 1, measurement = "1 cup", sellingWeight = "16 oz", typeOfIngredient = "sour cream", classification = "dairy"
};
var milk = new Ingredient("Whole Milk")
{
ingredientId = 2, recipeId = 2, measurement = "1 1/2 cups", sellingWeight = "1 gallon", typeOfIngredient = "milk", classification = "dairy"
};
var butter = new Ingredient("Unsalted Butter")
{
ingredientId = 3, recipeId = 3, measurement = "1/4 cup", sellingWeight = "1 lb", typeOfIngredient = "butter", classification = "dairy"
};
var buttermilk = new Ingredient("Buttermilk")
{
ingredientId = 4, recipeId = 3, measurement = "2 cups", sellingWeight = "1/4 gallon", typeOfIngredient = "buttermilk", classification = "dairy"
};
var honeyButtermilkBreadIngredients = new List <Ingredient> {
butter, buttermilk
};
var allIngredients = new List <Ingredient> {
sourCream, milk, butter, buttermilk
};
t.initializeDatabase();
t.insertIngredientIntoAllTables(sourCream, chocolateCake);
t.insertIngredientIntoAllTables(milk, yellowCake);
t.insertListOfIngredientsIntoAllTables(honeyButtermilkBreadIngredients, honeyButtermilkBread);
var myIngredients = t.queryAllTablesForAllIngredients(allIngredients);
sourCream.sellingPrice = 1.69m;
milk.sellingPrice = 2.98m;
butter.sellingPrice = 3.99m;
buttermilk.sellingPrice = 1.69m;
var costTable = dbC.queryCostTable();
t.updateAllTables(sourCream, chocolateCake);
t.updateAllTables(milk, yellowCake);
t.updateAllTablesForAllIngredients(honeyButtermilkBreadIngredients, honeyButtermilkBread);
var myUpdatedIngredients = t.queryAllTablesForAllIngredients(allIngredients);
var myRecipeBox = dbR.MyRecipeBox();
Assert.AreEqual(1.69m, myUpdatedIngredients[0].sellingPrice);
Assert.AreEqual(2.98m, myUpdatedIngredients[1].sellingPrice);
Assert.AreEqual(3.99m, myUpdatedIngredients[2].sellingPrice);
Assert.AreEqual(1.69m, myUpdatedIngredients[3].sellingPrice);
Assert.AreEqual(8.6m, myUpdatedIngredients[0].density);
Assert.AreEqual(8.2m, myUpdatedIngredients[1].density);
Assert.AreEqual(8m, myUpdatedIngredients[2].density);
Assert.AreEqual(8.2m, myUpdatedIngredients[3].density);
Assert.AreEqual(.91m, myUpdatedIngredients[0].priceOfMeasuredConsumption);
Assert.AreEqual(.91m, myRecipeBox[0].ingredients[0].priceOfMeasuredConsumption);
Assert.AreEqual(.29m, myUpdatedIngredients[1].priceOfMeasuredConsumption);
Assert.AreEqual(.29m, myRecipeBox[1].ingredients[0].priceOfMeasuredConsumption);
Assert.AreEqual(.5m, myUpdatedIngredients[2].priceOfMeasuredConsumption);
Assert.AreEqual(.5m, myRecipeBox[2].ingredients[0].priceOfMeasuredConsumption);
Assert.AreEqual(.87m, myUpdatedIngredients[3].priceOfMeasuredConsumption);
Assert.AreEqual(.87m, myRecipeBox[2].ingredients[1].priceOfMeasuredConsumption);
Assert.AreEqual(.91m, myRecipeBox[0].aggregatedPrice);
Assert.AreEqual(.29m, myRecipeBox[1].aggregatedPrice);
Assert.AreEqual(1.37m, myRecipeBox[2].aggregatedPrice);
}
public List <Recipe> getRecipes()
{
var db = new DatabaseAccessRecipe();
return(db.MyRecipeBox());
}
