public bool LayThongTinVeDon(string MaHoSo)
{
try
{
using (DMCWebEntities db = new DMCWebEntities())
{
long _maHS = long.Parse(MaHoSo);
var kq = from h in db.tblHoSoKeKhaiDuBis
join dt in db.tblChuHoSoDuBis on h.MaHoSoKeKhai equals dt.MaHoSoKeKhai
where h.MaHoSoKeKhai == _maHS
select new
{
MaHS = h.MaHoSoKeKhai,
Dvhc = h.DonViHanhChinh,
LoaiDT = h.MaLoaiDoiTuong
};
Session["MaDVHC"] = kq.Single().Dvhc;
string strLoaiDoiTuong = kq.Single().LoaiDT;
if (strLoaiDoiTuong == null || strLoaiDoiTuong == "")
drLoaiDoiTuong.SelectedIndex = -1;
else
drLoaiDoiTuong.SelectedValue = strLoaiDoiTuong;
drDonViHanhChinh.SelectedValue = Session["MaDVHC"].ToString();
return true;
}
}
catch (Exception ex)
{
string s = ex.Message;
return false;
}
}
public bool LayThongTinVeDon(string MaDangKyBienDong)
{
try
{
using (DMCWebEntities db = new DMCWebEntities())
{
long _maDangKyBienDong = long.Parse(MaDangKyBienDong);
if (Session["LoaiHoSo"] == "DuBi")
{
var kq = from h in db.tblDonXinDangKyBienDongDuBis
where h.ID == _maDangKyBienDong
select h;
Session["MaDVHC"] = kq.Single().DonViHanhChinh;
if (Session["MaDVHC"] != null && Session["MaDVHC"].ToString() != "")
drDonViHanhChinh.SelectedValue = Session["MaDVHC"].ToString();
Session["LoaiBienDong"] = kq.Single().LoaiBienDong;
string s = Session["LoaiBienDong"].ToString();
if (Convert.ToInt32(Session["LoaiBienDong"]) > 0)
drLoaiBienDong.SelectedValue = Session["LoaiBienDong"].ToString();
return true;
}
else if(Session["LoaiHoSo"] == "ChinhThuc")
{
var kq = from h in db.tblDonXinDangKyBienDongs
where h.MaDangKyBienDong == _maDangKyBienDong
select h;
Session["MaDVHC"] = kq.Single().DonViHanhChinh;
if (Session["MaDVHC"] != null && Session["MaDVHC"].ToString() != "")
drDonViHanhChinh.SelectedValue = Session["MaDVHC"].ToString();
Session["LoaiBienDong"] = kq.Single().LoaiBienDong;
string s = Session["LoaiBienDong"].ToString();
if (Convert.ToInt32(Session["LoaiBienDong"]) > 0)
drLoaiBienDong.SelectedValue = Session["LoaiBienDong"].ToString();
return true;
}
else
{
return false;
}
}
}
catch (Exception ex)
{
string s = ex.Message;
return false;
}
}
protected void grvChu_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
NhapThongTinChu_Visible(true);
string _maChu = e.CommandArgument.ToString();
Session["ThaoTac"] = ThaoTac.DangSua;
Session["MaChu"] = _maChu;
using (DMCWebEntities db = new DMCWebEntities())
{
long maChu = long.Parse(_maChu);
if (Session["LoaiHoSo"] == "DuBi")
{
tblChuDuBi chu = db.tblChuDuBis.SingleOrDefault(n => n.MaChu == maChu);
lblMaChu.Text = _maChu.ToString();
txtHoTen.Text = chu.HoTen;
drDanhXung.Text = chu.DanhXung;
txtNamSinh.Text = chu.NamSinh;
txtDiaChi.Text = chu.DiaChi;
txtSoDinhDanh.Text = chu.SoDinhDanh;
txtNoiCap.Text = chu.NoiCap;
txtNgayCap.Text = chu.NgayCap.ToString();
txtDinhDanh.Text = chu.DinhDanh;
}
else if (Session["LoaiHoSo"] == "ChinhThuc")
{
tblChu chu = db.tblChus.SingleOrDefault(n => n.MaChu == maChu);
lblMaChu.Text = "Mã chủ: " + _maChu.ToString();
txtHoTen.Text = chu.HoTen;
drDanhXung.Text = chu.DanhXung;
txtNamSinh.Text = chu.NamSinh;
txtDiaChi.Text = chu.DiaChi;
txtSoDinhDanh.Text = chu.SoDinhDanh;
txtNoiCap.Text = chu.NoiCap;
txtNgayCap.Text = chu.NgayCap.ToString();
txtDinhDanh.Text = chu.DinhDanh;
}
}
}
}
protected void grvThuaDat_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
NhapThongTinThuaDat_Visible(true);
string _maThuaDat = e.CommandArgument.ToString();
Session["ThaoTac"] = ThaoTac.DangSua;
Session["MaThuaDat"] = _maThuaDat;
using (DMCWebEntities db = new DMCWebEntities())
{
long maThuaDat = long.Parse(_maThuaDat);
var thuadatdangxet = (from td in db.tblThuaDatDuBis
where td.MaThuaDat == maThuaDat
select td).Single();
tblThuaDatDuBi thua = (tblThuaDatDuBi)thuadatdangxet;
lblMaThuaDat.Text = thua.MaThuaDat.ToString();
lblMaHoSo.Text = thua.MaHoSoKeKhai.ToString();
txtToBanDo.Text = thua.ToBanDo;
txtSoThua.Text = thua.SoThua;
txtDiaChi.Text = thua.DiaChi;
txtDienTich.Text = thua.DienTich;
txtDTSDChung.Text = thua.SuDungChung;
txtDTSDRieng.Text = thua.SuDungRieng;
txtMucDich.Text = thua.MucDichSuDung;
txtThoiHan.Text = thua.ThoiHanSuDung;
txtNgayBatDau.Text = thua.NgayBatDauSuDung.ToString();
drHanChe.SelectedValue = thua.CoHanCheSuDung.ToString().ToLower();
txtHanChe.Text = thua.NoiDungHanCheSuDung;
drLoaiNguonGoc.SelectedValue = thua.LoaiNguonGocSuDung;
}
}
}
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;
}
}
}
protected void grvChu_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
NhapThongTinChu_Visible(true);
string _maChu = e.CommandArgument.ToString();
Session["ThaoTac"] = ThaoTac.DangSua;
Session["MaChu"] = _maChu;
using(DMCWebEntities db = new DMCWebEntities())
{
long maChu = long.Parse(_maChu);
var q = (from c in db.tblChuDuBis
where c.MaChu == maChu
select c).Single();
tblChuDuBi chu = (tblChuDuBi)q;
lblMaChu.Text ="Mã chủ: "+ _maChu.ToString();
txtHoTen.Text = chu.HoTen;
drDanhXung.Text = chu.DanhXung;
txtNamSinh.Text = chu.NamSinh;
txtDiaChi.Text = chu.DiaChi;
txtSoDinhDanh.Text = chu.SoDinhDanh;
txtNoiCap.Text = chu.NoiCap;
txtNgayCap.Text = chu.NgayCap.ToString();
txtDinhDanh.Text = chu.DinhDanh;
}
}
}