public void TestChocolateChips()
{
var dbD = new DatabaseAccessDensityInformation();
var dbR = new DatabaseAccessRecipe();
var t = new DatabaseAccess();
var r = new Recipe("Chooalte Chip Cookies")
{
id = 1
};
var i = new Ingredient("Semi Sweet Morsels")
{
ingredientId = 1, recipeId = 1, sellingWeight = "36 oz", density = 5.35m, measurement = "1 cup"
};
//6.98 1.04
t.initializeDatabase();
//var filename = @"C:\Users\Rachel\Documents\Visual Studio 2015\Projects\RachelsRosesWebPages\RachelsRosesWebPages\densityTxtDatabase.txt";
dbD.insertDensityTextFileIntoDensityInfoDatabase();
t.insertIngredientIntoAllTables(i, r);
var mydensityDataInformation = dbD.queryDensityInfoTable();
var semiSweetMorsels = t.queryAllRelevantTablesSQLByIngredientName(i);
var myRecipes = dbR.MyRecipeBox();
Assert.AreEqual("all purpose flour", mydensityDataInformation[0].name);
Assert.AreEqual(1, myRecipes.Count());
Assert.AreEqual(6.98m, semiSweetMorsels.sellingPrice);
Assert.AreEqual(6.98m, myRecipes[0].ingredients[0].sellingPrice);
Assert.AreEqual(1.04m, semiSweetMorsels.priceOfMeasuredConsumption);
Assert.AreEqual(1.04m, myRecipes[0].ingredients[0].priceOfMeasuredConsumption);
}
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 TestQueryDensityTableDensityByName2()
{
var db = new DatabaseAccess();
var dbDI = new DatabaseAccessDensityInformation();
var softasilkCakeFlour = new Ingredient("Softasilk Cake Flour")
{
typeOfIngredient = "cake flour"
};
db.initializeDatabase();
dbDI.insertDensityTextFileIntoDensityInfoDatabase();
var myIngredientDensityInfo = dbDI.queryDensityTableRowDensityValueByName(softasilkCakeFlour);
Assert.AreEqual(4.5m, myIngredientDensityInfo);
}
public void TestQueryDensityTableDensityByName()
{
var db = new DatabaseAccess();
var dbDI = new DatabaseAccessDensityInformation();
var flour = new Ingredient("All Purpose Flour")
{
density = 5m
};
db.initializeDatabase();
dbDI.insertDensityTextFileIntoDensityInfoDatabase();
var myIngredientDensityInfo = dbDI.queryDensityTableRowDensityValueByName(flour);
Assert.AreEqual(5m, myIngredientDensityInfo);
}
public void TestInsertFileIntoDensityDatabase()
{
var t = new DatabaseAccess();
var dbDI = new DatabaseAccessDensityInformation();
var read = new Reader();
t.initializeDatabase();
dbDI.insertDensityTextFileIntoDensityInfoDatabase();
var myDensityInformationIngredients = dbDI.queryDensityInfoTable();
Assert.AreEqual(41, myDensityInformationIngredients.Count());
Assert.AreEqual("all purpose flour", myDensityInformationIngredients[0].name);
Assert.AreEqual(5m, myDensityInformationIngredients[0].density);
Assert.AreEqual("bananas, mashed", myDensityInformationIngredients[39].name);
Assert.AreEqual(12m, myDensityInformationIngredients[39].density);
}
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);
}