public bool SuaNhaODuBi(string MaNhaO, string LoaiNhaO, string DienTichXayDung, string DienTichSan, string KetCau, string SoTang, string SoHuuChung, string SoHuuRieng, string CoHanChe, string HanChe)
{
try
{
bool _cohanche = false;
if (CoHanChe.ToLower() == "true")
{
_cohanche = true;
}
else
{
_cohanche = false;
}
long _maNhaO = long.Parse(MaNhaO);
tblThongTinNhaODuBi nhaSua = db.tblThongTinNhaODuBis.Single(n => n.MaNhaO == _maNhaO);
nhaSua.LoaiNhaO = LoaiNhaO;
nhaSua.DienTichXayDung = DienTichXayDung;
nhaSua.DienTichSan = DienTichSan;
nhaSua.KetCau = KetCau;
nhaSua.SoTang = SoTang;
nhaSua.SoHuuChung = SoHuuChung;
nhaSua.SoHuuRieng = SoHuuRieng;
nhaSua.CoHanCheThoiHanSoHuu = _cohanche;
nhaSua.ThoiHanSoHuu = HanChe;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
protected void grvNhaO_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
NhapThongTinNhaO_Visible(true);
string _maNhaO = e.CommandArgument.ToString();
Session["ThaoTac"] = ThaoTac.DangSua;
Session["MaNhaO"] = _maNhaO;
using (DMCWebEntities db = new DMCWebEntities())
{
long maNhaO = long.Parse(_maNhaO);
var q = (from n in db.tblThongTinNhaODuBis
where n.MaNhaO == maNhaO
select n).Single();
tblThongTinNhaODuBi nha = (tblThongTinNhaODuBi)q;
lblMaNhaO.Text = nha.MaNhaO.ToString();
drLoaiNhaO.SelectedValue = nha.LoaiNhaO;
txtDienTichXayDung.Text = nha.DienTichXayDung;
txtDienTichSan.Text = nha.DienTichSan;
txtSoHuuChung.Text = nha.SoHuuChung;
txtSoHuuRieng.Text = nha.SoHuuRieng;
txtKetCau.Text = nha.KetCau;
txtHanCheNha.Text = nha.ThoiHanSoHuu;
drHanCheNha.SelectedValue = nha.CoHanCheThoiHanSoHuu.ToString();
txtSoTang.Text = nha.SoTang;
}
}
}
public bool XoaNhaODuBi(string MaNhaO)
{
try
{
long _maNhaO = long.Parse(MaNhaO);
tblThongTinNhaODuBi nhaXoa = db.tblThongTinNhaODuBis.Single(n => n.MaNhaO == _maNhaO);
db.tblThongTinNhaODuBis.Remove(nhaXoa);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool ThemNhaODuBi(string MaHoSo, string LoaiNhaO, string DienTichXayDung, string DienTichSan, string KetCau, string SoTang, string SoHuuChung, string SoHuuRieng, string CoHanChe, string HanChe)
{
try
{
bool _cohanche = false;
if (CoHanChe.ToLower() == "true")
{
_cohanche = true;
}
else
{
_cohanche = false;
}
tblThongTinNhaODuBi nhaNew = new tblThongTinNhaODuBi();
nhaNew.MaHoSoKeKhai = Convert.ToInt32(MaHoSo);
nhaNew.LoaiNhaO = LoaiNhaO;
nhaNew.DienTichXayDung = DienTichXayDung;
nhaNew.DienTichSan = DienTichSan;
nhaNew.KetCau = KetCau;
nhaNew.SoTang = SoTang;
nhaNew.SoHuuChung = SoHuuChung;
nhaNew.SoHuuRieng = SoHuuRieng;
nhaNew.CoHanCheThoiHanSoHuu = _cohanche;
nhaNew.ThoiHanSoHuu = HanChe;
db.tblThongTinNhaODuBis.Add(nhaNew);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
