private void btnDVThem_Click(object sender, EventArgs e) { try { if (KiemTraTrong()) { BEL_DichVu dv = new BEL_DichVu(null, txtDVTenDV.Text, float.Parse(txtDVGiaTien.Text), cbbDVDonVi.Text, txtDVGiamGia.Text); if (BAL_DichVu.Instance.AddDichVu(dv)) { MessageBox.Show("Thêm thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDichVu(dgvDichVu); XoaTrong(); } else { MessageBox.Show("Thêm thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Hãy điền đầy đủ thông tin", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch { } }
private void btnThue_Click(object sender, EventArgs e) { if (txtDVSoPhong.Text != "") { if (KiemTraDVTrung(cbbDsDV.Text)) { ListViewItem listview = new ListViewItem(); listview.Text = cbbDsDV.Text; BEL_DichVu dv = BAL_DichVu.Instance.LoadDichVuTheoTen(cbbDsDV.Text); listview.SubItems.Add(new ListViewItem.ListViewSubItem() { Text = dv.Gia.ToString() }); listview.SubItems.Add(new ListViewItem.ListViewSubItem() { Text = dv.Giamgia }); lvDsDichVu.Items.Add(listview); BEL_DichVu item = BAL_DichVu.Instance.LoadDichVuTheoTen(cbbDsDV.Text); DsDV.Add(item); TinhTongTien(); } else { MessageBox.Show("Dịch vụ đã có", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Hãy chọn phòng", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public BEL_DichVu LoadDichVuTheoTen(string ten) { DataTable data = DAL_DichVu.Instance.LoadDichVuTheoTen(ten); BEL_DichVu dv = new BEL_DichVu(data.Rows[0]); return(dv); }
public int UpDichVu(BEL_DichVu dv) { string sql = "UPDATE [dbo].[DichVu] " + "SET TenDichVu = @ten , Gia = @gia , DonViTinh = @donvi , GiamGia = @giamgia WHERE MaDV = @madv "; int result = DataProvider.Instance.ExecuteNonQuery(sql, new object[] { dv.Tendv, dv.Gia, dv.Donvi, dv.Giamgia, dv.Madv }); return(result); }
public int AddDichVu(BEL_DichVu dv) { string sql = "INSERT INTO [dbo].[DichVu] " + "VALUES( @tendv , @gia , @donvi , @trangthai , @giamgia )"; int result = DataProvider.Instance.ExecuteNonQuery(sql, new object[] { dv.Tendv, dv.Gia, dv.Donvi, "Yes", dv.Giamgia }); return(result); }
public int AddChiTiet(BEL_DichVu dv, string mahd, string sophong) { string sql = "INSERT INTO ChiTietHoaDonDichVu " + "VALUES( @madv , @mahd , @sophong )"; int result = DataProvider.Instance.ExecuteNonQuery(sql, new object[] { dv.Madv, mahd, sophong }); return(result); }
public List <BEL_DichVu> TimDichVu(string tendv) { List <BEL_DichVu> list = new List <BEL_DichVu>(); DataTable data = DAL_DichVu.Instance.TimDichVu(tendv); foreach (DataRow row in data.Rows) { BEL_DichVu item = new BEL_DichVu(row); list.Add(item); } return(list); }
public List <BEL_DichVu> LoadListDV() { List <BEL_DichVu> list = new List <BEL_DichVu>(); DataTable data = DAL_DichVu.Instance.LoadListDV(); foreach (DataRow row in data.Rows) { BEL_DichVu item = new BEL_DichVu(row); list.Add(item); } return(list); }
public List <BEL_DichVu> LoadDichVuTheoMaHD(string mahddv) { List <BEL_DichVu> list = new List <BEL_DichVu>(); DataTable data = DAL_DichVu.Instance.LoadDichVuTheoMaHD(mahddv); if (data.Rows.Count > 0) { foreach (DataRow row in data.Rows) { BEL_DichVu item = new BEL_DichVu(row); list.Add(item); } return(list); } return(null); }
private void tbnDVSua_Click(object sender, EventArgs e) { if (KiemTraTrong()) { BEL_DichVu dv = new BEL_DichVu(txtDVMaDV.Text, txtDVTenDV.Text, float.Parse(txtDVGiaTien.Text), cbbDVDonVi.Text, txtDVGiamGia.Text); if (BAL_DichVu.Instance.UpDichVu(dv)) { MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDichVu(dgvDichVu); XoaTrong(); } else { MessageBox.Show("Sửa thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
public bool UpDichVu(BEL_DichVu dv) { int result = DAL_DichVu.Instance.UpDichVu(dv); return(result > 0); }