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 TestGetDensityTableInformationFromDensityTable()
{
var t = new DatabaseAccess();
var dbD = new DatabaseAccessDensities();
var dbDI = new DatabaseAccessDensityInformation();
var chocolateCake = new Recipe("Chocolate Cake")
{
id = 1, yield = 20
};
var cakeFlour = new Ingredient("Softasilk Cake Flour")
{
ingredientId = 1, recipeId = 1, sellingWeight = "32 oz", classification = "flour", typeOfIngredient = "cake flour", measurement = "2 cups 2 tablespoons", density = 4.5m, pricePerOunce = .0931m
};
t.initializeDatabase();
dbDI.insertDensityTextFileIntoDensityInfoDatabase();
dbD.insertIngredientDensityData(cakeFlour);
var myIngrededientTableInformation = dbD.queryIngredientFromDensityTableByName(cakeFlour);
Assert.AreEqual(1, myIngrededientTableInformation.ingredientId);
Assert.AreEqual("32 oz", myIngrededientTableInformation.sellingWeight);
Assert.AreEqual(32m, myIngrededientTableInformation.sellingWeightInOunces);
Assert.AreEqual(2.98m, myIngrededientTableInformation.sellingPrice);
Assert.AreEqual(4.5m, myIngrededientTableInformation.density);
Assert.AreEqual(.0931m, myIngrededientTableInformation.pricePerOunce);
}
public void TestUpdatingSellingWeightInOunces2()
{
var t = new DatabaseAccess();
var dbD = new DatabaseAccessDensities();
var i = new Ingredient("Cake Flour")
{
ingredientId = 1,
sellingWeight = "32 ounces"
};
var i2 = new Ingredient("All-Purpose Flour")
{
ingredientId = 2,
sellingWeight = "2 lbs"
};
var i3 = new Ingredient("Baking Powder")
{
ingredientId = 3,
sellingWeight = "10 oz"
};
t.initializeDatabase();
dbD.insertIngredientDensityData(i);
dbD.insertIngredientDensityData(i2);
dbD.insertIngredientDensityData(i3);
var myIngInfo = dbD.queryDensitiesTableAllRows();
Assert.AreEqual(3, myIngInfo.Count());
Assert.AreEqual(32, myIngInfo[0].sellingWeightInOunces);
Assert.AreEqual(32, myIngInfo[1].sellingWeightInOunces);
Assert.AreEqual(10, myIngInfo[2].sellingWeightInOunces);
}
public void TestDeleteIngredientFromIngredientsTableDeleteOnlyFromIngredientTable()
{
var t = new DatabaseAccess();
var dbI = new DatabaseAccessIngredient();
var dbC = new DatabaseAccessConsumption();
var dbCosts = new DatabaseAccessCosts();
var dbDI = new DatabaseAccessDensityInformation();
var dbD = new DatabaseAccessDensities();
var HoneyButtermilkBread = new Recipe("Honey Buttermilk Bread")
{
id = 1, yield = 24
};
var breadFlour = new Ingredient("King Arthur Bread Flour")
{
ingredientId = 1, recipeId = 1, measurement = "6 cups", sellingWeight = "5 lb", typeOfIngredient = "bread flour", classification = "flour"
};
t.initializeDatabase();
t.insertIngredientIntoAllTables(breadFlour, HoneyButtermilkBread);
var myIngredientBox = dbI.myIngredientBox();
dbI.DeleteIngredientFromIngredientTable(breadFlour);
var myIngredientTableCount = dbI.queryAllIngredientsFromIngredientTable().Count();
var myIngredientBoxCount = dbI.myIngredientBox().Count();
var myCostTableCount = dbCosts.queryCostTable().Count();
var myDensitiesTableCount = dbD.queryDensitiesTableAllRows().Count();
var myDensityInformationTableCount = dbDI.queryDensityInfoTable().Count();
var myConsumptionTable = dbC.queryConsumptionTable().Count();
Assert.AreEqual(0, myIngredientTableCount);
Assert.AreEqual(1, myCostTableCount);
Assert.AreEqual(1, myDensitiesTableCount);
Assert.AreEqual(1, myConsumptionTable);
}
public ActionResult DeleteIngredientFromDensityTable(Ingredient ingredient)
{
var dbD = new DatabaseAccessDensities();
dbD.DeleteIngredientFromDensitiesTable(ingredient);
return(Redirect("/home/densityInformationTable"));
}
public void TestInsertionIntoAllTables()
{
var t = new DatabaseAccess();
var dbI = new DatabaseAccessIngredient();
var dbC = new DatabaseAccessConsumption();
var dbCosts = new DatabaseAccessCosts();
var dbD = new DatabaseAccessDensities();
var r = new Recipe("Honey Buttermilk Bread")
{
id = 1
};
var i = new Ingredient("King Arthur Bread Flour")
{
recipeId = 1,
ingredientId = 1,
sellingWeight = "5 lb",
measurement = "6 cups",
density = 5.4m
};
t.initializeDatabase();
t.insertIngredientIntoAllTables(i, r);
var myIngInfo = dbI.queryAllIngredientsFromIngredientTable();
var myIngCons = dbC.queryConsumptionTable();
var myIngDens = dbD.queryDensitiesTableAllRows();
var myIngCost = dbCosts.queryCostTable();
Assert.AreEqual(1, myIngInfo.Count());
Assert.AreEqual(1, myIngCons.Count());
Assert.AreEqual(1, myIngDens.Count());
Assert.AreEqual(1, myIngCost.Count());
}
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 TestUpdatingSellingPrice2()
{
var t = new DatabaseAccess();
var dbD = new DatabaseAccessDensities();
var rest = new MakeRESTCalls();
var i = new Ingredient("Bread Flour")
{
ingredientId = 1,
sellingWeight = "5 pound"
};
var i2 = new Ingredient("Softasilk Cake Flour")
{
ingredientId = 2,
sellingWeight = "32 ounces"
};
var i3 = new Ingredient("Pillsbury All-Purpose Flour")
{
ingredientId = 3,
sellingWeight = "2 pounds"
};
var i4 = new Ingredient("Baking Powder")
{
ingredientId = 4,
sellingWeight = "10 ounces"
};
var response = new ItemResponse()
{
name = "King Arthur Flour Unbleached Bread Flour, 5.0 LB"
};
var response2 = new ItemResponse()
{
name = "Pillsbury Softasilk: Enriched Bleached Cake Flour, 32 Oz"
};
var response3 = new ItemResponse()
{
name = "Pillsbury Best All Purpose Bleached Enriched Pre-Sifted Flour, 2 lb"
};
var respone4 = new ItemResponse()
{
name = "Rumford Premium Aluminum-Free Baking Powder, 10 oz"
};
t.initializeDatabase();
dbD.insertIngredientDensityData(i);
dbD.insertIngredientDensityData(i2);
dbD.insertIngredientDensityData(i3);
dbD.insertIngredientDensityData(i4);
var myIngInfo = dbD.queryDensitiesTableAllRows();
Assert.AreEqual(4, myIngInfo.Count());
Assert.AreEqual(rest.GetItemResponse(i), myIngInfo[0].sellingPrice);
Assert.AreEqual(rest.GetItemResponse(i2), myIngInfo[1].sellingPrice);
Assert.AreEqual(rest.GetItemResponse(i3), myIngInfo[2].sellingPrice);
Assert.AreEqual(rest.GetItemResponse(i4), myIngInfo[3].sellingPrice);
}
public void TestDeleteIngredientFromIngredientsTableAndAccessOtherTablesForDeletedIngredient()
{
var t = new DatabaseAccess();
var dbI = new DatabaseAccessIngredient();
var dbC = new DatabaseAccessConsumption();
var dbCosts = new DatabaseAccessCosts();
var dbD = new DatabaseAccessDensities();
var honeyButtermilkBread = new Recipe("Honey Buttermilk Bread")
{
id = 1, yield = 24
};
var cinnamonButtermilkBread = new Recipe("Cinnamon Buttermilk Bread")
{
id = 2, yield = 24
};
var breadFlour1 = new Ingredient("King Arthur Bread Flour")
{
ingredientId = 1, recipeId = 1, measurement = "6 cups", sellingWeight = "5 lb", typeOfIngredient = "bread flour", classification = "flour"
};
var breadFlour2 = new Ingredient("King Arthur Bread Flour")
{
ingredientId = 2, recipeId = 2, measurement = "6 cups", sellingWeight = "5 lb", typeOfIngredient = "bread flour", classification = "flour"
};
var salt = new Ingredient("Salt")
{
ingredientId = 3, recipeId = 2, measurement = "1 tablespoon", sellingWeight = "48 oz", typeOfIngredient = "salt", classification = "salt"
};
t.initializeDatabase();
t.insertIngredientIntoAllTables(breadFlour1, honeyButtermilkBread);
t.insertIngredientIntoAllTables(breadFlour2, cinnamonButtermilkBread);
t.insertIngredientIntoAllTables(salt, cinnamonButtermilkBread);
var myIngredientBox = dbI.myIngredientBox();
dbI.DeleteIngredientFromIngredientTable(breadFlour1);
dbI.DeleteIngredientFromIngredientTable(breadFlour2);
var myIngredientTable = dbI.queryAllIngredientsFromIngredientTable();
var myCostTable = dbCosts.queryCostTable();
var myDensitiesTable = dbD.queryDensitiesTableAllRows();
var myConsumptionTable = dbC.queryConsumptionTable();
Assert.AreEqual(1, myIngredientTable.Count());
Assert.AreEqual("Salt", myIngredientTable[0].name);
Assert.AreEqual(3, myCostTable.Count());
Assert.AreEqual(3, myDensitiesTable.Count());
Assert.AreEqual(2, myConsumptionTable.Count());
}
public void TestUpdatingSellingPrice()
{
var t = new DatabaseAccess();
var dbD = new DatabaseAccessDensities();
var i = new Ingredient("Bread Flour")
{
ingredientId = 1,
sellingWeight = "5 lb"
};
t.initializeDatabase();
dbD.insertIngredientDensityData(i);
var myIngInfo = dbD.queryDensitiesTableAllRows();
Assert.AreEqual(1, myIngInfo.Count());
Assert.AreEqual(2.62m, myIngInfo[0].sellingPrice);
}
public void TestGetListOfDistinctSellingWeights()
{
var t = new DatabaseAccess();
var dbD = new DatabaseAccessDensities();
var chocolateCake = new Recipe("Chocolate Cake")
{
id = 1, yield = 20
};
var eggs = new Ingredient("Eggs")
{
ingredientId = 1, recipeId = 1, sellingWeight = "1 dozen", sellingPrice = 1.50m, classification = "eggs", typeOfIngredient = "eggs", measurement = "3 eggs", expirationDate = new DateTime(2017, 3, 14)
};
var cakeFlour = new Ingredient("Softasilk Cake Flour")
{
ingredientId = 2, recipeId = 1, sellingWeight = "32 oz", classification = "flour", typeOfIngredient = "cake flour", measurement = "2 cups 2 tablespoons"
};
var bakingPowder = new Ingredient("Baking Powder")
{
ingredientId = 3, recipeId = 1, sellingWeight = "10 oz", typeOfIngredient = "baking powder", measurement = "2 1/2 teaspoons", classification = "rising agent"
};
var salt = new Ingredient("Salt")
{
ingredientId = 4, recipeId = 1, sellingWeight = "48 oz", typeOfIngredient = "salt", measurement = "1 teaspoon", classification = "salt"
};
var cocoaPowder = new Ingredient("Semi Sweet Cocoa")
{
ingredientId = 5, recipeId = 1, sellingWeight = "16 oz", typeOfIngredient = "baking cocoa", measurement = "1 cup", classification = "cocoa powder"
};
var chocolateCakeIngredients = new List <Ingredient> {
eggs, cakeFlour, bakingPowder, salt, cocoaPowder
};
t.initializeDatabase();
t.insertListOfIngredientsIntoAllTables(chocolateCakeIngredients, chocolateCake);
var myIngredientBox = t.queryAllTablesForAllIngredients(chocolateCakeIngredients);
var myListOfSellingWeights = dbD.getListOfDistinctSellingWeights();
Assert.AreEqual(5, myListOfSellingWeights.Count());
Assert.AreEqual(eggs.sellingWeight, myListOfSellingWeights[0]);
Assert.AreEqual(cakeFlour.sellingWeight, myListOfSellingWeights[1]);
Assert.AreEqual(bakingPowder.sellingWeight, myListOfSellingWeights[2]);
Assert.AreEqual(salt.sellingWeight, myListOfSellingWeights[3]);
Assert.AreEqual(cocoaPowder.sellingWeight, myListOfSellingWeights[4]);
}
public void TestSellingWeightDataType()
{
var t = new DatabaseAccess();
var dbD = new DatabaseAccessDensities();
var i = new Ingredient("Bread Flour")
{
ingredientId = 1,
sellingWeightInOunces = 80m,
sellingWeight = "5 lbs"
};
t.initializeDatabase();
dbD.insertIngredientDensityData(i);
var myIngInfo = dbD.queryDensitiesTableAllRows();
Assert.AreEqual(1, myIngInfo.Count());
Assert.AreEqual(i.sellingWeight, myIngInfo[0].sellingWeight);
Assert.AreEqual(i.sellingWeightInOunces, myIngInfo[0].sellingWeightInOunces);
Assert.AreEqual(80m, myIngInfo[0].sellingWeightInOunces);
}
public void TestPricePerOunce()
{
var t = new DatabaseAccess();
var dbD = new DatabaseAccessDensities();
var rest = new MakeRESTCalls();
var i = new Ingredient("King Arthur Bread Flour")
{
ingredientId = 1,
sellingWeight = "5 lb"
};
var response = new ItemResponse()
{
name = "King Arthur Flour Unbleached Bread Flour, 5.0 LB"
};
t.initializeDatabase();
dbD.insertIngredientDensityData(i);
var myIngInfo = dbD.queryDensitiesTableAllRows();
Assert.AreEqual(.0525m, myIngInfo[0].pricePerOunce);
}
public void TestDensitiesDatabase2()
{
var t = new DatabaseAccess();
var dbD = new DatabaseAccessDensities();
var i = new Ingredient("Honey, raw")
{
density = 12m,
sellingWeight = "32 ounces",
sellingPrice = 5.59m,
sellingWeightInOunces = 32m
};
i.pricePerOunce = i.sellingPrice / i.sellingWeightInOunces;
t.initializeDatabase();
dbD.insertIngredientDensityData(i);
var myIngredientInformation = dbD.queryDensitiesTableAllRows();
Assert.AreEqual(1, myIngredientInformation.Count());
Assert.AreEqual(i.density, (decimal)myIngredientInformation[0].density);
Assert.AreEqual(i.sellingWeight, (string)myIngredientInformation[0].sellingWeight);
}
public void TestUpdateDensityDatabase2()
{
var t = new DatabaseAccess();
var dbD = new DatabaseAccessDensities();
var i = new Ingredient("Butter")
{
ingredientId = 1,
density = 8m,
sellingWeight = "1 lb",
sellingPrice = 3.99m
};
t.initializeDatabase();
dbD.insertIngredientDensityData(i);
var myIngInfo = dbD.queryDensitiesTableAllRows();
Assert.AreEqual(1, myIngInfo.Count());
Assert.AreEqual(1, myIngInfo[0].ingredientId);
Assert.AreEqual(i.density, myIngInfo[0].density);
Assert.AreEqual(i.sellingWeight, myIngInfo[0].sellingWeight);
Assert.AreEqual(i.sellingPrice, myIngInfo[0].sellingPrice);
}
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);
}
public void TestDensitiesDatabase()
{
var t = new DatabaseAccess();
var dbD = new DatabaseAccessDensities();
var i = new Ingredient("King Arthur Bread Flour")
{
ingredientId = 1,
density = 4.5m,
pricePerOunce = .0525m,
sellingWeight = "5 lbs",
sellingPrice = 4.20m
};
t.initializeDatabase();
dbD.insertIngredientDensityData(i);
var myIngredientInformation = dbD.queryDensitiesTableAllRows();
Assert.AreEqual(1, myIngredientInformation.Count());
Assert.AreEqual(i.name, myIngredientInformation[0].name);
Assert.AreEqual(i.density, (decimal)myIngredientInformation[0].density);
Assert.AreEqual(i.pricePerOunce, (decimal)myIngredientInformation[0].pricePerOunce);
Assert.AreEqual(i.sellingWeight, (string)myIngredientInformation[0].sellingWeight);
Assert.AreEqual(i.sellingPrice, (decimal)myIngredientInformation[0].sellingPrice);
}
