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); }