public Networks GetNetworks()
        {
            string mainSQL = @"SELECT NetworkID, Organization, NetworkName, LongNetworkName, URL, StationNumber, ObsStartDate, ObsEndDate, LastUpdate, Contact FROM t_Network";
            SqlCommand aCommand;
            SqlDataReader aReader;
            Networks aNetworkSet = new Networks();
            List<NetworksNetwork> aNetworkList = new List<NetworksNetwork>();

            using (SqlConnection conn = new SqlConnection(Properties.Settings.Default.enterpriseOD))
            {
                aCommand = new SqlCommand();
                aCommand.Connection = conn;
                aCommand.CommandType = System.Data.CommandType.Text;
                aCommand.CommandText = mainSQL;
                conn.Open();
                aReader = aCommand.ExecuteReader();
                while (aReader.Read())
                {
                    NetworksNetwork aNetwork = new NetworksNetwork();
                    aNetwork.NetworkID = aReader.GetInt32(aReader.GetOrdinal("NetworkID"));
                    aNetwork.Organization = aReader["Organization"].ToString();
                    aNetwork.NetworkName = aReader["NetworkName"].ToString();
                    aNetwork.LongNetworkName = aReader["LongNetworkName"].ToString();
                    aNetwork.URL = aReader["URL"].ToString();
                    aNetwork.StationNumber = aReader.GetInt32(aReader.GetOrdinal("StationNumber"));
                    if (aReader["ObsStartDate"] is DBNull)
                        aNetwork.ObsStartDateSpecified = false;
                    else
                    {
                        aNetwork.ObsStartDate = aReader.GetDateTime(aReader.GetOrdinal("ObsStartDate"));
                        aNetwork.ObsStartDateSpecified = true;
                    }

                    if (aReader["ObsEndDate"] is DBNull)
                        aNetwork.ObsEndDateSpecified = false;
                    else
                    {
                        aNetwork.ObsEndDate = aReader.GetDateTime(aReader.GetOrdinal("ObsEndDate"));
                        aNetwork.ObsEndDateSpecified = true;
                    }

                    if (aReader["LastUpdate"] is DBNull)
                        aNetwork.LastUpdateSpecified = false;
                    else
                    {
                        aNetwork.LastUpdate = aReader.GetDateTime(aReader.GetOrdinal("LastUpdate"));
                        aNetwork.LastUpdateSpecified = true;
                    }
                    aNetwork.Contact = aReader["Contact"].ToString();

                    aNetworkList.Add(aNetwork);
                }
                aReader.Close();
            }
            aCommand.Dispose();
            aNetworkSet.Network = aNetworkList.ToArray();
            return aNetworkSet;
        }