public void Them_HD(int Manv, int Maban, bool tt, int Makh, int Tien) { RestaurantManagerDataContext dbs = new RestaurantManagerDataContext(); HOADONBH b = new HOADONBH(); //Tạo 1 hóa đơn mới b.MaNV = Manv; b.MaBan = Maban; b.TrangThai = tt; b.MaKH = Makh; b.TongTien = Tien; dbs.HOADONBHs.InsertOnSubmit(b); dbs.SubmitChanges(); }
private void btnChitiet_ItemClick(object sender, ItemClickEventArgs e) { FrmChitiet f2 = new FrmChitiet(textBox2.Text); //f2.cc = new FrmChitiet.KieuDulieuTruyenRa(nhancc); f2.ShowDialog(); RestaurantManagerDataContext dbs = new RestaurantManagerDataContext(); int r = GridHoadonBH.CurrentCell.RowIndex; string strID = GridHoadonBH.Rows[r].Cells[0].Value.ToString(); HOADONBH kh = dbs.HOADONBHs.Single(p => p.ID.ToString() == strID); dbs.SubmitChanges(); LoadData(); }
private void ThanhToan(Int32 mb) //Hàm thanh toán { RestaurantManagerDataContext dbs = new RestaurantManagerDataContext(); Int32 MaCanSua = mb; Sua2(MaCanSua); HOADONBH hd = dbs.HOADONBHs.FirstOrDefault(p => p.MaBan == mb && p.TrangThai == true); hd.TrangThai = false; MessageBox.Show("Thanh Toán Thành Công !!!"); dgvTable.Update(); loadData(); panelTable.Controls.Clear(); SetUpTable(); dbs.SubmitChanges(); }