/// <summary>
        /// Return a FoeServerAutoSubscriber object extract from next record in the SqlDataReader object provided.
        /// </summary>
        /// <param name="reader">SqlDataReader object that contains the query results.</param>
        /// <returns>The FoeServerAutoSubscriber object representing the next record in the SqlDataReader object.</returns>
        public static FoeServerAutoSubscriber GetNextAutoSubscriberFromSqlReader(SqlDataReader reader)
        {
            FoeServerAutoSubscriber sub = null;
            if ((reader != null) && (reader.Read()))
            {
                sub = new FoeServerAutoSubscriber();
                sub.Id = (int)FoeServerDb.GetInt32(reader, "Id");
                sub.UserEmail = FoeServerDb.GetString(reader, "UserEmail");
                sub.CatalogCode = FoeServerDb.GetString(reader, "CatalogCode");
                sub.RequestId = FoeServerDb.GetString(reader, "RequestId");
                sub.DtSubscribed = (DateTime)FoeServerDb.GetDateTime(reader, "DtSubscribed");
                sub.DtLastUpdated = FoeServerDb.GetDateTime(reader, "DtLastUpdated");
            }

            return sub;
        }
        /// <summary>
        /// Return a FoeServerAutoSubscriber object extract from next record in the SqlDataReader object provided.
        /// </summary>
        /// <param name="reader">SqlDataReader object that contains the query results.</param>
        /// <returns>The FoeServerAutoSubscriber object representing the next record in the SqlDataReader object.</returns>
        public static FoeServerAutoSubscriber GetNextAutoSubscriberFromSqlReader(SqlDataReader reader)
        {
            FoeServerAutoSubscriber sub = null;

            if ((reader != null) && (reader.Read()))
            {
                sub               = new FoeServerAutoSubscriber();
                sub.Id            = (int)FoeServerDb.GetInt32(reader, "Id");
                sub.UserEmail     = FoeServerDb.GetString(reader, "UserEmail");
                sub.CatalogCode   = FoeServerDb.GetString(reader, "CatalogCode");
                sub.RequestId     = FoeServerDb.GetString(reader, "RequestId");
                sub.DtSubscribed  = (DateTime)FoeServerDb.GetDateTime(reader, "DtSubscribed");
                sub.DtLastUpdated = FoeServerDb.GetDateTime(reader, "DtLastUpdated");
            }

            return(sub);
        }