public SO_BatchWPF(SO_Batch batch)
{
this.Id = batch.ID;
this.So_id = batch.SO_ID;
this.Day_number = batch.Day_Number;
this.Flavor = new FlavorWPF(batch.Flavor);
this.Quantity = batch.Quantity;
this.IsMini = batch.Is_Mini;
this.SpecialInstructions = batch.Special_Instructions;
}
public SO_Batch ToSO_Batch()
{
SO_Batch bat = new SO_Batch();
bat.ID = this.Id;
bat.SO_ID = this.So_id;
bat.Day_Number = this.Day_number;
bat.Flavor = this.Flavor.ToFlavor();
bat.Quantity = this.Quantity;
bat.Is_Mini = this.IsMini;
bat.Special_Instructions = this.SpecialInstructions;
return(bat);
}
public List <SO_Batch> GetSOBatches(int SO_ID, bool closeDB = true)
{
List <SO_Batch> batches = new List <SO_Batch>();
try
{
using (SQLiteDataReader rdr = dbComm.ExecuteCommand(@"SELECT * FROM SO_Batch WHERE so_id =" + SO_ID))
{
//SQLiteDataReader tmpRdr = dbComm.ExecuteCommand(@"SELECT * FROM SO_Batch WHERE so_id =" + SO_ID);
while (rdr.Read())
{
SO_Batch bat = new SO_Batch();
bat.ID = int.Parse(rdr["id"].ToString());
bat.SO_ID = int.Parse(rdr["so_id"].ToString());
bat.Day_Number = rdr["day_number"].ToString();
bat.Flavor = GetFlavor(int.Parse(rdr["flavor"].ToString()), false);
// check to see if flavor is null, if so replace ID = 0 (not found) then re-call GetFlavor()
if (bat.Flavor == null)
{
bat.Flavor = GetFlavor(0, false);
}
bat.Quantity = int.Parse(rdr["qty"].ToString());
bat.Is_Mini = (bool)rdr["is_mini"];
bat.QuantityMini = int.Parse(rdr["qty_mini"].ToString());
bat.Special_Instructions = rdr["special_instructions"].ToString();
batches.Add(bat);
}
if (closeDB)
{
dbComm.Close();
}
}
return(batches);
}
catch (Exception ex)
{
Log("GetSOBatches(int) - Error msg:" + ex.Message);
return(null);
}
}
public bool AddSO_Batch(int SO_ID, SO_Batch batch)
{
try
{
Dictionary <string, string> data = new Dictionary <string, string>();
data.Add("so_id", SO_ID.ToString());
data.Add("day_number", batch.Day_Number);
data.Add("flavor", batch.Flavor.ID.ToString());
data.Add("qty", batch.Quantity.ToString());
data.Add("is_mini", batch.Is_Mini.ToString());
data.Add("qty_mini", batch.QuantityMini.ToString());
data.Add("special_instructions", batch.Special_Instructions);
dbComm.Insert("SO_Batch", data);
return(true);
}
catch (Exception ex)
{
Log("AddSO_Batch(int,SO_Batch) - Error msg:" + ex.Message);
return(false);
}
}
public bool UpdateSpecialOrderBatch(int SO_ID, SO_Batch updatedBatch)
{
return(lck.UpdateSpecialOrderBatch(SO_ID, updatedBatch));
}
public bool AddSpecialOrderBatch(int SO_ID, SO_Batch batch)
{
return(lck.AddSO_Batch(SO_ID, batch));
}
