public List <KhuCanHo> LayToanBoKhuCanHo()
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
List <KhuCanHo> lstKCH = context.KhuCanHos.ToList();
foreach (KhuCanHo kch in lstKCH)
{
kch.CanHos.Clear();
}
return(lstKCH);
}
public KhuCanHo ChiTietKCH(int id)
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
KhuCanHo kch = context.KhuCanHos.FirstOrDefault(x => x.MaKhu == id);
if (kch != null)
{
kch.CanHos.Clear();
}
return(kch);
}
public CuDan ChiTietCuDan(string id)
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
CuDan cd = context.CuDans.FirstOrDefault(x => x.MaCuDan == id);
if (cd != null)
{
cd.CanHos = null;
cd.HopDongs = null;
}
return(cd);
}
public CuDan TimCuDanTheoSoCMT(string soCMT)
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
CuDan cd = context.CuDans.FirstOrDefault(x => x.SoCMT == soCMT);
if (cd != null)
{
cd.CanHos = null;
cd.HopDongs = null;
}
return(cd);
}
public List <CuDan> LayToanBoCuDan()
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
List <CuDan> lstCuDan = context.CuDans.ToList();
foreach (CuDan cd in lstCuDan)
{
cd.CanHos.Clear();
cd.HopDongs.Clear();
}
return(lstCuDan);
}
public bool LuuCanHo(CanHoModel chm)
{
try
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
CanHo ch = new CanHo {
MaCanHo = chm.MaCanHo, DienTich = chm.DienTich, Gia = chm.Gia, TrangThai = chm.TrangThai, SoPhong = chm.SoPhong, MaCuDan = chm.MaCuDan, MaKhu = chm.MaKhu
};
context.CanHos.InsertOnSubmit(ch);
context.SubmitChanges();
return(true);
}
catch { }
return(false);
}
public List <CanHo> DanhSachCanHoTheoCuDan(string maCD)
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
List <CanHo> lstch = context.CanHos
.Where(x => x.MaCuDan == maCD)
.ToList();
foreach (CanHo ch in lstch)
{
ch.HopDongs.Clear();
ch.KhuCanHo = null;
ch.CuDan = null;
}
return(lstch);
}
public bool LuuCuDan(CuDanModel cdm)
{
try
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
CuDan cd = new CuDan {
MaCuDan = cdm.MaCuDan, TenCuDan = cdm.TenCuDan, GioiTinh = cdm.GioiTinh, NgaySinh = cdm.NgaySinh, SoDT = cdm.SoDT, SoCMT = cdm.SoCMT, QueQuan = cdm.QueQuan
};
context.CuDans.InsertOnSubmit(cd);
context.SubmitChanges();
return(true);
}
catch { }
return(false);
}
public bool LuuKCH(KhuCanHoModel cdm)
{
try
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
KhuCanHo kch = new KhuCanHo {
TenKhu = cdm.TenKhu, SoTang = cdm.SoTang, SoCanHo = cdm.SoCanHo, DiaChi = cdm.DiaChi
};
context.KhuCanHos.InsertOnSubmit(kch);
context.SubmitChanges();
return(true);
}
catch { }
return(false);
}
public bool XoaCuDan(string macd)
{
try
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
CuDan cd = context.CuDans.FirstOrDefault(x => x.MaCuDan == macd);
if (cd != null)
{
context.CuDans.DeleteOnSubmit(cd);
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
public bool XoaCanHo(string mach)
{
try
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
CanHo ch = context.CanHos.FirstOrDefault(x => x.MaCanHo == mach);
if (ch != null)
{
context.CanHos.DeleteOnSubmit(ch);
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
public bool XoaKCH(int maKCH)
{
try
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
KhuCanHo kch = context.KhuCanHos.FirstOrDefault(x => x.MaKhu == maKCH);
if (kch != null)
{
context.KhuCanHos.DeleteOnSubmit(kch);
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
public CanHoModel ChiTietCanHo(string id)
{
CanHoModel chm = new CanHoModel();
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
CanHo ch = context.CanHos.FirstOrDefault(x => x.MaCanHo == id);
if (ch != null)
{
chm.MaCanHo = ch.MaCanHo;
chm.DienTich = ch.DienTich;
chm.Gia = ch.Gia;
chm.TrangThai = ch.TrangThai;
chm.SoPhong = ch.SoPhong;
chm.MaCuDan = ch.MaCuDan;
chm.MaKhu = ch.MaKhu;
}
return(chm);
}
public bool SuaKCH(KhuCanHoModel cdm)
{
try
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
KhuCanHo kch = context.KhuCanHos.FirstOrDefault(x => x.MaKhu == cdm.MaKhu);
if (kch != null)
{
kch.TenKhu = cdm.TenKhu;
kch.SoTang = cdm.SoTang;
kch.SoCanHo = cdm.SoCanHo;
kch.DiaChi = cdm.DiaChi;
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
public bool SuaCuDan(CuDanModel cdm)
{
try
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
CuDan cd = context.CuDans.FirstOrDefault(x => x.MaCuDan == cdm.MaCuDan);
if (cd != null)
{
cd.TenCuDan = cdm.TenCuDan;
cd.GioiTinh = cdm.GioiTinh;
cd.NgaySinh = cdm.NgaySinh;
cd.SoDT = cdm.SoDT;
cd.SoCMT = cdm.SoCMT;
cd.QueQuan = cdm.QueQuan;
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
public bool SuaCanHo(CanHoModel chm)
{
try
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
CanHo ch = context.CanHos.FirstOrDefault(x => x.MaCanHo == chm.MaCanHo);
if (ch != null)
{
ch.DienTich = chm.DienTich;
ch.Gia = chm.Gia;
ch.TrangThai = chm.TrangThai;
ch.SoPhong = chm.SoPhong;
ch.MaCuDan = chm.MaCuDan;
ch.MaKhu = chm.MaKhu;
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
public List <CanHoModel> LayToanBoCanHo()
{
List <CanHoModel> lstchm = new List <CanHoModel>();
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
List <CanHo> lstCanHo = context.CanHos.ToList();
foreach (CanHo ch in lstCanHo)
{
CanHoModel canho = new CanHoModel()
{
MaCanHo = ch.MaCanHo,
DienTich = ch.DienTich,
Gia = ch.Gia,
TrangThai = ch.TrangThai,
SoPhong = ch.SoPhong,
MaCuDan = ch.MaCuDan,
MaKhu = ch.MaKhu
};
lstchm.Add(canho);
}
return(lstchm);
}