public ChuyenPhong GetDuLieuChuyenPhong(int IdPhong, int Id)
{
ChuyenPhong chuyenPhong = new ChuyenPhong();
var ldk = _lichDangKyRepository.GetSingleById(Id);
chuyenPhong.ListThoiGianBatDau = GetDanhSachThoiGianDangKyBatDau(ldk.ThoiGianBatDau.TimeOfDay, ldk.NgayDangKy);
chuyenPhong.ListThoiGianKetThuc = GetDanhSachThoiGianDangKyBatDau(ldk.ThoiGianKetThuc.TimeOfDay, ldk.NgayDangKy);
chuyenPhong.ListLanhDao = GetDanhSachLanhDao(ldk.IdLanhDao);
chuyenPhong.ThanhPhan = ldk.ThanhPhan;
chuyenPhong.NgayDangKy = ldk.NgayDangKy;
chuyenPhong.ListPhong = GetDanhSachChuyenPhong(IdPhong);
chuyenPhong.ID = Id;
chuyenPhong.IdLanhDao = ldk.IdLanhDao.ToString();
chuyenPhong.PhongCu = IdPhong;
chuyenPhong.IdPhongMoi = ldk.IDPhong;
chuyenPhong.TieuDe = ldk.TieuDe;
chuyenPhong.Email = ldk.Email;
chuyenPhong.EmailNguoiChuTri = ldk.LanhDao.Email;
chuyenPhong.TenNguoiChuTriCuocHop = ldk.LanhDao.HoTen;
chuyenPhong.ChucVu = ldk.LanhDao.ChucVu;
chuyenPhong.DonViCongTac = ldk.LanhDao.DonViCongTac;
chuyenPhong.TenNguoiDangKy = ldk.TenNguoiDangKy;
chuyenPhong.NoiDungCuocHop = ldk.NoiDungCuocHop;
return(chuyenPhong);
}
void DisplayChuyenPhongWithSelectedTile(ThuePhongDTO thuePhong = null)
{
//DTO.PhongDTO phongDTO = new DTO.PhongDTO((int)tileView1.GetRowCellValue(tileView1.GetSelectedRows()[0], "MaPhong"), (string)tileView1.GetRowCellValue(tileView1.GetSelectedRows()[0], "TenPhong"), (int)tileView1.GetRowCellValue(tileView1.GetSelectedRows()[0], "MaLoaiPhong"), tileView1.GetRowCellValue(tileView1.GetSelectedRows()[0], "Tang").ToString(), tileView1.GetRowCellValue(tileView1.GetSelectedRows()[0], "GhiChu").ToString(), (int)tileView1.GetRowCellValue(tileView1.GetSelectedRows()[0], "MaTinhTrangPhong"));
ThuePhongDTO thuePhongDto;
if (thuePhong == null)
{
thuePhongDto = listPhongDangThue[(int)danhSachPhong.Rows[tileView1.GetFocusedDataSourceRowIndex()]["MaPhong"]];
}
else
{
thuePhongDto = thuePhong;
}
ChuyenPhong formChuyenPhong = new ChuyenPhong(thuePhongDto);
if (FlyoutDialog.Show(this.FindForm(), formChuyenPhong) == DialogResult.OK)
{
DisplayTinhTrangPhongWithSelectedTile(formChuyenPhong.GetThuePhongMoi());
}
else
{
}
//this.TinhtrangPagecontrol.SelectedPage = PageThanhtoan;
}
public ActionResult ChuyenLich(ChuyenPhong chuyenPhong)
{
MailHelper mailHelper = new MailHelper();
var entity = _lichDangKyRepository.GetSingleById(chuyenPhong.ID);
var phongCu = chuyenPhong.PhongCu;
if (_lichDangKyRepository.CheckOverlap(entity.ThoiGianBatDau, entity.ThoiGianKetThuc, chuyenPhong.IdPhongMoi))
{
return(RedirectToAction("ChuyenLichThatBai"));
}
else
{
var mail = _mailRepository.GetAll();
try
{
entity.IDPhong = int.Parse(chuyenPhong.TenPhong);
entity.IdLanhDao = int.Parse(chuyenPhong.IdLanhDao);
entity.ThanhPhan = chuyenPhong.ThanhPhan;
entity.NgayDangKy = chuyenPhong.NgayDangKy;
entity.ThoiGianBatDau = chuyenPhong.NgayDangKy.AddHours(double.Parse(chuyenPhong.ThoiGianBatDau));
entity.ThoiGianKetThuc = chuyenPhong.NgayDangKy.AddHours(double.Parse(chuyenPhong.ThoiGianKetThuc));
entity.NoiDungCuocHop = chuyenPhong.NoiDungCuocHop;
entity.TenNguoiDangKy = chuyenPhong.TenNguoiDangKy;
entity.Email = chuyenPhong.Email;
entity.TieuDe = chuyenPhong.TieuDe;
entity.TinhTrang = "Đã chuyển";
_lichDangKyRepository.Update(entity);
_unitOfWork.Commit();
var changeRoom = mail.Where(x => x.ValueOfMail == 2);
//Gửi mail đã chuyển phòng
int phongThayThe = int.Parse(chuyenPhong.TenPhong);
var PhongDangKy = _phongRepository.GetAll().Where(x => x.ID == phongCu);
var PhongChuyen = _phongRepository.GetAll().Where(x => x.ID == phongThayThe);
string contentChangeRoom = System.IO.File.ReadAllText(Server.MapPath("/Assets/Home/MailStructure/" + changeRoom.First().TenMail));
contentChangeRoom = contentChangeRoom.Replace("{{Name}}", entity.TenNguoiDangKy);
contentChangeRoom = contentChangeRoom.Replace("{{PhongDangKy}}", PhongDangKy.First().TenPhong);
contentChangeRoom = contentChangeRoom.Replace("{{PhongChuyen}}", PhongChuyen.First().TenPhong);
//Extra
contentChangeRoom = contentChangeRoom.Replace("{{Email}}", entity.Email);
contentChangeRoom = contentChangeRoom.Replace("{{ThoiGian}}", entity.ThoiGianBatDau + "h-" + entity.ThoiGianKetThuc + "h");
contentChangeRoom = contentChangeRoom.Replace("{{NgayDangKy}}", entity.NgayDangKy.ToShortDateString());
contentChangeRoom = contentChangeRoom.Replace("{{NoiDungCuocHop}}", entity.NoiDungCuocHop);
contentChangeRoom = contentChangeRoom.Replace("{{SoDienThoai}}", entity.SoDienThoai);
contentChangeRoom = contentChangeRoom.Replace("{{TieuDe}}", entity.TieuDe);
contentChangeRoom = contentChangeRoom.Replace("{{ThanhPhan}}", entity.ThanhPhan);
contentChangeRoom = contentChangeRoom.Replace("{{TinhTrang}}", entity.TinhTrang);
mailHelper.SendMail(entity.Email, "NEU", contentChangeRoom);
return(RedirectToAction("ChuyenLichThanhCong"));
}
catch (Exception ex)
{
return(RedirectToAction("ChuyenLichThatBai"));
}
}
}
public ChuyenPhong Layphieuchuyentheoma(string maPC)
{
DataTable dt = CPDAL.LayPCTheoMa(maPC);
ChuyenPhong cp = new ChuyenPhong();
cp.Maphieuchuyen = dt.Rows[0][0].ToString();
cp.Masinhvien = dt.Rows[0][1].ToString();
cp.Maphongcu = dt.Rows[0][2].ToString();
cp.Maphongmoi = dt.Rows[0][3].ToString();
cp.Loaiphong = dt.Rows[0][4].ToString();
cp.Ngaychuyen = dt.Rows[0][5].ToString();
cp.Manhanvien = dt.Rows[0][6].ToString();
cp.Ghichu = dt.Rows[0][7].ToString();
return(cp);
}
public void Xoaphieuchuyen(ChuyenPhong cp)
{
strSQL = "Delete ChuyenPhong where MaPC='" + cp.Maphieuchuyen + "'";
helper.ThucThiKN(strSQL);
}
public void Suaphieuchuyen(ChuyenPhong cp)
{
strSQL = "Update ChuyenPhong set MaSV='" + cp.Masinhvien + "',MaPhongCu='" + cp.Maphongcu + "',MaPhongMoi='" + cp.Maphongmoi + "',LoaiPhong=N'" + cp.Loaiphong + "',NgayChuyen='" + cp.Ngaychuyen + "',MaNV='" + cp.Manhanvien + "',GhiChu=N'" + cp.Ghichu + "'where MaPC='" + cp.Maphieuchuyen + "'";
helper.ThucThiKN(strSQL);
}
public void Themphieuchuyen(ChuyenPhong cp)
{
strSQL = "Insert into ChuyenPhong values('" + cp.Maphieuchuyen + "','" + cp.Masinhvien + "','" + cp.Maphongcu + "','" + cp.Maphongmoi + "',N'" + cp.Loaiphong + "','" + cp.Ngaychuyen + "','" + cp.Manhanvien + "',N'" + cp.Ghichu + "')";
helper.ThucThiKN(strSQL);
}
public void XoaPhieuChuyen(string MaPC)
{
CP = new ChuyenPhong(MaPC, "", "", "", "", "", "", "");
CPDAL.Xoaphieuchuyen(CP);
}
public void SuaPhieuChuyen(string mapc, string masv, string maphongcu, string maphongmoi, string loaiphong, string ngaychuyen, string manhanvien, string ghichu)
{
CP = new ChuyenPhong(mapc, masv, maphongcu, maphongmoi, Chuanhoaxau(loaiphong), ngaychuyen, manhanvien, Chuanhoaxau(ghichu));
CPDAL.Suaphieuchuyen(CP);
}
private void wbntQuanlyphong_ButtonClick(object sender, DevExpress.XtraBars.Docking2010.ButtonEventArgs e)
{
switch (e.Button.Properties.Tag.ToString())
{
case "Thêm Dịch Vụ":
folderDichVu.ChonDichVu chonDichVu = new folderDichVu.ChonDichVu(false);
XtraDialogArgs args = new XtraDialogArgs(caption: "Chọn dịch vụ", content: chonDichVu, buttons: new DialogResult[] { DialogResult.OK, DialogResult.Cancel });
args.Showing += Args_Showing;
if (XtraDialog.Show(args) == DialogResult.OK)
{
foreach (int dichVu_Key in chonDichVu.GetSelectedDichVu().Keys)
{
DichVuDatPhongBUS.LuuThongTinDichVuDatPhong(new DichVuDatPhongDTO(DichVuDatPhongBUS.PhatSinhMaDichVuPhong(), dichVu_Key, chonDichVu.GetSelectedDichVu()[dichVu_Key], DichVuBUS.LayThongTinDichVu(dichVu_Key).DonGia, chiTietDatPhong.MaChiTietDatPhong));
//DichVuBUS.LayThongTinDichVu(dichVu_Key);
}
RefreshDataBindingDichVuPhong();
}
break;
case "Chuyển Phòng":
ChuyenPhong formChuyenPhong = new ChuyenPhong(chiTietDatPhong);
if (FlyoutDialog.Show(this.FindForm(), formChuyenPhong) == DialogResult.OK)
{
XtraMessageBox.Show("Chuyển phòng thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
(Parent.Parent.Parent as ThongTinChiTietDatNhieuPhong).RefreshData();
}
break;
case "Xóa Dịch Vụ":
if (XtraMessageBox.Show("Bạn có chắc muốn xóa dịch vụ '" + dichVuPhong.Rows[gridView1.GetFocusedDataSourceRowIndex()]["TenDV"] + "' ?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes)
{
DichVuDatPhongBUS.XoaDichVuDatPhong((int)dichVuPhong.Rows[gridView1.GetFocusedDataSourceRowIndex()]["MaDichVuDatPhong"]);
RefreshDataBindingDichVuPhong();
}
break;
case "Nhận Phòng":
//Thông báo xác nhận
if (XtraMessageBox.Show("Xác nhận nhận đặt phòng?", "Xác nhận", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
(Parent.Parent.Parent as ThongTinChiTietDatNhieuPhong).NhanPhong();
break;
case "Hủy Phòng":
//Thông báo xác nhận
if (XtraMessageBox.Show("Bạn có chắc hủy phòng đã đặt này ?", "Xác nhận", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
Dictionary <int, DatPhongDTO> tempSapDat_1 = BUS.DatPhongBUS.LayCacDatPhongDangSapDuocDatVaDangDuocDat(ThamSoBUS.LayKhoangThoiGianChoDatPhong());
//Hủy đặt phòng
if (DatPhongBUS.DemSoLuongChiTietDatPhong(chiTietDatPhong.MaDatPhong) == 1)
{
foreach (ChiTietDatPhongDTO dp in DatPhongBUS.LayTatCaCacChiTietDatPhong(chiTietDatPhong.MaDatPhong))
{
if (PhongBUS.LayThongTinPhong(dp.MaPhong).MaTinhTrangPhong == 4 && tempSapDat_1.ContainsKey(dp.MaDatPhong))
{
PhongBUS.CapNhatTinhTrangPhong(dp.MaPhong, 0);
}
else if (PhongBUS.LayThongTinPhong(dp.MaPhong).MaTinhTrangPhong == 6 && tempSapDat_1.ContainsKey(dp.MaDatPhong))
{
PhongBUS.CapNhatTinhTrangPhong(dp.MaPhong, 5);
}
else if (PhongBUS.LayThongTinPhong(dp.MaPhong).MaTinhTrangPhong == 7 && tempSapDat_1.ContainsKey(dp.MaDatPhong))
{
PhongBUS.CapNhatTinhTrangPhong(dp.MaPhong, 1);
}
}
DatPhongBUS.CapNhatTinhTrangDatPhong(3, chiTietDatPhong.MaDatPhong);
(Parent.Parent.Parent as ThongTinChiTietDatNhieuPhong).RefreshData();
break;
}
//Hủy phòng
if (PhongBUS.LayThongTinPhong(chiTietDatPhong.MaPhong).MaTinhTrangPhong == 4 && tempSapDat_1.ContainsKey(chiTietDatPhong.MaDatPhong))
{
PhongBUS.CapNhatTinhTrangPhong(chiTietDatPhong.MaPhong, 0);
}
else if (PhongBUS.LayThongTinPhong(chiTietDatPhong.MaPhong).MaTinhTrangPhong == 6 && tempSapDat_1.ContainsKey(chiTietDatPhong.MaDatPhong))
{
PhongBUS.CapNhatTinhTrangPhong(chiTietDatPhong.MaPhong, 5);
}
else if (PhongBUS.LayThongTinPhong(chiTietDatPhong.MaPhong).MaTinhTrangPhong == 7 && tempSapDat_1.ContainsKey(chiTietDatPhong.MaDatPhong))
{
PhongBUS.CapNhatTinhTrangPhong(chiTietDatPhong.MaPhong, 1);
}
DatPhongBUS.XoaCacDichVuDatPhong(chiTietDatPhong);
DatPhongBUS.XoaDatChiTietDatPhong(chiTietDatPhong);
//if (DatPhongBUS.DemSoLuongChiTietDatPhong(chiTietDatPhong.MaDatPhong) == 0)
//{
// DatPhongBUS.XoaDatPhong(chiTietDatPhong.MaDatPhong);
//}
XtraMessageBox.Show("Xóa đặt phòng thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
(Parent.Parent.Parent as ThongTinChiTietDatNhieuPhong).RefreshData();
//ThuePhongBUS.XoaThuePhong(thuePhong);
//PhongBUS.CapNhatTinhTrangPhong(thuePhong.MaPhong, 0);
//if (HoaDonBUS.DemSoLuongThuePhong(hoaDon.MaHoaDon) == 0)
//{
// HoaDonBUS.XoaHoaDon(hoaDon);
//}
//((ThongTinChiTietNhieuPhong)Parent.Parent.Parent).OnXoaPhong();
break;
case "Hủy Đặt Phòng":
//Thông báo xác nhận
if (XtraMessageBox.Show("Bạn có chắc hủy đặt phòng này ?", "Xác nhận", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
//BUS.PhongBUS.CapNhatTinhTrangPhong(chiTiet.MaPhong, 0);
Dictionary <int, DatPhongDTO> tempSapDat = BUS.DatPhongBUS.LayCacDatPhongDangSapDuocDatVaDangDuocDat(ThamSoBUS.LayKhoangThoiGianChoDatPhong());
foreach (ChiTietDatPhongDTO dp in DatPhongBUS.LayTatCaCacChiTietDatPhong(chiTietDatPhong.MaDatPhong))
{
if (PhongBUS.LayThongTinPhong(dp.MaPhong).MaTinhTrangPhong == 4 && tempSapDat.ContainsKey(dp.MaDatPhong))
{
PhongBUS.CapNhatTinhTrangPhong(dp.MaPhong, 0);
}
else if (PhongBUS.LayThongTinPhong(dp.MaPhong).MaTinhTrangPhong == 6 && tempSapDat.ContainsKey(dp.MaDatPhong))
{
PhongBUS.CapNhatTinhTrangPhong(dp.MaPhong, 5);
}
else if (PhongBUS.LayThongTinPhong(dp.MaPhong).MaTinhTrangPhong == 7 && tempSapDat.ContainsKey(dp.MaDatPhong))
{
PhongBUS.CapNhatTinhTrangPhong(dp.MaPhong, 1);
}
}
DatPhongBUS.CapNhatTinhTrangDatPhong(3, chiTietDatPhong.MaDatPhong);
(Parent.Parent.Parent as ThongTinChiTietDatNhieuPhong).RefreshData();
break;
case "In phiếu đặt":
{
(Parent.Parent.Parent as ThongTinChiTietDatNhieuPhong).InPhieuDat();
break;
}
}
}
