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"); }); }
public void Insert(DetranModel detranModel) { using (context) { context.Detran.Add(detranModel); context.SaveChanges(); } }
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); }
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); } }
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); } }
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); }