Builder.FeedWriter.WritePollingPlaces C# (CSharp) Method

WritePollingPlaces() public method

public WritePollingPlaces ( OracleCommand oCmd ) : void
oCmd OracleCommand
return void
        public void WritePollingPlaces(OracleCommand oCmd)
        {
            oCmd.CommandText = "select * from Table";
            oCmd.CommandType = CommandType.Text;

            OracleDataReader oDataReader = oCmd.ExecuteReader();

            while (oDataReader.Read()) {
                WriteStartElement("polling_location");
                _oXmlWriter.WriteAttributeString("id", oDataReader["id"].ToString());
                WriteStartElement("address");

                if (oDataReader["location_name"] != DBNull.Value) {
                    _oXmlWriter.WriteElementString("location_name", oDataReader["location_name"].ToString());
                }

                _oXmlWriter.WriteElementString("line1", oDataReader["line1"].ToString());
                _oXmlWriter.WriteElementString("city", oDataReader["city"].ToString());
                _oXmlWriter.WriteElementString("state", oDataReader["state"].ToString());
                _oXmlWriter.WriteElementString("zip", oDataReader["zip"].ToString());
                WriteEndElement();

                if (oDataReader["directions"] != DBNull.Value) {
                    _oXmlWriter.WriteElementString("directions", oDataReader["directions"].ToString());
                }

                if (oDataReader["polling_hours"] != DBNull.Value) {
                    _oXmlWriter.WriteElementString("polling_hours", oDataReader["polling_hours"].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::WritePollingPlaces