Пример #1
0
        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();
        }
Пример #3
0
        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();
        }