public DataTable DataTable_DSTDV(ArrayList ds)
{
DichVuBUS dvbus = new DichVuBUS();
PhongBUS pbus = new PhongBUS();
KhachHangBUS khbus = new KhachHangBUS();
HoaDonDichVuBUS hddvbus = new HoaDonDichVuBUS();
ChiTietDichVuBUS ctdvbus = new ChiTietDichVuBUS();
eHoaDonDichVu hddv = new eHoaDonDichVu();//
DataTable dt = new DataTable();
dt.Columns.Add("Phòng", typeof(string));
dt.Columns.Add("Khách hàng", typeof(string));
dt.Columns.Add("Tiền DV", typeof(double));
dt.Columns.Add("Ngày Lập", typeof(string));
for (int i = 0; i < ds.Count; i++)
{
for (int j = 1; j < ds.Count; j++)
{
if (i == j)
{
continue;
}
if (ds[i].Equals(ds[j]))
{
ds.RemoveAt(i);
}
}
}
double tongTienDV = 0;
foreach (string item in ds)
{
foreach (var ctdv in ctdvbus.getctdv_byMaThue(item))
{
double tienDV = 0;
foreach (var ctdv1 in ctdvbus.getctdv_byMaThue(ctdv.MaThue))
{
tienDV += ctdv1.SoLuong * dvbus.getDonGia_byID(ctdv1.MaDV);
}
dt.Rows.Add(pbus.getTenPhong_ByID(ctdv.MaPhong), khbus.getenKH_ByID(ctdv.MaKhach), tienDV, hddvbus.getNgay_byMaThue(ctdv.MaThue).ToShortDateString());
tongTienDV += tienDV;
break;
}
}
lblTongTien.Text = string.Format("{0:#,##0 vnđ}", tongTienDV).ToString();
return(dt);
}
public double tienDV(ArrayList ds)
{
double tongTienDV = 0;
DichVuBUS dvbus = new DichVuBUS();
PhongBUS pbus = new PhongBUS();
KhachHangBUS khbus = new KhachHangBUS();
HoaDonDichVuBUS hddvbus = new HoaDonDichVuBUS();
ChiTietDichVuBUS ctdvbus = new ChiTietDichVuBUS();
eHoaDonDichVu hddv = new eHoaDonDichVu();
for (int i = 0; i < ds.Count; i++)
{
for (int j = 1; j < ds.Count; j++)
{
if (i == j)
{
continue;
}
if (ds[i].Equals(ds[j]))
{
ds.RemoveAt(i);
}
}
}
foreach (string item in ds)
{
foreach (var ctdv in ctdvbus.getctdv_byMaThue(item))
{
double tienDV = 0;
foreach (var ctdv1 in ctdvbus.getctdv_byMaThue(ctdv.MaThue))
{
tienDV += ctdv1.SoLuong * dvbus.getDonGia_byID(ctdv1.MaDV);
}
tongTienDV += tienDV;
break;
}
}
return(tongTienDV);
}
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");
}
}
}
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 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();
}
}
}
}
}
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;
}
}
