public decimal doubleAverageOuncesConsumed(Ingredient i)
{
var convert = new ConvertMeasurement();
var ouncesConsumedTable = new DatabaseAccessConsumptionOuncesConsumed();
var listOfIngredientOuncesConsumed = new List <decimal>();
var myIngredientOuncesConsumedTable = ouncesConsumedTable.queryConsumptionOuncesConsumed();
foreach (var ingredient in myIngredientOuncesConsumedTable)
{
if (ingredient.name == i.name)
{
listOfIngredientOuncesConsumed.Add(ingredient.ouncesConsumed);
}
}
var count = listOfIngredientOuncesConsumed.Count();
if (count > 0)
{
var aggregatedOuncesConsumed = 0m;
foreach (var measurement in listOfIngredientOuncesConsumed)
{
aggregatedOuncesConsumed += measurement;
}
return(Math.Round((aggregatedOuncesConsumed / count) * 2, 2));
}
else
{
return(0m);
}
}
//i need to rewrite the query to call a different () to get all the information for all the ingredients... i'm not getting an ing.id, densities...
//only the name and the measurement
public void UpdateRecipeYield(Recipe r)
{
var db = new DatabaseAccess();
var dbDensities = new DatabaseAccessDensityInformation();
var convert = new ConvertMeasurement();
var myRecipeBox = MyRecipeBox();
foreach (var recipe in myRecipeBox)
{
var myIngredients = db.queryAllTablesForAllIngredients(recipe.ingredients);
var tempIngredient = new Ingredient();
if (recipe.id == r.id)
{
foreach (var ingredient in recipe.ingredients)
{
tempIngredient = ingredient;
if (tempIngredient.density == 0)
{
tempIngredient.density = dbDensities.queryDensityTableRowDensityValueByName(ingredient);
}
tempIngredient.measurement = convert.AdjustIngredientMeasurement(ingredient.measurement, recipe.yield, r.yield);
tempIngredient.ouncesConsumed = ingredient.ouncesConsumed * (HomeController.currentRecipe.yield / r.yield);
db.updateAllTables(tempIngredient, r);
var myUpdatedIngredient = db.queryAllRelevantTablesSQLByIngredientName(tempIngredient);
}
recipe.yield = r.yield;
GetFullRecipePrice(recipe);
var myUpdatedIngredients = db.queryAllTablesForAllIngredients(recipe.ingredients);
}
}
}
public void TablespoonsToTesaspoons2()
{
var convert = new ConvertMeasurement();
var expected = 19.50;
var actual = convert.TablespoonsToTeaspoons(6.5m);
Assert.AreEqual(expected, actual);
}
public void AdjustTotalMeasurement19()
{
var convert = new ConvertMeasurement();
var expected = "20 eggs";
var actual = convert.AdjustIngredientMeasurement("5 eggs", 20, 80);
Assert.AreEqual(expected, actual);
}
public void TesSplittingMeasurement3()
{
var convert = new ConvertMeasurement();
var expected = new string[] { "3 1/4 cups", "2 teaspoons" };
var actual = convert.SplitMultiLevelMeasurement("3 1/4 cups 2 teaspoons");
Assert.AreEqual(expected, actual);
}
public void TablespoonsToCups2()
{
var convert = new ConvertMeasurement();
var expected = .66;
var actual = convert.TablespoonsToCups(10.56m);
Assert.AreEqual(expected, actual);
}
public void cupsToTeaspoons()
{
var convert = new ConvertMeasurement();
var expected = 48;
var actual = convert.CupsToTeaspoons(1m);
Assert.AreEqual(expected, actual);
}
public void CondenseTeaspoonMeasurement6()
{
var convert = new ConvertMeasurement();
var expected = "1 tablespoons";
var actual = convert.CondenseTeaspoonMeasurement(3m);
Assert.AreEqual(expected, actual);
}
public void CondenseTeaspoonsMeasurements14()
{
var convert = new ConvertMeasurement();
var expected = "2 pinches";
var actual = convert.CondenseTeaspoonMeasurement(.12m);
Assert.AreEqual(expected, actual);
}
public void TestSplittingMeasurements10()
{
var convert = new ConvertMeasurement();
var expected = new string[] { "1 1/2 pinches" };
var actual = convert.SplitMultiLevelMeasurement("1 1/2 pinches");
Assert.AreEqual(expected, actual);
}
public void TestSplittingMeasurements11()
{
var convert = new ConvertMeasurement();
var expected = new string[] { "2 teaspoons", "1 pinch" };
var actual = convert.SplitMultiLevelMeasurement("2 teaspoons 1 pinch");
Assert.AreEqual(expected, actual);
}
public void TestSplittingMeasurements8()
{
var convert = new ConvertMeasurement();
var expected = new string[] { "1 cup", "1 tablespoon", "1 teaspoon", "1 pinch" };
var actual = convert.SplitMultiLevelMeasurement("1 cup 1 tablespoon 1 teaspoon 1 pinch");
Assert.AreEqual(expected, actual);
}
public void TestSplittingMeasurements9()
{
var convert = new ConvertMeasurement();
var expected = new string[] { "1 1/2 cups", "2 1/8 tablespoons", "1 1/4 teaspoons", "2 pinches" };
var actual = convert.SplitMultiLevelMeasurement("1 1/2 cups 2 1/8 tablespoons 1 1/4 teaspoons 2 pinches");
Assert.AreEqual(expected, actual);
}
public void TestSplittingMeasurements7()
{
var convert = new ConvertMeasurement();
var expected = new string[] { "4 7/8 cups", "3 1/2 tablespoons", "1/2 teaspoons" };
var actual = convert.SplitMultiLevelMeasurement("4 7/8 cups 3 1/2 tablespoons 1/2 teaspoons");
Assert.AreEqual(expected, actual);
}
public void TestSplittingMeasurements6()
{
var convert = new ConvertMeasurement();
var expected = new string[] { "6 3/4 cup", "1 1/2 tablespoons", "2 teaspoons" };
var actual = convert.SplitMultiLevelMeasurement("6 3/4 cup 1 1/2 tablespoons 2 teaspoons");
Assert.AreEqual(expected, actual);
}
public void TeaspoonsToTablespoons2()
{
var convert = new ConvertMeasurement();
var expected = 5.67m;
var actual = convert.teaspoonsToTablespoons(17m);
Assert.AreEqual(expected, actual);
}
public void AdjustTeaspoonValues3()
{
var convert = new ConvertMeasurement();
var expected = 1m;
var actual = convert.ApplyMultiplierToTeaspoons(3m, .333m);
Assert.AreEqual(expected, actual);
}
public void TestSplittingEggMeasurements5()
{
var convert = new ConvertMeasurement();
var expected = new string[] { "256.125", "eggs" };
var actual = convert.SplitAndAdjustEggMeasurement("256 1/8 eggs", 1);
Assert.AreEqual(expected, actual);
}
public void CondenseTeaspoonMeasurement3()
{
var convert = new ConvertMeasurement();
var expected = "2 cups";
var actual = convert.CondenseTeaspoonMeasurement(96);
Assert.AreEqual(expected, actual);
}
public void TestSplittingEggMeasurements6()
{
var convert = new ConvertMeasurement();
var expected = new string[] { "16", "egg whites" };
var actual = convert.SplitAndAdjustEggMeasurement("4 egg whites", 4);
Assert.AreEqual(expected, actual);
}
public void CondenseTeaspoonsMeasurements10()
{
var convert = new ConvertMeasurement();
var expected = "9 cups";
var actual = convert.CondenseTeaspoonMeasurement(432m);
Assert.AreEqual(expected, actual);
}
public void TestSplittingEggMeasurements7()
{
var convert = new ConvertMeasurement();
var expected = new string[] { "6", "egg yolks" };
var actual = convert.SplitAndAdjustEggMeasurement("2 egg yolks", 3);
Assert.AreEqual(expected, actual);
}
public void AdjustTotalMeasurement()
{
var convert = new ConvertMeasurement();
var expected = "1 cups";
var actual = convert.AdjustIngredientMeasurement("1/2 cup", 2, 4);
Assert.AreEqual(expected, actual);
}
public void AccumulatingTeaspoonsFromVariousMeasurements6()
{
var convert = new ConvertMeasurement();
var expected = 56.5m;
var actual = convert.AccumulatedTeaspoonMeasurement("1 cup 2 tablespoons 2 1/2 teaspoons");
Assert.AreEqual(expected, actual);
}
public void AdjustTotalMeasurement3()
{
var convert = new ConvertMeasurement();
var expected = "1 teaspoons";
var actual = convert.AdjustIngredientMeasurement("1 tablespoon", 6, 2);
Assert.AreEqual(expected, actual);
}
public void ConvertStringMeasurementTeaspoonsToDecimalTeaspoons4()
{
var convert = new ConvertMeasurement();
var expected = 1.5m;
var actual = convert.AdjustToTeaspoons("1 1/2 teaspoons");
Assert.AreEqual(expected, actual);
}
public void AdjustTotalMeasurement18()
{
var convert = new ConvertMeasurement();
var expected = "1.5 eggs";
var actual = convert.AdjustIngredientMeasurement("3 eggs", 8, 4);
Assert.AreEqual(expected, actual);
}
public void AccumulatingTeaspoonsFromVariousMeasurements9()
{
var convert = new ConvertMeasurement();
var expected = 1.06m;
var actual = convert.AccumulatedTeaspoonMeasurement("1 teaspoon 1 pinch");
Assert.AreEqual(expected, actual);
}
public void AccumulatingTeaspoonsFromVariousMeasurements7()
{
var convert = new ConvertMeasurement();
var expected = 77.12m;
var actual = convert.AccumulatedTeaspoonMeasurement("1 1/2 cups 1 tablespoon 2 1/8 teaspoons");
Assert.AreEqual(expected, actual);
}
public void ConvertStringMeasurementsPinchToDecimalTeaspoons()
{
var convert = new ConvertMeasurement();
var expected = 0.06m;
var actual = convert.AdjustToTeaspoons("1 pinch");
Assert.AreEqual(expected, actual);
}
