public decimal getPricePerOunce(Ingredient i) { var convert = new ConvertWeight(); var myCostTableIngredients = queryCostTable(); var pricePerOunce = 0m; foreach (var ingredient in myCostTableIngredients) { if (ingredient.name == i.name) { i.sellingPrice = ingredient.sellingPrice; if (i.classification.ToLower().Contains("egg")) { i.sellingWeightInOunces = convert.NumberOfEggsFromSellingQuantity(i.sellingWeight); } else { i.sellingWeightInOunces = convert.ConvertWeightToOunces(ingredient.sellingWeight); } i.pricePerOunce = Math.Round((i.sellingPrice / i.sellingWeightInOunces), 4); pricePerOunce = i.pricePerOunce; } } return(pricePerOunce); }
public void refillIngredientInConsumptionDatabase(Ingredient i, string sellingWeightToRefill) { var db = new DatabaseAccess(); var convert = new ConvertWeight(); var myConsumptionTable = queryConsumptionTable(); var sellingWeightToRefillInOunces = 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 + sellingWeightToRefillInOunces; break; } } 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); }); }
public void insertIngredientDensityData(Ingredient i) { var convert = new ConvertWeight(); var db = new DatabaseAccess(); var dbDensityInformation = new DatabaseAccessDensityInformation(); if (i.sellingPrice == 0m) { myItemResponse = returnItemResponse(i); } i.density = dbDensityInformation.queryDensityTableRowDensityValueByName(i); if (i.sellingPrice == 0m) { i.sellingPrice = myItemResponse.salePrice; } if (i.classification.ToLower() == "egg" || i.classification.ToLower() == "eggs") { i.sellingWeightInOunces = convert.NumberOfEggsFromSellingQuantity(i.sellingWeight); } else { i.sellingWeightInOunces = convert.ConvertWeightToOunces(i.sellingWeight); } if (i.sellingWeightInOunces == 0m) { throw new Exception("Selling Weight In Ounces is 0; please check that your Selling Weight is an appopriate weight."); } i.pricePerOunce = Math.Round((i.sellingPrice / i.sellingWeightInOunces), 4); if (string.IsNullOrEmpty(i.classification)) { i.classification = " "; } var commandText = @"Insert into densities (name, density, selling_weight, selling_weight_ounces, selling_price, price_per_ounce) values (@name, @density, @selling_weight, @selling_weight_ounces, @selling_price, @price_per_ounce);"; db.executeVoidQuery(commandText, cmd => { cmd.Parameters.AddWithValue("@name", i.name); cmd.Parameters.AddWithValue("@density", i.density); cmd.Parameters.AddWithValue("@selling_weight", i.sellingWeight); cmd.Parameters.AddWithValue("@selling_price", i.sellingPrice); cmd.Parameters.AddWithValue("@selling_weight_ounces", i.sellingWeightInOunces); cmd.Parameters.AddWithValue("@price_per_ounce", i.pricePerOunce); return(cmd); }); }
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; } } }