Esempio n. 1
0
        public PesquisaViewModel()
        {
            // _pesquisaCPFCNPJ = Global.Investidor;
            pesquisaBusiness = new PesquisaBusiness();

            PesquisaCPFCNPJ = new PesquisaCPFCNPJModel();

            PesquisarClickedCommand = new Command(() => {
                var mensagem = "Consulta Realizada com Sucesso";
                try
                {
                    ArpenspModel arpenspModel = pesquisaBusiness.Arpensp(PesquisaCPFCNPJ.CPFCNPJ);
                    CagedModel cagedModel     = pesquisaBusiness.Caged(PesquisaCPFCNPJ.CPFCNPJ);
                    JucespModel jucespModel   = pesquisaBusiness.Jucesp(PesquisaCPFCNPJ.CPFCNPJ);
                    CensecModel censecModel   = pesquisaBusiness.Censec(PesquisaCPFCNPJ.CPFCNPJ);
                    SielModel sielModel       = pesquisaBusiness.Siel(PesquisaCPFCNPJ.CPFCNPJ);
                    SivecModel sivecModel     = pesquisaBusiness.Sivec(PesquisaCPFCNPJ.CPFCNPJ);
                    DetranModel detranModel   = pesquisaBusiness.Detran(PesquisaCPFCNPJ.CPFCNPJ);
                } catch (Exception ex) {
                    mensagem = "Não foi possível consultar os dados. Verifique sua conexão! \n Detalhe: " +
                               ex.Message;
                }

                DependencyService.Get <IMessage>().ShortAlert(mensagem);
                MessagingCenter.Send <PesquisaViewModel>(this, "PesquisaSucesso");
            });
        }
Esempio n. 2
0
 public void Insert(DetranModel detranModel)
 {
     using (context)
     {
         context.Detran.Add(detranModel);
         context.SaveChanges();
     }
 }
Esempio n. 3
0
        public DetranModel Detran(int cpfcnpj)
        {
            var detran = new Service.PesquisaService().Detran(cpfcnpj);

            DetranModel detranModel = JsonConvert.DeserializeObject <DetranModel>(detran);

            //variavel global
            Global.Detran = detranModel;

            return(detranModel);
        }
