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);
}
