コード例 #1
0
        /// <summary>
        /// Adds the specified <see cref="AceQLParameter"/>. object to the <see cref="AceQLParameterCollection"/>.
        /// </summary>
        /// <param name="value">The <see cref="AceQLParameter"/> to add to the collection.</param>
        /// <exception cref="System.ArgumentNullException">If value is null.</exception>
        public void Add(AceQLParameter value)
        {
            if (value == null)
            {
                throw new ArgumentNullException("value is null!");
            }

            aceqlParameters.Add(value);
        }
コード例 #2
0
        /// <summary>
        ///  Adds a value to the end of the <see cref="AceQLParameterCollection"/>.
        /// </summary>
        /// <param name="parameterName">The name of the parameter.</param>
        /// <param name="value">The value to be added. Cannot ne bull.</param>
        /// <exception cref="System.ArgumentNullException">If parameterName or value is null.</exception>
        public void AddWithValue(string parameterName, object value)
        {
            if (parameterName == null)
            {
                throw new ArgumentNullException("parameterName is null!");
            }

            AceQLParameter aceQLParameter = new AceQLParameter(parameterName, value);

            aceqlParameters.Add(aceQLParameter);
        }
コード例 #3
0
 /// <summary>
 ///  Removes the <see cref="AceQLParameter"/> from the <see cref="AceQLParameterCollection"/>
 ///  at the specified parameter name.
 /// </summary>
 /// <param name="parameterName">The name of the <see cref="AceQLParameter"/> to Remove.</param>
 public void RemoveAt(string parameterName)
 {
     for (int i = 0; i < aceqlParameters.Count; i++)
     {
         AceQLParameter aceQLParameter = aceqlParameters[i];
         if (aceQLParameter.ParameterName.Equals(parameterName))
         {
             aceqlParameters.RemoveAt(i);
             return;
         }
     }
 }
コード例 #4
0
 /// <summary>
 /// Removes the specified <see cref="AceQLParameter"/> from the collection.
 /// </summary>
 /// <param name="value">The object to Remove from the collection.</param>
 public void Remove(object value)
 {
     for (int i = 0; i < aceqlParameters.Count; i++)
     {
         AceQLParameter aceQLParameter = aceqlParameters[i];
         if (aceQLParameter.Value.Equals(value))
         {
             aceqlParameters.RemoveAt(i);
             return;
         }
     }
 }
コード例 #5
0
 /// <summary>
 ///  Gets the location of the specified <see cref="Object"/> within the collection.
 /// </summary>
 /// <param name="value">The <see cref="Object"/> to find.</param>
 /// <returns> The zero-based location of the specified <see cref="Object"/> that is a <see cref="AceQLParameter"/> within the collection. Returns -1 when the object does not exist in the <see cref="AceQLParameterCollection"/>.</returns>
 /// <exception cref="System.ArgumentNullException">If parameterName is null.</exception>
 public int IndexOf(object value)
 {
     for (int i = 0; i < aceqlParameters.Count; i++)
     {
         AceQLParameter aceQLParameter = aceqlParameters[i];
         if (aceQLParameter.Value.Equals(value))
         {
             return(i);
         }
     }
     return(-1);
 }
コード例 #6
0
        /// <summary>
        /// Gets the <see cref="AceQLParameter"/> for it's name.
        /// </summary>
        /// <param name="parameterName">Name of the <see cref="AceQLParameter"/>.</param>
        /// <returns>The <see cref="AceQLParameter"/> for the parameter name.</returns>
        public AceQLParameter GetAceQLParameter(string parameterName)
        {
            for (int i = 0; i < aceqlParameters.Count; i++)
            {
                AceQLParameter aceQLParameter = aceqlParameters[i];
                if (aceQLParameter.ParameterName.Equals(parameterName))
                {
                    return(aceQLParameter);
                }
            }

            return(null);
        }
コード例 #7
0
        /// <summary>
        /// Adds a value to the end of the <see cref="AceQLParameterCollection"/>.
        /// To be used for Blobs insert or update.
        /// </summary>
        /// <param name="parameterName">Name of the parameter.</param>
        /// <param name="stream">The Blob stream to read. Cannot be null.</param>
        /// <param name="length">The Blob stream length.</param>
        /// <exception cref="System.ArgumentNullException">If parameterName or stream is null.</exception>
        public void AddWithValue(string parameterName, Stream stream, long length)
        {
            if (parameterName == null)
            {
                throw new ArgumentNullException("parameterName is null!");
            }

            if (stream == null)
            {
                throw new ArgumentNullException("stream is null!");
            }

            AceQLParameter aceQLParameter = new AceQLParameter(parameterName, stream, length);

            aceqlParameters.Add(aceQLParameter);
        }
コード例 #8
0
        /// <summary>
        ///  Gets the location of the specified <see cref="AceQLParameter"/> with the specified name.
        /// </summary>
        /// <param name="parameterName">Name of the parameter.</param>
        /// <returns> The case-sensitive name of the <see cref="AceQLParameter"/> to find.</returns>
        /// <exception cref="System.ArgumentNullException">If parameterName is null.</exception>
        public int IndexOf(string parameterName)
        {
            if (parameterName == null)
            {
                throw new ArgumentNullException("parameterName is null!");
            }

            for (int i = 0; i < aceqlParameters.Count; i++)
            {
                AceQLParameter aceQLParameter = aceqlParameters[i];
                if (aceQLParameter.ParameterName.Equals(parameterName))
                {
                    return(i);
                }
            }
            return(-1);
        }