public void Insert(CadespModel cadespModel) { using (context) { context.Cadesp.Add(cadespModel); context.SaveChanges(); } }
public CadespModel getCadesp(string cnpj) { string uri = "http://10.0.2.2:8080/cadesp/cnpj?cnpj=" + cnpj; CadespModel cadesp = new CadespModel(); System.Net.Http.HttpClient client = new HttpClient(); var resposta = client.GetAsync(uri).Result; if (resposta.IsSuccessStatusCode) { var resultado = resposta.Content.ReadAsStringAsync().Result; cadesp = JsonConvert.DeserializeObject <CadespModel>(resultado); return(cadesp); } else { throw new Exception("Dados não encontrados"); } }
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/cadesp/login.html"); // page 1 driver.FindElement(By.Id("ctl00_conteudoPaginaPlaceHolder_loginControl_UserName")).SendKeys("1"); driver.FindElement(By.Id("ctl00_conteudoPaginaPlaceHolder_loginControl_Password")).SendKeys("1"); driver.FindElement(By.CssSelector("ctl00_conteudoPaginaPlaceHolder_loginControl_loginButton")).Click(); // page 2 Actions actionPage2 = new Actions(driver); var menuDropDown = driver.FindElement(By.CssSelector("#ctl00_menuPlaceHolder_menuControl1_LoginView1_menuSuperiorn1 > table")); actionPage2.MoveToElement(menuDropDown).Build().Perform(); driver.FindElement(By.CssSelector("#ctl00_menuPlaceHolder_menuControl1_LoginView1_menuSuperiorn1 > table > tbody > tr > td > a")).Click(); // page 3 driver.FindElement(By.Id("ctl00_conteudoPaginaPlaceHolder_tcConsultaCompleta_TabPanel1_txtIdentificacao")).SendKeys(_cnpj); driver.FindElement(By.Id("ctl00_conteudoPaginaPlaceHolder_tcConsultaCompleta_TabPanel1_btnConsultarEstabelecimento")).Click(); // page 4 - Capturar dados var downloadFolderPath = $@"{AppDomain.CurrentDomain.BaseDirectory}temp\cadesp\"; if (!Directory.Exists(downloadFolderPath)) { Directory.CreateDirectory(downloadFolderPath); } var data = DateTime.Now.ToString("yyyyMMddhhmm", System.Globalization.CultureInfo.InvariantCulture); var arquivo = $@"{downloadFolderPath}{_cnpj}_{data}.png"; try { Screenshot screenshot = ((ITakesScreenshot)driver).GetScreenshot(); screenshot.SaveAsFile(arquivo, ScreenshotImageFormat.Png); } catch (Exception e) { Console.WriteLine("[CADESP] Ocorreu um erro ao capturara a tela! \nMensagem de erro: " + e); result = null; return(CrawlerStatus.Skipped); } var cadespResult = new CadespModel { Imagem = arquivo }; result = cadespResult; driver.Close(); Console.WriteLine("CadespCrawler OK"); return(CrawlerStatus.Success); } } catch (NotSupportedException e) { Console.WriteLine("Fail loading browser caught: {0}", e.Message); SetErrorMessage(typeof(CadespCrawler), e.Message); result = null; return(CrawlerStatus.Skipped); } catch (Exception e) { Console.WriteLine("Exception caught: {0}", e.Message); SetErrorMessage(typeof(CadespCrawler), e.Message); result = null; return(CrawlerStatus.Error); } }
//Cadesp public string Cadesp(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/cadesp/login.html"); driver.FindElement(By.Id("ctl00_conteudoPaginaPlaceHolder_loginControl_UserName")).SendKeys("fiap"); driver.FindElement(By.Id("ctl00_conteudoPaginaPlaceHolder_loginControl_Password")).SendKeys("mpsp"); driver.FindElement(By.Id("ctl00_conteudoPaginaPlaceHolder_loginControl_Password")).SendKeys(Keys.Enter); //driver.FindElement(By.XPath("//*[@id='ctl00_menuPlaceHolder_menuControl1_LoginView1_menuSuperiorn1']/table/tbody/tr/td/a")).Click(); driver.Navigate().GoToUrl("http://ec2-18-231-116-58.sa-east-1.compute.amazonaws.com/cadesp/pagina3-pesquisa.html"); driver.FindElement(By.Id("ctl00_conteudoPaginaPlaceHolder_tcConsultaCompleta_TabPanel1_txtIdentificacao")).SendKeys(pesquisaCPFCNPJ.CPFCNPJ.ToString()); driver.FindElement(By.Id("ctl00_conteudoPaginaPlaceHolder_tcConsultaCompleta_TabPanel1_btnConsultarEstabelecimento")).SendKeys(Keys.Enter); var resultado1 = driver.FindElement(By.XPath("//*[@id='ctl00_conteudoPaginaPlaceHolder_dlCabecalho']/tbody/tr/td/table")).Text; var resultado = driver.FindElement(By.XPath("//*[@id='ctl00_conteudoPaginaPlaceHolder_dlEstabelecimentoGeral']/tbody/tr[2]/td")).Text; var resultadoFinal = resultado1 + resultado; string[] strsplit = resultadoFinal.Replace("\r\n", ":").Split(':'); string ie = strsplit[1].Replace("Situação", "").Trim(); string situacao = strsplit[2].Trim(); string cnpj = strsplit[4].Replace("Data da Inscrição no Estado", "").Trim(); string dataInscricao = strsplit[5].Trim(); string nomeEmpresarial = strsplit[7].Replace("Regime Estadual", "").Trim(); string regimeEstadual = strsplit[8].Trim(); string drt = strsplit[10].Replace("Posto Fiscal", "").Trim(); string postoFiscal = strsplit[11].Trim(); string nire = strsplit[21].Trim(); string ocorrenciaFiscal = strsplit[26].Trim(); string tipoUnidade = strsplit[28].Replace("Formas de Atuação", "").Trim(); string formaAtuacao = strsplit[30].Trim(); CadespModel objCad = new CadespModel(); objCad.IE = ie; objCad.Situacao = situacao; objCad.CNPJ = long.Parse(cnpj.Replace(".", "").Replace("/", "").Replace("-", "")); objCad.DataInscricao = dataInscricao; objCad.NomeEmpresarial = nomeEmpresarial; objCad.RegimeEstadual = regimeEstadual; objCad.DRT = drt; objCad.PostoFiscal = postoFiscal; objCad.Nire = nire; objCad.OcorrenciaFiscal = ocorrenciaFiscal; objCad.TipoUnidade = tipoUnidade; objCad.FormasAtuacao = formaAtuacao; cadespRepository.Insert(objCad); string objjsonData = JsonConvert.SerializeObject(objCad, new JsonSerializerSettings { Formatting = Formatting.Indented }); return(objjsonData); } }
//Cadesp public JsonResult WebScrapingCadesp() { using (IWebDriver driver = new ChromeDriver()) { /*driver.Manage().Window.Maximize(); * driver.Navigate().GoToUrl("http://ec2-18-231-116-58.sa-east-1.compute.amazonaws.com/ "); * driver.FindElement(By.Id("username")).SendKeys("fiap"); * driver.FindElement(By.Id("password")).SendKeys("mpsp"); * driver.FindElement(By.Id("password")).SendKeys(Keys.Enter); */ Actions builder = new Actions(driver); driver.Navigate().GoToUrl("http://ec2-18-231-116-58.sa-east-1.compute.amazonaws.com/cadesp/login.html"); driver.FindElement(By.Id("ctl00_conteudoPaginaPlaceHolder_loginControl_UserName")).SendKeys("fiap"); driver.FindElement(By.Id("ctl00_conteudoPaginaPlaceHolder_loginControl_Password")).SendKeys("mpsp"); driver.FindElement(By.Id("ctl00_conteudoPaginaPlaceHolder_loginControl_Password")).SendKeys(Keys.Enter); //driver.FindElement(By.XPath("//*[@id='ctl00_menuPlaceHolder_menuControl1_LoginView1_menuSuperiorn1']/table/tbody/tr/td/a")).Click(); driver.Navigate().GoToUrl("http://ec2-18-231-116-58.sa-east-1.compute.amazonaws.com/cadesp/pagina3-pesquisa.html"); driver.FindElement(By.Id("ctl00_conteudoPaginaPlaceHolder_tcConsultaCompleta_TabPanel1_txtIdentificacao")).SendKeys("54545454545454"); driver.FindElement(By.Id("ctl00_conteudoPaginaPlaceHolder_tcConsultaCompleta_TabPanel1_btnConsultarEstabelecimento")).SendKeys(Keys.Enter); var resultado1 = driver.FindElement(By.XPath("//*[@id='ctl00_conteudoPaginaPlaceHolder_dlCabecalho']/tbody/tr/td/table")).Text; var resultado = driver.FindElement(By.XPath("//*[@id='ctl00_conteudoPaginaPlaceHolder_dlEstabelecimentoGeral']/tbody/tr[2]/td")).Text; var resultadoFinal = resultado1 + resultado; string[] strsplit = resultadoFinal.Replace("\r\n", ":").Split(':'); string ie = strsplit[1].Replace("Situação", ""); string situacao = strsplit[2]; string cnpj = strsplit[4].Replace("Data da Inscrição no Estado", ""); string dataInscricao = strsplit[5]; string nomeEmpresarial = strsplit[7].Replace("Regime Estadual", ""); string regimeEstadual = strsplit[8]; string drt = strsplit[10].Replace("Posto Fiscal", ""); string postoFiscal = strsplit[11]; string nire = strsplit[21]; string ocorrenciaFiscal = strsplit[26]; string tipoUnidade = strsplit[28].Replace("Formas de Atuação", ""); string formaAtuacao = strsplit[30]; CadespModel objCad = new CadespModel(); objCad.IE = ie; objCad.Situacao = situacao; objCad.CNPJ = cnpj; objCad.DataInscricao = dataInscricao; objCad.NomeEmpresarial = nomeEmpresarial; objCad.RegimeEstadual = regimeEstadual; objCad.DRT = drt; objCad.PostoFiscal = postoFiscal; objCad.Nire = nire; objCad.OcorrenciaFiscal = ocorrenciaFiscal; objCad.TipoUnidade = tipoUnidade; objCad.FormasAtuacao = formaAtuacao; string objjsonData = JsonConvert.SerializeObject(objCad, new JsonSerializerSettings { Formatting = Formatting.Indented }); Response.Write(objjsonData); //System.IO.File.WriteAllText(@"C:\Users\Nicolas PC\Desktop\teste\Cadesp.txt", resultado1 + resultado); System.IO.File.WriteAllText(@"C:\Users\nperes\Desktop\Projeto\Arquivos\Cadesp.txt", objjsonData); return(Json(objjsonData, JsonRequestBehavior.AllowGet)); } }
public PessoaJuridicaViewModel() { PesquisarClickedCommand = new Command(() => { var pessoaJuridicaBusiness = new PessoaJuridicaBusiness(); //Instanciando business para acessar a service e pegar dados da api var service = pessoaJuridicaBusiness.getService(); //atribuiu o objeto service a uma variavel para fazer as chamadas das API dentros dos IF conforme resultados do Picker var relatorio = new RelatorioViewModel(); // instancia relatorio para envio das informações para a tela //validação CNPJ NULO if (String.IsNullOrEmpty(cnpj) == true) { DependencyService.Get <IMessage>().ShortAlert("Por favor digite seu CNPJ"); } else { //Validação Picker Nulo if (baseDados == null) { DependencyService.Get <IMessage>().ShortAlert("Por favor selecione ao menos uma base de dados para consulta"); } else { if (baseDados == "Todos") { JucespModel jucesp = new JucespModel(); jucesp = service.getJucesp(cnpj); relatorio.Resultado = jucesp.ToString(); CadespModel cadesp = new CadespModel(); cadesp = service.getCadesp(cnpj); relatorio.Resultado += cadesp.ToString(); GlobalViewModel.Relatorio = relatorio;// manda os dados para a global, fazendo a RelatorioViewModel enxergar string sourceImage1 = service.getArisp(cnpj); relatorio.NomeImage = "------ARISP----"; relatorio.Image = sourceImage1; string sourceImage2 = service.getInfocrim(cnpj); relatorio.NomeImage2 = "------INFOCRIM----"; relatorio.Image2 = sourceImage2; GlobalViewModel.Relatorio = relatorio; } if (baseDados == "Jucesp") { JucespModel jucesp = new JucespModel(); jucesp = service.getJucesp(cnpj); relatorio.Resultado = jucesp.ToString(); GlobalViewModel.Relatorio = relatorio; } if (baseDados == "Cadesp") { CadespModel cadesp = new CadespModel(); cadesp = service.getCadesp(cnpj); relatorio.Resultado = cadesp.ToString(); GlobalViewModel.Relatorio = relatorio; } if (baseDados == "Arisp") { string sourceImage1 = service.getArisp(cnpj); relatorio.NomeImage = "------ARISP----"; relatorio.Image = sourceImage1; GlobalViewModel.Relatorio = relatorio; } if (baseDados == "Infocrim") { string sourceImage2 = service.getInfocrim(cnpj); relatorio.NomeImage = "------INFOCRIM----"; relatorio.Image = sourceImage2; GlobalViewModel.Relatorio = relatorio; } MessagingCenter.Send <PessoaJuridicaViewModel>(this, "RelatorioPageAbrir"); } } }); }
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 CadespModel SimplesCadesp(string cadesp) { CadespModel cadespModel = JsonConvert.DeserializeObject <CadespModel>(cadesp); return(cadespModel); }