public void XoaChuphong(int MaChu)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.ChuPhong_Xoa(MaChu);
pt.SubmitChanges();
}
}
public void SuaPhong(DTOPhong dtoP)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.Phong_Sua(dtoP.maphong, dtoP.maloaiphong, dtoP.tenphong.ToUpper(), dtoP.status, dtoP.tinhtrangphong);
pt.SubmitChanges();
}
}
public void XoaCuocPhi(int MaCuoc)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.CuocPhi_Xoa(MaCuoc);
pt.SubmitChanges();
}
}
public void XoaHopDong(Int64 mahopdong)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.HopDong_Xoa(mahopdong);
pt.SubmitChanges();
}
}
public void XoaThuePhong(DTOThuePhong dtoTP)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.ThuePhong_Xoa(dtoTP.maphong, dtoTP.makhach, dtoTP.mahopdong);
pt.SubmitChanges();
}
}
public void SuaCuocPhi(DTOCuocPhi dtoCuoc)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.CuocPhi_Sua(dtoCuoc.macuocphi, dtoCuoc.tencuocphi, dtoCuoc.giacuocphi, dtoCuoc.thongtin);
pt.SubmitChanges();
}
}
public void XoaKhach(Int64 MaKhach)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.Khach_Xoa(MaKhach);
pt.SubmitChanges();
}
}
public void SuaLoaiPhong(DTOLoaiPhong dtoLP)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.LoaiPhong_Sua(dtoLP.maloaiphong, dtoLP.machuphong, dtoLP.tenloaiphong.ToUpper(), dtoLP.giathue, dtoLP.sokhach, dtoLP.thongtin, dtoLP.diachi);
pt.SubmitChanges();
}
}
public void SuaChuPhong(DTOChuPhong dtoCP)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.ChuPhong_Sua(dtoCP.machuphong, dtoCP.tenchuphong.ToUpper(), dtoCP.gioitinh, dtoCP.sodinhdanh, dtoCP.sodienthoai, dtoCP.diachi);
pt.SubmitChanges();
}
}
public void XoaPhong(int MaPhong)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.Phong_Xoa(MaPhong);
pt.SubmitChanges();
}
}
public void SuaNguoiDung(DTONguoiDung dtoND)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.NguoiDung_Sua(dtoND.manguoidung, dtoND.tendangnhap, dtoND.madangnhap, dtoND.admin, dtoND.status);
pt.SubmitChanges();
}
}
public void XoaChiSoThang(DTOChiSoThang dtoCST)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.ChiSoThang_Xoa(dtoCST.maphong, dtoCST.ngaycapnhat);
pt.SubmitChanges();
}
}
public void SuaChiSoThang(DTOChiSoThang dtoCST)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.ChiSoThang_Sua(dtoCST.maphong, dtoCST.ngaycapnhat, dtoCST.chisodien, dtoCST.chisonuoc);
pt.SubmitChanges();
}
}
public void XoaChiuCuocPhi(DTOChiuCuocPhi dtoCCP)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.ChiuCuocPhi_Xoa(dtoCCP.mahopdong, dtoCCP.macuocphi);
pt.SubmitChanges();
}
}
public void ThemChiuCuocPhi(DTOChiuCuocPhi dtoCCP)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.ChiuCuocPhi_Them(dtoCCP.mahopdong, dtoCCP.macuocphi, dtoCCP.soluong);
pt.SubmitChanges();
}
}
public void SuaKhach(DTOKhach dtoK)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.Khach_Sua(dtoK.makhach, dtoK.tenkhach.ToUpper(), dtoK.ngaysinh, dtoK.gioitinh, dtoK.sodinhdanh,
dtoK.sodienthoai, dtoK.diachi, dtoK.hinh, dtoK.tinhtranghonnhan, dtoK.dangkytamtru);
pt.SubmitChanges();
}
}
/// <summary>
/// Tìm kiếm rút gọn.
/// </summary>
/// <param name="searchby">0:tenchuphong-1:tenloaiphong-2:tenphong-3:All</param>
/// <param name="timkiem"></param>
/// <returns></returns>
public List <DTOPhong> SearchP_LP_CP(int SearchBy, string TuTim)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
List <Phong> liP = new List <Phong>();
switch (SearchBy)
{
case 0:
liP = (from p in pt.Phongs
join lp in pt.LoaiPhongs on p.MaLoaiPhong equals lp.MaLoaiPhong
join cp in pt.ChuPhongs on lp.MaChuPhong equals cp.MaChuPhong
where (cp.TenChuPhong.Contains(TuTim))
select p).ToList();
break;
case 1:
liP = (from p in pt.Phongs
join lp in pt.LoaiPhongs on p.MaLoaiPhong equals lp.MaLoaiPhong
join cp in pt.ChuPhongs on lp.MaChuPhong equals cp.MaChuPhong
where (lp.TenLoaiPhong.Contains(TuTim))
select p).ToList();
break;
case 2:
liP = (from p in pt.Phongs
join lp in pt.LoaiPhongs on p.MaLoaiPhong equals lp.MaLoaiPhong
join cp in pt.ChuPhongs on lp.MaChuPhong equals cp.MaChuPhong
where (p.TenPhong.Contains(TuTim))
select p).ToList();
break;
default:
liP = (from p in pt.Phongs
join lp in pt.LoaiPhongs on p.MaLoaiPhong equals lp.MaLoaiPhong
join cp in pt.ChuPhongs on lp.MaChuPhong equals cp.MaChuPhong
select p).ToList();
break;
}
List <DTOPhong> liDtoP = new List <DTOPhong>();
foreach (Phong p in liP)
{
DTOPhong dtoP = new DTOPhong();
dtoP.maphong = p.MaPhong;
dtoP.maloaiphong = p.MaLoaiPhong;
dtoP.tenphong = p.TenPhong;
dtoP.status = p.Status;
dtoP.tinhtrangphong = p.TinhTrangPhong;
liDtoP.Add(dtoP);
}
return(liDtoP);
}
}
public void ThemHopDong(DTOHopDong dtoHD)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
pt.HopDong_Them(dtoHD.ngaythue, dtoHD.ngaytra, dtoHD.ngaylamhopdong, dtoHD.tiencoc, dtoHD.giathue, dtoHD.chisodien, dtoHD.chisonuoc, dtoHD.ghichu);
pt.SubmitChanges();
}
BAL_ThuePhong balTP = new BAL_ThuePhong();
BAL_Khach balK = new BAL_Khach();
foreach (Int64 makhach in balTP.DanhSachMaKhachTheoMaHopDong(dtoHD.mahopdong))
{
balK.CapNhatStatusTungKhach(makhach);
}
}
public List <DTOThuePhong> GetAll()
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
List <DTOThuePhong> liDtoTP = new List <DTOThuePhong>();
foreach (ThuePhong tp in pt.ThuePhongs)
{
DTOThuePhong dtoTP = new DTOThuePhong();
dtoTP.maphong = tp.MaPhong;
dtoTP.makhach = tp.MaKhach;
dtoTP.mahopdong = tp.MaHopDong;
dtoTP.chuphong = tp.ChuPhong;
liDtoTP.Add(dtoTP);
}
return(liDtoTP);
}
}
public List <DTOChiuCuocPhi> GetAll()
{
List <DTOChiuCuocPhi> liDtoCCP = new List <DTOChiuCuocPhi>();
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
foreach (ChiuCuocPhi ccp in pt.ChiuCuocPhis)
{
DTOChiuCuocPhi dtoCCP = new DTOChiuCuocPhi();
dtoCCP.mahopdong = ccp.MaHopDong;
dtoCCP.macuocphi = ccp.MaCuocPhi;
dtoCCP.soluong = ccp.SoLuong;
liDtoCCP.Add(dtoCCP);
}
}
return(liDtoCCP);
}
public List <DTOCuocPhi> GetAll()
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
List <DTOCuocPhi> liDtoCuoc = new List <DTOCuocPhi>();
foreach (CuocPhi cuoc in pt.CuocPhis.ToList())
{
DTOCuocPhi dtoCuoc = new DTOCuocPhi();
dtoCuoc.macuocphi = cuoc.MaCuocPhi;
dtoCuoc.tencuocphi = cuoc.TenCuocPhi;
dtoCuoc.giacuocphi = Convert.ToDecimal(cuoc.GiaCuocPhi);
dtoCuoc.thongtin = cuoc.ThongTin;
liDtoCuoc.Add(dtoCuoc);
}
return(liDtoCuoc);
}
}
public List <DTOChiSoThang> GetAll()
{
List <DTOChiSoThang> liDtoCST = new List <DTOChiSoThang>();
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
foreach (ChiSoThang cst in pt.ChiSoThangs.ToList())
{
DTOChiSoThang dtoCST = new DTOChiSoThang();
dtoCST.maphong = cst.MaPhong;
dtoCST.ngaycapnhat = cst.NgayCapNhat;
dtoCST.chisodien = cst.ChiSoDien;
dtoCST.chisonuoc = cst.ChiSoNuoc;
liDtoCST.Add(dtoCST);
}
}
return(liDtoCST);
}
public List <DTONguoiDung> GetAll()
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
List <DTONguoiDung> liDtoND = new List <DTONguoiDung>();
foreach (NguoiDung nd in pt.NguoiDungs.ToList())
{
DTONguoiDung dtoND = new DTONguoiDung();
dtoND.manguoidung = nd.MaNguoiDung;
dtoND.tendangnhap = nd.TenDangNhap;
dtoND.madangnhap = nd.MaDangNhap;
dtoND.admin = nd.Admin;
dtoND.status = nd.Status;
liDtoND.Add(dtoND);
}
return(liDtoND);
}
}
public List <DTOPhong> GetAll()
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
List <DTOPhong> liP = new List <DTOPhong>();
foreach (Phong p in pt.Phongs.ToList())
{
DTOPhong dtoP = new DTOPhong();
dtoP.maphong = p.MaPhong;
dtoP.maloaiphong = p.MaLoaiPhong;
dtoP.tenphong = p.TenPhong;
dtoP.status = p.Status;
dtoP.tinhtrangphong = p.TinhTrangPhong;
liP.Add(dtoP);
}
return(liP);
}
}
public void CapNhatStatusTungKhach(Int64 MaKhach)
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
bool TrangThai = false;
Khach k = pt.Khaches.Where(kh => kh.MaKhach == MaKhach).FirstOrDefault();
List <Int64> liMaHD = pt.ThuePhongs.Where(t => t.MaKhach == MaKhach).Select(t => t.MaHopDong).ToList();
foreach (Int64 MaHopDong in liMaHD)
{
HopDong hd = pt.HopDongs.Where(h => h.MaHopDong == MaHopDong).FirstOrDefault();
if (hd.Status)
{
TrangThai = true;
}
}
k.Status = TrangThai;
pt.SubmitChanges();
}
}
public List <DTOChuPhong> GetAll()
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
List <DTOChuPhong> liDtoCP = new List <DTOChuPhong>();
foreach (ChuPhong cp in pt.ChuPhongs.ToList())
{
DTOChuPhong dtoCP = new DTOChuPhong();
dtoCP.machuphong = cp.MaChuPhong;
dtoCP.tenchuphong = cp.TenChuPhong;
dtoCP.gioitinh = cp.GioiTinh;
dtoCP.sodinhdanh = cp.SoDinhDanh;
dtoCP.sodienthoai = cp.SoDienThoai;
dtoCP.diachi = cp.DiaChi;
liDtoCP.Add(dtoCP);
}
return(liDtoCP);
}
}
public void CapNhatStatus()
{
BAL_ThuePhong balTP = new BAL_ThuePhong();
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
foreach (HopDong hd in pt.HopDongs.Where(h => h.NgayThue.Date < DateTime.Now.Date).ToList())
{
if (hd.NgayTra == null || DateTime.Now.Date < Convert.ToDateTime(hd.NgayTra).Date)
{
hd.Status = true;
int maphong = balTP.MaPhongTuMaHopDong(hd.MaHopDong);
Phong ph = pt.Phongs.Where(p => p.MaPhong == maphong).SingleOrDefault();
ph.Status = true;
pt.SubmitChanges();
}
}
}
}
public List <DTOLoaiPhong> GetAll()
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
List <DTOLoaiPhong> liLP = new List <DTOLoaiPhong>();
foreach (LoaiPhong lp in pt.LoaiPhongs.ToList())
{
DTOLoaiPhong dtoLP = new DTOLoaiPhong();
dtoLP.maloaiphong = lp.MaLoaiPhong;
dtoLP.machuphong = lp.MaChuPhong;
dtoLP.tenloaiphong = lp.TenLoaiPhong;
dtoLP.giathue = Convert.ToDecimal(lp.GiaThue);
dtoLP.sokhach = Convert.ToInt32(lp.SoKhach);
dtoLP.thongtin = lp.ThongTin;
dtoLP.diachi = lp.DiaChi;
liLP.Add(dtoLP);
}
return(liLP);
}
}
public List <DTOHopDong> GetAll()
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
List <DTOHopDong> liDtoHD = new List <DTOHopDong>();
foreach (HopDong hd in pt.HopDongs)
{
DTOHopDong dtoHD = new DTOHopDong();
dtoHD.mahopdong = hd.MaHopDong;
dtoHD.ngaythue = hd.NgayThue;
dtoHD.ngaytra = hd.NgayTra;
dtoHD.ngaylamhopdong = hd.NgayLamHopDong;
dtoHD.tiencoc = hd.TienCoc;
dtoHD.giathue = hd.GiaThue;
dtoHD.chisodien = hd.ChiSoDien;
dtoHD.chisonuoc = hd.ChiSoNuoc;
dtoHD.ghichu = hd.GhiChu;
dtoHD.status = hd.Status;
liDtoHD.Add(dtoHD);
}
return(liDtoHD);
}
}
public List <DTOKhach> GetAll()
{
using (PhongTroDBDataContext pt = new PhongTroDBDataContext())
{
List <DTOKhach> liDtoK = new List <DTOKhach>();
foreach (Khach k in pt.Khaches.ToList())
{
DTOKhach dtoK = new DTOKhach();
dtoK.makhach = k.MaKhach;
dtoK.tenkhach = k.TenKhach;
dtoK.ngaysinh = k.NgaySinh;
dtoK.gioitinh = k.GioiTinh;
dtoK.sodinhdanh = k.SoDinhDanh;
dtoK.sodienthoai = k.SoDienThoai;
dtoK.diachi = k.DiaChi;
dtoK.hinh = k.Hinh;
dtoK.tinhtranghonnhan = k.TinhTrangHonNhan;
dtoK.dangkytamtru = k.DangKyTamTru;
dtoK.status = k.Status;
liDtoK.Add(dtoK);
}
return(liDtoK);
}
}
