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