private void addUse()
{
foreach(Dry_Ingredient_Use_Temp dt in diut)
{
Dry_Ingredient_Use use = new Dry_Ingredient_Use();
use.Lot_Code = dt.Lot_Code;
use.bags_used = dt.bags_used;
use.mix_date = dt.mix_date;
use.litres_produced = dt.litresToProduce;
use.flavour = dt.recipe_name;
use.PT_Number = dt.PT_Number;
use.ingredient = dt.ingredient;
use.PT_Number = dt.PT_Number;
ctx.Dry_Ingredient_Use.Add(use);
}
try
{
ctx.SaveChanges();
MessageBox.Show("The Inventory Has Been Adjusted", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
//this.clear(true);
}
catch(Exception ex)
{
Console.WriteLine(ex);
MessageBox.Show("Something Went Wrong /nFrom Add Use Method", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
clearDBandLists();
//foreach (Dry_Ingredient_Use_Temp dt in diut)
//{
// ctx.Dry_Ingredient_Use_Temp.Remove(dt);
//}
//try
//{
// ctx.SaveChanges();
//}
//catch(Exception ex)
//{
// Console.WriteLine(ex);
// MessageBox.Show("Could Not Clear Temporary Use Table/n Creating New Batches will not work until this is resolved");
//}
}
//this is the final save
/// <summary>
/// this is the final save.
/// </summary>
private void saveToDryIngredientUse()
{
string strMessage = "";
foreach(RawMixIngredient ing in listOfIngredientsAndQuantities)
{
if(ing.lotCodes.Count < 1 && ing.name != "Water")
{
strMessage += ing.name + " doesn't have a lot code\n";
}
}
//if (!String.IsNullOrEmpty(strMessage))
//{
// strMessage = "One Or More Ingredients does not have a lot code associated with it.\nWill Not Save";
// MessageBox.Show(strMessage);
//}
//else
//{
foreach (RawMixIngredient ing in listOfIngredientsAndQuantities)
{
foreach (LotCode l in ing.lotCodes)
{
Dry_Ingredient_Use d = new Dry_Ingredient_Use();
d.Lot_Code = l.lotCode;
d.bags_used = l.quantity;
d.mix_date = DateTime.Today;
d.litres_produced = txtAmount.Value;
d.flavour = cmbRecipeName.Text;
d.PT_Number = Convert.ToInt32(txtPtNumber.Value);
d.ingredient = l.ingredientName;
d.purchase_order_number = ing.purchaseOrderNumber;
ctx.Dry_Ingredient_Use.Add(d);
}
}
try
{
ctx.SaveChanges();
MessageBox.Show("Your mix has been saved", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
try
{
ctx.Database.ExecuteSqlCommand("delete from dbo.Dry_Ingredient_Use_Temp");
reloadForm();
}
catch (Exception deletingFromTempGeneralException)
{
ErrorLog log = new ErrorLog();
log.createLogFile(deletingFromTempGeneralException);
MessageBox.Show(deletingFromTempGeneralException.ToString());
}
}
catch (Exception savingToAddUseGeneralException)
{
ErrorLog eLog = new ErrorLog();
eLog.createLogFile(savingToAddUseGeneralException);
MessageBox.Show("Failed. Please see log for details.", "Can't Continue", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//TODO: save to the three new table to be able to reproduce the report
// }
}
