public void TestListOfIngredientsUpdateDensityInfoTable() { var t = new DatabaseAccess(); var dbD = new DatabaseAccessDensityInformation(); var i = new Ingredient("all purpose flour"); var i2 = new Ingredient("pastry flour"); var i3 = new Ingredient("vanilla extract"); var myIngredients = new List <Ingredient> { i, i2, i3 }; t.initializeDatabase(); dbD.insertListIntoDensityInfoDatabase(myIngredients); var BeforeMyDensityInfoTable = dbD.queryDensityInfoTable(); i.density = 5m; i2.density = 4.25m; i3.density = 6.86m; dbD.updateListOfIngredientsInDensityInfoTable(myIngredients); var AfterMyDensityInfoTable = dbD.queryDensityInfoTable(); Assert.AreEqual(3, BeforeMyDensityInfoTable.Count()); Assert.AreEqual(3, AfterMyDensityInfoTable.Count()); Assert.AreEqual(0, BeforeMyDensityInfoTable[0].density); Assert.AreEqual(0, BeforeMyDensityInfoTable[1].density); Assert.AreEqual(0, BeforeMyDensityInfoTable[2].density); Assert.AreEqual(5m, AfterMyDensityInfoTable[0].density); Assert.AreEqual(4.25m, AfterMyDensityInfoTable[1].density); Assert.AreEqual(6.86m, AfterMyDensityInfoTable[2].density); }
public void TestInsertListOfIngredientsIntoDensityInfo() { var t = new DatabaseAccess(); var dbDI = new DatabaseAccessDensityInformation(); var i = new Ingredient("all purpose flour") { density = 5m }; var i2 = new Ingredient("pastry flour") { density = 4.25m }; var i3 = new Ingredient("vanilla extract") { density = 6.86m }; var myIngredients = new List <Ingredient> { i, i2, i3 }; t.initializeDatabase(); dbDI.insertListIntoDensityInfoDatabase(myIngredients); var myDensityInfoTable = dbDI.queryDensityInfoTable(); Assert.AreEqual(3, myDensityInfoTable.Count()); Assert.AreEqual(i.name, myDensityInfoTable[0].name); Assert.AreEqual(i.density, myDensityInfoTable[0].density); Assert.AreEqual(i2.name, myDensityInfoTable[1].name); Assert.AreEqual(i2.density, myDensityInfoTable[1].density); Assert.AreEqual(i3.name, myDensityInfoTable[2].name); Assert.AreEqual(i3.density, myDensityInfoTable[2].density); }