public List <PhongDTO> TraCuu(int x, int y)
{
PhongDAO a = new PhongDAO();
return(a.TraCuu(x, y));
}
/// <summary>
/// Load thông tin sinh viên theo mã số phòng
/// </summary>
/// <param name="maphong"></param>
/// <returns></returns>
public static DataTable LoadSinhVien(string maphong)
{
return(PhongDAO.LoadSinhVien(maphong));
}
public DataTable SelectAllPhong()
{
PhongDAO dao = new PhongDAO();
return(dao.SelectAllPhong());
}
public PhongBUS()
{
phongDAO = new PhongDAO();
}
/// <summary>
/// Load thông tin sinh viên theo phòng
/// </summary>
/// <returns></returns>
public static DataTable LoadSinhVien()
{
return(PhongDAO.LoadSinhVien());
}
public PhongKhamBUS()
{
phongKhamService = new PhongDAO();
}
public List <PhongDTO> getDanhSachPhong(int iPage, int numberItem)
{
PhongDAO dao = new PhongDAO();
return(dao.getDanhSachPhong(iPage, numberItem));
}
public int CapNhat(PhongDTO phong)
{
PhongDAO CapNhat = new PhongDAO();
return(CapNhat.CapNhatPhong(phong));
}
public int add_PhongBUS(PhongDTO phongdto)
{
PhongDAO phongdao = new PhongDAO();
return(phongdao.insert_PhongnDAO(phongdto));
}
public bool ThemPhongChieu(PhongDTO phong)
{
PhongDAO pDAO = new PhongDAO();
return(pDAO.ThemPhong(phong));
}
public int Xoa(int MaPhong)
{
PhongDAO XoaDAO = new PhongDAO();
return(XoaDAO.XoaPhong(MaPhong));
}
public List <PhongDTO> LoadPhong(int MaPhim)
{
PhongDAO phong = new PhongDAO();
return(phong.LoadDSPhong(MaPhim));
}
public List <PhongDTO> LoadPhong()
{
PhongDAO phong = new PhongDAO();
return(phong.LoadDSPhong());
}
public SinhVienBUS(SinhVienDAO sv, PhongDAO p)
{
_sv = sv;
_p = p;
}
public static PhongDTO LayPhongTheoTenPhong(String tenphong)
{
return(PhongDAO.LayPhongTheoTenPhong(tenphong));
}
public int update_phongBUS(PhongDTO phongdto)
{
PhongDAO phongdao = new PhongDAO();
return(phongdao.update_PhongDAO(phongdto));
}
public static Boolean CapNhatTinhTrangPhongTheoMaPhong(String maphong)
{
return(PhongDAO.CapNhatTinhTrangPhongTheoMaPhong(maphong));
}
public int delete_PhongBUS(PhongDTO phongdto)
{
PhongDAO phongdao = new PhongDAO();
return(phongdao.delete_PhongDAO(phongdto));
}
public int getTongSoRecord()
{
PhongDAO dao = new PhongDAO();
return(dao.getTongSoRecord());
}
private void Button_Click(object sender, RoutedEventArgs e)
{
var button = (Button)sender;
ContextMenu cm = this.FindResource("cmButton") as ContextMenu;
cm.PlacementTarget = sender as Button;
cm.IsOpen = true;
MenuItem thuephong = LogicalTreeHelper.FindLogicalNode(cm, "thuephong") as MenuItem;
MenuItem thongtinkhach = LogicalTreeHelper.FindLogicalNode(cm, "thongtinkhach") as MenuItem;
MenuItem capnhatdichvu = LogicalTreeHelper.FindLogicalNode(cm, "capnhatdichvu") as MenuItem;
MenuItem doiphong = LogicalTreeHelper.FindLogicalNode(cm, "doiphong") as MenuItem;
MenuItem khachrangoai = LogicalTreeHelper.FindLogicalNode(cm, "khachrangoai") as MenuItem;
MenuItem datphong = LogicalTreeHelper.FindLogicalNode(cm, "datphong") as MenuItem;
MenuItem chitietdatphong = LogicalTreeHelper.FindLogicalNode(cm, "chitietdatphong") as MenuItem;
MenuItem donphong = LogicalTreeHelper.FindLogicalNode(cm, "donphong") as MenuItem;
MenuItem suaphong = LogicalTreeHelper.FindLogicalNode(cm, "suaphong") as MenuItem;
int maPhong = Int32.Parse(button.Name.Substring(1));
int tinhTrang = PhongDAO.GetTinhTrangPhong(maPhong);
int trangThai = PhongDAO.GetTrangThaiPhong(maPhong);
if (trangThai == 3 || trangThai == 4)
{
thuephong.IsEnabled = false;
thuephong.Header = "Khách thuê phòng";
thongtinkhach.IsEnabled = false;
capnhatdichvu.IsEnabled = false;
doiphong.IsEnabled = false;
khachrangoai.IsEnabled = false;
khachrangoai.Header = "Khách ra ngoài";
datphong.IsEnabled = false;
datphong.Header = "Đặt phòng";
chitietdatphong.IsEnabled = false;
if (trangThai == 3)
{
suaphong.IsEnabled = false;
donphong.Header = "Kết thúc dọn phòng";
suaphong.Header = "Sửa phòng";
donphong.IsEnabled = true;
}
else
{
donphong.IsEnabled = false;
suaphong.IsEnabled = true;
donphong.Header = "Dọn phòng";
suaphong.Header = "Kết thúc sửa phòng";
}
return;
}
if (tinhTrang == 1)
{
thuephong.IsEnabled = true;
thuephong.Header = "Khách thuê phòng";
thongtinkhach.IsEnabled = false;
capnhatdichvu.IsEnabled = false;
doiphong.IsEnabled = false;
khachrangoai.IsEnabled = false;
khachrangoai.Header = "Khách ra ngoài";
datphong.IsEnabled = true;
chitietdatphong.IsEnabled = false;
donphong.IsEnabled = true;
suaphong.IsEnabled = true;
datphong.Header = "Đặt phòng";
donphong.Header = "Dọn phòng";
suaphong.Header = "Sửa phòng";
return;
}
if (tinhTrang == 4)
{
thuephong.IsEnabled = true;
thuephong.Header = "Khách thuê phòng";
thongtinkhach.IsEnabled = false;
capnhatdichvu.IsEnabled = false;
doiphong.IsEnabled = false;
khachrangoai.IsEnabled = false;
khachrangoai.Header = "Khách ra ngoài";
datphong.IsEnabled = true;
datphong.Header = "Hủy đặt phòng";
chitietdatphong.IsEnabled = true;
donphong.IsEnabled = true;
suaphong.IsEnabled = true;
donphong.Header = "Dọn phòng";
suaphong.Header = "Sửa phòng";
return;
}
if (tinhTrang == 2 && trangThai == 1)
{
thuephong.IsEnabled = true;
thuephong.Header = "Trả phòng";
thongtinkhach.IsEnabled = true;
capnhatdichvu.IsEnabled = true;
doiphong.IsEnabled = true;
khachrangoai.IsEnabled = true;
khachrangoai.Header = "Khách ra ngoài";
datphong.IsEnabled = false;
chitietdatphong.IsEnabled = false;
donphong.IsEnabled = false;
suaphong.IsEnabled = false;
datphong.Header = "Đặt phòng";
donphong.Header = "Dọn phòng";
suaphong.Header = "Sửa phòng";
return;
}
if (trangThai == 2)
{
thuephong.IsEnabled = false;
thuephong.Header = "Trả phòng";
thongtinkhach.IsEnabled = true;
capnhatdichvu.IsEnabled = false;
doiphong.IsEnabled = false;
khachrangoai.IsEnabled = true;
khachrangoai.Header = "Khách quay lại";
datphong.IsEnabled = false;
chitietdatphong.IsEnabled = false;
donphong.IsEnabled = true;
suaphong.IsEnabled = false;
datphong.Header = "Đặt phòng";
donphong.Header = "Dọn phòng";
suaphong.Header = "Sửa phòng";
return;
}
}
public List <PhongDTO> TimKiemPhong(double Giatu, double Giaden, int MaPhong, bool KhuyenMai, bool DaDuocDat)
{
PhongDAO dao = new PhongDAO();
return(dao.TimKiemPhong(Giatu, Giaden, MaPhong, KhuyenMai, DaDuocDat));
}
public static bool ThemPhong(PhongDTO lp)
{
return(PhongDAO.ThemPhong(lp));
}
public SinhVienBUS(SinhVienDAO sv, PhongDAO p, HopDongDAO hd)
{
_hd = hd;
_sv = sv;
_p = p;
}
public static bool SuaPhong(PhongDTO lp)
{
return(PhongDAO.SuaPhong(lp));
}
/// <summary>
/// Load thông tin phòng trong cơ sở dữ liệu
/// </summary>
/// <returns></returns>
public static DataTable LoadPhong()
{
return(PhongDAO.LoadPhong());
}
public static int KiemTraSua(PhongDTO lp)
{
return(PhongDAO.KiemTraSua(lp));
}
/// <summary>
/// Kiểm tra một phòng trống hay không
/// </summary>
/// <param name="IDPhong"></param>
/// <returns></returns>
public static bool KiemTraPhong(string IDPhong)
{
return(PhongDAO.KiemTraPhong(IDPhong));
}
public static PhongDTO LayPhongTheoMaPhong(String mph)
{
return(PhongDAO.LayPhongTheoMaPhong(mph));
}
public DataTable SortByPhongChuaThue()
{
PhongDAO dao = new PhongDAO();
return(dao.SortByPhongChuaThue());
}
public bool CapNhatPhong(PhongDTO phong)
{
PhongDAO a = new PhongDAO();
return(a.CapNhatPhong(phong));
}
