public Cake_BatchWPF(Cake_Batch cake) { this.Id = cake.ID; this.So_id = cake.SO_ID; this.Cake = new CakeWPF(cake.Cake); this.Flavor = new FlavorWPF(cake.Flavor); this.Quantity = cake.Quantity; }
public Cake_Batch ToCake_Batch() { Cake_Batch bat = new Cake_Batch(); bat.ID = this.Id; bat.SO_ID = this.So_id; bat.Cake = this.Cake.ToCake(); bat.Flavor = this.Flavor.ToFlavor(); bat.Quantity = this.Quantity; return(bat); }
public bool AddSO_Cake(int SO_ID, Cake_Batch batch) { try { Dictionary <string, string> data = new Dictionary <string, string>(); data.Add("so_id", SO_ID.ToString()); data.Add("cake_id", batch.Cake.ID.ToString()); data.Add("flavor", batch.Flavor.ID.ToString()); data.Add("qty", batch.Quantity.ToString()); dbComm.Insert("Cake_Batch", data); return(true); } catch (Exception ex) { Log("AddSO_Cake(int,Cake_Batch) - Error msg:" + ex.Message); return(false); } }
public bool UpdateSpecialOrderCake(int SO_ID, Cake_Batch updateCake) { try { Dictionary <string, string> data = new Dictionary <string, string>(); data.Add("so_id", SO_ID.ToString()); data.Add("cake_id", updateCake.Cake.ID.ToString()); data.Add("flavor", updateCake.Flavor.ID.ToString()); data.Add("qty", updateCake.Quantity.ToString()); dbComm.Update("Cake_Batch", data, String.Format("id = {0}", updateCake.ID)); return(true); } catch (Exception ex) { Log("UpdateSpecialOrderBatch(int,SO_Batch) - Error msg:" + ex.Message); return(false); } }
public List <Cake_Batch> GetSOCakes(int SO_ID, bool closeDB = true) { List <Cake_Batch> cakes = new List <Cake_Batch>(); try { using (SQLiteDataReader rdr = dbComm.ExecuteCommand(@"SELECT * FROM Cake_Batch WHERE so_id =" + SO_ID)) { while (rdr.Read()) { Cake_Batch itm = new Cake_Batch(); itm.ID = int.Parse(rdr["id"].ToString()); itm.SO_ID = int.Parse(rdr["so_id"].ToString()); itm.Cake = GetCake(int.Parse(rdr["cake_id"].ToString()), false); itm.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 (itm.Flavor == null) { itm.Flavor = GetFlavor(0, false); } itm.Quantity = int.Parse(rdr["qty"].ToString()); cakes.Add(itm); } if (closeDB) { dbComm.Close(); } } return(cakes); } catch (Exception ex) { Log("GetSOCakes(int) - Error msg:" + ex.Message); return(null); } }
public bool AddSpecialOrderCakeBatch(int SO_ID, Cake_Batch cakeBatch) { return(lck.AddSO_Cake(SO_ID, cakeBatch)); }