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