public void refillIngredientInConsumptionDatabase(Ingredient i, string sellingWeightToRefill, string newExpirationDate)
{
var db = new DatabaseAccess();
var dbIngredients = new DatabaseAccessIngredient();
var convert = new ConvertWeight();
var myConsumptionTable = queryConsumptionTable();
var myIngredientTable = dbIngredients.queryAllIngredientsFromIngredientTable();
var sellingWeightToRefillOunces = convert.ConvertWeightToOunces(sellingWeightToRefill);
foreach (var ingredient in myConsumptionTable)
{
if (ingredient.name.ToLower() == i.name.ToLower())
{
if (i.ouncesRemaining < 0m)
{
i.ouncesRemaining = 0m;
}
i.ouncesRemaining = ingredient.ouncesRemaining + sellingWeightToRefillOunces;
var commandText = "update consumption set ounces_remaining=@ounces_remaining where name=@name;";
db.executeVoidQuery(commandText, cmd => {
cmd.Parameters.AddWithValue("@name", i.name);
cmd.Parameters.AddWithValue("@ounces_remaining", i.ouncesRemaining);
return(cmd);
});
break;
}
}
foreach (var ingredient in myIngredientTable)
{
if (ingredient.ingredientId == i.ingredientId && ingredient.name.ToLower() == i.name.ToLower())
{
ingredient.expirationDate = dbIngredients.convertStringMMDDYYYYToDateYYYYMMDD(newExpirationDate);
var commandText = "update ingredients set expiration_date=@expiration_date where ing_id=@ing_id";
db.executeVoidQuery(commandText, cmd => {
cmd.Parameters.AddWithValue("@expiration_date", dbIngredients.convertDateToStringMMDDYYYY(ingredient.expirationDate));
cmd.Parameters.AddWithValue("@ing_id", ingredient.ingredientId);
return(cmd);
});
break;
}
}
}
public void subtractOuncesRemainingIfExpirationDateIsPast(Ingredient i)
{
var db = new DatabaseAccess();
var dbIngredients = new DatabaseAccessIngredient();
var convert = new ConvertWeight();
var myIngredient = db.queryAllRelevantTablesSQLByIngredientName(i);
if (i.expirationDate < DateTime.Today && (dbIngredients.convertDateToStringMMDDYYYY(i.expirationDate) != "01/01/0001"))
{
myIngredient.ouncesRemaining = myIngredient.ouncesRemaining - i.sellingWeightInOunces;
if (myIngredient.ouncesRemaining < 0m)
{
myIngredient.ouncesRemaining = 0m;
}
var commandText = @"update consumption set ounces_remaining=@ounces_remaining where name=@name";
db.executeVoidQuery(commandText, cmd => {
cmd.Parameters.AddWithValue("@name", myIngredient.name);
cmd.Parameters.AddWithValue("@ounces_remaining", i.ouncesRemaining);
return(cmd);
});
}
var myUpdatedIngredient = queryConsumptionTable();
}