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