public bool SuaXacNhanCoQuanDangKy(string MaHoSo, string NgayKiemtra, string NguoiKiemTra, string ChucVuNguoiKiemTra, string NoiDungYKien, string GhiChu, string NgayKy, string GiamDoc)
{
try
{
long _maHoSo = long.Parse(MaHoSo);
tblXacNhanCoQuanDangKyDatDai kq = db.tblXacNhanCoQuanDangKyDatDais.Single(n => n.MaHoSo == _maHoSo);
kq.NgayKiemTra = Convert.ToDateTime(NgayKiemtra);
kq.NguoiKiemTra = NguoiKiemTra;
kq.ChucVuNguoiKiemTra = ChucVuNguoiKiemTra;
kq.NoiDungYKien = NoiDungYKien;
kq.GhiChu = GhiChu;
if (NgayKy.Trim() != "")
{
kq.NgayKy = Convert.ToDateTime(NgayKy);
}
kq.GiamDoc = GiamDoc;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public tblXacNhanCoQuanDangKyDatDai LayThongTinXacNhanCoQuanDangKy(string MaHoSo)
{
try
{
long _maHS = long.Parse(MaHoSo);
tblXacNhanCoQuanDangKyDatDai xacnhan = db.tblXacNhanCoQuanDangKyDatDais.SingleOrDefault(n => n.MaHoSo == _maHS);
return(xacnhan);
}
catch (Exception)
{
return(null);
}
}
public bool XoaXacNhanCoQuanDangKy(string MaHoSo)
{
try
{
long _maHoSo = long.Parse(MaHoSo);
tblXacNhanCoQuanDangKyDatDai kq = db.tblXacNhanCoQuanDangKyDatDais.Single(n => n.MaHoSo == _maHoSo);
db.tblXacNhanCoQuanDangKyDatDais.Remove(kq);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
protected void loadData(string MaHoSo)
{
try
{
tblXacNhanCoQuanDangKyDatDai xn = n.result(MaHoSo);
lblMaHoSo.Text = xn.MaHoSo.ToString();
txtNgayKiemTra.Text = xn.NgayKiemTra.ToString();
txtNguoiKiemTra.Text = xn.NguoiKiemTra;
txtChucVuNguoiKiemTra.Text = xn.ChucVuNguoiKiemTra;
txtNoiDungYKien.Text = xn.NoiDungYKien;
txtGhiChu.Text = xn.GhiChu;
txtNgayKy.Text = xn.NgayKy.ToString();
txtGiamDoc.Text = xn.GiamDoc;
}
catch (Exception)
{
return;
}
}
public bool KiemTraTonTai(string MaHoSo)
{
try
{
long _maHoSo = long.Parse(MaHoSo);
tblXacNhanCoQuanDangKyDatDai kq = (from n in db.tblXacNhanCoQuanDangKyDatDais
where n.MaHoSo == _maHoSo
select n).SingleOrDefault();
if (kq != null)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
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;
}
}
