public void insertIngredientIntoAllTables(Ingredient i, Recipe r)
{
var dbRecipes = new DatabaseAccessRecipe();
var dbIngredients = new DatabaseAccessIngredient();
var dbConsumptionOuncesConsumed = new DatabaseAccessConsumptionOuncesConsumed();
var dbConsumption = new DatabaseAccessConsumption();
var dbDensities = new DatabaseAccessDensities();
var dbDensitiesInformation = new DatabaseAccessDensityInformation();
var dbCosts = new DatabaseAccessCosts();
var myRecipes = dbRecipes.queryRecipes();
//var myIngredientBox = dbIngredients.queryAllIngredientsFromIngredientTable();
var myIngredients = queryAllRelevantTablesSQLByIngredientName(i);
var myRecipe = dbRecipes.queryRecipeFromRecipesTableByName(r);
if (string.IsNullOrEmpty(myRecipe.name))
{
dbRecipes.InsertRecipe(r);
}
dbIngredients.insertIngredient(i, r);
var myIng = queryAllRelevantTablesSQLByIngredientName(i);
dbDensitiesInformation.insertIngredientIntoDensityInfoDatabase(i);
dbDensities.insertIngredientDensityData(i);
dbConsumption.insertIngredientConsumtionData(i);
var myIngUpdated = queryAllRelevantTablesSQLByIngredientName(i);
dbCosts.insertIngredientCostDataCostTable(i);
var myConsumptionIngredient = dbConsumption.queryConsumptionTableRowByName(i);
dbIngredients.UpdateIngredient(i);
var myUpdatedIngredient = queryAllRelevantTablesSQLByIngredientName(i);
}
public void updateAllTables(Ingredient i, Recipe r)
{
var dbRecipes = new DatabaseAccessRecipe();
var dbIngredients = new DatabaseAccessIngredient();
var dbConsumptionOuncesConsumed = new DatabaseAccessConsumptionOuncesConsumed();
var dbConsumption = new DatabaseAccessConsumption();
var dbDensities = new DatabaseAccessDensities();
var dbDensityInformation = new DatabaseAccessDensityInformation();
var dbCosts = new DatabaseAccessCosts();
var myCostTable = dbCosts.queryCostTable();
foreach (var ingredient in myCostTable)
{
if (ingredient.ingredientId == i.ingredientId)
{
if (ingredient.sellingPrice == 0m && i.sellingPrice != 0m)
{
dbCosts.updateCostDataTable(i);
break;
}
}
}
dbRecipes.UpdateRecipe(r);
dbIngredients.UpdateIngredient(i);
var updatedIngredient = queryAllRelevantTablesSQLByIngredientName(i);
dbDensityInformation.updateDensityInfoTable(i);
dbDensities.updateDensityTable(i);
dbCosts.updateCostDataTable(i);
}
public void insertIngredientIntoConsumptionOuncesConsumed(Ingredient i)
{
var db = new DatabaseAccess();
var dbi = new DatabaseAccessIngredient();
var myConsumptionOuncesConsumedIngredient = new Ingredient();
var dbc = new DatabaseAccessConsumption();
var ingredientTableRow = dbi.queryIngredientFromIngredientsTableByName(i);
var consumptiontablerow = dbc.queryConsumptionTableRowByName(i);
if (i.classification.ToLower().Contains("egg"))
{
i.classification = char.ToUpper(i.classification[0]) + i.classification.Substring(1, i.classification.Length - 1);
}
var commandTextQueryMultipleRows = string.Format(@"SELECT ingredients.name, ingredients.measurement, consumption.ounces_consumed, consumption.ounces_remaining
FROM ingredients
JOIN consumption
ON (ingredients.name=consumption.name AND ingredients.measurement=consumption.measurement)
OR (ingredients.ingredient_classification=consumption.name AND ingredients.measurement=consumption.measurement)
WHERE ingredients.name='{0}' AND ingredients.measurement='{1}' AND ingredients.ingredient_classification='{2}';", i.name, i.measurement, i.classification);
var myListOfQueriedIngredients = db.queryItems(commandTextQueryMultipleRows, reader => {
myConsumptionOuncesConsumedIngredient.name = (string)reader["name"];
myConsumptionOuncesConsumedIngredient.measurement = (string)reader["measurement"];
myConsumptionOuncesConsumedIngredient.ouncesConsumed = (decimal)reader["ounces_consumed"];
myConsumptionOuncesConsumedIngredient.ouncesRemaining = (decimal)reader["ounces_remaining"];
return(myConsumptionOuncesConsumedIngredient);
});
var commandTextVarsFilled = string.Format(@"INSERT INTO consumption_ounces_consumed
(name, ounces_consumed, ounces_remaining, measurement)
VALUES ('{0}', {1}, {2}, '{3}');", myListOfQueriedIngredients[0].name, myListOfQueriedIngredients[0].ouncesConsumed, myListOfQueriedIngredients[0].ouncesRemaining, myListOfQueriedIngredients[0].measurement);
db.executeVoidQuery(commandTextVarsFilled, cmd => { return(cmd); });
//as a note to self, i was using the querySingleItem from DatabaseAccess, and that's the difference between my working query and my query that reutrned null...
//something is off w that method.
//check:
var myConsumptionOuncesConsumedTable = queryConsumptionOuncesConsumed();
}
