public WritePrecincts ( OracleCommand oCmd ) : void | ||
oCmd | OracleCommand | |
return | void |
public void WritePrecincts(OracleCommand oCmd)
{
//OracleCommand oCmdPolling = new OracleCommand();
//oCmdPolling.Connection = oCmd.Connection;
//oCmdPolling.CommandType = CommandType.Text;
oCmd.CommandText = "select * from Table";
oCmd.CommandType = CommandType.Text;
OracleDataReader oDataReader = oCmd.ExecuteReader();
//OracleDataReader oPollingReader;
while (oDataReader.Read()) {
WriteStartElement("precinct");
_oXmlWriter.WriteAttributeString("id", oDataReader["id"].ToString());
_oXmlWriter.WriteElementString("name", oDataReader["name"].ToString());
_oXmlWriter.WriteElementString("locality_id", oDataReader["locality_id"].ToString());
// based on relationship between polling place and precinct
//oCmdPolling.CommandText = "";
//oPollingReader = oCmdPolling.ExecuteReader();
// if there is only one polling place per precinct, this may be unnecessary
/*while (oPollingReader.Read()) {
_oXmlWriter.WriteElementString("polling_location_id", oPollingReader["polling_location_id"].ToString());
}*/
if (oDataReader["polling_location_id"] != DBNull.Value) {
_oXmlWriter.WriteElementString("polling_location_id", oPollingReader["polling_location_id"].ToString());
}
WriteEndElement();
}
}
public static void Main(String[] args) { DateTime oScriptStart = DateTime.UtcNow; NameValueCollection oVipSettings = new NameValueCollection(); NameValueCollection oXmlSettings = ConfigurationManager.GetSection("xmlWriterSettings") as NameValueCollection; //NameValueCollection oElectionAdminSettings = ConfigurationManager.GetSection("electionOfficial") as NameValueCollection; oVipSettings.Add("ScriptStart", oScriptStart.ToString("yyyy-MM-ddTHH:mm:ss")); oVipSettings.Add(ConfigurationManager.GetSection("vipSettings") as NameValueCollection); FeedWriter oFeedWriter = new FeedWriter( oVipSettings.Get("FilePath"), oVipSettings.Get("StateFIPS"), oXmlSettings ); oFeedWriter.WriteStartElement("vip_object"); oFeedWriter.WriteHeader(oVipSettings); // this may not be necessary if the election_officials are stored in the db //oFeedWriter.WriteElementFromConfig("election_official", oElectionAdminSettings); try { oFeedWriter.WritePollingPlaces(); oFeedWriter.WriteStreetSegments(); oFeedWriter.WritePrecincts(); oFeedWriter.WritePrecinctSplits(); oFeedWriter.WriteLocalities(); } catch (Exception ex) { // TODO: Write success or failure to a text file Console.WriteLine(ex.Message.ToString()); } oFeedWriter.WriteEndElement(); }