public List <uspDanhSachPhongTroResult> DSPT()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <uspDanhSachPhongTroResult> dspt = context.uspDanhSachPhongTro().ToList();
return(dspt);
}
public List <uspPTKVPResult> PTKVP()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <uspPTKVPResult> dsPTKVP = context.uspPTKVP().ToList();
return(dsPTKVP);
}
public List <uspChiTietPhongTroResult> DanhSachPhongTroVaSoNguoiHienCo()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <uspChiTietPhongTroResult> dsctpt = context.uspChiTietPhongTro().ToList();
return(dsctpt);
}
public List <usp_Search_KHResult> SearchKH(String tenKH)
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <usp_Search_KHResult> dsKH = context.usp_Search_KH(tenKH).ToList();
return(dsKH);
}
public List <usp_KH_HD_PResult> KHP(String tenKH)
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <usp_KH_HD_PResult> dsKHP = context.usp_KH_HD_P(tenKH).ToList();
return(dsKHP);
}
public List <uspPhongTroListResult> KVP()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <uspPhongTroListResult> dsphongtro = context.uspPhongTroList().ToList();
return(dsphongtro);
}
public List <uspDSDKDVResult> DSDKDVR()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <uspDSDKDVResult> dsdkdv = context.uspDSDKDV().ToList();
return(dsdkdv);
}
public List <uspHoaDonDichVuResult> DSHDDV()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <uspHoaDonDichVuResult> dshddv = context.uspHoaDonDichVu().ToList();
return(dshddv);
}
public List <uspHoaDonPhongTroResult> HoaDonPhongTro()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <uspHoaDonPhongTroResult> hdpt = context.uspHoaDonPhongTro().ToList();
return(hdpt);
}
public List <uspHoaDonPhongTroChuaThanhToanResult> HoaDonPhongTroChuaThanhToan()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <uspHoaDonPhongTroChuaThanhToanResult> hdptctt = context.uspHoaDonPhongTroChuaThanhToan().ToList();
return(hdptctt);
}
public List <uspSoNguoiHienCoResult> SoNguoiHienCo()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <uspSoNguoiHienCoResult> snhc = context.uspSoNguoiHienCo().ToList();
return(snhc);
}
public List <uspDangNhapUserResult> DangNhapUser(String email, String pws)
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <uspDangNhapUserResult> dn = context.uspDangNhapUser(email, pws).ToList();
return(dn);
}
public List <QuyDinh> DanhSachQuyDinh()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <QuyDinh> dsquydinh = context.QuyDinhs.ToList();
return(dsquydinh);
}
public List <uspHopDongResult> ChiTietDanhSachHopDong()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <uspHopDongResult> dshd = context.uspHopDong().ToList();
return(dshd);
}
public List <uspThietBiPhongKhuVucResult> DanhSachThietBiPhong()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <uspThietBiPhongKhuVucResult> dstbp = context.uspThietBiPhongKhuVuc().ToList();
return(dstbp);
}
public List <uspSpDangKyDichVuResult> SpinnerDangKyDichVu()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <uspSpDangKyDichVuResult> spdkdv = context.uspSpDangKyDichVu().ToList();
return(spdkdv);
}
public List <uspHoaDonDichVuChuaThanhToanResult> DanhSachHoaDonDichVuChuaThanhToan()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <uspHoaDonDichVuChuaThanhToanResult> dshddvctt = context.uspHoaDonDichVuChuaThanhToan().ToList();
return(dshddvctt);
}
public List <KhachHang> DanhSachKhachHang()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <KhachHang> dskh = context.KhachHangs.ToList();
foreach (KhachHang kh in dskh)
{
kh.HopDongs.Clear();
}
return(dskh);
}
public List <ThietBi> DanhSachThietBi()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <ThietBi> dstb = context.ThietBis.ToList();
foreach (ThietBi tb in dstb)
{
tb.PhongTro = null;
}
return(dstb);
}
public List <HoaDonPhongTro> ToanBoHoaDonPhongTro()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <HoaDonPhongTro> dshdpt = context.HoaDonPhongTros.ToList();
foreach (HoaDonPhongTro hdpt in dshdpt)
{
hdpt.HopDong = null;
}
return(dshdpt);
}
public List <HoaDonDichVu> HoaDonDichVuDaThanhToan()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <HoaDonDichVu> dshddv = context.HoaDonDichVus.Where(x => x.ThoiGianThanhToan != null).ToList();
foreach (HoaDonDichVu hddv in dshddv)
{
hddv.DangKyDichVu = null;
}
return(dshddv);
}
public List <HoaDonDichVu> DanhSachHoaDonDichVu()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <HoaDonDichVu> dshddv = context.HoaDonDichVus.ToList();
foreach (HoaDonDichVu hddv in dshddv)
{
hddv.DangKyDichVu = null;
}
return(dshddv);
}
public List <DichVu> DanhSachDichVu()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <DichVu> dsdv = context.DichVus.ToList();
foreach (DichVu dv in dsdv)
{
dv.DangKyDichVus.Clear();
}
return(dsdv);
}
public List <DangNhap> DanhSachTaiKhoan()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <DangNhap> dsdn = context.DangNhaps.ToList();
foreach (DangNhap dn in dsdn)
{
dn.ChuNhaTro = null;
}
return(dsdn);
}
public List <KhuVucPhong> DanhSachKhuVuc()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <KhuVucPhong> dskvp = context.KhuVucPhongs.ToList();
foreach (KhuVucPhong kvp in dskvp)
{
kvp.PhongTros.Clear();
}
return(dskvp);
}
public List <ChuNhaTro> DanhSachChuNhaTro()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <ChuNhaTro> dscnt = context.ChuNhaTros.ToList();
foreach (ChuNhaTro cnt in dscnt)
{
cnt.DangNhaps.Clear();
cnt.HopDongs.Clear();
}
return(dscnt);
}
public List <DangKyDichVu> DanhSachDangKy()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <DangKyDichVu> dsdkdv = context.DangKyDichVus.ToList();
foreach (DangKyDichVu dkdv in dsdkdv)
{
dkdv.HoaDonDichVus.Clear();
dkdv.DichVu = null;
dkdv.PhongTro = null;
}
return(dsdkdv);
}
public List <HopDong> DanhSachHopDong()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <HopDong> dshd = context.HopDongs.ToList();
foreach (HopDong hd in dshd)
{
hd.ChuNhaTro = null;
hd.KhachHang = null;
hd.PhongTro = null;
hd.HoaDonPhongTros.Clear();
}
return(dshd);
}
public List <PhongTro> DanhSachPhongTheoKhuVuc(int makhuvuc)
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <PhongTro> dspt = context.PhongTros.Where(x => x.MaKV == makhuvuc).ToList();
foreach (PhongTro pt in dspt)
{
pt.DangKyDichVus.Clear();
pt.HopDongs.Clear();
pt.KhuVucPhong = null;
pt.ThietBis.Clear();
}
return(dspt);
}
public List <PhongTro> DanhSachPhongTro()
{
QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext();
List <PhongTro> dspt = context.PhongTros.ToList();
foreach (PhongTro pt in dspt)
{
pt.DangKyDichVus.Clear();
pt.HopDongs.Clear();
pt.KhuVucPhong = null;
pt.ThietBis.Clear();
}
return(dspt);
}
