public void CreateNewBill_Or_UpdateBill(Table table, ComboBox cbDrink) { long idBillMax; long idDrink = (cbDrink.SelectedItem as Drink).Id;; long idBill = GetBillId_By_TableId(table.Id); if (idBill == -1) { InsertBill(table.Id); idBillMax = GetMaxBillId(); BillInfoProvider.Instance.InsertBillInfo(idDrink, idBillMax); } else { BillInfo billInfo = BillInfoProvider.Instance.GetBillInfo_ByDrinkID_And_BillId(idDrink, idBill); if (billInfo != null) { BillInfoProvider.Instance.UpdateBillInfo(idDrink, idBill); } else { BillInfoProvider.Instance.InsertBillInfo(idDrink, idBill); } } }
private void button3_Click(object sender, EventArgs e) { BillInfo billinfo = new BillInfo(dgv); billinfo.FormClosed += new FormClosedEventHandler(billinfo_closed); this.Hide(); billinfo.ShowDialog(); }
public List <BillInfo> GetListBillInfo_By_Id() // Unit Test { List <BillInfo> listBillInfo = new List <BillInfo>(); DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM BillInfo"); foreach (DataRow item in data.Rows) { BillInfo billInfo = new BillInfo(item); listBillInfo.Add(billInfo); } return(listBillInfo); }
public BillInfo GetBillInfo_ByDrinkID_And_BillId(long idDrink, long idBill) // Unit Test { try { string query = "SELECT * FROM BillInfo WHERE IdDrink = " + idDrink.ToString() + " AND IdBill = " + idBill.ToString(); DataTable dataBillInfo = DataProvider.Instance.ExecuteQuery(query); BillInfo billInfo = new BillInfo(dataBillInfo.Rows[0]); return(billInfo); } catch { return(null); } }