private void btnLuu_Click(object sender, EventArgs e)
{
if (Convert.ToInt32(txtGiamTru.Text) > 10 && Convert.ToInt32(txtGiamTru.Text) < 0)
{
MessageBox.Show("Mức giảm giá phải nhỏ hơn 10%");
txtGiamTru.Focus();
return;
}
if (txtKhachThanhToan.Text.Equals(""))
{
MessageBox.Show("Xin hãy nhập số tiền khách thanh toán");
return;
}
TimeSpan gioHienTai = new TimeSpan(DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
HoaDonTienPhongBUS hdtpbus = new HoaDonTienPhongBUS();
ThuePhongBUS tpbus = new ThuePhongBUS();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
HoaDonDichVuBUS hddvbus = new HoaDonDichVuBUS();
PhongBUS pbus = new PhongBUS();
int a = 0;
int b = 0;
if (cttpbus.getChiTietThuePhong_By_MaThue(MaThue).Count < 2)
{
eHoaDonTienPhong tt_ent = new eHoaDonTienPhong();
tt_ent.MaThue = lblMaThue.Text.Trim();
tt_ent.NgayLap = DateTime.Now;
tt_ent.GioLap = gioHienTai;
tt_ent.ThueVAT = Convert.ToSingle(10 / 10);
tt_ent.KhuyenMai = Convert.ToSingle((Convert.ToSingle(txtGiamTru.Text) * tienphong));
a = hdtpbus.insertThanhToan(tt_ent);
}
if (tpbus.getMaDoan_ByMaThue(MaThue) != null || ctdvbus.getctdv_MaThue_MaPhong(MaThue, pbus.maPhong_byTen(TenPhong)).Count != 0)
{
b++;
}
/* Với a = 1 thanh toán khách lẻ
* Với b = 1 thanh toán khách đoàn */
//Update lại trạng thái phòng
ePhong phong = new ePhong();
phong.MaPhong = pbus.maPhong_byTen(TenPhong);
phong.TinhTrang = false;
pbus.updateTinhTrangPhong(phong);
//Update lại trạng thái chi tiết thuê phòng
eChiTietThuePhong cttp = new eChiTietThuePhong();
foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue_MaPhong(MaThue, pbus.maPhong_byTen(TenPhong)))
{
cttp.MaThue = MaThue;
cttp.MaKhach = item.MaKhach;
cttp.MaPhong = item.MaPhong;
cttp.TrangThai = true;
cttpbus.updateTrangThaiChiTietThuePhong(cttp);
}
//update lại thông tin thuê phòng
eThuePhong tp = new eThuePhong();
tp.MaThue = MaThue;
tp.TrangThai = true;
tpbus.updateThuePhong(tp);
if (a == 1)
{
MessageBox.Show("Đã thanh toán thành công");
KhachHangBUS khbus = new KhachHangBUS();
NhanVienBUS nvbus = new NhanVienBUS();
LoaiPhongBUS lpbus = new LoaiPhongBUS();
HoaDon bc = new HoaDon();
List <eChiTietBaoCao> listphong = new List <eChiTietBaoCao>();
foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue_MaPhong(MaThue, pbus.maPhong_byTen(TenPhong)))
{
eChiTietBaoCao ctbc = new eChiTietBaoCao();
ctbc.tenPhong = pbus.getTenPhong_ByID(item.MaPhong);
ctbc.tenLoaiPhong = lpbus.getTen_Byma(pbus.getLoaiPhong_ByID(item.MaPhong));
ctbc.thoiGianNhan = item.GioVao + " " + item.NgayVao.Date.ToShortDateString();
ctbc.thoiGianTra = item.GioRa + " " + item.NgayRa.Date.ToShortDateString();
ctbc.tienPhong = tienvat + tienphong + tiendv + Convert.ToDouble(phuthu);
listphong.Add(ctbc);
break;
}
if (cttpbus.getChiTietThuePhong_By_MaThue(MaThue).Count < 2)
{
foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue_MaPhong(MaThue, pbus.maPhong_byTen(TenPhong)))
{
bc.tenNV = nvbus.getenNV_ByID(maNVThanhToan);
bc.tenKH = khbus.getenKH_ByID(item.MaKhach);
bc.soHD = hdtpbus.gemaHD_BymaThue(MaThue); //Cần xem xét lại
bc.thoiGianInHD = DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString();
}
}
this.Close();
frmPrint frmp = new frmPrint();
frmp.InHoaDonInTuReport(bc, listphong.ToList());
frmp.ShowDialog();
}
if (b == 1)
{
List <eCTDV> lsctdv = new List <eCTDV>();
DichVuBUS dvbus = new DichVuBUS();
KhachHangBUS khbus = new KhachHangBUS();
NhanVienBUS nvbus = new NhanVienBUS();
LoaiPhongBUS lpbus = new LoaiPhongBUS();
HoaDon bc = new HoaDon();
if (ctdvbus.getctdv_MaThue_MaPhong(MaThue, pbus.maPhong_byTen(TenPhong)) != null)
{
foreach (var item in ctdvbus.getctdv_MaThue_MaPhong(MaThue, pbus.maPhong_byTen(TenPhong)))
{
eHoaDonDichVu hddv = new eHoaDonDichVu();
hddv.MaHDDV = (DateTime.Now.Day).ToString() + (DateTime.Now.Month).ToString() + (DateTime.Now.Year).ToString() + item.MaThue + item.MaKhach + item.MaPhong;
hddv.MaThue = MaThue;
hddv.NgayLap = DateTime.Now.Date;
hddv.GioLap = gioHienTai;
hddv.MaKH = item.MaKhach;
hddv.MaPhong = item.MaPhong;
hddvbus.insertThanhToanDV(hddv);
break;
}
}
foreach (var item in ctdvbus.getctdv_MaThue_MaPhong(MaThue, pbus.maPhong_byTen(TenPhong)))
{
eCTDV ctdv = new eCTDV();
ctdv.TenDV = dvbus.getTenDV_byID(item.MaDV);
ctdv.SoLuong = item.SoLuong;
ctdv.DonGia = dvbus.getDonGia_byID(item.MaDV);
lsctdv.Add(ctdv);
}
foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue_MaPhong(MaThue, pbus.maPhong_byTen(TenPhong)))
{
if (item.MaPhong.Equals(pbus.maPhong_byTen(TenPhong)))
{
bc.tenNV = nvbus.getenNV_ByID(maNVThanhToan);
bc.tenKH = khbus.getenKH_ByID(item.MaKhach);
bc.soHD = hddvbus.gemaHD_BymaThue_maPhong(MaThue, item.MaPhong);
bc.thoiGianInHD = DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString();
bc.tenPhong = pbus.getTenPhong_ByID(item.MaPhong);
}
}
frmPrint frmInDV = new frmPrint();
frmInDV.InHoaDonInDichVuTuReport(bc, lsctdv.ToList());
frmInDV.ShowDialog();
this.Close();
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
ThuePhongBUS tpbus = new ThuePhongBUS();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
ChiTietDichVuBUS ctdvbus = new ChiTietDichVuBUS();
PhongBUS pbus = new PhongBUS();
int s = 0;
foreach (eThuePhong item in tpbus.getMaThue(maThue))
{
eThuePhong etp = new eThuePhong();
etp.MaNV = item.MaNV;
etp.MaDoan = item.MaDoan;
etp.SoLuongPhong = item.SoLuongPhong;
etp.TrangThai = false;
s = tpbus.insertThuePhong(etp);
}
if (s != 1)
{
return;
}
if (s == 1)
{
foreach (eChiTietThuePhong item in cttpbus.getChiTietThuePhong_By_MaThue_MaPhong(maThue, pbus.maPhong_byTen(TenPhong)))
{
eChiTietThuePhong ect = new eChiTietThuePhong();
ect.GioRa = item.GioRa;
ect.GioVao = item.GioVao;
ect.MaKhach = item.MaKhach;
ect.MaPhong = cboPhongTrong.SelectedValue.ToString();
ect.NgayRa = item.NgayRa;
ect.NgayVao = item.NgayVao;
ect.TienKhac = tienkhac;
ect.MaThue = tpbus.getMaThueCuoi();
ect.TrangThai = false;
ect.GhiChu = cttpbus.getCTTP_By_MaPhong_TrangThai(pbus.maPhong_byTen(TenPhong), false).GhiChu + lblTenPhong.Text + " (" + item.GioVao + " " + item.NgayVao.ToShortDateString() + ")" + " đến " + cboPhongTrong.Text + " (" + DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString() + ")";
cttpbus.insertCTTP(ect);
}
foreach (eChiTietThuePhong item in cttpbus.getChiTietThuePhong_By_MaThue_TrangThai(maThue, 0))
{
if (!item.MaPhong.Equals(pbus.maPhong_byTen(TenPhong)))
{
eChiTietThuePhong ect = new eChiTietThuePhong();
ect.GioRa = item.GioRa;
ect.GioVao = item.GioVao;
ect.MaKhach = item.MaKhach;
ect.MaPhong = item.MaPhong;
ect.NgayRa = item.NgayRa;
ect.NgayVao = item.NgayVao;
ect.MaThue = tpbus.getMaThueCuoi();
ect.TrangThai = false;
cttpbus.insertCTTP(ect);
}
}
foreach (eChiTietThuePhong item in cttpbus.getChiTietThuePhong_By_MaThue_TrangThai(maThue, 1))
{
eChiTietThuePhong ect = new eChiTietThuePhong();
ect.GioRa = item.GioRa;
ect.GioVao = item.GioVao;
ect.MaKhach = item.MaKhach;
ect.MaPhong = item.MaPhong;
ect.NgayRa = item.NgayRa;
ect.NgayVao = item.NgayVao;
ect.MaThue = tpbus.getMaThueCuoi();
ect.TrangThai = true;
cttpbus.insertCTTP(ect);
}
foreach (eChiTetDichVu item in ctdvbus.getctdv_byMaThue(maThue))
{
eChiTetDichVu ctdv = new eChiTetDichVu();
ctdv.MaThue = tpbus.getMaThueCuoi();
ctdv.MaPhong = cboPhongTrong.SelectedValue.ToString();
ctdv.MaKhach = item.MaKhach;
ctdv.MaDV = item.MaDV;
ctdv.SoLuong = item.SoLuong;
ctdvbus.insertCTDV(ctdv);
}
foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue(maThue))
{
if (item.MaPhong.Equals(pbus.maPhong_byTen(TenPhong)))
{
eChiTietThuePhong ectOld = new eChiTietThuePhong();
ectOld.MaThue = maThue;
ectOld.MaPhong = item.MaPhong;
//ectOld.MaKhach = cttpbus.getMaKhach_By_MaPhong_TrangThai(ectOld.MaPhong, false);
ectOld.MaKhach = item.MaKhach;
ectOld.TrangThai = true;
ectOld.GhiChu = "Đổi phòng";
cttpbus.updateTrangThaiChiTietThuePhong(ectOld);
}
else
{
eChiTietThuePhong ectOld = new eChiTietThuePhong();
ectOld.MaThue = maThue;
ectOld.MaPhong = item.MaPhong;
ectOld.MaKhach = item.MaKhach;
ectOld.TrangThai = true;
ectOld.GhiChu = null;
cttpbus.updateTrangThaiChiTietThuePhong(ectOld);
}
}
eThuePhong tp = new eThuePhong();
tp.MaThue = maThue;
tp.TrangThai = true;
tpbus.updateThuePhong(tp);
ePhong ep = new ePhong();
ep.MaPhong = pbus.maPhong_byTen(TenPhong);
ep.TinhTrang = false;
pbus.updateTinhTrangPhong(ep);
ePhong newp = new ePhong();
newp.MaPhong = cboPhongTrong.SelectedValue.ToString();
newp.TinhTrang = true;
newp.SoNgHienTai = pbus.getEPhong_byID(pbus.maPhong_byTen(TenPhong)).SoNgHienTai;
pbus.updateTinhTrangPhong(newp);
MessageBox.Show("Thành công");
this.Close();
}
else
{
MessageBox.Show("Không thành công");
return;
}
}