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