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