Builder.FeedWriter.WritePrecincts C# (CSharp) Method

WritePrecincts() public method

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

Usage Example

Example #1
0
        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();
        }
All Usage Examples Of Builder.FeedWriter::WritePrecincts