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);
}
}
