public bool LuuThongTinXetDuyetCapCSDuBi(string MaHoSo, string TieuDe, string NguoiGui, string LoaiDeNghi, string NghiaVuTC, string GiayToKemTheo, string DeNghiKhac, string Email, string DienThoai, string NguoiNhan, string NgayNhan, string SotiepNhan, string Quyen) { try { long _maHS = long.Parse(MaHoSo); tblHoSoKeKhaiDuBi HS = db.tblHoSoKeKhaiDuBis.Single(h => h.MaHoSoKeKhai == _maHS); HS.KinhGuiCoQuanChucNang = TieuDe; HS.NguoiVietDon = NguoiGui; HS.MaLoaiDeNghi = LoaiDeNghi; HS.NghiaVuTaiChinh = NghiaVuTC; HS.GiayToKemTheo = GiayToKemTheo; HS.DeNghiKhac = DeNghiKhac; HS.DiaChiMail = Email; HS.SoDienThoaiLienHe = DienThoai; HS.NguoiNhanHoSo = NguoiNhan; if (NgayNhan.Trim() != "") { HS.NgayNhanHoSo = Convert.ToDateTime(NgayNhan); } HS.SoTiepNhan = SotiepNhan; HS.Quyen = Quyen; db.SaveChanges(); return(true); } catch (Exception ex) { string s = ex.Message; return(false); } }
protected void LoadThongTinGuiNhanHoSo() { try { tblHoSoKeKhaiDuBi HSKeKhaiHienTai = don.LayThongTinXetDuyetCapCSDuBi(Session["MaDon"].ToString()); txtTieuDeKinhGui.Text = HSKeKhaiHienTai.KinhGuiCoQuanChucNang; txtNguoiVietDon.Text = HSKeKhaiHienTai.NguoiVietDon; drLoaiDeNghiCapGCN.SelectedValue = HSKeKhaiHienTai.MaLoaiDeNghi; txtNghiaVuTaiChinh.Text = HSKeKhaiHienTai.NghiaVuTaiChinh; txtGiayToKemTheo.Text = HSKeKhaiHienTai.GiayToKemTheo; txtDeNghiKhac.Text = HSKeKhaiHienTai.DeNghiKhac; txtEmailNguoiVietDon.Text = HSKeKhaiHienTai.DiaChiMail; txtDienThoaiNguoiVietDon.Text = HSKeKhaiHienTai.SoDienThoaiLienHe; txtNguoiNhan.Text = HSKeKhaiHienTai.NguoiNhanHoSo; txtNgayNhan.Text = HSKeKhaiHienTai.NgayNhanHoSo.ToString(); txtSoTiepNhan.Text = HSKeKhaiHienTai.SoTiepNhan; txtQuyen.Text = HSKeKhaiHienTai.Quyen; } catch (Exception ex) { string s = ex.Message; } }
/// <summary> /// Hiển thi thông tin về đơn. /// </summary> /// <param name="MaHoSo"></param> public tblHoSoKeKhaiDuBi LayThongTinXetDuyetCapCSDuBi(string MaHoSo) { try { long _maHS = long.Parse(MaHoSo); tblHoSoKeKhaiDuBi HS = db.tblHoSoKeKhaiDuBis.Single(h => h.MaHoSoKeKhai == _maHS); return(HS); } catch (Exception ex) { return(null); } }
public bool CapNhatLoaiDoiTuong(string MaHoSo, string MaLoaiDoiTuong) { try { long _maHoSo = long.Parse(MaHoSo); tblHoSoKeKhaiDuBi HoSoHienTai = db.tblHoSoKeKhaiDuBis.Single(h => h.MaHoSoKeKhai == _maHoSo); HoSoHienTai.MaLoaiDoiTuong = MaLoaiDoiTuong; db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool GuiHoSoDi(string MaHoSo) { try { long _maHS = long.Parse(MaHoSo); tblHoSoKeKhaiDuBi HS = db.tblHoSoKeKhaiDuBis.Single(h => h.MaHoSoKeKhai == _maHS); HS.DaGuiDi = true; db.SaveChanges(); return(true); } catch (Exception ex) { string s = ex.Message; return(false); } }
public int TaoDonMoi(string MaDVHC) { int i = 0; try { tblHoSoKeKhaiDuBi hsNew = new tblHoSoKeKhaiDuBi(); hsNew.DonViHanhChinh = MaDVHC; db.tblHoSoKeKhaiDuBis.Add(hsNew); db.SaveChanges(); i = Convert.ToInt32(hsNew.MaHoSoKeKhai); } catch (Exception ex) { } return(i); }
//************************ QUAN TRỌNG! // ĐÂY LÀ PHẦN CHẤP NHẬN HỒ SƠ, CẬP NHẬT VÀ TÁC DỘNG ĐẾN NHIỀU BẢNG // NÊN CẦN DÀNH THỜI GIAN XEM XÉT KỸ LẠI PHẦN NÀY! public bool KiemTraDuDieuKienChapNhan(string MaHoSoKeKhai) { try { long _maHS = long.Parse(MaHoSoKeKhai); tblHoSoKeKhaiDuBi HS = db.tblHoSoKeKhaiDuBis.Single(h => h.MaHoSoKeKhai == _maHS); if (HS.SoTiepNhan.Trim() == "" && HS.Quyen.Trim() == "") { return(false); } else { return(true); } } catch (Exception) { return(false); } }
public bool ChapNhanHoSo(string MaHoSoKeKhai) { try { long _maHS = long.Parse(MaHoSoKeKhai); tblHoSoKeKhaiDuBi HS = db.tblHoSoKeKhaiDuBis.Single(h => h.MaHoSoKeKhai == _maHS); //-- tao ho so moi tblHoSo HoSoMoi = new tblHoSo(); db.tblHoSoes.Add(HoSoMoi); //-- them vao bang ho so tblHoSoKeKhai HSKK = new tblHoSoKeKhai(); HSKK.KinhGuiCoQuanChucNang = HS.KinhGuiCoQuanChucNang; HSKK.NgayNhanHoSo = HS.NgayNhanHoSo; HSKK.NguoiNhanHoSo = HS.NguoiNhanHoSo; HSKK.SoTiepNhan = HS.SoTiepNhan; HSKK.Quyen = HS.Quyen; HSKK.NguoiVietDon = HS.NguoiVietDon; HSKK.DonViHanhChinh = HS.DonViHanhChinh; HSKK.GiayToKemTheo = HS.GiayToKemTheo; HSKK.NghiaVuTaiChinh = HS.NghiaVuTaiChinh; HSKK.DeNghiKhac = HS.DeNghiKhac; HSKK.SoDienThoaiLienHe = HS.SoDienThoaiLienHe; HSKK.DiaChiMail = HS.DiaChiMail; HSKK.MaLoaiDeNghi = HS.MaLoaiDeNghi; HSKK.MaHoSo = _maHS; db.tblHoSoKeKhais.Add(HSKK); //-- insert vao bang hosokekhaiduocchapnhan tblHoSoKeKhaiDuocChapNhan HSKKDCN = new tblHoSoKeKhaiDuocChapNhan(); HSKKDCN.MaHoSoKeKhai = HSKK.MaHoSoKeKhai; HSKKDCN.MaHoSoKeKhaiDuBi = HS.MaHoSoKeKhai; HSKKDCN.NgayThucHien = DateTime.Today; db.tblHoSoKeKhaiDuocChapNhans.Add(HSKKDCN); //-- insert vao bang hoso HoSoMoi.LoaiDoiTuong = HS.MaLoaiDoiTuong; HoSoMoi.DonViHanhChinh = HS.DonViHanhChinh; HoSoMoi.TrangThaiHoSoCapGCN = "1"; //HoSoMoi.TongSoThua se cap nhat o phan thua dat... //-- insert vao bang thuadat List <tblThuaDatDuBi> dsThuaDat = (from td in db.tblThuaDatDuBis where td.MaHoSoKeKhai == HS.MaHoSoKeKhai select td).ToList <tblThuaDatDuBi>(); if (dsThuaDat.Count > 0) { HoSoMoi.TongSoThua = dsThuaDat.Count; for (int i = 0; i < dsThuaDat.Count; i++) { tblThuaDat ThuaDaMoi = new tblThuaDat(); ThuaDaMoi.MaHoSo = dsThuaDat[i].MaHoSoKeKhai; ThuaDaMoi.ToBanDo = dsThuaDat[i].ToBanDo; ThuaDaMoi.SoThua = dsThuaDat[i].SoThua; ThuaDaMoi.DiaChi = dsThuaDat[i].DiaChi; ThuaDaMoi.DienTich = dsThuaDat[i].DienTich; ThuaDaMoi.SuDungChung = dsThuaDat[i].SuDungChung; ThuaDaMoi.SuDungRieng = dsThuaDat[i].SuDungRieng; ThuaDaMoi.MucDichSuDung = dsThuaDat[i].MucDichSuDung; ThuaDaMoi.ThoiHanSuDung = dsThuaDat[i].ThoiHanSuDung; ThuaDaMoi.NgayBatDauSuDung = dsThuaDat[i].NgayBatDauSuDung; ThuaDaMoi.LoaiNguonGocSuDung = dsThuaDat[i].LoaiNguonGocSuDung; ThuaDaMoi.CoHanCheSuDung = dsThuaDat[i].CoHanCheSuDung.ToString(); ThuaDaMoi.NoiDungHanCheSuDung = dsThuaDat[i].NoiDungHanCheSuDung; db.tblThuaDats.Add(ThuaDaMoi); } } //-- insert vao bang nhao List <tblThongTinNhaODuBi> dsNhaO = (from n in db.tblThongTinNhaODuBis where n.MaHoSoKeKhai == _maHS select n).ToList <tblThongTinNhaODuBi>(); if (dsNhaO.Count > 0) { for (int i = 0; i < dsNhaO.Count; i++) { tblThongTinNhaO NhaMoi = new tblThongTinNhaO(); NhaMoi.MaHoSo = dsNhaO[i].MaHoSoKeKhai; NhaMoi.LoaiNhaO = dsNhaO[i].LoaiNhaO; NhaMoi.DienTichXayDung = dsNhaO[i].DienTichXayDung; NhaMoi.DienTichSan = dsNhaO[i].DienTichSan; NhaMoi.SoHuuChung = dsNhaO[i].SoHuuChung; NhaMoi.SoHuuRieng = dsNhaO[i].SoHuuRieng; NhaMoi.KetCau = dsNhaO[i].KetCau; NhaMoi.SoTang = dsNhaO[i].SoTang; NhaMoi.CoHanCheThoiHanSoHuu = dsNhaO[i].CoHanCheThoiHanSoHuu; NhaMoi.ThoiHanSoHuu = dsNhaO[i].ThoiHanSoHuu; db.tblThongTinNhaOs.Add(NhaMoi); } } //-- insert vao bang chuhoso va bang chu List <tblChuHoSoDuBi> dsChuHS = (from chs in db.tblChuHoSoDuBis where chs.MaHoSoKeKhai == _maHS select chs).ToList <tblChuHoSoDuBi>(); if (dsChuHS.Count > 0) { for (int i = 0; i < dsChuHS.Count; i++) { tblChuHoSo ChuHS = new tblChuHoSo(); ChuHS.MaChu = dsChuHS[i].MaChu; ChuHS.MaHoSo = _maHS; db.tblChuHoSoes.Add(ChuHS); long ma = (long)dsChuHS[i].MaChu; tblChuDuBi chudubi = db.tblChuDuBis.Single(c => c.MaChu == ma); tblChu Chu = new tblChu(); Chu.DanhXung = chudubi.DanhXung; Chu.HoTen = chudubi.HoTen; Chu.NamSinh = chudubi.NamSinh; Chu.DiaChi = chudubi.DiaChi; Chu.DinhDanh = chudubi.DinhDanh; Chu.SoDinhDanh = chudubi.SoDinhDanh; Chu.NoiCap = chudubi.NoiCap; Chu.NgayCap = chudubi.NgayCap; Chu.QuocTich = chudubi.QuocTich; db.tblChus.Add(Chu); } } //LƯU LẠI LẦN 1 db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }