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