Esempio n. 4
0
        public string Detran(PesquisaCPFCNPJ pesquisaCPFCNPJ)
        {
            var options = new ChromeOptions();

            //options.AddArguments("headless");
            options.AddArguments("no-sandbox");
            using (IWebDriver driver = new ChromeDriver("C:/inetpub/wwwroot/wwwroot", options))
            //using (IWebDriver driver = new ChromeDriver(options))
            {
                Actions builder = new Actions(driver);

                driver.Navigate().GoToUrl("http://ec2-18-231-116-58.sa-east-1.compute.amazonaws.com/detran/login.html");
                driver.FindElement(By.Id("form:j_id563205015_44efc15b")).Click();
                driver.FindElement(By.Id("navigation_a_M_16")).Click();
                driver.FindElement(By.XPath("//*[@id='navigation_a_F_16']")).Click();
                driver.FindElement(By.Id("form:rg")).SendKeys(pesquisaCPFCNPJ.CPFCNPJ.ToString());
                driver.FindElement(By.Id("form:nome")).SendKeys(pesquisaCPFCNPJ.Nome);
                driver.FindElement(By.LinkText("Pesquisar")).Click();

                driver.SwitchTo().Window(driver.WindowHandles[1]);
                URL url = new URL(driver.Url);
                BufferedInputStream fileToParse = new BufferedInputStream(url.openStream());
                PDFParser           parser      = new PDFParser(fileToParse);
                parser.parse();
                COSDocument     cosDoc      = parser.getDocument();
                PDDocument      pdDoc       = new PDDocument(cosDoc);
                PDFTextStripper pdfStripper = new PDFTextStripper();
                pdfStripper.setStartPage(1);
                pdfStripper.setEndPage(1);
                string parsedText = pdfStripper.getText(pdDoc);

                string saida = new PDFTextStripper().getText(parser.getPDDocument());

                driver.SwitchTo().Window(driver.WindowHandles[0]);
                driver.FindElement(By.Id("navigation_a_M_16")).Click();
                driver.FindElement(By.PartialLinkText("Consultar Imagem da CNH")).Click();
                driver.FindElement(By.LinkText("Pesquisar")).Click();
                driver.SwitchTo().Window(driver.WindowHandles[2]);
                //string nomePai = driver.FindElement(By.XPath("/html/body/div[4]/div/table/tbody/tr/td/div/div/form/div[3]/div/table/tbody/tr/td/table/tbody/tr[2]/td/table/tbody/tr/td[2]")).Text;
                string nPai = driver.FindElement(By.XPath("/html/body/div[4]/div/table/tbody/tr/td/div/div/form/div[3]/div/table/tbody/tr/td/table/tbody/tr[2]/td/table/tbody/tr/td[2]/table/tbody/tr[3]/td/table/tbody/tr[2]/td/span")).Text;
                string nMae = driver.FindElement(By.XPath("/html/body/div[4]/div/table/tbody/tr/td/div/div/form/div[3]/div/table/tbody/tr/td/table/tbody/tr[2]/td/table/tbody/tr/td[2]/table/tbody/tr[4]/td/table/tbody/tr[2]/td/span")).Text;


                driver.SwitchTo().Window(driver.WindowHandles[0]);
                driver.FindElement(By.Id("navigation_a_M_18")).Click();
                driver.FindElement(By.PartialLinkText("Consultar Veículo Base Estadual")).Click();
                driver.FindElement(By.XPath("/html/body/div[4]/div/table/tbody/tr/td/div/div/form/div[1]/div[2]/table[2]/tbody/tr[2]/td[2]/input")).SendKeys(pesquisaCPFCNPJ.CPFCNPJ.ToString());
                driver.FindElement(By.LinkText("Pesquisar")).Click();
                driver.SwitchTo().Window(driver.WindowHandles[3]);

                URL urlCarro = new URL(driver.Url);
                BufferedInputStream fileToParseCarro = new BufferedInputStream(urlCarro.openStream());
                PDFParser           parserCarro      = new PDFParser(fileToParseCarro);
                parserCarro.parse();
                COSDocument     cosDocCarro      = parserCarro.getDocument();
                PDDocument      pdDocCarro       = new PDDocument(cosDocCarro);
                PDFTextStripper pdfStripperCarro = new PDFTextStripper();
                pdfStripper.setStartPage(1);
                pdfStripper.setEndPage(1);
                string parsedTextCarro = pdfStripperCarro.getText(pdDocCarro);

                string saidaCarro = new PDFTextStripper().getText(parserCarro.getPDDocument());

                string resultado = saida + nPai + nMae + saidaCarro;

                string[] strsplit = resultado.Replace("\r\n", ":").Split(':');

                string cpf               = strsplit[33].Trim();
                string rg                = strsplit[13].Trim();
                string expeditor         = strsplit[34].Trim();
                string registro          = strsplit[36].Trim();
                string local             = strsplit[38].Trim();
                string espelhoPid        = strsplit[40].Trim();
                string emissaoCnh        = strsplit[42].Trim();
                string categoria         = strsplit[46].Trim();
                string primeiraHab       = strsplit[48].Trim();
                string statusCnh         = strsplit[50].Trim();
                string renach            = strsplit[52].Trim();
                string espelhoCnh        = strsplit[54].Trim();
                string validadeCnh       = strsplit[56].Trim();
                string pontuacao         = strsplit[58].Trim();
                string nomePai           = strsplit[119].Trim();
                string nomeMae           = strsplit[120].Trim();
                string placa             = strsplit[144].Replace(" 7107 - SAO PAULO", "").Trim();
                string municipioPlaca    = strsplit[144].Replace("gge4223  ", "").Trim();
                string renavam           = strsplit[146].Replace("  9AAAAVAU0J4001600 ", "").Trim();
                string chassi            = strsplit[146].Replace("01172566666  ", "").Trim();
                string numMotor          = strsplit[148].Replace("  22/11/18 00", "").Trim();
                string dataAltMotor      = strsplit[148].Replace("CWL031481  ", "").Trim();
                string tipo              = strsplit[151].Replace(" 1 - IMPORTADO 16 - ALCO/GASOL", "").Trim();
                string procedencia       = strsplit[151].Replace("6 - AUTOMOVEL ", "").Replace(" 16 - ALCO/GASOL ", "").Trim();
                string combustivel       = strsplit[151].Replace("6 - AUTOMOVEL 1 - IMPORTADO ", "").Trim();
                string cor               = strsplit[153].Replace("  162801 – VARIANT GL ", "").Trim();
                string marcaModelo       = strsplit[153].Replace("4 - BRANCA  162801 – ", "").Trim();
                string categoriaAut      = strsplit[155].Replace(" 1971 1972 ", "").Trim();
                string anoFab            = strsplit[155].Replace("1 - PARTICULAR ", "").Replace(" 1972 ", "").Trim();
                string anoMod            = strsplit[155].Replace("1 - PARTICULAR 1971 ", "").Trim();
                string logradouro        = strsplit[166].Replace("  00121 ", "").Trim();
                string numero            = strsplit[166].Replace("AV LINS DE VASCONCELOS  ", "").Trim();
                string complemento       = strsplit[182].Replace("  010006-010 ", "").Trim();
                string cep               = strsplit[182].Replace("4 ANDAR  ", "").Trim();
                string bairro            = strsplit[184].Replace(" 7107 - SAO PAULO SP ", "").Trim();
                string licenciamento     = strsplit[225].Replace("   07/03/2019 ", "").Trim();
                string dataLicenciamento = strsplit[225].Replace("2019   ", "").Trim();
                string dataEmissaoCRV    = strsplit[227].Trim();

                DetranModel objDen = new DetranModel();
                objDen.CNPJCPF             = long.Parse(cpf.Replace(".", "").Replace("-", ""));
                objDen.RG                  = rg;
                objDen.Expeditor           = expeditor;
                objDen.Registro            = registro;
                objDen.Local               = local;
                objDen.PID                 = espelhoPid;
                objDen.EmissaoCnh          = emissaoCnh;
                objDen.Categoria           = categoria;
                objDen.PrimeiraHabilitação = primeiraHab;
                objDen.StatusCnh           = statusCnh;
                objDen.Renach              = renach;
                objDen.EspelhoCnh          = espelhoCnh;
                objDen.ValidadeCnh         = validadeCnh;
                objDen.Pontuacao           = pontuacao;
                objDen.NomePai             = nPai;
                objDen.NomeMae             = nMae;
                objDen.Placa               = placa;
                objDen.MunicipioCarro      = municipioPlaca;
                objDen.Renavam             = renavam;
                objDen.Chassi              = chassi;
                objDen.NumMotor            = numMotor;
                objDen.DataAltMotor        = dataAltMotor;
                objDen.Tipo                = tipo;
                objDen.Procedencia         = procedencia;
                objDen.Combustivel         = combustivel;
                objDen.Cor                 = cor;
                objDen.MarcaModelo         = marcaModelo;
                objDen.CategoriaAut        = categoriaAut;
                objDen.Fabricacao          = anoFab;
                objDen.Modelo              = anoMod;
                objDen.Logradouro          = logradouro;
                objDen.Numero              = numero;
                objDen.Complemento         = complemento;
                objDen.CEP                 = cep;
                objDen.Bairro              = bairro;
                objDen.Licenciamento       = licenciamento;
                objDen.DataLicenciamento   = dataLicenciamento;
                objDen.DataEmissaoCRV      = dataEmissaoCRV;

                detranRepository.Insert(objDen);

                string objjsonData = JsonConvert.SerializeObject(objDen, new JsonSerializerSettings {
                    Formatting = Formatting.Indented
                });

                //System.IO.File.WriteAllText(@"C:\Users\favar\Desktop\Texto\Detran.txt", objjsonData);

                return(objjsonData);
            }
        }
