public BEL_HoaDonThue LoadHDThueTheoMaDP(string madp)
{
DataTable data = DAL_HoaDonThue.Instance.LoadHDThueTheoMaDP(madp);
BEL_HoaDonThue item = new BEL_HoaDonThue(data.Rows[0]);
return(item);
}
public BEL_HoaDonThue LoadHDThueTheoPhong(string sophong)
{
DataTable data = DAL_HoaDonThue.Instance.LoadHDThueTheoPhong(sophong);
BEL_HoaDonThue item = new BEL_HoaDonThue(data.Rows[0]);
return(item);
}
public bool AddHoaDon(BEL_HoaDonThue hd, string makh, string sophong)
{
string sql_1 = "INSERT INTO [dbo].[HoaDonThuePhong] " + " ( [MaNV] , [MaDatPhong] , [MaTraPhong] ,[MaKH] ,[NgayLapHD] ,[TienDatCoc] ,[TongTienThue] ,[TrangThai]) " +
"VALUES( @manv , @madp , NULL , @makh , GETDATE() , @tiencoc , @tongtien , @trangthai )";
int result_1 = DataProvider.Instance.ExecuteNonQuery(sql_1, new object[] { hd.Manv, hd.Madatphong, hd.Makh, hd.Tiencoc, hd.Tongtien, hd.Trangthai });
return(result_1 > 0);
}
public rpHoaDon(string makh, string sophong, BEL_DatPhong dp, BEL_KhachHang kh, BEL_TraPhong tp, BEL_HoaDonThue hd)
{
InitializeComponent();
this.makh = makh;
this.sophong = sophong;
this.dp = dp;
this.kh = kh;
this.tp = tp;
this.hd = hd;
}
public List <BEL_HoaDonThue> LoadHoaDon()
{
List <BEL_HoaDonThue> list = new List <BEL_HoaDonThue>();
DataTable data = DAL_HoaDonThue.Instance.LoadHoaDon();
foreach (DataRow row in data.Rows)
{
BEL_HoaDonThue item = new BEL_HoaDonThue(row);
list.Add(item);
}
return(list);
}
private void btnDPLuu_Click(object sender, EventArgs e)
{
if (KiemTraTrongDP())
{
string GioiTinh;
if (radDPNam.Checked == true)
{
GioiTinh = "Nam";
}
else
{
GioiTinh = "Nu";
}
BEL_KhachHang kh = new BEL_KhachHang(txtDPMaKH.Text, txtDPHoTenKH.Text, GioiTinh, txtSDTDP.Text, TimeDPNgaySinh.Value, txtDPDiaChi.Text, txtDPQuocTich.Text, txtDPCMND.Text);
BEL_DatPhong dp = new BEL_DatPhong(txtDPMaDP.Text, txtDPMaKH.Text, cbDPSoPhong.Text, TimeDPNgayDat.Value);
BEL_HoaDonThue hd = new BEL_HoaDonThue("NULL", Manv, dp.MaDatPhong, "NULL", kh.MaKH, DateTime.Now, float.Parse(txtDPTienCoc.Text), 0, "Yes");
if (BAL_KhachHang.Instance.LoadKhachHangTheoMa(kh.MaKH) == null)
{
if (BAL_DatPhong.Instance.LoadDatPhongTheoMa(dp.MaDatPhong) == null)
{
if (BAL_KhachHang.Instance.InsertCustomer(kh))
{
if (BAL_DatPhong.Instance.AddDatPhong(dp))
{
MessageBox.Show("Đặt phòng thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
BAL_HoaDonThue.Instance.AddHoaDon(hd, kh.MaKH, dp.SoPhong);
BAL_Phong.Instance.UpdateRoomTrangThai(cbDPSoPhong.Text, "Yes");
XoaTrongDP();
BAL_HoaDonThue.Instance.AddChiTiet(BAL_HoaDonThue.Instance.LoadHDThueTheoMaDP(dp.MaDatPhong).Mahd, dp.SoPhong);
}
}
else
{
MessageBox.Show("Đặt phòng thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Mã đặt phòng trùng", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Mã khách hàng trùng", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Hãy điền đầy đủ thông tin", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool AddHoaDon(BEL_HoaDonThue hd, string makh, string sophong)
{
return(DAL_HoaDonThue.Instance.AddHoaDon(hd, makh, sophong));
}
private void btnTPXuat_Click(object sender, EventArgs e)
{
if (cbbTPSoPhong.Text != "" && txtTPMaTP.Text != "")
{
if (BAL_TraPhong.Instansce.KiemTraTonTai(txtTPMaTP.Text) == false)
{
string sophong = cbbTPSoPhong.Text;
BEL_DatPhong dp = BAL_DatPhong.Instance.LoadDatPhongTheoSoPhong(sophong);
BEL_KhachHang kh = BAL_KhachHang.Instance.LoadKhachHangTheoMa(dp.MaKH);
BEL_TraPhong tp = new BEL_TraPhong(txtTPMaTP.Text, kh.MaKH, dp.SoPhong, DateTime.Now);
BEL_HoaDonThue hd = BAL_HoaDonThue.Instance.LoadHDThueTheoMaDP(dp.MaDatPhong);
BEL_HoaDonDichVu dv = BAL_HoaDonDichVu.Instance.LayHoaDonTheoMaKH(kh.MaKH);
if (dv != null)
{
if (txtTPThanhTien.Text == "0")
{
hd.Tongtien = (float.Parse(txtTPThanhTien.Text)) + float.Parse(dv.Thanhtien);
}
else
{
if (float.Parse(txtTPThanhTien.Text) < hd.Tiencoc)
{
hd.Tongtien = (hd.Tiencoc - float.Parse(txtTPThanhTien.Text)) + float.Parse(dv.Thanhtien);
}
else
{
hd.Tongtien = (float.Parse(txtTPThanhTien.Text) - hd.Tiencoc) + float.Parse(dv.Thanhtien);
}
}
}
else
{
if (txtTPThanhTien.Text == "0")
{
hd.Tongtien = (float.Parse(txtTPThanhTien.Text));
}
else
{
if (float.Parse(txtTPThanhTien.Text) < hd.Tiencoc)
{
hd.Tongtien = (hd.Tiencoc - float.Parse(txtTPThanhTien.Text));
}
else
{
hd.Tongtien = (float.Parse(txtTPThanhTien.Text) - hd.Tiencoc);
}
}
}
hd.Matraphong = txtTPMaTP.Text;
rpHoaDon rp = new rpHoaDon(dp.MaKH, sophong, dp, kh, tp, hd);
rp.ShowDialog();
}
else
{
MessageBox.Show("Trùng mã đặt phòng", "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);
}
}