public fChuyenBan(TaiKhoanDTO taiKhoanHienTai, BanDTO ban) { InitializeComponent(); _taiKhoanHienTai = taiKhoanHienTai; _ban = ban; LoadCBXT(); }
//chuyen qua chon mon private void button1_Click(object sender, EventArgs e) { dsBandadatDTO ban = new dsBandadatDTO(); BanDTO banDTO = new BanDTO(); ban.soban = int.Parse(comboBox1.Text); ban.bookeddate = dateTimePicker1.Value; banDTO.soban = int.Parse(comboBox1.Text); //2. Kiểm tra data hợp lệ or not //3. Thêm vào DB if (dsbanBUS.checkBookStatus(ban.soban, ban.bookeddate)) { System.Windows.MessageBox.Show("Đặt bàn thất bại. Bàn đã bị đặt"); return; } bool kq = dsbanBUS.Them(ban); if (kq == false) { System.Windows.MessageBox.Show("Đặt bàn thất bại. Vui lòng kiểm tra lại dũ liệu"); } else { System.Windows.MessageBox.Show("Đặt bàn thành công"); LapHoaDon frm = new LapHoaDon(banDTO); frm.ShowDialog(); } loadData_Vao_GridView(comboBox1.Text); }
private void BtInTamTinh_Click(object sender, EventArgs e) { try { BanDTO ban = dtgvHoaDon.Tag as BanDTO; string ThanhTien = txbThanhTien.Text; int idHoaDon = HoaDonDAO.Instance.LayIDHoaDonChuaThanhToanBangIDBan(ban.ID); string TenDN = TaiKhoanHienTai.TenDangNhap; string NhanVien = ThongTinTaiKhoanDAO.Instance.GetTenBangTenDN(TenDN); DateTime?GioVao = HoaDonDAO.Instance.GetGioVaoByID(ban.ID); string VAT; if (ckbxGTGT.Checked == true) { VAT = txbGTGT.Text; } else { VAT = "0"; } string ThanhToan = txbTongThanhToan.Text; rptInTam rptInTam = new rptInTam(ban.ID); rptInTam.XuatHoaDon(idHoaDon, ban.TenBan, NhanVien, ThanhTien, GioVao, VAT, ThanhToan); rptInTam.ShowDialog(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnThemBan_Click(object sender, EventArgs e) { BanDTO banTam = new BanDTO(); if (txtTenBan.Text == string.Empty) { MessageBox.Show("Bạn chưa nhập đầy đủ thông tin!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { banTam.Tenban = txtTenBan.Text; banTam.Socho = Convert.ToInt32(nmrSoCho.Value); } if (banBus.ThemBan(banTam)) { MessageBox.Show("Thêm thành công!", "Thành công", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDsBan(); AutoCompleteBan(); } else { MessageBox.Show("Thêm thất bại!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public Ban_Sua(string maBan) { InitializeComponent(); ban = BanDAO.Instance.GetBan(maBan); loadKhuVuc(); fillInput(); }
public BanDTO Constructor02(BanDTO HoaDon) { BanDTO target = new BanDTO(HoaDon); return(target); // TODO: add assertions to method BanDTOTest.Constructor02(BanDTO) }
public int SoGheGet([PexAssumeUnderTest] BanDTO target) { int result = target.SoGhe; return(result); // TODO: add assertions to method BanDTOTest.SoGheGet(BanDTO) }
public BanDTO Constructor01(int maBan, int soGhe) { BanDTO target = new BanDTO(maBan, soGhe); return(target); // TODO: add assertions to method BanDTOTest.Constructor01(Int32, Int32) }
public BanDTO Constructor() { BanDTO target = new BanDTO(); return(target); // TODO: add assertions to method BanDTOTest.Constructor() }
private void btnSuaBan_Click(object sender, EventArgs e) { BanDTO banTam = new BanDTO(); banTam.Soban = Convert.ToInt32(dtgvBan.SelectedCells[0].OwningRow.Cells["colMaBan"].Value.ToString()); if (txtTenBan.Text == string.Empty) { MessageBox.Show("Bạn chưa nhập đầy đủ thông tin!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { banTam.Tenban = txtTenBan.Text; banTam.Socho = Convert.ToInt32(nmrSoCho.Value); } if (banBus.SuaBan(banTam)) { MessageBox.Show("Sửa thành công!", "Thành công", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDsBan(); AutoCompleteBan(); } else { MessageBox.Show("Sửa thất bại!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static bool Ban_ThemSuaXoa(BanDTO b, int type) { string query = ""; switch (type) { case 1: query = "EXEC Ban_Them '" + b.Ban_id + "',N'" + b.Ban_ten + "',N'" + b.Ban_trangthai + "'," + b.Kv_id + "," + b.Ban_xoa + ""; break; case 2: query = "EXEC Ban_Sua '" + b.Ban_id + "',N'" + b.Ban_ten + "',N'" + b.Ban_trangthai + "'," + b.Kv_id + ""; break; case 3: query = "EXEC Ban_Xoa '" + b.Ban_id + "'"; break; } if (conn.ExcuteQuery(query)) { return(true); } else { return(false); } }
public Ban_Them(string defaultMaKV) { InitializeComponent(); ban = new BanDTO(); ban.KhuVuc = KhuVucDAO.Instance.GetKhuVuc(defaultMaKV); loadKhuVuc(); fillInput(); }
public void SoGheSet516() { BanDTO s0 = new BanDTO(0, 0); this.SoGheSet(s0, 0); Assert.IsNotNull((object)s0); Assert.AreEqual <int>(0, s0.MaBan); Assert.AreEqual <int>(0, s0.SoGhe); }
public void Constructor02862() { BanDTO banDTO; BanDTO s0 = new BanDTO(0, 0); banDTO = this.Constructor02(s0); Assert.IsNotNull((object)banDTO); Assert.AreEqual <int>(0, banDTO.MaBan); Assert.AreEqual <int>(0, banDTO.SoGhe); }
public void MaBanGet151() { int i; BanDTO s0 = new BanDTO(0, 0); i = this.MaBanGet(s0); Assert.AreEqual <int>(0, i); Assert.IsNotNull((object)s0); Assert.AreEqual <int>(0, s0.MaBan); Assert.AreEqual <int>(0, s0.SoGhe); }
public LapHoaDon(BanDTO ban) { dsmaBUS = new DSMonAnBUS(); hdBUS = new hoaDonBUS(); nvBUS = new NhanVienBUS(); banBUS = new BanBUS(); banDTO = ban; InitializeComponent(); loadDataVaoComboBox(); loadData_Vao_GridView(); }
public int GetIdBanByTen(string tenBan) { string query = "SELECT * FROM dbo.Ban WHERE TenBan = N'" + tenBan + "'"; DataTable table = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in table.Rows) { BanDTO ban = new BanDTO(item); return(ban.ID); } return(-1); }
public string GetTrangThaiBanBangIDBan(int idBan) { string query = "SELECT * FROM dbo.Ban WHERE id = " + idBan; DataTable table = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in table.Rows) { BanDTO ban = new BanDTO(item); return(ban.TrangThai); } return(string.Empty); }
public List <BanDTO> LoadDsBan() { // Trả về danh sách bàn với các giá trị : Id,Tên bàn, Trạng thái List <BanDTO> tableList = new List <BanDTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("USP_GetTableList"); foreach (DataRow item in data.Rows) { BanDTO table = new BanDTO(item); tableList.Add(table); } return(tableList); }
public string GetTenBan(string tenBan) { // Lấy tên bàn // VD: SELECT * FROM dbo.Ban WHERE TenBan = N'Bàn 01' => Nếu có trả về "Bàn 1" không có trả về "". string query = "SELECT * FROM dbo.Ban WHERE TenBan = N'" + tenBan + "'"; DataTable table = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in table.Rows) { BanDTO ban = new BanDTO(item); return(ban.TenBan); } return(string.Empty); }
public static List <BanDTO> LayDSBan() { List <BanDTO> _ds = new List <BanDTO>(); string sql = "select * from BanAn"; DataTable dt = SqlDataAccessHelper.ExecuteQuery(sql); for (int i = 0; i < dt.Rows.Count; i++) { BanDTO b = new BanDTO(); b.MaBan = int.Parse(dt.Rows[i]["MaSoBan"].ToString()); b.SoGhe = int.Parse(dt.Rows[i]["SoGhe"].ToString()); _ds.Add(b); } return(_ds); }
public bool SuaBan(BanDTO ban) { try { BAN banDB = db.BANs.SingleOrDefault(p => p.SOBAN == ban.Soban && p.TRANGTHAI != 0); banDB.SOCHO = ban.Socho; banDB.TENBAN = ban.Tenban; db.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
public static List <BanDTO> Ban_List() { DataTable dt = Ban_Load(); List <BanDTO> listBan = new List <BanDTO>(); for (int i = 0; i < dt.Rows.Count; i++) { BanDTO ban = new BanDTO(); ban.Ban_id = dt.Rows[i]["ban_id"].ToString(); ban.Ban_ten = dt.Rows[i]["ban_ten"].ToString(); ban.Ban_trangthai = dt.Rows[i]["ban_trangthai"].ToString(); ban.Kv_id = int.Parse(dt.Rows[i]["kv_id"].ToString()); listBan.Add(ban); } return(listBan); }
public static List <BanDTO> Ban_List_KhuVuc(int maKhuVuc) { DataTable dt = conn.getTable("EXEC Ban_Load_KhuVuc " + maKhuVuc + ""); List <BanDTO> listBan = new List <BanDTO>(); for (int i = 0; i < dt.Rows.Count; i++) { BanDTO ban = new BanDTO(); ban.Ban_id = dt.Rows[i]["ban_id"].ToString(); ban.Ban_ten = dt.Rows[i]["ban_ten"].ToString(); ban.Ban_trangthai = dt.Rows[i]["ban_trangthai"].ToString(); ban.Kv_id = int.Parse(dt.Rows[i]["kv_id"].ToString()); listBan.Add(ban); } return(listBan); }
public void LoadDsBan(BanDTO banglobal) { flpBan.Controls.Clear(); List <BanDTO> dsBan = banBUS.LoadDsBan(); foreach (BanDTO item in dsBan) { Button button = new Button() { Width = Instance.ChieuDaiBan, Height = Instance.ChieuRongBan }; button.Click += button_Click; button.Tag = item; button.Image = Image.FromFile(Instance.HinhAnhBan); button.ImageAlign = ContentAlignment.MiddleLeft; button.TextAlign = ContentAlignment.MiddleRight; if (item.Trangthai == 1) { button.Text = item.Tenban + Instance.BanTrong; if (banglobal.Soban != item.Soban) { button.BackColor = Color.LightGreen; } else { button.BackColor = Color.SkyBlue; } } else if (item.Trangthai == 2) { button.Text = item.Tenban + Instance.BanKhongTrong; if (banglobal.Soban != item.Soban) { button.BackColor = Color.LightPink; } else { button.BackColor = Color.SkyBlue; } } flpBan.Controls.Add(button); } }
public bool ThanhToan(BanDTO ban, double tongTien, HoaDonTamDTO hdtam, int Manvlap) { bool flag; try { //HOA_DON hd = db.HOA_DON.Where(u => u.SOBAN == ban.Soban && u.TRANGTHAI == 0).SingleOrDefault(); //hd.TONGTIEN = tongTien; //hd.TRANGTHAI = 1; //db.SaveChanges(); //BAN bandb = db.BANs.Where(u => u.SOBAN == ban.Soban).SingleOrDefault(); //bandb.TRANGTHAI = 1; //db.SaveChanges(); HOA_DON hd = new HOA_DON { SOBAN = hdtam.MaBan, NGAYLAP = DateTime.Now, MANVLAP = Manvlap, TONGTIEN = tongTien }; db.HOA_DON.Add(hd); db.SaveChanges(); foreach (ThucUongDTO tu in hdtam.ListTUTam) { CHI_TIET_HOA_DON cthd = new CHI_TIET_HOA_DON { MAHD = hd.MAHD, MATU = tu.Matu, SL = tu.Soluong, GIABAN = tu.Gia }; db.CHI_TIET_HOA_DON.Add(cthd); db.SaveChanges(); } flag = true; } catch (Exception e) { flag = false; } return(flag); }
//xoa private void button2_Click(object sender, EventArgs e) { BanDTO ban = new BanDTO(); ban.soban = int.Parse(comboBox1.Text); bool kq = banBUS.Xoa(ban); if (kq == false) { MessageBox.Show("Xóa bàn thất bại. Vui lòng kiểm tra lại dũ liệu"); } else { MessageBox.Show("Xóa bàn thành công"); Loaddatavaocombo(); } }
private void datbanToolStripMenuItem_Click(object sender, EventArgs e) { BanDTO ban = new BanDTO(); ban.Ban_id = maban; if (DialogResult.Yes == XtraMessageBox.Show("Bạn có chắc chắn muốn đặt trước bàn" + maban, "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { if (BanBUS.Ban_CapNhatTrangThaiBan(maban, "Đặt trước")) { XtraMessageBox.Show("Bàn" + maban + "đã được đặt"); } else { XtraMessageBox.Show("Lỗi không đặt trước được!"); } Tao_Ban(); } }
public bool ThemBan(BanDTO ban) { try { BAN banDB = new BAN() { SOCHO = ban.Socho, TENBAN = ban.Tenban }; db.BANs.Add(banDB); db.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
public bool ThemBan(BanDTO ban) { try { BAN banDB = new BAN() { SOCHO = ban.Socho, TENBAN = ban.Tenban, TRANGTHAI = Instance.TrangThaiBanTrong }; db.BANs.Add(banDB); db.SaveChanges(); return(true); } catch (Exception e) { return(false); } }