Builder.FeedWriter.WriteStreetSegments C# (CSharp) Method

        public void WriteStreetSegments(OracleCommand oCmd)
        {
            String start_house = "";
            String end_house = "";

            oCmd.CommandText = "select * from Table";
            oCmd.CommandType = CommandType.Text;

            OracleDataReader oDataReader = oCmd.ExecuteReader();

            while (oDataReader.Read()) {
                if(oDataReader["precinct_id"] == DBNull.Value) {
              continue;
            } else {
              WriteStartElement("street_segment");
              _oXmlWriter.WriteAttributeString("id", oDataReader["id"].ToString());

              if(oDataReader["start_house_number"] == DBNull.Value || oDataReader["start_house_number"].ToString() == "") {
                    start_house = "1";
              } else {
                    start_house = oDataReader["start_house_number"].ToString();
              }

              if (oDataReader["end_house_number"] == DBNull.Value || oDataReader["end_house_number"].ToString() == "") {
                    end_house = "999999";
              } else {
                    end_house = oDataReader["end_house_number"].ToString();
              }

              _oXmlWriter.WriteElementString("start_house_number", start_house);
              _oXmlWriter.WriteElementString("end_house_number", end_house);

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

              WriteStartElement("non_house_address");

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

              _oXmlWriter.WriteElementString("street_name", oDataReader["street_name"].ToString().Replace("\"",""));

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

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

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

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

              WriteEndElement(); // end non_house_address

              _oXmlWriter.WriteElementString("precinct_id", oDataReader["precinct_id"].ToString());

              WriteEndElement(); // end street_segment
            }
            }
        }

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