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); } }