public ActionResult ConsumptionTable()
{
var dbC = new DatabaseAccessConsumption();
ViewBag.consumptiontable = dbC.queryConsumptionTable();
return(View());
}
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 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 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());
}