public void AtualizaInfoDeputados()
{
var ws = new CamaraWS.Deputados();
XmlNode deputados = ws.ObterDeputados();
XmlNodeList deputado = deputados.SelectNodes("*");
StringBuilder sqlFields = new StringBuilder();
using (var banco = new Banco())
{
foreach (XmlNode fileNode in deputado)
{
sqlFields.Clear();
foreach (XmlNode item in fileNode.SelectNodes("*"))
{
var nodeName = item.Name;
if (nodeName == "ideCadastro")
{
banco.AddParameter(nodeName, item.InnerText.ToUpper());
}
else if (nodeName != "comissoes")
{
if (nodeName == "nomeParlamentar")
{
nodeName = "txNomeParlamentar";
}
//sqlFields.Append(string.Format(",{0}='{1}'", nodeName, item.InnerText.ToUpper()));
sqlFields.Append(string.Format(",{0}=@{0}", nodeName));
banco.AddParameter(nodeName, item.InnerText.ToUpper());
}
}
banco.ExecuteNonQuery("UPDATE parlamentares SET " + sqlFields.ToString().Substring(1) + " WHERE ideCadastro=@ideCadastro");
}
}
}
public void AtualizaInfoDeputados()
{
var ws = new CamaraWS.Deputados();
XmlNode deputados = ws.ObterDeputados();
XmlNodeList deputado = deputados.SelectNodes("*");
StringBuilder sqlFields = new StringBuilder();
using (var banco = new Banco())
{
foreach (XmlNode fileNode in deputado)
{
sqlFields.Clear();
foreach (XmlNode item in fileNode.SelectNodes("*"))
{
var nodeName = item.Name;
if (nodeName == "ideCadastro")
{
banco.AddParameter(nodeName, item.InnerText.ToUpper());
}
else if (nodeName != "comissoes")
{
if (nodeName == "nomeParlamentar")
nodeName = "txNomeParlamentar";
//sqlFields.Append(string.Format(",{0}='{1}'", nodeName, item.InnerText.ToUpper()));
sqlFields.Append(string.Format(",{0}=@{0}", nodeName));
banco.AddParameter(nodeName, item.InnerText.ToUpper());
}
}
banco.ExecuteNonQuery("UPDATE parlamentares SET " + sqlFields.ToString().Substring(1) + " WHERE ideCadastro=@ideCadastro");
}
}
}
