private void btnAdd_Click_1(object sender, RoutedEventArgs e)
{
int tableID = (dtgvBill.Tag as TABLELIST).tableID;
//Lay du lieu tu combobox
int foodID = (cbFood.SelectedItem as FOOD).foodID;
int count = int.Parse(cbSoLuong.Text);
//MessageBox.Show(count+"");
//Kiem tra ban da thanh toan chua neu chua thi them vao bill hien tai neu roi thi tao bill moi
if (DataProvider.Ins.DB.BILLs.Where(x => x.tableID == tableID && x.billStatus == 0).Count() > 0)
{
var bill = DataProvider.Ins.DB.BILLs.Where(x => x.tableID == tableID && x.billStatus == 0).ToList();
//Lay Bill cua ban hien tai
var b = bill.First();
//them billInfo moi
BILLINFO billInfo = new BILLINFO();
billInfo.billID = b.billID;
billInfo.foodID = foodID;
billInfo.count = count;
DataProvider.Ins.DB.BILLINFOes.Add(billInfo);
DataProvider.Ins.DB.SaveChanges();
ShowBill(tableID);
}
else
{
//Tao bill moi
BILL bill = new BILL();
bill.tableID = tableID;
bill.billStatus = 0;
bill.username = AccountLogin.userName;
bill.checkIn = DateTime.Now; //
DataProvider.Ins.DB.BILLs.Add(bill);
DataProvider.Ins.DB.SaveChanges();
//Them billInfo moi
BILLINFO billInfo = new BILLINFO();
billInfo.billID = bill.billID;
billInfo.foodID = foodID;
billInfo.count = count;
DataProvider.Ins.DB.BILLINFOes.Add(billInfo);
DataProvider.Ins.DB.SaveChanges();
//Cap nhat lai thanh ban da co nguoi
var table = DataProvider.Ins.DB.TABLELISTs.Where(x => x.tableID == tableID).ToList();
var tb = table.First();
if (tb != null)
{
tb.tableStatus = "Có người";
}
DataProvider.Ins.DB.SaveChanges();
ShowBill(tableID);
stacklist.Children.Clear();
LoadTable();
}
}
public void CreateNewBillInfo(int idbill, int idproser, int count)
{
BILLINFO bi = new BILLINFO();
bi.IDBILL = idbill;
bi.IDPRO_SER = idproser;
bi.COUNT = count;
spa.BILLINFOs.InsertOnSubmit(bi);
spa.SubmitChanges();
}
public List <BILLINFO> GetListBillInfo(int id)
{
List <BILLINFO> listBillInfo = new List <BILLINFO>();
DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM dbo.BILLINFO WHERE iddrink = " + id);
foreach (DataRow item in data.Rows)
{
BILLINFO info = new BILLINFO(item);
listBillInfo.Add(info);
}
return(listBillInfo);
}
