private void show_DV()
{
lsvDV.Items.Clear();
tiendichvu = 0;
ptpBUS = new PhieuThuePhongBUS();
PhieuThuePhongDTO ptp = ptpBUS.getPhieuThuePhongByID(cmbMaPT.Text);
cttpBUS = new ChiTietThuePhongBUS();
IList <ChiTietThuePhongDTO> listcttp = cttpBUS.getChiTietThuePhongByID(ptp.Maphieuthue);
dvBUS = new DichVuBUS();
foreach (ChiTietThuePhongDTO cttp in listcttp)
{
int i = lsvDV.Items.Count;
DichVuDTO dv = dvBUS.getDichVuByID(cttp.Madichvu);
lsvDV.Items.Add(dv.Tendichvu);
lsvDV.Items[i].SubItems.Add(cttp.Maphong);
lsvDV.Items[i].SubItems.Add(cttp.Ngay.ToShortDateString());
lsvDV.Items[i].SubItems.Add(cttp.Ngay.ToLongTimeString());
lsvDV.Items[i].SubItems.Add(dv.Gia.ToString("0,0"));
lsvDV.Items[i].SubItems.Add(cttp.Soluong.ToString());
decimal tt = dv.Gia * cttp.Soluong;
lsvDV.Items[i].SubItems.Add(tt.ToString("0,0"));
tiendichvu += tt;
}
labTDV.Text = tiendichvu.ToString("0,0");
}
private void show_MaPT()
{
cmbMaPT.Items.Clear();
ptpBUS = new PhieuThuePhongBUS();
hdBUS = new HoaDonBUS();
IList <PhieuThuePhongDTO> listptp = ptpBUS.getListPhieuThuePhongAll();
IList <HoaDonDTO> listHD = hdBUS.getListHoaDonAll();
foreach (PhieuThuePhongDTO pt in listptp)
{
if (listHD.Count <= 0)
{
cmbMaPT.Items.Add(pt.Maphieuthue);
}
else
{
if (ktHD(pt.Maphieuthue))
{
cmbMaPT.Items.Add(pt.Maphieuthue);
}
}
}
if (maphieuthue == "" && cmbMaPT.Items.Count > 0)
{
cmbMaPT.SelectedIndex = 0;
}
else if (maphieuthue != "")
{
cmbMaPT.Text = maphieuthue;
}
}
private void Hienthithongtinthuephong(int maPhieuthue)
{
PhieuThuePhongDTO phieuThuePhongDTO = new PhieuThuePhongDTO();
PhieuThuePhongBUS phieuThuePhongBUS = new PhieuThuePhongBUS();
phieuThuePhongDTO = phieuThuePhongBUS.LayPhieuthuephongTheoma(maPhieuthuephong);
maP = phieuThuePhongDTO.MaPhong;
PhongDTO phongDTO = new PhongDTO();
PhongBUS phongBUS = new PhongBUS();
phongDTO = phongBUS.LayPhongTheoMaSo(phieuThuePhongDTO.MaPhong);
HienthiComboboxLoaiGia();
HienthiKhachhang(phieuThuePhongDTO.MaKhachHang);
lbTenPhong.Text = phongDTO.Ten;
lbTang.Text = phongDTO.Tang.ToString();
dtpkGioBD.Value = phieuThuePhongDTO.ThoiGianNhanPhong;
dtpkGioKT.Value = phieuThuePhongDTO.ThoiGianTraPhong;
dtpkNgayBD.Value = phieuThuePhongDTO.ThoiGianNhanPhong;
dtpkNgayKT.Value = phieuThuePhongDTO.ThoiGianTraPhong;
cbmLoaiDangKy.SelectedValue = phieuThuePhongDTO.MaLoaiThuePhong;
lbLoaiPhong.Text = phongBUS.LayLoaiPhong(phongDTO.MaLoaiPhong);
HienthiGiaPhong(int.Parse(cbmLoaiDangKy.SelectedValue.ToString()), phongDTO.MaLoaiPhong);
HienthiThoiGian();
}
private void show_MaPT()
{
cmbMaPT.Items.Clear();
ptpBUS = new PhieuThuePhongBUS();
IList <PhieuThuePhongDTO> listptp = ptpBUS.getListPhieuThuePhongAll();
foreach (PhieuThuePhongDTO ptp in listptp)
{
if (kt_phieuthue_hoadon(ptp.Maphieuthue))
{
cmbMaPT.Items.Add(ptp.Maphieuthue);
}
}
if (maphieudat != "")
{
ptpBUS = new PhieuThuePhongBUS();
IList <PhieuThuePhongDTO> list = ptpBUS.getListPhieuThuePhongByMaPhieuDat(maphieudat);
foreach (PhieuThuePhongDTO ptp in list)
{
cmbMaPT.Text = ptp.Maphieuthue;
}
}
else if (cmbMaPT.Items.Count > 0)
{
cmbMaPT.SelectedIndex = 0;
}
}
private void bntChiTietThuePhong_Click(object sender, EventArgs e)
{
if (gridKhachHang.Rows.Count != 0)
{
if (_loaiKH == 1)
{
PhieuThuePhongBUS phieuThuePhongBUS = new PhieuThuePhongBUS();
PhieuThuePhongDTO phieuThuePhongDTO = new PhieuThuePhongDTO();
phieuThuePhongDTO = phieuThuePhongBUS.DangO_KhachHang(int.Parse(gridKhachHang.CurrentRow.Cells[0].Value.ToString()));
PhieuThuePhong phieuThuePhong = new PhieuThuePhong();
PhieuThuePhong.maKH = Convert.ToInt32(gridKhachHang.CurrentRow.Cells[0].Value.ToString());
PhieuThuePhong.dangO = true;
PhieuThuePhong.maPhieuthuephong = phieuThuePhongDTO.Ma;
phieuThuePhong.ShowDialog();
Load();
}
else if (_loaiKH == 2)
{
DanhSachDatPhongTheoKhachHang ds = new DanhSachDatPhongTheoKhachHang();
DanhSachDatPhongTheoKhachHang.maKH = Convert.ToInt32(gridKhachHang.CurrentRow.Cells[0].Value.ToString());
ds.MyParent = this;
ds.ShowDialog();
}
}
}
private void show_Phong()
{
lsvPhong.Items.Clear();
tienphong = 0;
ptpBUS = new PhieuThuePhongBUS();
PhieuThuePhongDTO ptp = ptpBUS.getPhieuThuePhongByID(cmbMaPT.Text);
pdpBUS = new PhieuDatPhongBUS();
PhieuDatPhongDTO pdp = pdpBUS.getPhieuDatPhongByID(ptp.Maphieudat);
ctdpBUS = new ChiTietDatPhongBUS();
IList <ChiTietDatPhongDTO> list = ctdpBUS.getChiTietDatPhongByID(pdp.Maphieudat);
pBUS = new PhongBUS();
lpBUS = new LoaiPhongBUS();
foreach (ChiTietDatPhongDTO ctdp in list)
{
int i = lsvPhong.Items.Count;
PhongDTO p = pBUS.getPhongByID(ctdp.Maphong);
LoaiPhongDTO lp = lpBUS.getLoaiPhongByID(p.Maloai);
lsvPhong.Items.Add(ctdp.Maphong);
lsvPhong.Items[i].SubItems.Add(lp.Gia.ToString("0,0"));
lsvPhong.Items[i].SubItems.Add(pdp.Ngayden.ToShortDateString());
lsvPhong.Items[i].SubItems.Add(pdp.Ngaydi.ToShortDateString());
TimeSpan sno = pdp.Ngaydi.Date.AddDays(1) - pdp.Ngayden.Date;
lsvPhong.Items[i].SubItems.Add(sno.Days.ToString());
decimal tp = lp.Gia * sno.Days;
lsvPhong.Items[i].SubItems.Add(tp.ToString("0,0"));
tienphong += tp;
}
labTP.Text = tienphong.ToString("0,0");
}
private void show_Phong()
{
cmbMaphong.Items.Clear();
string fe = cmbMaPT.SelectedItem.ToString();
ptpBUS = new PhieuThuePhongBUS();
PhieuThuePhongDTO listptp = ptpBUS.getPhieuThuePhongByID(fe);
string fe1 = listptp.Maphieudat;
pdpBUS = new PhieuDatPhongBUS();
PhieuDatPhongDTO listpdt = pdpBUS.getPhieuDatPhongByID(fe1);
string fe2 = listptp.Maphieudat;
ctdpBUS = new ChiTietDatPhongBUS();
IList <ChiTietDatPhongDTO> listcttp = ctdpBUS.getChiTietDatPhongByID(fe2);
foreach (ChiTietDatPhongDTO ctdp in listcttp)
{
cmbMaphong.Items.Add(ctdp.Maphong);
}
if (maphong != "")
{
cmbMaphong.Text = maphong;
}
else
{
cmbMaphong.SelectedValue = 0;
}
}
public CapNhatPhieuThuePhong_UI()
{
InitializeComponent();
khachHangBUS = new KhachHangBUS();
doankhachBUS = new DoanKhachBUS();
phieuThuePhongBUS = new PhieuThuePhongBUS();
phongBUS = new PhongBUS();
}
private void btnNhanPhong_Click(object sender, EventArgs e)
{
PhieuThuePhongBUS phieuThuePhongBUS = new PhieuThuePhongBUS();
if (phieuThuePhongBUS.CapNhatTinhTrang(Convert.ToInt32(gridDanhsachphong.CurrentRow.Cells[0].Value.ToString()), 2))
{
MyParent.Load();
}
}
private void DanhSachDatPhongTheoKhachHang_Load(object sender, EventArgs e)
{
PhieuThuePhongBUS phieuThuePhongBUS = new PhieuThuePhongBUS();
gridDanhsachphong.DataSource = phieuThuePhongBUS.DanhSachDatPhong(maKH);
gridDanhsachphong.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
gridDanhsachphong.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
gridDanhsachphong.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void Dp_ngaythanhtoan_SelectedDateChanged(object sender, SelectionChangedEventArgs e)
{
TimeSpan time = new TimeSpan();
time = Convert.ToDateTime(dp_ngaythanhtoan.Text) - Convert.ToDateTime(dp_ngaybd.Text);
int day = time.Days;
if (day <= 0 || tb_tenphong.Text == "" || tb_loaiphong.Text == "")
{
MessageBox.Show("Chọn ngày thanh toán không hợp lệ hoặc dữ liệu trống, vui lòng chọn lại ngày khác và kiểm tra dữ liệu", "Chọn ngày không hợp lệ", MessageBoxButton.OK);
dp_ngaythanhtoan.SelectedDate = DateTime.Now.Date.AddDays(1);
}
else
{
tb_songaythue.Text = day.ToString();
KhachHangBUS kh = new KhachHangBUS();
PhieuThuePhongBUS pt = new PhieuThuePhongBUS();
var khachhang = kh.selectKhachHang(pt.selectPhieuThuePhongGanNhat(tb_tenphong.Text).Rows[0].Field <string>(0));
int SoKhachNuocNgoai = 0;
int Soluongkhach = 0;
foreach (DataRow row in khachhang.Rows)
{
if (row.Field <string>(2) == "khach nuoc ngoai")
{
SoKhachNuocNgoai++;
}
Soluongkhach++;
}
ThamSoBUS ts = new ThamSoBUS();
var thamso = ts.SelectThamSo();
tb_tienphong.Text = (double.Parse(tb_gia.Text) * day).ToString();
if (SoKhachNuocNgoai > 0 && Soluongkhach >= thamso.Rows[0].Field <int>(0))
{
tb_phuthu.Text = ((double.Parse(tb_tienphong.Text) * thamso.Rows[0].Field <double>(2) - double.Parse(tb_tienphong.Text)) + double.Parse(tb_tienphong.Text) * thamso.Rows[0].Field <double>(1)).ToString();
}
if (SoKhachNuocNgoai == 0 && Soluongkhach >= thamso.Rows[0].Field <int>(0))
{
tb_phuthu.Text = (double.Parse(tb_tienphong.Text) * thamso.Rows[0].Field <double>(1)).ToString();
}
if (SoKhachNuocNgoai > 0 && Soluongkhach < thamso.Rows[0].Field <int>(0))
{
tb_phuthu.Text = ((double.Parse(tb_tienphong.Text) * thamso.Rows[0].Field <double>(2) - double.Parse(tb_tienphong.Text))).ToString();
}
if (SoKhachNuocNgoai == 0 && Soluongkhach < thamso.Rows[0].Field <int>(0))
{
tb_phuthu.Text = "0";
}
tb_tongtien.Text = (double.Parse(tb_phuthu.Text) + double.Parse(tb_tienphong.Text)).ToString();
tb_tienchu.Text = DocTienBangChu(long.Parse(tb_tongtien.Text), " VNĐ");
}
}
private void bntDatPhong_Click(object sender, EventArgs e)
{
PhieuThuePhongDTO phieuThuePhongDTO = new PhieuThuePhongDTO();
phieuThuePhongDTO.MaPhong = maP;
if (maKH != 0)
{
phieuThuePhongDTO.MaKhachHang = maKH;
}
else
{
phieuThuePhongDTO.MaKhachHang = ThemKhachHang();
}
if (isSodoKScall)
{
DateTime s = dtpkNgayBD.Value.Date;
TimeSpan ts = dtpkGioBD.Value.TimeOfDay;
_thoiGianNhan = s.Date + ts;
DateTime f = dtpkNgayKT.Value.Date;
TimeSpan tf = dtpkGioKT.Value.TimeOfDay;
_thoiGianTra = f.Date + tf;
}
phieuThuePhongDTO.ThoiGianNhanPhong = _thoiGianNhan;
phieuThuePhongDTO.ThoiGianTraPhong = _thoiGianTra;
phieuThuePhongDTO.MaLoaiThuePhong = int.Parse(cbmLoaiDangKy.SelectedValue.ToString());
phieuThuePhongDTO.Gia = float.Parse(lbGiaPhong.Text);
phieuThuePhongDTO.TrangThai = 1;
phieuThuePhongDTO.TraTruoc = float.Parse(lbTraTruoc.Text);
PhieuThuePhongBUS phieuThuePhongBUS = new PhieuThuePhongBUS();
if (phieuThuePhongBUS.ThemPhieuThuePhong(phieuThuePhongDTO))
{
MessageBoxDS m = new MessageBoxDS();
MessageBoxDS.thongbao = "Đặt phòng thành công!";
MessageBoxDS.maHinh = 1;
m.ShowDialog();
result = true;
}
else
{
MessageBoxDS m = new MessageBoxDS();
MessageBoxDS.thongbao = "Đặt phòng thất bại!";
MessageBoxDS.maHinh = 3;
m.ShowDialog();
}
}
private void CustomePhong_EventNhanPhong(object sender, ProcessEventArgs e)
{
// call nhận phòng
try
{
PhieuThuePhongBUS phieuThuePhong = new PhieuThuePhongBUS();
phieuThuePhong.CapNhatTrangThaiPhieuThuePhongCoMaPhong(e.PHONG.Ma);
}catch (Exception ex)
{
MessageBoxDS m = new MessageBoxDS();
MessageBoxDS.thongbao = "Thời gian nhận phòng chưa đến";
MessageBoxDS.maHinh = 3;
m.ShowDialog();
}
}
public HttpResponseMessage DatPhongAPI([FromBody] PhieuThuePhongDTO phieuThuePhongDTO)
{
if (phieuThuePhongDTO != null)
{
PhieuThuePhongBUS phieuThuePhongBUS = new PhieuThuePhongBUS();
try
{
phieuThuePhongBUS.ThemPhieuThuePhong(phieuThuePhongDTO);
return(Request.CreateResponse(HttpStatusCode.OK, "success"));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.GatewayTimeout, "error"));
}
}
return(Request.CreateResponse(HttpStatusCode.GatewayTimeout, "error"));
}
private void nhanphong(string maphieudat)
{
ptpBUS = new PhieuThuePhongBUS();
ptpDTO = new PhieuThuePhongDTO();
ptpDTO.Maphieuthue = "PT00" + showid();
ptpDTO.Maphieudat = maphieudat;
ptpDTO.Username = frmMain.m_username;
if (ptpBUS.insertPhieuThuePhong(ptpDTO) == 1)
{
show_MaPT();
show_CTTP();
MessageBox.Show("Đã tạo Phiếu Thuê Phòng từ Phiếu Đặt Phòng: " + maphieudat);
}
else
{
MessageBox.Show("Lỗi thêm dữ liệu!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void Tb_tenphong_TextChanged(object sender, TextChangedEventArgs e)
{
PhongBUS bus = new PhongBUS();
if (tb_tenphong.Text != "")
{
var data = bus.SearchTheoTenPhongdathue(tb_tenphong.Text);
if (data.Rows.Count != 0)
{
PhieuThuePhongBUS phieuthue = new PhieuThuePhongBUS();
var dt = phieuthue.selectPhieuThuePhongGanNhat(data.Rows[0].Field <string>(0));
if (dt.Rows.Count != 0)
{
dp_ngaybd.SelectedDate = dt.Rows[0].Field <DateTime>(1);
KhachHangBUS khachhang = new KhachHangBUS();
if (khachhang.selectKhachHang(dt.Rows[0].Field <string>(0)).Rows.Count != 0)
{
gv_khachhang.ItemsSource = khachhang.selectKhachHang(dt.Rows[0].Field <string>(0)).AsDataView();
}
}
tb_loaiphong.Text = data.Rows[0].Field <string>(1);
tb_gia.Text = data.Rows[0].Field <double>(2).ToString();
tb_ghichu.Text = data.Rows[0].Field <string>(3).ToString();
dp_ngaythanhtoan.SelectedDate = DateTime.Now.Date;
}
else
{
dp_ngaybd.SelectedDate = DateTime.Now.Date;
gv_khachhang.ItemsSource = null;
tb_loaiphong.Text = "";
tb_gia.Text = "";
tb_ghichu.Text = "";
}
}
else
{
dp_ngaybd.SelectedDate = DateTime.Now.Date;
gv_khachhang.ItemsSource = null;
tb_loaiphong.Text = "";
tb_gia.Text = "";
tb_ghichu.Text = "";
}
}
private void show_kh()
{
ptpBUS = new PhieuThuePhongBUS();
PhieuThuePhongDTO listptp = ptpBUS.getPhieuThuePhongByID(cmbMaPT.Text);
pdpBUS = new PhieuDatPhongBUS();
PhieuDatPhongDTO listpdp = pdpBUS.getPhieuDatPhongByID(listptp.Maphieudat);
khBUS = new KhachHangBUS();
KhachHangDTO listkh = khBUS.getKhachHangByID(listpdp.Makhachhang);
emtylsvKH();
lsvKH.Items[0].SubItems[1].Text = listkh.Makhachhang;
lsvKH.Items[1].SubItems[1].Text = listkh.Tenkhachhang;
lsvKH.Items[2].SubItems[1].Text = listkh.CMND_PASSPORT;
lsvKH.Items[3].SubItems[1].Text = listkh.Diachi;
lsvKH.Items[4].SubItems[1].Text = listkh.Coquan;
lsvKH.Items[5].SubItems[1].Text = listkh.Sodienthoai;
lsvKH.Items[6].SubItems[1].Text = listkh.Email;
}
private void DichVuToolStripMenuItem1_Click(object sender, EventArgs e)
{
if (lsvMain.SelectedItems.Count <= 0)
{
MessageBox.Show("Vui lòng chọn 1 phòng!!!");
return;
}
pBUS = new PhongBUS();
PhongDTO pDTO = pBUS.getPhongByID(lsvMain.SelectedItems[0].Text);
if (pDTO.Danhan == true)
{
string mpt = "";
ctdpBUS = new ChiTietDatPhongBUS();
IList <ChiTietDatPhongDTO> listctdp = ctdpBUS.getListChiTietDatPhongByName(pDTO.Maphong);
foreach (ChiTietDatPhongDTO ctdp in listctdp)
{
pdpBUS = new PhieuDatPhongBUS();
ptpBUS = new PhieuThuePhongBUS();
PhieuDatPhongDTO pdp = pdpBUS.getPhieuDatPhongByID(ctdp.Maphieudat);
IList <PhieuThuePhongDTO> ptp = ptpBUS.getListPhieuThuePhongByMaPhieuDat(pdp.Maphieudat);
if (ptp != null)
{
foreach (PhieuThuePhongDTO pt in ptp)
{
mpt = pt.Maphieuthue;
}
}
}
FormPhieuThuePhong frmPTP = new FormPhieuThuePhong();
frmPTP.frmMain = this;
frmPTP.maphong = pDTO.Maphong;
frmPTP.maphieuthue = mpt;
frmPTP.ShowDialog();
}
else
{
MessageBox.Show("Phòng chưa có người!");
return;
}
}
private void show_KH()
{
//lsvKH.Items.Clear();
ptpBUS = new PhieuThuePhongBUS();
PhieuThuePhongDTO listptp = ptpBUS.getPhieuThuePhongByID(cmbMaPT.Text);
pdpBUS = new PhieuDatPhongBUS();
PhieuDatPhongDTO pdp = pdpBUS.getPhieuDatPhongByID(listptp.Maphieudat);
labTDC.Text = pdp.Sotiendatcoc.ToString("0,0");
khBUS = new KhachHangBUS();
// emtylsvgKH();
KhachHangDTO kh = khBUS.getKhachHangByID(pdp.Makhachhang);
lsvKH.Items[0].SubItems[1].Text = kh.Makhachhang;
lsvKH.Items[1].SubItems[1].Text = kh.Tenkhachhang;
lsvKH.Items[2].SubItems[1].Text = kh.CMND_PASSPORT;
lsvKH.Items[3].SubItems[1].Text = kh.Diachi;
lsvKH.Items[4].SubItems[1].Text = kh.Coquan;
lsvKH.Items[5].SubItems[1].Text = kh.Sodienthoai;
lsvKH.Items[6].SubItems[1].Text = kh.Email;
}
private void bntTraPhong_Click(object sender, EventArgs e)
{
try
{
//Lưu hóa đơn
HoaDonDTO hoaDonDTO = new HoaDonDTO();
hoaDonDTO.Maphieuthuephong = maPhieuthuephong;
NhanVienBUS nhanVienBUS = new NhanVienBUS();
hoaDonDTO.Manhanvienlap = nhanVienBUS.LayMaNhanVien(maTaiKhoan);
hoaDonDTO.Ghichu = txtGhiChu.Text;
hoaDonDTO.Tongtien = float.Parse(lbTongTien.Text);
hoaDonDTO.Ngaytao = DateTime.Now.Date;
HoaDonBUS hoaDonBUS = new HoaDonBUS();
hoaDonBUS.LuuHoaDon(hoaDonDTO);
//Cập nhật trạng thái phiếu thuê phòng.
PhieuThuePhongBUS phieuThuePhongBUS = new PhieuThuePhongBUS();
phieuThuePhongBUS.CapNhatTinhTrang(maPhieuthuephong, 3);
MessageBoxDS m = new MessageBoxDS();
MessageBoxDS.thongbao = "Trả phòng thành công";
MessageBoxDS.maHinh = 1;
m.ShowDialog();
result = true;
}
catch
{
MessageBoxDS m = new MessageBoxDS();
MessageBoxDS.thongbao = "Trả phòng thất bại";
MessageBoxDS.maHinh = 3;
m.ShowDialog();
}
}
private void bntCapNhat_Click(object sender, EventArgs e)
{
if (dangO)
{
}
else
{
PhieuThuePhongBUS phieuThuePhongBUS = new PhieuThuePhongBUS();
if (phieuThuePhongBUS.HuyDatPhong(maPhieuthuephong))
{
MessageBoxDS m = new MessageBoxDS();
MessageBoxDS.thongbao = "Hủy đặt phòng thành công!";
MessageBoxDS.maHinh = 1;
m.ShowDialog();
}
else
{
MessageBoxDS m = new MessageBoxDS();
MessageBoxDS.thongbao = "Hủy đặt phòng thất bại!";
MessageBoxDS.maHinh = 3;
m.ShowDialog();
}
}
}
private void TraPhong_Load(object sender, EventArgs e)
{
if (isSodoKScall)
{
PhieuThuePhongDTO phieuThuePhongDTO = new PhieuThuePhongDTO();
PhieuThuePhongBUS phieuThuePhongBUS = new PhieuThuePhongBUS();
phieuThuePhongDTO = phieuThuePhongBUS.DangO_Phong(maP);
maLoaiThuePhong = phieuThuePhongDTO.MaLoaiThuePhong;
maPhieuthuephong = phieuThuePhongDTO.Ma;
PhongDTO phongDTO = new PhongDTO();
PhongBUS phongBUS = new PhongBUS();
phongDTO = phongBUS.LayPhongTheoMaSo(phieuThuePhongDTO.MaPhong);
HienthiKhachhang(phieuThuePhongDTO.MaKhachHang);
lbTenPhong.Text = phongDTO.Ten;
dtpkGioBD.Value = phieuThuePhongDTO.ThoiGianNhanPhong;
dtpkGioKT.Value = phieuThuePhongDTO.ThoiGianTraPhong;
dtpkNgayBD.Value = phieuThuePhongDTO.ThoiGianNhanPhong;
dtpkNgayKT.Value = phieuThuePhongDTO.ThoiGianTraPhong;
lbLoaiDangKy.Text = phongBUS.LayLoaiDangKy(phieuThuePhongDTO.MaLoaiThuePhong);
lbLoaiPhong.Text = phongBUS.LayLoaiPhong(phongDTO.MaLoaiPhong);
HienthiGiaPhong(phieuThuePhongDTO.MaLoaiThuePhong, phongDTO.MaLoaiPhong);
HienthiThoiGian();
HienthiTongTienDichVu();
HienthiTongTienPhaiTra();
}
else
{
PhieuThuePhongDTO phieuThuePhongDTO = new PhieuThuePhongDTO();
PhieuThuePhongBUS phieuThuePhongBUS = new PhieuThuePhongBUS();
phieuThuePhongDTO = phieuThuePhongBUS.DangO_KhachHang(maKH);
maLoaiThuePhong = phieuThuePhongDTO.MaLoaiThuePhong;
maPhieuthuephong = phieuThuePhongDTO.Ma;
maP = phieuThuePhongDTO.MaPhong;
PhongDTO phongDTO = new PhongDTO();
PhongBUS phongBUS = new PhongBUS();
phongDTO = phongBUS.LayPhongTheoMaSo(phieuThuePhongDTO.MaPhong);
HienthiKhachhang(phieuThuePhongDTO.MaKhachHang);
lbTenPhong.Text = phongDTO.Ten;
dtpkGioBD.Value = phieuThuePhongDTO.ThoiGianNhanPhong;
dtpkGioKT.Value = phieuThuePhongDTO.ThoiGianTraPhong;
dtpkNgayBD.Value = phieuThuePhongDTO.ThoiGianNhanPhong;
dtpkNgayKT.Value = phieuThuePhongDTO.ThoiGianTraPhong;
lbLoaiDangKy.Text = phongBUS.LayLoaiDangKy(phieuThuePhongDTO.MaLoaiThuePhong);
lbLoaiPhong.Text = phongBUS.LayLoaiPhong(phongDTO.MaLoaiPhong);
HienthiGiaPhong(phieuThuePhongDTO.MaLoaiThuePhong, phongDTO.MaLoaiPhong);
HienthiThoiGian();
HienthiTongTienDichVu();
HienthiTongTienPhaiTra();
}
}
private void checkAndChangeTinhTrangPhong()
{
PhieuThuePhongBUS phieuThuePhongBUS = new PhieuThuePhongBUS();
phieuThuePhongBUS.DuyetVaCapNhatTrangThai();
}
private void btnTinhTien_Click(object sender, EventArgs e)
{
if (kiemtra())
{
labTPT.Text = Math.Round(decimal.Parse(labTP.Text) + decimal.Parse(labTDV.Text) - decimal.Parse(labTDC.Text), 0).ToString("0,0");
ptpBUS = new PhieuThuePhongBUS();
hdBUS = new HoaDonBUS();
pdpBUS = new PhieuDatPhongBUS();
hdDTO = new HoaDonDTO();
ctdpBUS = new ChiTietDatPhongBUS();
pBUS = new PhongBUS();
PhieuThuePhongDTO ptp = ptpBUS.getPhieuThuePhongByID(cmbMaPT.Text);
PhieuDatPhongDTO pdp = pdpBUS.getPhieuDatPhongByID(ptp.Maphieudat);
hdDTO.Mahoadon = labMaHD.Text;
hdDTO.Ngaythanhtoan = dtpNgay.Value;
hdDTO.Tongtien = decimal.Parse(labTPT.Text);
hdDTO.Maphieuthue = cmbMaPT.Text;
hdDTO.Makhachhang = pdp.Makhachhang;
hdDTO.Username = frmMain.m_username;
if (hdBUS.insertHoaDon(hdDTO) == 1)
{
pdpDTO = new PhieuDatPhongDTO();
pdpDTO.Maphieudat = pdp.Maphieudat;
pdpDTO.Makhachhang = pdp.Makhachhang;
pdpDTO.Ngayden = pdp.Ngayden;
pdpDTO.Ngaydi = pdp.Ngaydi;
pdpDTO.Sotiendatcoc = pdp.Sotiendatcoc;
pdpDTO.Username = pdp.Username;
pdpDTO.Tinhtrang = "finish";
pdpDTO.Songuoi = pdp.Songuoi;
if (pdpBUS.updatePhieuDatPhong(pdpDTO) == 1)
{
IList <ChiTietDatPhongDTO> listctdp = ctdpBUS.getChiTietDatPhongByID(pdp.Maphieudat);
foreach (ChiTietDatPhongDTO ctdp in listctdp)
{
pDTO = new PhongDTO();
PhongDTO p = pBUS.getPhongByID(ctdp.Maphong);
pDTO.Maphong = p.Maphong;
pDTO.Maloai = p.Maloai;
pDTO.Dadat = false;
pDTO.Danhan = false;
if (pBUS.updatePhong(pDTO) == 1)
{
}
else
{
MessageBox.Show("Lỗi sửa phòng!");
}
}
}
else
{
MessageBox.Show("Lỗi sửa phiếu đặt phòng!");
}
flagtinhtien = true;
show_KH();
show_Phong();
show_DV();
//show_MaPT();
frmMain.CapNhatPhong();
MessageBox.Show("Đã tính tiền!");
btnInhoadon.Visible = true;
}
else
{
MessageBox.Show("Lỗi dữ liệu!");
}
}
}
private void Bt_dongy_Click(object sender, RoutedEventArgs e)
{
bool checkThanhToan = false;
HoaDonThanhToanBUS bus = new HoaDonThanhToanBUS();
foreach (DataRow row in bus.KiemTraThanhToan().Rows)
{
if (row.Field <string>(0) == tb_tenphong.Text)
{
checkThanhToan = true;
}
}
if (checkThanhToan == false)
{
if (tb_tongtien.Text != "")
{
var data_ = bus.selectAllHoaDon();
string MaHd = "";
var HD = "HD001";
if (data_.Rows.Count != 0)
{
foreach (DataRow row in data_.Rows)
{
MaHd = row.Field <string>(0);
}
var so = int.Parse(MaHd.Substring(2));
if (so < 10)
{
HD = "HD00" + (so + 1).ToString();
}
else if (so < 100)
{
HD = "HD0" + (so + 1).ToString();
}
else
{
HD = "HD" + (so + 1).ToString();
}
}
DateTime? date = dp_ngaythanhtoan.SelectedDate;
string month = date.Value.Month.ToString();
string day = date.Value.Day.ToString();
string year = date.Value.Year.ToString();
PhieuThuePhongBUS pt = new PhieuThuePhongBUS();
var mapt = pt.selectPhieuThuePhongGanNhat(tb_tenphong.Text);
bus.insertHoaDon(HD, tb_tenphong.Text, month + "/" + day + "/" + year, int.Parse(tb_songaythue.Text), double.Parse(tb_tienphong.Text), double.Parse(tb_phuthu.Text), double.Parse(tb_tongtien.Text), mapt.Rows[0].Field <string>(0));
//Cập nhật lại tình trạng phòng
PhongBUS phong = new PhongBUS();
phong.updateTTPhongAsChuaThue();
MessageBox.Show("Đã thanh toán phòng thành công", "Thanh toán thành công", MessageBoxButton.OK);
}
else
{
MessageBox.Show("Thanh toán không thành công vui lòng kiểm tra lại dữ liệu", "Thanh toán không thành công", MessageBoxButton.OK);
}
}
else
{
MessageBox.Show("Phòng này đã được khách thanh toán trước dó ! ", "Phòng đã được thanh toán trươc đó", MessageBoxButton.OK);
}
this.Close();
}
private int showid()
{
ptpBUS = new PhieuThuePhongBUS();
return(ptpBUS.Count() + 1);
}
private void Bt_dongy_Click(object sender, RoutedEventArgs e)
{
PhieuThuePhongBUS bus = new PhieuThuePhongBUS();
var data_ = bus.selectAllPhieuThuePhong();
string MaPT = "";
var PT = "PT001";
if (data_.Rows.Count != 0)
{
foreach (DataRow row in data_.Rows)
{
MaPT = row.Field <string>(0);
}
var so = int.Parse(MaPT.Substring(2));
if (so < 10)
{
PT = "PT00" + (so + 1).ToString();
}
else if (so < 100)
{
PT = "PT0" + (so + 1).ToString();
}
else
{
PT = "PT" + (so + 1).ToString();
}
}
DateTime?date = dp_ngaybd.SelectedDate;
string month = date.Value.Month.ToString();
string day = date.Value.Day.ToString();
string year = date.Value.Year.ToString();
var sluongkhach = 0;
foreach (TextBox tb in listTB)
{
if (tb.Text != "")
{
sluongkhach++;
}
if (tb.Text == "")
{
break;
}
}
if (sluongkhach % 3 == 0 && sluongkhach > 0 && tb_tenphong.Text != "" && tb_loaiphong.Text != "")
{
var kh = new KhachHangBUS();
List <KhachHangDTO> listkh = new List <KhachHangDTO>();
int checkBreak = 1;
int stt = listTB.Count / 3;
int dem = 0;
while (true) // chuyển dữ liệu từ textbox ten, cmt, dia chi vào list khách hàng
{
KhachHangDTO khachhang = new KhachHangDTO();
foreach (TextBox tb in listTB)
{
dem++;
if (dem == checkBreak)
{
if (tb.Name == "ten" + stt.ToString())
{
khachhang.ten = tb.Text;
}
if (tb.Name == "cmt" + stt.ToString())
{
int n;
bool isNumeric = int.TryParse(tb.Text, out n);
if (isNumeric == false)
{
MessageBox.Show("Vui lòng nhập số vào ô cmt ", "CMT chứa ký tự chữ", MessageBoxButton.OK);
return;
}
else if (tb.Text.Length > 13 || tb.Text.Length < 9)
{
MessageBox.Show("Số cmt không được ít hơn 9 số hoặc cmt quá dài vui lòng nhập lại", "Số cmt sai", MessageBoxButton.OK);
return;
}
khachhang.cmt = double.Parse(tb.Text);
}
if (tb.Name == "diachi" + stt.ToString())
{
khachhang.diachi = tb.Text;
}
if (checkBreak % 3 == 0)
{
break;
}
checkBreak++;
}
}
listkh.Add(khachhang);
if (dem == checkBreak - 1 || dem == sluongkhach)
{
break;
}
stt--;
checkBreak++;
dem = 0;
}
var tempDem = 1;
var tempChay = 0;
foreach (KhachHangDTO khach in listkh)
{
foreach (ComboBox cb in listCBB)
{
tempChay++;
if (tempDem == tempChay)
{
tempDem++;
if (cb.SelectedIndex == 0)
{
khach.loai = "khach noi dia";
break;
}
if (cb.SelectedIndex == 1)
{
khach.loai = "khach nuoc ngoai";
break;
}
}
}
tempChay = 0;
}
foreach (KhachHangDTO k in listkh)
{
kh.insertKhachHang(k.cmt, k.ten, k.loai, k.diachi, PT); // insert vào bảng khách hàng
}
PhongBUS p = new PhongBUS();
p.updatePhong(tb_tenphong.Text); // update lại tình trạng phòng
bus.insertPhieuThuePhong(PT, month + "/" + day + "/" + year, sluongkhach / 3, tb_tenphong.Text); // insert phiếu thuê phòng
MessageBox.Show("Thuê phòng thành công", "Thuê thành công", MessageBoxButton.OK);
}
else
{
MessageBox.Show("Thuê phòng không thành công, kiểm tra lại dữ liệu đã nhập", "Thuê không thành công", MessageBoxButton.OK);
}
this.Close();
}
//public void functionGetThongTinDangNhap(NHANVIEN nhanVien)
//{
// this.nhanVien = nhanVien;
//}
public void LoadPhong()
{
flowBody.Controls.Clear();
PhongBUS phongBUS = new PhongBUS();
PhongDTO[] phongs = phongBUS.LayDanhSachPhong();
PhieuThuePhongBUS phieuThuePhongBUS = new PhieuThuePhongBUS();
PhieuThuePhongDTO[] phieuThuePhongs = phieuThuePhongBUS.LayDanhSachPhieuThuePhongTrangThai1Va2();
KhachHangBUS khachHangBUS = new KhachHangBUS();
int i;
int j, coTrongPhieuThuePhong = 0;
int numberPhong = phongBUS.LaySoLuongPhongLonNhatTrongCacTang();
int with_sizeCustomePhong = flowBody.Size.Width / numberPhong - numberPhong - 1;
for (i = 0; i < phongs.Length; i++)
{
// khai báo control customePhong
CustomePhong customePhong = new CustomePhong(phongs[i]);
customePhong.Size = new Size(with_sizeCustomePhong, customePhong.Size.Height);
coTrongPhieuThuePhong = 0;
for (j = 0; j < phieuThuePhongs.Length; j++)
{
if (phongs[i].Ma == phieuThuePhongs[j].MaPhong)
{
coTrongPhieuThuePhong = 1;
if (phieuThuePhongs[j].TrangThai == 1)
// khách hàng chưa nhận phòng
{
PhieuThuePhongDTO phieuThuePhongKiemTra = phieuThuePhongBUS.CoPhaiPhongCoNguoiDangO(phongs[i].Ma);
if (phieuThuePhongKiemTra != null)
{
string strtime = String.Format("{0:MM/dd/yyyy HH:mm}", phieuThuePhongKiemTra.ThoiGianTraPhong);
KhachHangDTO khachHang = khachHangBUS.LayKhachHangCoMaSo(phieuThuePhongKiemTra.MaKhachHang);
string tenKhachHang = "";
if (khachHang != null)
{
tenKhachHang = khachHang.Ten;
}
customePhong.ThayDoiTrangThaiDangO(strtime, tenKhachHang);
// kiểm tra khách hàng có quá hạn hay không
int time = (int)(DateTime.Now - phieuThuePhongKiemTra.ThoiGianTraPhong).TotalMinutes;
if (time > 0)
{
if (time < 60) // nhỏ hơn 60 phút
{
strtime = time + " phút ";
}
else if (time < 60 * 24) // nhỏ hơn 24h
{
strtime = time / 60 + " giờ ";
}
else // lớn hơn 24h
{
strtime = time / (60 * 24) + " ngày ";
}
strtime += String.Format("{0:MM/dd/yyyy HH:mm}", phieuThuePhongKiemTra.ThoiGianTraPhong);
customePhong.ThayDoiTrangThaiQuaHan(strtime, tenKhachHang);
}
}
else
{
string time = String.Format("{0:MM/dd/yyyy HH:mm}", phieuThuePhongs[j].ThoiGianNhanPhong);
KhachHangDTO khachHang = khachHangBUS.LayKhachHangCoMaSo(phieuThuePhongs[j].MaKhachHang);
string tenKhachHang = "";
if (khachHang != null)
{
tenKhachHang = khachHang.Ten;
}
customePhong.ThayDoiTrangThaiDaDat(time, tenKhachHang);
}
}
else if (phieuThuePhongs[j].TrangThai == 2)
// khách hàng đã nhận phòng
{
string strtime = String.Format("{0:MM/dd/yyyy HH:mm}", phieuThuePhongs[j].ThoiGianTraPhong);
KhachHangDTO khachHang = khachHangBUS.LayKhachHangCoMaSo(phieuThuePhongs[j].MaKhachHang);
string tenKhachHang = "";
if (khachHang != null)
{
tenKhachHang = khachHang.Ten;
}
customePhong.ThayDoiTrangThaiDangO(strtime, tenKhachHang);
// kiểm tra khách hàng có quá hạn hay không
int time = (int)(DateTime.Now - phieuThuePhongs[j].ThoiGianTraPhong).TotalMinutes;
if (time > 0)
{
if (time < 60) // nhỏ hơn 60 phút
{
strtime = time + " phút ";
}
else if (time < 60 * 24) // nhỏ hơn 24h
{
strtime = time / 60 + " giờ ";
}
else // lớn hơn 24h
{
strtime = time / (60 * 24) + " ngày ";
}
strtime += String.Format("{0:MM/dd/yyyy HH:mm}", phieuThuePhongs[j].ThoiGianTraPhong);
customePhong.ThayDoiTrangThaiQuaHan(strtime, tenKhachHang);
}
}
break;
}
}
if (coTrongPhieuThuePhong == 0)
{
customePhong.ThayDoiTrangThaiTrong();
}
customePhong.EventDatPhong += CustomePhong_EventDatPhong;
customePhong.EventNhanPhong += CustomePhong_EventNhanPhong;
customePhong.EventThanhToanPhong += CustomePhong_EventThanhToanPhong;
flowBody.Controls.Add(customePhong);
}
}
