private void thuePhongToolStripMenuItem_Click(object sender, EventArgs e) { ThuePhongBUS tpbus = new ThuePhongBUS(); ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS(); foreach (eThuePhong item in tpbus.getMaThue(cttpbus.getMaThue_By_MaPhong_TrangThai(pbus.maPhong_byTen(TenPhong), false))) { if (item.MaDoan != null) { frmTraKhachLe frm = new frmTraKhachLe(this, item.MaDoan); frm.ShowDialog(); } else { frmTraKhachLe frm = new frmTraKhachLe(this); frm.ShowDialog(); } } }
private void btnThanhToan_Click(object sender, EventArgs e) { ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS(); ThuePhongBUS tpbus = new ThuePhongBUS(); DoanBUS dbus = new DoanBUS(); PhongBUS pbus = new PhongBUS(); HoaDonTienPhongBUS hdtpbus = new HoaDonTienPhongBUS(); TimeSpan gioHienTai = new TimeSpan(DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second); eHoaDonTienPhong tt_ent = new eHoaDonTienPhong(); tt_ent.MaThue = tpbus.getMaThue_ByMaDoan(dbus.getId_ByTenDoan(txtTenDoan.Text), 0); tt_ent.NgayLap = DateTime.Now; tt_ent.GioLap = gioHienTai; tt_ent.ThueVAT = Convert.ToSingle(txtThueVAT.Text); tt_ent.KhuyenMai = Convert.ToSingle(txtKhuyenMai.Text); int a = hdtpbus.insertThanhToan(tt_ent); if (a == 1) { foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue(tpbus.getMaThue_ByMaDoan(dbus.getId_ByTenDoan(txtTenDoan.Text), 0))) { eChiTietThuePhong ectOld = new eChiTietThuePhong(); ectOld.MaThue = tpbus.getMaThue_ByMaDoan(dbus.getId_ByTenDoan(txtTenDoan.Text), 0); ectOld.MaPhong = item.MaPhong; ectOld.MaKhach = item.MaKhach; ectOld.NgayRa = DateTime.Now.Date; ectOld.GioRa = gioHienTai; ectOld.TrangThai = true; cttpbus.updateChiTietThuePhong(ectOld); ePhong newp = new ePhong(); newp.MaPhong = item.MaPhong; newp.TinhTrang = false; newp.SoNgHienTai = 0; pbus.updateTinhTrangPhong(newp); } eThuePhong tp = new eThuePhong(); tp.MaThue = tpbus.getMaThue_ByMaDoan(dbus.getId_ByTenDoan(txtTenDoan.Text), 0); tp.TrangThai = true; tpbus.updateThuePhong(tp); MessageBox.Show("Thanh toán thành công"); 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_TrangThai(tp.MaThue, 1)) { 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(); eHoaDonTienPhong hdtp = new eHoaDonTienPhong(); double tienPhong = Convert.ToDouble(hdtp.tinhTienPhong(item, lpbus.donGia(pbus.getLoaiPhong_ByID(item.MaPhong)), Convert.ToDateTime(item.GioVao + " " + item.NgayVao.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString()))); double tienPhuThu = Convert.ToDouble(hdtp.tinhTienPhuThu(item, lpbus.donGia(pbus.getLoaiPhong_ByID(item.MaPhong)))); ctbc.tienPhong = tienPhong + tienPhuThu; listphong.Add(ctbc); } for (int i = 0; i < listphong.Count; i++) { for (int j = 1; j < listphong.Count; j++) { if (i == j) { continue; } if (listphong[i].tenPhong.Equals(listphong[j].tenPhong)) { listphong.RemoveAt(i); } } } foreach (var item in tpbus.getMaThue(tp.MaThue)) { bc.tenNV = nvbus.getenNV_ByID(maNVThanhToan); bc.tenKH = dbus.getTen_ById(item.MaDoan); bc.soHD = hdtpbus.gemaHD_BymaThue(tp.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(); ChiTietDichVuBUS ctdvbus = new ChiTietDichVuBUS(); HoaDonDichVuBUS hddvbus = new HoaDonDichVuBUS(); DichVuBUS dvbus = new DichVuBUS(); KhachHangBUS khbus = new KhachHangBUS(); if (ctdvbus.getctdv_byMaThue(tt_ent.MaThue) != null) { foreach (var item in ctdvbus.getctdv_byMaThue(tt_ent.MaThue)) { if (hddvbus.kiemTraTonTai(item.MaThue, item.MaPhong) == false) { 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 = item.MaThue; hddv.MaKH = item.MaKhach; hddv.MaPhong = item.MaPhong; hddv.NgayLap = DateTime.Now.Date; hddv.GioLap = gioHienTai; hddvbus.insertThanhToanDV(hddv); List <eCTDV> lsctdv = new List <eCTDV>(); foreach (eChiTetDichVu dv in ctdvbus.getctdv_MaThue_MaPhong(item.MaThue, item.MaPhong)) { eCTDV ctdv = new eCTDV(); ctdv.TenDV = dvbus.getTenDV_byID(dv.MaDV); ctdv.SoLuong = dv.SoLuong; ctdv.DonGia = dvbus.getDonGia_byID(dv.MaDV); lsctdv.Add(ctdv); } bc.tenNV = nvbus.getenNV_ByID(maNVThanhToan); bc.tenKH = khbus.getenKH_ByID(item.MaKhach); bc.soHD = hddvbus.gemaHD_BymaThue_maPhong(item.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(); } } } } }
//Load giao diện các phòng trống và phòng có chứa khách hàng public void TaoGiaoDienPhong(List <ePhong> soPhong, List <ePhong> phongTrong, List <ePhong> coKhach, string title) { //Tạo ra một flowLayoutPanel để chứa các panel PhongBUS pbus = new PhongBUS(); FlowLayoutPanel flowLayoutPanel3 = new FlowLayoutPanel(); flowLayoutPanel3.AutoSize = true; flowLayoutPanel3.AutoSizeMode = AutoSizeMode.GrowAndShrink; flowLayoutPanel1.Controls.Add(flowLayoutPanel3); Label text = new Label(); text.Size = new Size(1850, 30); text.TextAlign = ContentAlignment.TopCenter; text.Text = title; flowLayoutPanel3.Controls.Add(text); //Tạo các label để chứa thông tin, màu sắc thể hiện các phòng foreach (var item in soPhong) { DevExpress.XtraEditors.PanelControl P0001 = new DevExpress.XtraEditors.PanelControl(); Label lbl = new Label(); flowLayoutPanel3.Controls.Add(P0001); P0001.Appearance.Options.UseBackColor = true; P0001.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Style3D; P0001.Controls.Add(lbl); P0001.Location = new Point(3, 3); P0001.Name = item.MaPhong; P0001.Size = new Size(170, 150); lbl.Font = new Font("Tahoma", 9F); lbl.Dock = DockStyle.Fill; lbl.Size = new Size(150, 120); lbl.TextAlign = ContentAlignment.TopCenter; } //Load thông tin của phòng trống vào từng label foreach (var item in phongTrong) { foreach (var pnl in flowLayoutPanel3.Controls.OfType <DevExpress.XtraEditors.PanelControl>()) { if (pnl.Name.Equals(item.MaPhong.Trim())) { pnl.BackColor = Color.LawnGreen; foreach (var lbl in pnl.Controls.OfType <Label>()) { string ma = item.MaPhong.Substring(3, 5); lbl.BackColor = Color.LawnGreen; lbl.Text = "Phòng " + Convert.ToInt32(ma); lbl.MouseDown += new MouseEventHandler(lbl_ClickTP); lbl.ContextMenuStrip = cmnstrpSanSang; } } } } //Load thông tin của phòng đang có khách vào từng label foreach (var item in coKhach) { foreach (var pnl in flowLayoutPanel3.Controls.OfType <DevExpress.XtraEditors.PanelControl>()) { if (pnl.Name.Equals(item.MaPhong.Trim())) { pnl.BackColor = Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(128))))); foreach (var lbl in pnl.Controls.OfType <Label>()) { lbl.BackColor = Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(128))))); string ma = item.MaPhong.Substring(3, 5); ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS(); DoanBUS dbus = new DoanBUS(); ThuePhongBUS tpbus = new ThuePhongBUS(); foreach (var thuePhong in tpbus.getMaThue(cttpbus.getMaThue_By_MaPhong_TrangThai(item.MaPhong, false))) { if (thuePhong.MaDoan == null) { lbl.Text = "Phòng " + Convert.ToInt32(ma); } else { string tendoan = dbus.getTen_ById(tpbus.getMaDoan_ByMaThue(cttpbus.getMaThue_By_MaPhong_TrangThai(item.MaPhong, false))); string tenPhong = "Phòng " + Convert.ToInt32(ma); lbl.Text = tenPhong + "\n\n\rĐoàn: " + tendoan; } } lbl.MouseDown += new MouseEventHandler(lblred_Click); lbl.MouseHover += new EventHandler(lblred_MouseHover); lbl.ContextMenuStrip = cmnstrpCoKhach; } } } } }
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; } }