Esempio n. 5
0
        public override CrawlerStatus Execute(out object result)
        {
            try
            {
                using (var driver = WebDriverService.CreateWebDriver(WebBrowser.Firefox))
                {
                    var lastTab  = driver.WindowHandles.Last();
                    var firstTab = driver.WindowHandles.First();
                    var data     = DateTime.Now.ToString("yyyyMMddhhmm", System.Globalization.CultureInfo.InvariantCulture);

                    driver.Navigate().GoToUrl(@"http://ec2-18-231-116-58.sa-east-1.compute.amazonaws.com/detran/login.html");

                    // page 1
                    driver.FindElement(By.Id("form:j_id563205015_44efc1ab")).SendKeys(_usuario);
                    driver.FindElement(By.Id("form:j_id563205015_44efc191")).SendKeys(_senha);
                    driver.FindElement(By.Id("form:j_id563205015_44efc15b")).Click();

                    var resultado = new DetranModel();

                    if (_tipo.Equals("Physical"))
                    {
                        // page 2

                        Actions builder1      = new Actions(driver);
                        var     menuDropDown1 = driver.FindElement(By.Id("navigation_a_M_16"));
                        builder1.MoveToElement(menuDropDown1).Build().Perform();
                        //Thread.Sleep(5000);
                        driver.FindElement(By.Id("navigation_a_F_16")).Click();

                        // page 3
                        // TODO: INSERIR MAIS DADOS PESSOAIS DE BUSCA
                        driver.FindElement(By.Id("form:cpf")).SendKeys(_cpf);
                        driver.FindElement(By.Id("form:rg")).SendKeys(_rg);
                        driver.FindElement(By.CssSelector("#form\\:j_id2049423534_c43228e_content > table:nth-child(3) > tbody > tr > td > a")).Click();

                        // page 4 - Capturar dados 1
                        // indo para a janela aberta
                        lastTab = driver.WindowHandles.Last();
                        driver.SwitchTo().Window(lastTab);
                        var nameFileLinhaVida = $"{_pathTemp}/linhadeVida-{data}.pdf";
                        client.DownloadFileAsync(new Uri(driver.Url), nameFileLinhaVida);

                        // fechando a janela aberta
                        driver.Close();

                        // page 3
                        // voltando para a janela anterior
                        driver.SwitchTo().Window(firstTab);

                        Actions builder2      = new Actions(driver);
                        var     menuDropDown2 = driver.FindElement(By.Id("navigation_a_M_16"));
                        builder2.MoveToElement(menuDropDown2).Build().Perform();
                        driver.FindElement(By.CssSelector("#navigation_ul_M_16 > li:nth-child(2) > a:nth-child(1)")).Click();

                        // page 4
                        driver.FindElement(By.Id("form:cpf")).SendKeys(_cpf);
                        driver.FindElement(By.CssSelector("a.ui-button > span:nth-child(1)")).Click();

                        // page 5 - Capturar dados 2

                        lastTab = driver.WindowHandles.Last();
                        driver.SwitchTo().Window(lastTab);

                        var resultadoRenach       = driver.FindElement(By.CssSelector("#form\\:pnCNH > tbody:nth-child(1) > tr:nth-child(2) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(2) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(1) > span:nth-child(2)")).Text.Trim();
                        var resultadoCategoria    = driver.FindElement(By.CssSelector("#form\\:pnCNH > tbody:nth-child(1) > tr:nth-child(2) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(2) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(2) > span:nth-child(2)")).Text.Trim();
                        var resultadoEmissão      = driver.FindElement(By.CssSelector("#form\\:pnCNH > tbody:nth-child(1) > tr:nth-child(2) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(2) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(3) > span:nth-child(2)")).Text.Trim();
                        var resultadoNascimento   = driver.FindElement(By.CssSelector("#form\\:pnCNH > tbody:nth-child(1) > tr:nth-child(2) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(2) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(4) > span:nth-child(2)")).Text.Trim();
                        var resultadoNomeCondutor = driver.FindElement(By.CssSelector("#form\\:pnCNH > tbody:nth-child(1) > tr:nth-child(2) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(2) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(2) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(2) > td:nth-child(1) > span:nth-child(1)")).Text.Trim();
                        var resultadoNomePai      = driver.FindElement(By.CssSelector("#form\\:pnCNH > tbody:nth-child(1) > tr:nth-child(2) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(2) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(3) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(2) > td:nth-child(1) > span:nth-child(1)")).Text.Trim();
                        var resultadoNomeMae      = driver.FindElement(By.CssSelector("#form\\:pnCNH > tbody:nth-child(1) > tr:nth-child(2) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(2) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(4) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(2) > td:nth-child(1) > span:nth-child(1)")).Text.Trim();
                        var resultadoRegistro     = driver.FindElement(By.CssSelector("#form\\:pnCNH > tbody:nth-child(1) > tr:nth-child(2) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(2) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(5) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(1) > span:nth-child(2)")).Text.Trim();
                        var resultadoTipografico  = driver.FindElement(By.CssSelector("#form\\:pnCNH > tbody:nth-child(1) > tr:nth-child(2) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(2) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(5) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(2) > span:nth-child(2)")).Text.Trim();
                        var resultadoRg           = driver.FindElement(By.CssSelector("#form\\:pnCNH > tbody:nth-child(1) > tr:nth-child(2) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(2) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(5) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(3) > span:nth-child(2)")).Text.Trim();
                        var resultadoCpf          = driver.FindElement(By.CssSelector("#form\\:pnCNH > tbody:nth-child(1) > tr:nth-child(2) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(2) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(5) > td:nth-child(1) > table:nth-child(1) > tbody:nth-child(1) > tr:nth-child(1) > td:nth-child(4) > span:nth-child(2)")).Text.Trim();
                        try
                        {
                            var fotoSrc       = driver.FindElement(By.Id("form:imgFoto")).GetAttribute("src");
                            var assinaturaSrc = driver.FindElement(By.Id("form:imgAssinatura")).GetAttribute("src");

                            //var rndPicture = new Random();
                            //var nextRndPicture = rndPicture.Next(1000, 10001);

                            var nameFileFoto = $@"{_pathTemp}/foto_{data}.png";
                            client.DownloadFile(new Uri(fotoSrc), nameFileFoto);
                            var nameFileAssinatura = $@"{_pathTemp}/assinatura_{data}.png";
                            client.DownloadFileAsync(new Uri(assinaturaSrc), nameFileAssinatura);

                            #region Objeto com os dados capturados
                            resultado = new DetranModel
                            {
                                Renach     = resultadoRenach,
                                Categoria  = resultadoCategoria,
                                Emissao    = resultadoEmissão,
                                Nascimento = resultadoNascimento,
                                Nome       = resultadoNomeCondutor,
                                NomePai    = resultadoNomePai,
                                NomeMae    = resultadoNomeMae,
                                Registro   = resultadoRegistro,
                                Tipografo  = resultadoTipografico,
                                RG         = resultadoRg,
                                CPF        = resultadoCpf,
                                Arquivo1   = nameFileLinhaVida,
                                Imagem1    = nameFileFoto,
                                Imagem2    = nameFileAssinatura,
                            };
                            #endregion
                        }
                        catch (Exception e)
                        {
                            Console.WriteLine("[DETRAN] Ocorreu um erro ao tentar baixar as Imagens! \nMensagem de erro: " + e);
                            result = null;
                            return(CrawlerStatus.Skipped);
                        }

                        // page 6
                        // voltando para a janela anterior
                        driver.Close();
                        firstTab = driver.WindowHandles.First();
                        driver.SwitchTo().Window(firstTab);
                    }

                    Actions builder3      = new Actions(driver);
                    var     menuDropDown3 = driver.FindElement(By.Id("navigation_a_M_18"));
                    builder3.MoveToElement(menuDropDown3).Build().Perform();
                    driver.FindElement(By.CssSelector("#navigation_a_F_18")).Click();

                    // page 7
                    if (_cpf != null)
                    {
                        driver.FindElement(By.Id("form:j_id2124610415_1b3be1e3")).SendKeys(_cpf);
                    }

                    if (_cnpj != null)
                    {
                        driver.FindElement(By.Id("form:j_id2124610415_1b3be1e3")).SendKeys(_cnpj);
                    }

                    driver.FindElement(By.CssSelector("a.ui-button > span:nth-child(1)")).Click();


                    // page 8 - Capturar dados 3
                    lastTab = driver.WindowHandles.Last();
                    driver.SwitchTo().Window(lastTab);
                    var nameFileVeiculo = $@"{_pathTemp}/relatorioveiculo_{data}.pdf";
                    client.DownloadFileAsync(new Uri(driver.Url), nameFileVeiculo);

                    driver.Close();

                    firstTab = driver.WindowHandles.First();
                    driver.SwitchTo().Window(firstTab);
                    driver.Close();

                    if (_tipo.Equals("Physical"))
                    {
                        resultado.Arquivo2 = nameFileVeiculo;
                    }
                    else
                    {
                        #region Objeto com os dados capturados
                        resultado = new DetranModel
                        {
                            Arquivo2 = nameFileVeiculo
                        };
                        #endregion
                    }

                    Console.WriteLine("DetranCrawler OK");
                    result = resultado;
                    return(CrawlerStatus.Success);
                }
            }
            catch (NotSupportedException e)
            {
                Console.WriteLine("Fail loading browser caught: {0}", e.Message);
                SetErrorMessage(typeof(DetranCrawler), e.Message);
                result = null;
                return(CrawlerStatus.Skipped);
            }
            catch (Exception e)
            {
                Console.WriteLine("Exception caught: {0}", e.Message);
                SetErrorMessage(typeof(DetranCrawler), e.Message);
                result = null;
                return(CrawlerStatus.Error);
            }
        }
