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