private void btnPhong_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
txtDVSoPhong.Text = btn.Text;
lvDsDichVu.Items.Clear();
BEL_DatPhong dp = BAL_DatPhong.Instance.LoadDatPhongTheoSoPhong(txtDVSoPhong.Text);
BEL_HoaDonDichVu hddv = BAL_HoaDonDichVu.Instance.LayHoaDonTheoMaKH(dp.MaKH);
if (hddv != null)
{
DsDVDaCo = BAL_DichVu.Instance.LoadDichVuTheoMaHD(hddv.Mahd.ToString());
if (DsDVDaCo.Count > 0)
{
foreach (BEL_DichVu dv in DsDVDaCo)
{
ListViewItem lvitem = new ListViewItem();
lvitem.Text = dv.Tendv;
lvitem.SubItems.Add(new ListViewItem.ListViewSubItem()
{
Text = dv.Gia.ToString()
});
lvitem.SubItems.Add(new ListViewItem.ListViewSubItem()
{
Text = dv.Giamgia.ToString()
});
lvDsDichVu.Items.Add(lvitem);
}
}
TinhTongTien();
}
}
private void btnDVThanhToan_Click(object sender, EventArgs e)
{
if (txtDVTong.Text != "0")
{
if (DsDV.Count > 0 && DsDVDaCo.Count == 0)
{
BEL_DatPhong DP = BAL_DatPhong.Instance.LoadDatPhongTheoSoPhong(txtDVSoPhong.Text);
BEL_HoaDonDichVu hd = new BEL_HoaDonDichVu(0, DP.MaKH, DateTime.Now, txtDVTong.Text, TK1.Manv.ToString());
BAL_HoaDonDichVu.Instance.AddHoaDonDV(hd);
BAL_HoaDonDichVu.Instance.AddChiTiet(DsDV, txtDVSoPhong.Text);
lvDsDichVu.Items.Clear();
MessageBox.Show("Thêm dịch vụ thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
if (DsDV.Count > 0 && DsDVDaCo.Count > 0)
{
BAL_HoaDonDichVu.Instance.AddChiTiet(DsDV, txtDVSoPhong.Text);
BEL_DatPhong dp = BAL_DatPhong.Instance.LoadDatPhongTheoSoPhong(txtDVSoPhong.Text);
BEL_HoaDonDichVu hddv = BAL_HoaDonDichVu.Instance.LayHoaDonTheoMaKH(dp.MaKH);
BAL_HoaDonDichVu.Instance.UpTongTien(hddv.Mahd.ToString(), txtDVTong.Text);
lvDsDichVu.Items.Clear();
MessageBox.Show("Thêm dịch vụ thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
if (DsDV.Count == 0)
{
MessageBox.Show("Chưa có dịch mới được chọn", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Hãy chọn chọn dịch vụ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void cbbTPSoPhong_SelectedValueChanged(object sender, EventArgs e)
{
try
{
string sophong = cbbTPSoPhong.Text;
BEL_DatPhong dp = BAL_DatPhong.Instance.LoadDatPhongTheoSoPhong(sophong);
BEL_KhachHang kh = BAL_KhachHang.Instance.LoadKhachHangTheoMa(dp.MaKH);
BEL_Phong Phong = BAL_Phong.Instance.LoadRoomSoPhong(sophong);
BEL_LoaiPhong loaiphong = BAL_LoaiPhong.Instance.LoadLoaiPhongTheoMa(Phong.Maloaiphong);
txtTPHoTen.Text = kh.Hotenkh;
TimeTPNgaySinh.Value = kh.Ngaysinh;
if (kh.Gioitinh == "Nam")
{
radTPNam.Checked = true;
}
else
{
radTPNu.Checked = true;
}
txtTPSDT.Text = kh.Sdt;
txtTPDiaChi.Text = kh.Diachi;
txtTPQuocTich.Text = kh.Quoctich;
txtTPCMND.Text = kh.Cmnd;
TimeTPNgayDat.Value = dp.NgayDatPhong;
DateTime dt = TimeTPNgayTra.Value;
TimeSpan t = dt.Subtract(dp.NgayDatPhong);
double day = t.TotalDays;
txtTPThanhTien.Text = (Math.Round(day) * loaiphong.Giaphong).ToString();
}
catch
{
}
}
public int AddDatPhong(BEL_DatPhong room)
{
string sql = "INSERT INTO dbo.DatPhong VALUES( @madp , @makh , @sophong , @ngaydat , @trangthai )";
int result = DataProvider.Instance.ExecuteNonQuery(sql, new object[] { room.MaDatPhong, room.MaKH, room.SoPhong, room.NgayDatPhong, "No" });
return(result);
}
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 BEL_DatPhong LoadDatPhongTheoMa(string madp)
{
DataTable Data = DAL_DatPhong.Instance.LoadDatPhongTheoMa(madp);
if (Data.Rows.Count > 0)
{
BEL_DatPhong item = new BEL_DatPhong(Data.Rows[0]);
return(item);
}
return(null);
}
public BEL_DatPhong LoadDatPhongTheoSoPhong(string sophong)
{
BEL_DatPhong list = null;
DataTable Data = DAL_DatPhong.Instance.LoadDatPhongTheoSoPhong(sophong);
foreach (DataRow row in Data.Rows)
{
list = new BEL_DatPhong(row);
}
return(list);
}
public List <BEL_DatPhong> LoadDatPhong()
{
List <BEL_DatPhong> list = new List <BEL_DatPhong>();
DataTable Data = DAL_DatPhong.Instance.LoadDatPhong();
foreach (DataRow row in Data.Rows)
{
BEL_DatPhong item = new BEL_DatPhong(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);
}
}
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);
}
}
public bool AddDatPhong(BEL_DatPhong room)
{
int result = DAL_DatPhong.Instance.AddDatPhong(room);
return(result > 0);
}
