protected void loadData(string MaHoSo)
{
try
{
tblXacNhanCapCoSo x = n.result(MaHoSo);
lblMaHoSoCS.Text = x.MaHoSo.ToString();
txtNoiDungKeKhaiSoVoiHienTai.Text = x.NoiDungKeKhaiSoVoiHienTrang;
txtNguonGocSuDungDat.Text = x.NguonGocSuDungDat;
txtThoiDiemSuDungDatVaoMucDichDangKy.Text = x.ThoiDiemSuDungDatVaoMucDichDangKy.ToString();
txtThoiDiemTaoLapTaiSanGanLienVoiDat.Text = x.ThoiDiemTaoLapTaiSanGanLienVoiDat.ToString();
txtSuPhuHopVoiQuyHoachSuDungDatVaQuyHoachXayDung.Text = x.SuPhuHopVoiQuyHoachSuDungDatVaQuyHoachXayDung;
txtTinhTrangTranhChapDatDaiVaTaiSan.Text = x.TinhTrangTranhChapDatDaiVaTaiSan;
txtNoiDungKhac.Text = x.NoiDungKhac;
txtDiaChinh_NgayXacNhan.Text = x.DiaChinh_NgayXacNhan.ToString();
txtDiaChinh_TieuDeKy.Text = x.DiaChinh_TieuDeKy;
txtDiaChinh_NguoiKy.Text = x.DiaChinh_CanBo;
txtUBND_NgayXacNhan.Text = x.UBND_NgayKy.ToString();
txtUBND_TieuDeKy.Text = x.UBND_TieuDeKy;
txtUBND_NguoiKy.Text = x.UBND_NguoiKy;
}
catch (Exception)
{
return;
}
}
public bool SuaXacNhanCapCoSo(string MaHoSo, string NoiDungKeKhaiSoVoiHienTai, string NguonGocSuDungDat, string ThoiDiemSuDungDatVaoMucDichDangKy, string ThoiDiemTaoLapTaiSanGanLienVoiDat, string TinhTrangTranhChapDatDaiVaTaiSan, string SuPhuHopVoiQuyHoachSuDungDatVaQuyHoachXayDung, string NoiDungKhac, string DiaChinh_NgayXacNhan, string UBND_NgayXacNhan, string DiaChinh_TieuDeKy, string UBND_TieuDeKy, string DiaChinh_NguoiKy, string UBND_NguoiKy)
{
try
{
long _maHoSo = long.Parse(MaHoSo);
tblXacNhanCapCoSo xacnhan = db.tblXacNhanCapCoSoes.Single(x => x.MaHoSo == _maHoSo);
xacnhan.NoiDungKeKhaiSoVoiHienTrang = NoiDungKeKhaiSoVoiHienTai;
xacnhan.NguonGocSuDungDat = NguonGocSuDungDat;
xacnhan.ThoiDiemSuDungDatVaoMucDichDangKy = Convert.ToDateTime(ThoiDiemSuDungDatVaoMucDichDangKy);
xacnhan.ThoiDiemTaoLapTaiSanGanLienVoiDat = Convert.ToDateTime(ThoiDiemTaoLapTaiSanGanLienVoiDat);
xacnhan.TinhTrangTranhChapDatDaiVaTaiSan = TinhTrangTranhChapDatDaiVaTaiSan;
xacnhan.SuPhuHopVoiQuyHoachSuDungDatVaQuyHoachXayDung = SuPhuHopVoiQuyHoachSuDungDatVaQuyHoachXayDung;
xacnhan.NoiDungKhac = NoiDungKhac;
xacnhan.DiaChinh_NgayXacNhan = Convert.ToDateTime(DiaChinh_NgayXacNhan);
xacnhan.UBND_NgayKy = Convert.ToDateTime(UBND_NgayXacNhan);
xacnhan.DiaChinh_TieuDeKy = DiaChinh_TieuDeKy;
xacnhan.UBND_TieuDeKy = UBND_TieuDeKy;
xacnhan.DiaChinh_CanBo = DiaChinh_NguoiKy;
xacnhan.UBND_NguoiKy = UBND_NguoiKy;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public tblXacNhanCapCoSo LayThongTinXacNhanCapCoSo(string MaHoSo)
{
try
{
long _maHS = long.Parse(MaHoSo);
tblXacNhanCapCoSo xacnhan = db.tblXacNhanCapCoSoes.SingleOrDefault(n => n.MaHoSo == _maHS);
return(xacnhan);
}
catch (Exception)
{
return(null);
}
}
protected void LoadThongTin(string MaHoSo)
{
try
{
long _maHoSo = long.Parse(MaHoSo);
XuLyDonXinCapGCN don = new XuLyDonXinCapGCN();
tblHoSoKeKhai kk = don.LayThongTinHoSoKeKhai(MaHoSo);
if (kk != null)
{
lblTieuDeDon.Text = kk.KinhGuiCoQuanChucNang;
lblNguoiVietDon.Text = kk.NguoiVietDon;
lblEmail.Text = kk.DiaChiMail;
lblDienThoai.Text = kk.SoDienThoaiLienHe;
lblDeNghi.Text = kk.MaLoaiDeNghi;
lblDeNghiKhac.Text = kk.DeNghiKhac;
lblNgayNhanHoSo.Text = ((DateTime)kk.NgayNhanHoSo).ToString("dd/MM/yyyy");
lblNguoiNhanHoSo.Text = kk.NguoiNhanHoSo;
lblSoVaoSo.Text = kk.SoTiepNhan;
lblQuyen.Text = kk.Quyen;
lblNghiaVuTaiChinh.Text = kk.NghiaVuTaiChinh;
lblGiayToKemTheo.Text = kk.GiayToKemTheo;
}
grvChu.DataSource = don.dsChu(MaHoSo);
grvChu.DataBind();
grvThuaDat.DataSource = don.dsThuaDat(MaHoSo);
grvThuaDat.DataBind();
grvNhaO.DataSource = don.dsNhaO(MaHoSo);
grvNhaO.DataBind();
// thong tin rung cay lau nam...
// thong tin rung san xuat...
// thong tin xet duyet cap co so
tblXacNhanCapCoSo xd1 = don.LayThongTinXacNhanCapCoSo(MaHoSo);
if (xd1 != null)
{
lblNoiDungKeKhaiSoVoiHienTai.Text = xd1.NoiDungKeKhaiSoVoiHienTrang;
lblNguonGoc.Text = xd1.NguonGocSuDungDat;
lblThoiDiemSuDungDat.Text = ((DateTime)xd1.ThoiDiemSuDungDatVaoMucDichDangKy).ToString("dd/MM/yyyy");
lblThoiDiemTaoTaiSan.Text = ((DateTime)xd1.ThoiDiemTaoLapTaiSanGanLienVoiDat).ToString("dd/MM/yyyy");
lblTinhTrangTranhChap.Text = xd1.TinhTrangTranhChapDatDaiVaTaiSan;
lblPhuHopQuyHoach.Text = xd1.SuPhuHopVoiQuyHoachSuDungDatVaQuyHoachXayDung;
lblNoiDungKhac.Text = xd1.NoiDungKhac;
lblDiaChinhNgay.Text = ((DateTime)xd1.DiaChinh_NgayXacNhan).ToString("dd/MM/yyyy");
lblDiaChinhNguoi.Text = xd1.DiaChinh_CanBo;
lblDiaChinhTieuDe.Text = xd1.DiaChinh_TieuDeKy;
lblUBNDNgay.Text = ((DateTime)xd1.UBND_NgayKy).ToString("dd/MM/yyyy");
lblUBNDNguoi.Text = xd1.UBND_NguoiKy;
lblUBNDTieuDe.Text = xd1.UBND_TieuDeKy;
}
// thong tin xac nhan co quan dang ky
tblXacNhanCoQuanDangKyDatDai xd2 = don.LayThongTinXacNhanCoQuanDangKy(MaHoSo);
if (xd2 != null)
{
lblNgayKiemTra.Text = ((DateTime)xd2.NgayKiemTra).ToString("dd/MM/yyyy");
lblNguoiKiemTra.Text = xd2.NguoiKiemTra;
lblChucVuNguoiKiemTra.Text = xd2.ChucVuNguoiKiemTra;
lblNoiDungYKien.Text = xd2.NoiDungYKien;
lblGhiChuYKien.Text = xd2.GhiChu;
lblNgayKyVPDK.Text = ((DateTime)xd2.NgayKy).ToString("dd/MM/yyyy");
lblGiamDocVPDK.Text = xd2.GiamDoc;
}
}
catch (Exception)
{
return;
}
}