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

                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.tblChus.Add(chumoi);
                db.SaveChanges();


                tblChuHoSo chuhoso = new tblChuHoSo();
                chuhoso.MaChu  = chumoi.MaChu;
                chuhoso.MaHoSo = Convert.ToInt32(MaHoSo);
                db.tblChuHoSoes.Add(chuhoso);
                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);
            }
        }