public bool ThemChuDuBi(string MaHoSo, string DanhXung, string HoTen, string NamSinh, string DiaChi, string DinhDanh, string SoDinhDanh, string NoiCap, string NgayCap, string QuocTich)
        {
            try
            {
                tblChuDuBi chumoi = new tblChuDuBi();

                chumoi.DanhXung   = DanhXung;
                chumoi.HoTen      = HoTen;
                chumoi.NamSinh    = NamSinh;
                chumoi.DiaChi     = DiaChi;
                chumoi.DinhDanh   = DinhDanh;
                chumoi.SoDinhDanh = SoDinhDanh;
                chumoi.NoiCap     = NoiCap;
                chumoi.NgayCap    = Convert.ToDateTime(NgayCap);
                chumoi.QuocTich   = QuocTich;

                db.tblChuDuBis.Add(chumoi);
                db.SaveChanges();

                tblChuHoSoDuBi chuhoso = new tblChuHoSoDuBi();
                chuhoso.MaChu        = chumoi.MaChu;
                chuhoso.MaHoSoKeKhai = Convert.ToInt32(MaHoSo);
                db.tblChuHoSoDuBis.Add(chuhoso);
                db.SaveChanges();


                return(true);
            }
            catch (Exception ex)
            {
                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);
                    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;
                }
            }
        }
        public bool XoaChuDuBi(string MaChu)
        {
            try
            {
                long       _maChu    = long.Parse(MaChu);
                tblChuDuBi chucanxoa = db.tblChuDuBis.Single(c => c.MaChu == _maChu);
                db.tblChuDuBis.Remove(chucanxoa);

                db.SaveChanges();
                return(true);
            }
            catch (Exception ex)
            {
                return(false);
            }
        }
        public bool XoaHoSoDuBi(string MaHoSoKeKhai)
        {
            try
            {
                long _maHoSo = long.Parse(MaHoSoKeKhai);

                //-- xoa trong bang chuhoso va chu du bi
                List <tblChuHoSoDuBi> dsChuHS_xoa = (from chs in db.tblChuHoSoDuBis
                                                     where chs.MaHoSoKeKhai == _maHoSo
                                                     select chs).ToList();
                if (dsChuHS_xoa.Count > 0)
                {
                    for (int i = 0; i < dsChuHS_xoa.Count; i++)
                    {
                        long       ma      = (long)dsChuHS_xoa[i].MaChu;
                        tblChuDuBi Chu_xoa = db.tblChuDuBis.Single(n => n.MaChu == ma);
                        db.tblChuDuBis.Remove(Chu_xoa);
                        db.tblChuHoSoDuBis.Remove(dsChuHS_xoa[i]);
                    }
                }
                //-- xoa trong bang nha o du bi
                var NhaO_xoa = from n in db.tblThongTinNhaODuBis
                               where n.MaHoSoKeKhai == _maHoSo
                               select n;
                db.tblThongTinNhaODuBis.RemoveRange(NhaO_xoa);

                //-- xoa trong bang thuadat du bi
                var ThuaDat_xoa = from td in db.tblThuaDatDuBis
                                  where td.MaHoSoKeKhai == _maHoSo
                                  select td;
                db.tblThuaDatDuBis.RemoveRange(ThuaDat_xoa);
                // -- xoa trong bang ho so ke khai du bi
                var HoSoKeKhai_xoa = (from h in db.tblHoSoKeKhaiDuBis
                                      where h.MaHoSoKeKhai == _maHoSo
                                      select h).SingleOrDefault();
                db.tblHoSoKeKhaiDuBis.Remove(HoSoKeKhai_xoa);

                db.SaveChanges();
                return(true);
            }
            catch (Exception)
            {
                return(false);
            }
        }
Пример #5
0
        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;
                    }
                }
            }
        }
        public bool SuaChuDuBi(string MaChu, string DanhXung, string HoTen, string NamSinh, string DiaChi, string DinhDanh, string SoDinhDanh, string NoiCap, string NgayCap, string QuocTich)
        {
            try
            {
                long       _maChu    = long.Parse(MaChu);
                tblChuDuBi chucansua = db.tblChuDuBis.Single(c => c.MaChu == _maChu);
                chucansua.DanhXung   = DanhXung;
                chucansua.HoTen      = HoTen;
                chucansua.NamSinh    = NamSinh;
                chucansua.DiaChi     = DiaChi;
                chucansua.DinhDanh   = DinhDanh;
                chucansua.SoDinhDanh = SoDinhDanh;
                chucansua.NoiCap     = NoiCap;
                chucansua.NgayCap    = Convert.ToDateTime(NgayCap);
                chucansua.QuocTich   = QuocTich;

                db.SaveChanges();
                return(true);
            }
            catch (Exception ex)
            {
                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);
            }
        }