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(SielModel sielModel) { using (context) { context.Siel.Add(sielModel); context.SaveChanges(); } }
public SielModel Siel(int cpfcnpj) { var siel = new Service.PesquisaService().Siel(cpfcnpj); SielModel sielModel = JsonConvert.DeserializeObject <SielModel>(siel); //variavel global Global.Siel = sielModel; return(sielModel); }
public string Siel(PesquisaCPFCNPJ pesquisaCPFCNPJ) { var options = new ChromeOptions(); options.AddArguments("headless"); 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/siel/login.html"); driver.FindElement(By.XPath("//html/body/div[1]/div[1]/div[4]/form/table/tbody/tr[3]/td[2]/input")).Click(); driver.FindElement(By.XPath("/html/body/div[1]/div[1]/div[4]/form[2]/fieldset[1]/table/tbody/tr[1]/td[2]/input")).SendKeys(pesquisaCPFCNPJ.Nome); driver.FindElement(By.XPath("/html/body/div[1]/div[1]/div[4]/form[2]/fieldset[2]/table[1]/tbody/tr/td[2]/input")).Click(); driver.FindElement(By.XPath("/html/body/div[1]/div[1]/div[4]/form[1]/div[2]/table/tbody/tr/td/p")).Click(); driver.FindElement(By.XPath("/html/body/div[1]/div[1]/div[4]/form[2]/fieldset[2]/table[1]/tbody/tr/td[2]/input")).SendKeys(pesquisaCPFCNPJ.Processo); driver.FindElement(By.XPath("/html/body/div[1]/div[1]/div[4]/form[2]/table/tbody/tr/td[2]/input")).Click(); string tabela = driver.FindElement(By.XPath("/html/body/div[1]/div[1]/div[4]/table")).Text; string[] strsplit = tabela.Replace("\r\n", ":").Split(':'); string titulo = strsplit[2].Replace("Título ", "").Trim(); string zona = strsplit[4].Replace("Zona ", "").Trim(); string dataDomicilio = strsplit[8].Replace("Data Domicílio ", "").Trim(); SielModel objSiel = new SielModel(); objSiel.CNPJSiel = pesquisaCPFCNPJ.CPFCNPJ; objSiel.Titulo = titulo; objSiel.Zona = zona; objSiel.DataDomicilio = dataDomicilio; sielRepository.Insert(objSiel); string objjsonData = JsonConvert.SerializeObject(objSiel); //System.IO.File.WriteAllText(@"C:\Users\favar\Desktop\Texto\SielSaida.txt", objjsonData); return(objjsonData); } }
public override CrawlerStatus Execute(out object result) { try { using (var driver = WebDriverService.CreateWebDriver(WebBrowser.Firefox)) { driver.Navigate().GoToUrl(@"http://ec2-18-231-116-58.sa-east-1.compute.amazonaws.com/siel/login.html"); // page 1 - Login // Inserir usuário e senha -> Clicar em Enviar driver.FindElement(By.CssSelector("div.mioloInterna.apps > form > table > tbody > tr:nth-child(1) > td:nth-child(2) > input[type=text]")).SendKeys(_usuario); driver.FindElement(By.CssSelector("div.mioloInterna.apps > form > table > tbody > tr:nth-child(2) > td:nth-child(2) > input[type=password]")).SendKeys(_senha); driver.FindElement(By.CssSelector("div.mioloInterna.apps > form > table > tbody > tr:nth-child(3) > td:nth-child(2) > input[type=submit]")).Click(); // page 2 - Pesquisa // Inserir Nome e Número do processo -> Clicar em Enviar if (!string.IsNullOrEmpty(_nomeCompleto) && !string.IsNullOrEmpty(_nomeDaMae) && !string.IsNullOrEmpty(_dataNascimento)) { driver.FindElement(By.CssSelector("form.formulario > fieldset:nth-child(1) > table > tbody > tr:nth-child(1) > td:nth-child(2) > input[type=text]")).SendKeys(_nomeCompleto); driver.FindElement(By.CssSelector("form.formulario > fieldset:nth-child(1) > table > tbody > tr:nth-child(2) > td:nth-child(2) > input[type=text]")).SendKeys(_nomeDaMae); driver.FindElement(By.CssSelector("form.formulario > fieldset:nth-child(1) > table > tbody > tr:nth-child(3) > td:nth-child(2) > input[type=text]")).SendKeys(_dataNascimento); } if (!string.IsNullOrEmpty(_tituloEleitor)) { driver.FindElement(By.CssSelector("form.formulario > fieldset:nth-child(1) > table > tbody > tr:nth-child(4) > td:nth-child(2) > input[type=text]")).SendKeys(_tituloEleitor); } driver.FindElement(By.Id("num_processo")).SendKeys(_numeroProcesso); driver.FindElement(By.CssSelector("form.formulario > table > tbody > tr > td:nth-child(2) > input")).Click(); // page 3 - Capturar dados var dados = driver.FindElements(By.CssSelector(".lista tbody > tr > td:nth-child(2)")); #region Objeto com os dados capturados var resultado = new SielModel { Nome = dados[0].Text, Titulo = dados[1].Text, DataNascimento = dados[2].Text, Zona = dados[3].Text, Endereco = dados[4].Text, Municipio = dados[5].Text, UF = dados[6].Text, DataDomicilio = dados[7].Text, NomePai = dados[8].Text, NomeMae = dados[9].Text, Naturalidade = dados[10].Text, CodValidacao = dados[11].Text }; #endregion result = resultado; driver.Close(); Console.WriteLine("SielCrawler OK"); return(CrawlerStatus.Success); } } catch (NotSupportedException e) { Console.WriteLine("Fail loading browser caught: {0}", e.Message); SetErrorMessage(typeof(SielCrawler), e.Message); result = null; return(CrawlerStatus.Skipped); } catch (Exception e) { Console.WriteLine("Exception caught: {0}", e.Message); SetErrorMessage(typeof(SielCrawler), 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 SielModel SimplesSiel(string siel) { SielModel sielModel = JsonConvert.DeserializeObject <SielModel>(siel); return(sielModel); }