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