Esempio n. 6
0
        public ActionResult RelatorioSimplificado(PesquisaCPFCNPJ pesquisaCPFCNPJ)
        {
            string arpensp = "";
            string cadesp  = "";
            string caged   = "";
            string censec  = "";
            string detran  = "";
            string juscesp = "";
            string siel    = "";
            string sivec   = "";

            if (pesquisaCPFCNPJ.Arpensp == "on")
            {
                arpensp = webScraping.Arpensp(pesquisaCPFCNPJ);
            }
            if (pesquisaCPFCNPJ.Cadesp == "on")
            {
                cadesp = webScraping.Cadesp(pesquisaCPFCNPJ);
            }
            if (pesquisaCPFCNPJ.Caged == "on")
            {
                caged = webScraping.Caged(pesquisaCPFCNPJ);
            }
            if (pesquisaCPFCNPJ.Censec == "on")
            {
                censec = webScraping.Censec(pesquisaCPFCNPJ);
            }
            if (pesquisaCPFCNPJ.Jucesp == "on")
            {
                juscesp = webScraping.Jucesp(pesquisaCPFCNPJ);
            }
            if (pesquisaCPFCNPJ.Detran == "on")
            {
                detran = webScraping.Detran(pesquisaCPFCNPJ);
            }
            if (pesquisaCPFCNPJ.Siel == "on")
            {
                siel = webScraping.Siel(pesquisaCPFCNPJ);
            }
            if (pesquisaCPFCNPJ.Sivec == "on")
            {
                sivec = webScraping.Sivec(pesquisaCPFCNPJ);
            }



            ArpenspModel arpenspModel = relatorioSimplificadoRepository.SimplesArpensp(arpensp);
            CadespModel  cadespModel  = relatorioSimplificadoRepository.SimplesCadesp(cadesp);
            JucespModel  jucespModel  = relatorioSimplificadoRepository.SimplesJucesp(juscesp);
            CagedModel   cagedModel   = relatorioSimplificadoRepository.SimplesCaged(caged);
            DetranModel  detranModel  = relatorioSimplificadoRepository.SimplesDetran(detran);
            CensecModel  censecModel  = relatorioSimplificadoRepository.SimplesCensec(censec);
            SielModel    sielModel    = relatorioSimplificadoRepository.SimplesSiel(siel);
            SivecModel   sivecModel   = relatorioSimplificadoRepository.SimplesSivec(sivec);

            consultaAnteriorRepository.Insert(pesquisaCPFCNPJ);

            return(View(new PesquisaCPFCNPJ()
            {
                ArpenspModel = arpenspModel, CadespModel = cadespModel, JucespModel = jucespModel, CagedModel = cagedModel, DetranModel = detranModel, CensecModel = censecModel, SielModel = sielModel, SivecModel = sivecModel
            }));
        }
        public DetranModel SimplesDetran(string detran)
        {
            DetranModel detranModel = JsonConvert.DeserializeObject <DetranModel>(detran);

            return(detranModel);
        }