static void Main(string[] args)
{
IEnumerable <Consulta> consultas;
using (contexto = new Context())
{
var itemQuery = contexto.Database.Connection.Query <Consulta>(Resources.query);
consultas = itemQuery;
}
foreach (var consulta in consultas)
{
StringBuilder builder = new StringBuilder();
builder.AppendFormat(Resources.consulta, consulta.cpf, consulta.datanascimento);
string texto = Resources.parte1 + builder.ToString() + Resources.parte2;
using (var writer = new StreamWriter(filePath, false))
{
writer.Write(texto);
}
using (var client = new WebClient())
{
var response = client.DownloadString(url);
XmlDocument doc = new XmlDocument();
doc.LoadXml(response);
XmlNodeList nodeErros = doc.GetElementsByTagName("Error");
if (nodeErros[0].HasChildNodes)
{
error = new Error
{
code = Convert.ToInt32(nodeErros[0].ChildNodes[0].InnerText),
message = nodeErros[0].ChildNodes[1].InnerText
};
ErrorRepository repository = new ErrorRepository();
repository.Insert(error);
}
else
{
XmlNodeList nodePessoa = doc.GetElementsByTagName("Pessoa");
if (nodePessoa[0].HasChildNodes)
{
pessoa = new Pessoa
{
cpf = nodePessoa[0].ChildNodes[0].InnerText,
nome = nodePessoa[0].ChildNodes[1].InnerText,
situacao = nodePessoa[0].ChildNodes[2].InnerText,
datanascimento = nodePessoa[0].ChildNodes[3].InnerText,
datainscricao = nodePessoa[0].ChildNodes[4].InnerText,
datahora = nodePessoa[0].ChildNodes[5].InnerText,
comprovante = nodePessoa[0].ChildNodes[6].InnerText,
status = Convert.ToInt32(nodePessoa[0].ChildNodes[7].InnerText),
message = nodePessoa[0].ChildNodes[8].InnerText,
fonte = Convert.ToInt32(nodePessoa[0].ChildNodes[9].InnerText)
};
PessoaRepository repository = new PessoaRepository();
repository.Insert(pessoa);
}
}
}
}
}
