public void Insert_bill(Button bt, ListView lv, ComboBox cb, NumericUpDown nb, TextBox tx) { DAL_HOADON hd = new DAL_HOADON(); DAL_THONGTINHOADON tt = new DAL_THONGTINHOADON(); BAL_BAN ban = new BAL_BAN(); BEL_BAN tb = lv.Tag as BEL_BAN; hd.Insert_Bill(tb.Soban); int idBill = hd.GetBill(tb.Soban); int idFood = (cb.SelectedItem as BEL_NUOC).Manuoc; int count = (int)nb.Value; if (idBill == -1) { hd.Insert_Bill(idBill); tt.InsertBillInfo(hd.getMaxID(), idFood, count); } else { tt.InsertBillInfo(idBill, idFood, count); } ban.get_lv(lv, tx); ban.showBill(tb.Soban); }
public int Check_out(ListView lv, TextBox tx) { BEL_BAN table = lv.Tag as BEL_BAN; DAL_HOADON bill = new DAL_HOADON(); int idBill = bill.GetBill(table.Soban); return(idBill); }
private void bntThemMon_Click(object sender, EventArgs e) { BEL_BAN table = lsvBill.Tag as BEL_BAN; BAL_HOADON hd = new BAL_HOADON(); hd.Insert_bill(btnThemMon, lsvBill, cboMonAn, nCount, txt_totalprice); loadban(); }
void btn_Click(object sender, EventArgs e) { int tableID = ((sender as Button).Tag as BEL_BAN).Soban; view.Tag = (sender as Button).Tag; showBill(tableID); BEL_BAN table = view.Tag as BEL_BAN; update_ban(tableID, flp); }
private void bntThanhToan_Click(object sender, EventArgs e) { //fHoaDon XuatHoaDon = new fHoaDon(); // XuatHoaDon.ShowDialog(); BAL_HOADON hd = new BAL_HOADON(); DAL_HOADON bill = new DAL_HOADON(); BAL_BAN ban = new BAL_BAN(); BEL_BAN table = lsvBill.Tag as BEL_BAN; ban.get_lv(lsvBill, txt_totalprice); if (hd.Check_out(lsvBill, txt_totalprice) != -1) { if (MessageBox.Show("Bạn có chắc thanh toán hóa đơn cho bàn " + table.Tenban, "Thông báo", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK) { bill.CheckOut(bill.GetBill(table.Soban)); ban.showBill(table.Soban); loadban(); } } }
public List <BEL_BAN> Upate_Ban(int id) { List <BEL_BAN> dsban = new List <BEL_BAN>(); string query = "SELECT* FROM dbo.TableFood Where id = " + id; SqlCommand cmd = new SqlCommand(query, Getcon()); //DataTable ds = new DataTable(); try { SqlDataReader rd = cmd.ExecuteReader(); dt.Load(rd); foreach (DataRow item in dt.Rows) { BEL_BAN ban = new BEL_BAN(item); dsban.Add(ban); } } catch (Exception err) { throw; } return(dsban); }