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);
}
