Builder.FeedWriter.WriteLocalities C# (CSharp) Method

WriteLocalities() public method

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

            OracleDataReader oDataReader = oCmd.ExecuteReader();

            while (oDataReader.Read()) {
                WriteStartElement("locality");
                _oXmlWriter.WriteAttributeString("id", oDataReader["id"].ToString());
                _oXmlWriter.WriteElementString("name", oDataReader["name"].ToString());
                _oXmlWriter.WriteElementString("state_id", oDataReader["state_id"].ToString());
                _oXmlWriter.WriteElementString("type", oDataReader["type"].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::WriteLocalities