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