public void load_list_dichvu()
{
PhongBUS pbus = new PhongBUS();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
dgvCTDV.DataSource = DataTable_DSDV(ctdvbus.getctdv(MaThue, cttpbus.getMaKhach_By_MaPhong_TrangThai(pbus.maPhong_byTen(TenPhong), false)));
}
public void lblred_MouseHover(object sender, EventArgs e)
{
PhongBUS pbus = new PhongBUS();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
ThuePhongBUS tpbus = new ThuePhongBUS();
KhachHangBUS khbus = new KhachHangBUS();
Label lbl = sender as Label;
string ttPhong = lbl.Text;
string[] lsPhong = ttPhong.Split('\r');
string mathue = cttpbus.getMaThue_By_MaPhong_TrangThai(pbus.maPhong_byTen(lsPhong[0].Trim()), false);
string ttThuePhong = "";
int stt = 0;
foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue_MaPhong(mathue, pbus.maPhong_byTen(lsPhong[0].Trim())))
{
stt++;
ttThuePhong += "Khách hàng " + stt + " : " + khbus.getenKH_ByID(item.MaKhach) + "\n";
}
foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue_MaPhong(mathue, pbus.maPhong_byTen(lsPhong[0].Trim())))
{
if (item.NgayRa < DateTime.Now.Date)
{
ttThuePhong += "Ngày ra: " + DateTime.Now.Date.ToShortDateString();
}
else
{
ttThuePhong += "Ngày ra: " + item.NgayRa.ToShortDateString();
}
break;
}
toolTipTTThuePhong.SetToolTip(lbl, ttThuePhong);
}
private void btnIn_Click(object sender, EventArgs e)
{
HoaDon bc = new HoaDon();
List <eKhachHang> listkh = new List <eKhachHang>();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
PhongBUS pbus = new PhongBUS();
for (int i = 0; i < gridViewLuongKhach.RowCount; i++)
{
eKhachHang kh = new eKhachHang();
kh.SoPhong = gridViewLuongKhach.GetRowCellValue(i, gridViewLuongKhach.Columns[0]).ToString();
kh.TenKH = gridViewLuongKhach.GetRowCellValue(i, gridViewLuongKhach.Columns[1]).ToString();
kh.SoCMND = gridViewLuongKhach.GetRowCellValue(i, gridViewLuongKhach.Columns[2]).ToString();
kh.SoDT = gridViewLuongKhach.GetRowCellValue(i, gridViewLuongKhach.Columns[3]).ToString();
string tgian = cttpbus.getCTTP_By_MaPhong_TrangThai(pbus.maPhong_byTen(kh.SoPhong), false).GioVao + " " + cttpbus.getCTTP_By_MaPhong_TrangThai(pbus.maPhong_byTen(kh.SoPhong), false).NgayVao.ToShortDateString();
kh.ThoiGianNhanPhong = tgian;
listkh.Add(kh);
}
bc.thoiGianInHD = DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString();
frmPrint frmInBCDV = new frmPrint();
frmInBCDV.InBaoCaoInLuongKhachTuReport(bc, listkh.ToList());
frmInBCDV.ShowDialog();
this.Close();
}
private void btnSua_Click(object sender, EventArgs e)
{
if (lsvCTPT.SelectedItems.Count <= 0)
{
return;
}
if (kiemtra())
{
cttpBUS = new ChiTietThuePhongBUS();
cttpDT0 = new ChiTietThuePhongDTO();
cttpDT0.Maphieuthue = cmbMaPT.SelectedItem.ToString();
cttpDT0.Madichvu = cmbMaDV.SelectedValue.ToString();
cttpDT0.Maphong = cmbMaphong.SelectedItem.ToString();
cttpDT0.Ngay = dtpNgayGio.Value;
cttpDT0.Soluong = (int)numSL.Value;
if (cttpBUS.updateChiTietThuePhong(cttpDT0) == 1)
{
show_CTTP();
}
else
{
MessageBox.Show("Lỗi!");
}
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (lsvCTPT.SelectedItems.Count <= 0)
{
return;
}
else
{
if (MessageBox.Show("Bạn có chắc thực hiện việc này không", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
cttpBUS = new ChiTietThuePhongBUS();
cttpDT0.Maphieuthue = cmbMaPT.SelectedItem.ToString();
cttpDT0.Maphong = cmbMaphong.SelectedValue.ToString();
cttpDT0.Ngay = dtpNgayGio.Value;
if (cttpBUS.deleteChiTietThuePhong(cmbMaPT.SelectedItem.ToString(), cmbMaphong.SelectedValue.ToString(), dtpNgayGio.Value, cmbMaDV.SelectedValue.ToString()) == 1)
{
show_CTTP();
}
else
{
MessageBox.Show("Không xóa được!");
}
}
else
{
lsvCTPT.SelectedItems.Clear();
}
}
}
private void frmBC_SoLuongKhachHang_Load(object sender, EventArgs e)
{
cboNgayThang.SelectedIndex = 0;
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
gdvBC_LuongKhach.DataSource = DataTable_DSTP(cttpbus.getAllKHDangO());
}
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");
}
public void LoadKHDangThuePhong()
{
List <eKhachHang> ls = new List <eKhachHang>();
KhachHangBUS khbus = new KhachHangBUS();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
foreach (var item in cttpbus.getAllKHDangO())
{
ls.Add(khbus.getallKhDangO(item.MaKhach));
}
gridControlDsKH.DataSource = ls.ToList();
}
public void tinhTienPhong()
{
TimeSpan nhan6h = new TimeSpan(6, 0, 0);
TimeSpan nhan13h = new TimeSpan(13, 0, 0);
TimeSpan nhan14h = new TimeSpan(14, 0, 0);
PhongBUS pbus = new PhongBUS();
eHoaDonTienPhong hdtp = new eHoaDonTienPhong();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue_MaPhong(MaThue, pbus.maPhong_byTen(TenPhong)))
{
lblNhanPhong.Text = item.GioVao + " " + item.NgayVao.ToShortDateString();
string gioMacDinh = nhan14h + " " + item.NgayVao.ToShortDateString();
lblTraPhong.Text = DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString();
TimeSpan date = Convert.ToDateTime(lblTraPhong.Text) - Convert.ToDateTime(lblNhanPhong.Text);
int ngay = date.Days;
int h = date.Hours;
if (item.NgayVao == DateTime.Now.Date)
{
tienphong = hdtp.tinhTienPhong(item, tienPhong(pbus.getLoaiPhong_ByID(item.MaPhong)), Convert.ToDateTime(lblNhanPhong.Text), Convert.ToDateTime(lblTraPhong.Text));
txtTienPhong.Text = (string.Format("{0:#,##0}", tienphong)).ToString();
}
else
{
tienphong = hdtp.tinhTienPhong(item, tienPhong(pbus.getLoaiPhong_ByID(item.MaPhong)), Convert.ToDateTime(gioMacDinh), Convert.ToDateTime(lblTraPhong.Text));
txtTienPhong.Text = (string.Format("{0:#,##0}", tienphong)).ToString();
}
if (ngay == 0 && h < 5)
{
lblGhiChu.Text = item.GhiChu + "\n" + "\nSố tiền phòng: " + item.GioVao + " " + item.NgayVao.ToShortDateString() + "đến " + lblTraPhong.Text + " là " + string.Format("{0:#,##0}", tienphong).ToString() + " đồng";
phuthu = 0;
txtPhuThu.Text = string.Format("{0:#,##0}", phuthu).ToString();
}
else
{
if (item.GioVao > nhan6h && item.GioVao < nhan13h)
{
lblGhiChu.Text = item.GhiChu + "\n" + "Số tiền khách đến sớm: " + item.GioVao + " " + item.NgayVao.ToShortDateString() + "đến " + nhan14h + " " + item.NgayVao.ToShortDateString() + "là " + string.Format("{0:#,##0}", phuthu).ToString() + " đồng"
+ "\nSố tiền phòng: " + nhan14h + " " + item.NgayVao.ToShortDateString() + "đến " + lblTraPhong.Text + " là " + string.Format("{0:#,##0}", tienphong).ToString() + " đồng";
}
else
{
lblGhiChu.Text = item.GhiChu + "\n" + "\nSố tiền phòng: " + item.GioVao + " " + item.NgayVao.ToShortDateString() + " đến " + lblTraPhong.Text + " là " + string.Format("{0:#,##0}", tienphong).ToString() + " đồng";
}
}
tienkhac += item.TienKhac;
txtTienKhac.Text = string.Format("{0:#,##0}", tienkhac).ToString();
}
}
private void cboPhongTrong_SelectedIndexChanged(object sender, EventArgs e)
{
LoaiPhongBUS lpbus = new LoaiPhongBUS();
PhongBUS pbus = new PhongBUS();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
eChiTietThuePhong cttp = new eChiTietThuePhong();
eHoaDonTienPhong hdtp = new eHoaDonTienPhong();
cttp = cttpbus.getCTTP_By_MaPhong_TrangThai(pbus.maPhong_byTen(TenPhong), false);
double tienPhongCu = hdtp.tinhTienPhong(cttp, lpbus.donGia(pbus.getLoaiPhong_ByID(pbus.maPhong_byTen(TenPhong))), Convert.ToDateTime(cttp.GioVao + " " + cttp.NgayVao.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString()));
double tienPhongMoi = hdtp.tinhTienPhong(cttp, lpbus.donGia(pbus.getLoaiPhong_ByID(pbus.maPhong_byTen(cboPhongTrong.Text.Trim()))), Convert.ToDateTime(cttp.GioVao + " " + cttp.NgayVao.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString()));
tienkhac = tienPhongCu - tienPhongMoi + cttp.TienKhac;
lblTienKhac.Text = (string.Format("{0:#,##0 vnd}", tienkhac).ToString());
}
public void tienPhuThu()
{
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
PhongBUS pbus = new PhongBUS();
eHoaDonTienPhong pt = new eHoaDonTienPhong();
if (cttpbus.getCTTP_By_MaPhong_TrangThai(pbus.maPhong_byTen(TenPhong), false).GhiChu == null)
{
phuthu = pt.tinhTienPhuThu(cttpbus.getCTTP_By_MaPhong_TrangThai(pbus.maPhong_byTen(TenPhong), false), tienPhong(pbus.getLoaiPhong_ByID(pbus.maPhong_byTen(TenPhong))));
}
else
{
phuthu = pt.tinhTienPhuThu(cttpbus.getCTTP_By_MaPhong_TrangThai(pbus.maPhong_byTen(TenPhong), false), tienPhong(pbus.getLoaiPhong_ByID(pbus.maPhong_byTen(cttpbus.getCTTP_By_MaPhong_TrangThai(pbus.maPhong_byTen(TenPhong), false).GhiChu.Substring(0, 8)))));
}
txtPhuThu.Text = string.Format("{0:#,##0}", phuthu).ToString();
}
public double tienPhong(ArrayList ds)
{
double tienPhong = 0;
PhongBUS pbus = new PhongBUS();
ThuePhongBUS tpbus = new ThuePhongBUS();
LoaiPhongBUS lpbus = new LoaiPhongBUS();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
eHoaDonTienPhong hdtp = new eHoaDonTienPhong();
foreach (string item in ds)
{
foreach (var cttp in cttpbus.getChiTietThuePhong_By_MaThue(item))
{
tienPhong += hdtp.tinhTienPhong(cttp, lpbus.donGia(pbus.getLoaiPhong_ByID(cttp.MaPhong)), Convert.ToDateTime(cttp.GioVao + " " + cttp.NgayVao.ToShortDateString()), Convert.ToDateTime(cttp.GioRa + " " + cttp.NgayRa.ToShortDateString())) + hdtp.tinhTienPhuThu(cttp, lpbus.donGia(pbus.getLoaiPhong_ByID(cttp.MaPhong))) + cttp.TienKhac;
}
}
return(tienPhong);
}
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();
}
}
}
public DataTable DataTable_DSTP(ArrayList ds)
{
KhachHangBUS khbus = new KhachHangBUS();
PhongBUS pbus = new PhongBUS();
ThuePhongBUS tpbus = new ThuePhongBUS();
DoanBUS dbus = new DoanBUS();
LoaiPhongBUS lpbus = new LoaiPhongBUS();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
eHoaDonTienPhong hdtp = new eHoaDonTienPhong();
DataTable dt = new DataTable();
dt.Columns.Add("Tên khách hàng", typeof(string));
dt.Columns.Add("Tiền phòng", typeof(double));
dt.Columns.Add("Thời gian vào", typeof(string));
dt.Columns.Add("Thời gian ra", typeof(string));
foreach (string item in ds)
{
double tienPhong = 0;
foreach (var cttp in cttpbus.getChiTietThuePhong_By_MaThue(item))
{
tienPhong += hdtp.tinhTienPhong(cttp, lpbus.donGia(pbus.getLoaiPhong_ByID(cttp.MaPhong)), Convert.ToDateTime(cttp.GioVao + " " + cttp.NgayVao.ToShortDateString()), Convert.ToDateTime(cttp.GioRa + " " + cttp.NgayRa.ToShortDateString())) + hdtp.tinhTienPhuThu(cttp, lpbus.donGia(pbus.getLoaiPhong_ByID(cttp.MaPhong))) + cttp.TienKhac;
}
if (tpbus.getMaDoan_ByMaThue(item) == null)
{
foreach (var cttp in cttpbus.getChiTietThuePhong_By_MaThue(item))
{
dt.Rows.Add(khbus.getenKH_ByID(cttp.MaKhach), tienPhong, cttp.GioVao + " " + cttp.NgayVao.ToShortDateString(), cttp.GioRa + " " + cttp.NgayRa.ToShortDateString());
}
}
else
{
foreach (var cttp in cttpbus.getChiTietThuePhong_By_MaThue(item))
{
dt.Rows.Add(dbus.getTen_ById(tpbus.getMaDoan_ByMaThue(item)), tienPhong, cttp.GioVao + " " + cttp.NgayVao.ToShortDateString(), cttp.GioRa + " " + cttp.NgayRa.ToShortDateString());
break;
}
}
}
return(dt);
}
private void show_CTTP()
{
lsvCTPT.Items.Clear();
decimal t = 0;
txtTongTien.Clear();
dtpNgayGio.Enabled = false;
dtpNgayGio.Format = DateTimePickerFormat.Custom;
dtpNgayGio.CustomFormat = "dd/MM/yyyy h:mm:ss";
dtpNgayGio.Value = DateTime.Now;
string fePT = cmbMaPT.SelectedItem.ToString();
cttpBUS = new ChiTietThuePhongBUS();
IList <ChiTietThuePhongDTO> listcttp = cttpBUS.getChiTietThuePhongByID(fePT);
foreach (ChiTietThuePhongDTO cttp in listcttp)
{
int i = lsvCTPT.Items.Count;
if (cmbMaphong.Text != "")
{
if (cttp.Maphong == cmbMaphong.SelectedItem.ToString())
{
dvBUS = new DichVuBUS();
DichVuDTO listdv = dvBUS.getDichVuByID(cttp.Madichvu);
lsvCTPT.Items.Add(listdv.Tendichvu);
lsvCTPT.Items[i].SubItems.Add(cttp.Ngay.ToString());
lsvCTPT.Items[i].SubItems.Add(cttp.Soluong.ToString());
int sl = cttp.Soluong;
decimal gia = listdv.Gia;
decimal tien = sl * gia;
t += tien;
lsvCTPT.Items[i].SubItems.Add(tien.ToString("0,0"));
}
}
}
txtTongTien.Text = t.ToString("0,0");
}
public void loadKhachHang()
{
PhongBUS pbus = new PhongBUS();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue_MaPhong(MaThue, pbus.maPhong_byTen(TenPhong)))
{
eKhachHang kh = new eKhachHang();
kh = khbus.getmaKH(item.MaKhach);
txtHoTen.Text = kh.TenKH;
txtCMND.Text = kh.SoCMND;
txtSDT.Text = kh.SoDT;
if (kh.GioiTinh)
{
radNam.Checked = true;
}
else
{
radNu.Checked = true;
}
}
}
public DataTable DataTable_DSTP(List <eChiTietThuePhong> ds)
{
KhachHangBUS khbus = new KhachHangBUS();
PhongBUS pbus = new PhongBUS();
ThuePhongBUS tpbus = new ThuePhongBUS();
DoanBUS dbus = new DoanBUS();
LoaiPhongBUS lpbus = new LoaiPhongBUS();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
eHoaDonTienPhong hdtp = new eHoaDonTienPhong();
DataTable dt = new DataTable();
dt.Columns.Add("Tên phòng", typeof(string));
dt.Columns.Add("Tên khách hàng", typeof(string));
dt.Columns.Add("Số CMND", typeof(string));
dt.Columns.Add("Số điện thoại", typeof(string));
dt.Columns.Add("Thời gian nhận phòng", typeof(string));
foreach (eChiTietThuePhong item in ds)
{
eKhachHang kh = new eKhachHang();
kh = khbus.getmaKH(item.MaKhach);
dt.Rows.Add(pbus.getTenPhong_ByID(item.MaPhong), kh.TenKH, kh.SoCMND, kh.SoDT, item.GioVao + " " + item.NgayVao.ToShortDateString());
}
return(dt);
}
private void btnThem_Click(object sender, EventArgs e)
{
if (kiemtra())
{
dtpNgayGio.Format = DateTimePickerFormat.Custom;
dtpNgayGio.CustomFormat = "dd/MM/yyyy h:mm:ss";
cttpBUS = new ChiTietThuePhongBUS();
cttpDT0 = new ChiTietThuePhongDTO();
cttpDT0.Maphieuthue = cmbMaPT.SelectedItem.ToString();
cttpDT0.Maphong = cmbMaphong.SelectedItem.ToString();
cttpDT0.Ngay = DateTime.Parse(dtpNgayGio.Value.ToString());
cttpDT0.Madichvu = cmbMaDV.SelectedValue.ToString();
cttpDT0.Soluong = (int)numSL.Value;
if (cttpBUS.insertChiTietThuePhong(cttpDT0) == 1)
{
show_CTTP();
}
else
{
MessageBox.Show("Lỗi thêm dữ liệu!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
dtpNgayGio.Value = DateTime.Now;
}
}
}
/**Tạo sự kiện kích chuột phải vào label để lấy các thông tin trong label đó
* ra truyền qua các form khác* */
public void lblred_Click(object sender, MouseEventArgs e)
{
PhongBUS pbus = new PhongBUS();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
ThuePhongBUS tpbus = new ThuePhongBUS();
Label lbl = sender as Label;
if (e.Button == MouseButtons.Right)
{
string ttPhong = lbl.Text;
string[] lsPhong = ttPhong.Split('\r');
string tenPhong = lsPhong[0].Trim();
frmTraKhachLe.TenPhong = tenPhong;
frmDatPhong.TenLoaiPhong = "Phòng " + lpbus.getTen_Byma(pbus.getLoaiPhong_ByID(pbus.maPhong_byTen(tenPhong)));
frmTraKhachLe.LoaiPhong = "Phòng " + lpbus.getTen_Byma(pbus.getLoaiPhong_ByID(pbus.maPhong_byTen(tenPhong)));
frmDatPhong.TenPhong = tenPhong;
frmTraKhachLe.MaThue = cttpbus.getMaThue_By_MaPhong_TrangThai(pbus.maPhong_byTen(tenPhong), false);
frmDatPhong.maThue = cttpbus.getMaThue_By_MaPhong_TrangThai(pbus.maPhong_byTen(tenPhong), false);
frmDatPhong.maKhachHang = cttpbus.getMaKhach_By_MaPhong_TrangThai(pbus.maPhong_byTen(tenPhong), false);
frmDoiPhong.TenPhong = tenPhong;
frmDoiPhong.maThue = cttpbus.getMaThue_By_MaPhong_TrangThai(pbus.maPhong_byTen(tenPhong), false);
TenPhong = tenPhong;
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
ThuePhongBUS tpbus = new ThuePhongBUS();
PhongBUS pbus = new PhongBUS();
LoaiPhongBUS lpbus = new LoaiPhongBUS();
eThuePhong tp = new eThuePhong();
NhanVienBUS nvbus = new NhanVienBUS();
DoanBUS dbus = new DoanBUS();
//Tao Doan
eDoan doan = new eDoan();
doan.DiaChi = txtDiaChi.Text.Trim();
doan.MaTruongDoan = txtTruongDoan.Text.Trim();
doan.TenDoan = txtTenDoan.Text.Trim();
doan.Sdt = txtSdtDoan.Text.Trim();
if (dbus.getdoan_sdt(txtSdtDoan.Text.Trim()) == null)
{
int kqTaoDoan = dbus.insertDoan(doan);
}
tp.MaNV = nvbus.getmaNV_byEmail(emailNV);
tp.MaDoan = dbus.getId_ByTenDoan(txtTenDoan.Text.Trim()); //ma doan
int soLuongP = 0;
for (int i = 0; i < gridViewLoaiPhong.RowCount; i++)
{
soLuongP += Convert.ToInt32(gridViewLoaiPhong.GetRowCellValue(i, gridViewLoaiPhong.Columns[3]));
}
tp.SoLuongPhong = soLuongP;
tp.TrangThai = false;
TimeSpan gioVao = new TimeSpan(DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
TimeSpan gioRa = new TimeSpan(14, 00, 00);
int a = tpbus.insertThuePhong(tp);
eChiTietThuePhong cttp = new eChiTietThuePhong();
if (a == 1)
{
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
foreach (eKhachHang item in ls)
{
cttp.MaThue = tpbus.getMaThueCuoi();
cttp.MaKhach = item.MaKH;
cttp.MaPhong = pbus.maPhong_byTen(item.SoPhong);
cttp.NgayRa = Convert.ToDateTime(dtmNgayRa.Text).Date;
cttp.NgayVao = DateTime.Now.Date;
cttp.GioRa = gioRa;
cttp.GioVao = gioVao;
cttp.TrangThai = false;
cttpbus.insertCTTP(cttp);
ePhong p = new ePhong();
p.MaPhong = pbus.maPhong_byTen(item.SoPhong);
p.TinhTrang = true;
int soPhong = 0;
foreach (var kh in ls)
{
if (kh.SoPhong.Equals(item.SoPhong))
{
soPhong++;
}
}
p.SoNgHienTai = soPhong;
pbus.updateTinhTrangPhong(p);
}
MessageBox.Show("Đặt phòng thành công");
this.Close();
}
else
{
MessageBox.Show("Không thành công");
return;
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (kieuForm == 1)
{
PhongBUS pbus = new PhongBUS();
LoaiPhongBUS lpbus = new LoaiPhongBUS();
eThuePhong tp = new eThuePhong();
NhanVienBUS nvbus = new NhanVienBUS();
tp.MaNV = nvbus.getmaNV_byEmail(emailNV);
tp.SoLuongPhong = 1;
tp.TrangThai = false;
TimeSpan gioVao = new TimeSpan(DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
TimeSpan gioRa = new TimeSpan(14, 00, 00);
int a = tpbus.insertThuePhong(tp);
eChiTietThuePhong cttp = new eChiTietThuePhong();
if (a == 1)
{
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
cttp.MaThue = tpbus.getMaThueCuoi();
cttp.MaKhach = maKH;
cttp.MaPhong = pbus.maPhong_byTen(TenPhong);
cttp.NgayRa = Convert.ToDateTime(dtmNgayRa.Text).Date;
cttp.NgayVao = DateTime.Now.Date;
cttp.GioRa = gioRa;
cttp.GioVao = gioVao;
cttp.TrangThai = false;
cttp.TienKhac = 0;
cttpbus.insertCTTP(cttp);
ePhong p = new ePhong();
p.MaPhong = pbus.maPhong_byTen(TenPhong);
p.TinhTrang = true;
pbus.updateTinhTrangPhong(p);
MessageBox.Show("Đặt phòng thành công");
this.Close();
}
else
{
MessageBox.Show("Không thành công");
return;
}
DichVuBUS dvbus = new DichVuBUS();
eDichVu dv = new eDichVu();
ChiTietDichVuBUS ctdvbus = new ChiTietDichVuBUS();
eChiTetDichVu ctdv = new eChiTetDichVu();
//Thêm chi tiết dịch vụ nếu có đặt dịch vụ
if (gridViewCTDV.RowCount > 0)
{
for (int i = 0; i < gridViewCTDV.RowCount; i++)
{
ctdv.MaThue = cttp.MaThue;
ctdv.MaThue = cttp.MaThue;
ctdv.MaKhach = cttp.MaKhach;
ctdv.MaPhong = cttp.MaPhong;
ctdv.MaDV = gridViewCTDV.GetRowCellValue(i, gridViewCTDV.Columns[0]).ToString();
ctdv.SoLuong = Convert.ToInt32(gridViewCTDV.GetRowCellValue(i, gridViewCTDV.Columns[2]).ToString());
int s = ctdvbus.insertCTDV(ctdv);
foreach (eDichVu item in mangDichVu)
{
//Cập nhật lại số lượng trong bảng dịch vụ
if (gridViewCTDV.GetRowCellValue(i, gridViewCTDV.Columns[0]).ToString() == item.MaDV)
{
dv.MaDV = item.MaDV;
dv.TenDV = item.TenDV;
dv.DonGia = item.DonGia;
dv.SoLuong = (item.SoLuong - Convert.ToInt32(gridViewCTDV.GetRowCellValue(i, gridViewCTDV.Columns[2])));
dvbus.SuaDV(dv);
}
}
}
}
}
if (kieuForm == 2)
{
//Thêm chi tiết dịch vụ nếu có đặt dịch vụ
if (gridViewCTDV.RowCount > 0)
{
for (int i = 0; i < gridViewCTDV.RowCount; i++)
{
PhongBUS pbus = new PhongBUS();
ChiTietDichVuBUS ctdvbus = new ChiTietDichVuBUS();
eChiTetDichVu ctdv = new eChiTetDichVu();
ctdv.MaThue = maThue.Trim();
ctdv.MaKhach = maKhachHang;
ctdv.MaPhong = pbus.maPhong_byTen(TenPhong);
ctdv.MaDV = gridViewCTDV.GetRowCellValue(i, gridViewCTDV.Columns[0]).ToString();
//ctdv.SoLuong = Convert.ToInt32(gridViewCTDV.GetRowCellValue(i, gridViewCTDV.Columns[2]).ToString());
/**Kiểm tra xem mã thuê và mã dịch vụ đó có trong csdl hay chưa
* Nếu có thì hãy update lại số lượng
* Chưa có thì thêm mới chi tiết dịch vụ**/
if (!ctdvbus.maThue_maDV_CoTonTai(ctdv.MaThue, ctdv.MaDV))
{
foreach (var item in ctdvbus.getctdv(ctdv.MaThue, ctdv.MaKhach))
{
if (item.MaThue == ctdv.MaThue && item.MaDV == ctdv.MaDV)
{
ctdv.SoLuong = Convert.ToInt32(gridViewCTDV.GetRowCellValue(i, gridViewCTDV.Columns[2]).ToString()) + item.SoLuong;
ctdvbus.updateCTDV(ctdv);
}
if (item.MaDV == null)
{
ctdv.SoLuong = Convert.ToInt32(gridViewCTDV.GetRowCellValue(i, gridViewCTDV.Columns[2]).ToString());
int s = ctdvbus.insertCTDV(ctdv);
}
}
}
else
{
ctdv.SoLuong = Convert.ToInt32(gridViewCTDV.GetRowCellValue(i, gridViewCTDV.Columns[2]).ToString());
int s = ctdvbus.insertCTDV(ctdv);
}
DichVuBUS dvbus = new DichVuBUS();
eDichVu dv = new eDichVu();
foreach (eDichVu item in mangDichVu)
{
//Cập nhật lại số lượng trong bảng dịch vụ
if (gridViewCTDV.GetRowCellValue(i, gridViewCTDV.Columns[0]).ToString() == item.MaDV)
{
dv.MaDV = item.MaDV;
dv.TenDV = item.TenDV;
dv.DonGia = item.DonGia;
dv.SoLuong = (item.SoLuong - Convert.ToInt32(gridViewCTDV.GetRowCellValue(i, gridViewCTDV.Columns[2])));
dvbus.SuaDV(dv);
}
}
}
MessageBox.Show("Cập nhật dịch vụ thành công");
this.Close();
}
else
{
MessageBox.Show("Không có dịch vụ cần cập nhật xin nhập lại");
}
}
}
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();
}
}
}
}
}
public void loadThuePhong_Doan()
{
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
ThuePhongBUS tpbus = new ThuePhongBUS();
DoanBUS dbus = new DoanBUS();
LoaiPhongBUS lpbus = new LoaiPhongBUS();
PhongBUS pbus = new PhongBUS();
ChiTietDichVuBUS ctdvbus = new ChiTietDichVuBUS();
DichVuBUS dvbus = new DichVuBUS();
List <eChiTietThuePhong> list_ect = new List <eChiTietThuePhong>();
list_ect = cttpbus.getChiTietThuePhong_By_MaThue_TrangThai(tpbus.getMaThue_ByMaDoan(dbus.getId_ByTenDoan(txtTenDoan.Text), 0), 0);
for (int i = 0; i < list_ect.Count; i++)
{
for (int j = 1; j < list_ect.Count; j++)
{
if (i == j)
{
list_ect.RemoveAt(i);
continue;
}
if (list_ect[i].MaPhong.Equals(list_ect[j].MaPhong))
{
list_ect.RemoveAt(i);
}
}
}
List <eThuePhong_Doan> lstp_d = new List <eThuePhong_Doan>();
foreach (eChiTietThuePhong item in list_ect)
{
eThuePhong_Doan etpd = new eThuePhong_Doan();
eHoaDonTienPhong hdtp = new eHoaDonTienPhong();
eHoaDonDichVu hddv = new eHoaDonDichVu();
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 = 0;
if (item.GhiChu.Equals(""))
{
tienPhuThu += Convert.ToDouble(hdtp.tinhTienPhuThu(item, lpbus.donGia(pbus.getLoaiPhong_ByID(item.MaPhong))));
}
else
{
tienPhuThu += Convert.ToDouble(hdtp.tinhTienPhuThu(item, lpbus.donGia(pbus.getLoaiPhong_ByID(pbus.maPhong_byTen(item.GhiChu.Substring(0, 8))))));
}
etpd.Tenphong = pbus.getTenPhong_ByID(item.MaPhong);
etpd.TienPhong = tienPhong + tienPhuThu;
double tienDV = 0;
foreach (eChiTetDichVu ctdv in ctdvbus.getctdv_MaThue_MaPhong(item.MaThue, item.MaPhong))
{
tienDV += hddv.tinhDichVu(dvbus.getDonGia_byID(ctdv.MaDV), ctdv.SoLuong);
}
etpd.TienDV = tienDV;
etpd.TienKhac = item.TienKhac;
etpd.GhiChu = item.GhiChu;
lstp_d.Add(etpd);
}
dgvDsThuePhong.DataSource = lstp_d.ToList();
double tongTienPhong = 0;
for (int i = 0; i < gridViewDsThuePhong.RowCount; i++)
{
tongTienPhong += Convert.ToDouble(gridViewDsThuePhong.GetRowCellValue(i, gridViewDsThuePhong.Columns[1]));
}
txtTongTienPhong.Text = string.Format("{0:#,##0}", tongTienPhong).ToString();
txtThueVAT.Text = string.Format("{0:#,##0}", tongTienPhong * 0.1).ToString();
txtKhuyenMai.Text = string.Format("{0:#,##0}", tongTienPhong * 0.2).ToString();
txtTienThanhToan.Text = string.Format("{0:#,##0}", tongTienPhong + tongTienPhong * 0.1 - tongTienPhong * 0.2).ToString();
}
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();
}
}
//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;
}
}
