public void TestMeasuredIngredientPriceIngredientsTable2()
{
var t = new DatabaseAccess();
var dbI = new DatabaseAccessIngredient();
var dbC = new DatabaseAccessConsumption();
var dbCosts = new DatabaseAccessCosts();
var dbD = new DatabaseAccessDensities();
var rest = new MakeRESTCalls();
var r = new Recipe("Wholesome Whole Wheat Bread")
{
id = 1
};
var i = new Ingredient("King Arthur Whole Wheat Flour")
{
recipeId = 1,
ingredientId = 1,
sellingWeight = "5 lb",
measurement = "3 cups",
density = 5
};
var i2 = new Ingredient("Rumford Baking Powder")
{
recipeId = 1,
ingredientId = 2,
sellingWeight = "10 oz",
measurement = "1 teaspoon",
density = 8.4m
};
var i3 = new Ingredient("King Arthur All Purpose Flour")
{
recipeId = 1,
ingredientId = 3,
sellingWeight = "5 lb",
measurement = "2 cups",
density = 5
};
t.initializeDatabase();
dbI.insertIngredient(i, r);
dbI.insertIngredient(i2, r);
dbI.insertIngredient(i3, r);
dbC.insertIngredientConsumtionData(i);
dbC.insertIngredientConsumtionData(i2);
dbC.insertIngredientConsumtionData(i3);
dbD.insertIngredientDensityData(i);
dbD.insertIngredientDensityData(i2);
dbD.insertIngredientDensityData(i3);
dbCosts.insertIngredientCostDataCostTable(i);
dbCosts.insertIngredientCostDataCostTable(i2);
dbCosts.insertIngredientCostDataCostTable(i3);
var ingredientMeasuredPrice1 = dbI.MeasuredIngredientPrice(i);
var ingredient2MeasuredPrice = dbI.MeasuredIngredientPrice(i2);
var ingredient3MeasuredPrice = dbI.MeasuredIngredientPrice(i3);
Assert.AreEqual(.79m, ingredientMeasuredPrice1);
Assert.AreEqual(.04m, ingredient2MeasuredPrice);
Assert.AreEqual(.46m, ingredient3MeasuredPrice);
}
public void TestMeasuredIngredientPriceIngredientsTablew()
{
var t = new DatabaseAccess();
var dbI = new DatabaseAccessIngredient();
var dbC = new DatabaseAccessConsumption();
var dbCosts = new DatabaseAccessCosts();
var dbD = new DatabaseAccessDensities();
var rest = new MakeRESTCalls();
var r = new Recipe("Wholesome Whole Wheat Bread")
{
id = 1
};
var i = new Ingredient("king arthur whole wheat flour")
{
recipeId = 1,
ingredientId = 1,
sellingWeight = "5 lb",
measurement = "1 1/2 cups",
density = 5.4m
};
t.initializeDatabase();
dbI.insertIngredient(i, r);
dbC.insertIngredientConsumtionData(i);
dbD.insertIngredientDensityData(i);
dbCosts.insertIngredientCostDataCostTable(i);
var IngredientMeasuredPrice = dbI.MeasuredIngredientPrice(i);
var myIngInfo = dbCosts.queryCostTable();
Assert.AreEqual(.43m, IngredientMeasuredPrice);
}
public void TestQueryCostTableRowByName()
{
var db = new DatabaseAccess();
var dbI = new DatabaseAccessIngredient();
var dbC = new DatabaseAccessConsumption();
var dbDI = new DatabaseAccessDensityInformation();
var dbD = new DatabaseAccessDensities();
var dbCosts = new DatabaseAccessCosts();
var cake = new Recipe("Cake")
{
id = 1, yield = 12
};
var softasilkCakeFlour = new Ingredient("Softasilk Cake Flour")
{
ingredientId = 1, recipeId = 1, sellingWeight = "32 oz", measurement = "1 1/2 cups", typeOfIngredient = "cake flour", classification = "flour"
};
db.initializeDatabase();
dbDI.insertDensityTextFileIntoDensityInfoDatabase();
dbDI.queryDensityInfoTable();
dbI.insertIngredient(softasilkCakeFlour, cake);
var myIngredientInformation = dbI.queryIngredientFromIngredientsTableByName(softasilkCakeFlour);
dbD.insertIngredientDensityData(softasilkCakeFlour);
var myIngredientDensityInformation = dbD.queryIngredientFromDensityTableByName(softasilkCakeFlour);
dbC.insertIngredientConsumtionData(softasilkCakeFlour);
var myIngredientConsumptionInformation = dbC.queryConsumptionTableRowByName(softasilkCakeFlour);
//i'm getting 0 for ounces remaining still... i need to figure that one out
dbCosts.insertIngredientCostDataCostTable(softasilkCakeFlour);
var myCostIngredientInformation = dbCosts.queryCostsTableByName(softasilkCakeFlour);
Assert.AreEqual("Softasilk Cake Flour", myCostIngredientInformation.name);
Assert.AreEqual(2.98m, myCostIngredientInformation.sellingPrice);
Assert.AreEqual(.0931m, myCostIngredientInformation.pricePerOunce);
Assert.AreEqual("32 oz", myCostIngredientInformation.sellingWeight);
}