/mcs/class/System.Data.OracleClient/System.Data.OracleClient/OracleParameterCollection.cs

//
// OracleParameterCollection.cs
//
// Part of the Mono class libraries at
// mcs/class/System.Data.OracleClient/System.Data.OracleClient
//
// Assembly: System.Data.OracleClient.dll
// Namespace: System.Data.OracleClient
//
// Authors:
//    Tim Coleman <tim@timcoleman.com>
//
// Copyright (C) Tim Coleman , 2003
//
// Licensed under the MIT/X11 License.
//

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
#if NET_2_0
using System.Data.Common;
#endif
using System.Data.OracleClient.Oci;
using System.Drawing.Design;
using System.Globalization;
using System.Reflection;

namespace System.Data.OracleClient
{
	[ListBindable (false)]
	[Editor ("Microsoft.VSDesigner.Data.Design.DBParametersEditor, " + Consts.AssemblyMicrosoft_VSDesigner, typeof(UITypeEditor))]
	public sealed class OracleParameterCollection :
#if NET_2_0
		DbParameterCollection
#else
		MarshalByRefObject, IDataParameterCollection, IList, ICollection, IEnumerable
#endif
	{
		#region Fields

		readonly ArrayList list;

		#endregion // Fields

		#region Constructors

		public OracleParameterCollection ()
		{
			list = new ArrayList ();
		}

		#endregion // Constructors

		#region Properties

		public
#if NET_2_0
		override
#endif
		int Count {
			get { return list.Count; }
		}

		public
#if NET_2_0
		override
#endif
		bool IsFixedSize {
			get { return list.IsFixedSize; }
		}

		public
#if NET_2_0
		override
#endif
		bool IsReadOnly {
			get { return list.IsReadOnly; }
		}

		public
#if NET_2_0
		override
#endif
		bool IsSynchronized {
			get { return list.IsSynchronized; }
		}

		public
#if NET_2_0
		new
#endif
		OracleParameter this [string parameterName] {
			get {
				return (OracleParameter) GetParameter (parameterName);
			}
			set {
				SetParameter (parameterName, value);
			}
		}

		public
#if NET_2_0
		override
#endif
		object SyncRoot {
			get { return this; }
		}

		public
#if NET_2_0
		new
#endif
		OracleParameter this [int index]
		{
			get {
				return (OracleParameter) GetParameter (index);
			}
			set {
				SetParameter (index, value);
			}
		}

#if !NET_2_0
		object IList.this [int index] {
			get { return this [index]; }
			set { this [index] = (OracleParameter) value; }
		}

		object IDataParameterCollection.this [string index] {
			get { return this [index]; }
			set {
				if (!(value is OracleParameter))
					throw new InvalidCastException ("The parameter was not an OracleParameter.");
				this [index] = (OracleParameter) value;
			}
		}
#endif

		#endregion // Properties

		#region Methods

#if NET_2_0
		[EditorBrowsable (EditorBrowsableState.Never)]
#endif
		public
#if NET_2_0
		override
#endif
		int Add (object value)
		{
			AssertParameterValid (value);

			Add ((OracleParameter) value);
			return IndexOf (value);
		}

		public OracleParameter Add (OracleParameter value)
		{
#if NET_2_0
			if (value == null)
				throw CreateParameterNullException ();
#endif
			if (value.Container != null)
				throw new ArgumentException ("The OracleParameter specified in the value parameter is already added to this or another OracleParameterCollection.");
			value.Container = this;
			list.Add (value);
			return value;
		}

		public OracleParameter Add (string parameterName, object value)
		{
			return Add (new OracleParameter (parameterName, value));
		}

		public OracleParameter Add (string parameterName, OracleType dataType)
		{
			return Add (new OracleParameter (parameterName, dataType));
		}

		public OracleParameter Add (string parameterName, OracleType dataType, int size)
		{
			return Add (new OracleParameter (parameterName, dataType, size));
		}

		public OracleParameter Add (string parameterName, OracleType dataType, int size, string srcColumn)
		{
			return Add (new OracleParameter (parameterName, dataType, size, srcColumn));
		}

#if NET_2_0
		public override void AddRange (Array values)
		{
			if (values == null)
				throw new ArgumentNullException ("values");

			foreach (object param in values)
				AssertParameterValid (param);

			foreach (OracleParameter param in values)
				Add (param);
		}

		public void AddRange (OracleParameter [] values)
		{
			if (values == null)
				throw new ArgumentNullException ("values");

			foreach (OracleParameter param in values)
				if (param == null)
					throw CreateParameterNullException ();

			foreach (OracleParameter param in values)
				Add (param);
		}
#endif

		public
#if NET_2_0
		override
#endif
		void Clear ()
		{
			foreach (OracleParameter param in list)
				param.Container = null;
			list.Clear ();
		}

		public
#if NET_2_0
		override
#endif
		bool Contains (object value)
		{
			return (IndexOf (value) != -1);
		}

#if NET_2_0
		public bool Contains (OracleParameter value)
		{
			return (IndexOf (value) != -1);
		}
#endif

		public
#if NET_2_0
		override
#endif
		bool Contains (string parameterName)
		{
			return (IndexOf (parameterName) != -1);
		}

		public
#if NET_2_0
		override
#endif
		void CopyTo (Array array, int index)
		{
			list.CopyTo (array, index);
		}

		public
#if NET_2_0
		override
#endif
		IEnumerator GetEnumerator ()
		{
			return list.GetEnumerator ();
		}

#if NET_2_0
		protected override DbParameter GetParameter (int index)
#else
		object GetParameter (int index)
#endif
		{
			AssertIndex (index);
			return (OracleParameter) list [index];
		}

#if NET_2_0
		protected override DbParameter GetParameter (string parameterName)
#else
		object GetParameter (string parameterName)
#endif
		{
			int index = IndexOf (parameterName);
			if (index == -1)
				throw ParameterNotFoundException (parameterName, index);
			return (OracleParameter) list [index];
		}

#if NET_2_0
		protected override void SetParameter (int index, DbParameter value)
#else
		void SetParameter (int index, IDbDataParameter value)
#endif
		{
			AssertIndex (index);
			AssertParameterValid (value);

			OracleParameter new_value = (OracleParameter) value;
			OracleParameter old_value = (OracleParameter) list [index];

#if !NET_2_0
			old_value.Container = null;
#endif

			if (new_value.Container != null) {
				if (new_value.Container != this)
					throw ParameterAlreadyOwnedException ();
				if (IndexOf (new_value) != index)
					throw ParameterAlreadyOwnedException ();
			}

			list [index] = new_value;
			new_value.Container = this;
#if NET_2_0
			old_value.Container = null;
#endif
		}

#if NET_2_0
		protected override void SetParameter (string parameterName, DbParameter value)
#else
		void SetParameter (string parameterName, IDbDataParameter value)
#endif
		{
			int index = IndexOf (parameterName);
			if (index == -1)
				throw ParameterNotFoundException (parameterName, index);

			AssertParameterValid (value);

			OracleParameter new_value = (OracleParameter) value;
			OracleParameter old_value = (OracleParameter) list [index];

#if !NET_2_0
			old_value.Container = null;
#endif

			if (new_value.Container != null) {
				if (new_value.Container != this)
					throw ParameterAlreadyOwnedException ();
				if (IndexOf (new_value) != index)
					throw ParameterAlreadyOwnedException ();
			}

			list [index] = new_value;
			new_value.Container = this;
#if NET_2_0
			old_value.Container = null;
#endif
		}

		public
#if NET_2_0
		override
#endif
		int IndexOf (object value)
		{
			if (value != null)
				AssertParameterValid (value);

			for (int i = 0; i < Count; i += 1)
				if (list [i] == value)
					return i;
			return -1;
		}

#if NET_2_0
		public int IndexOf (OracleParameter value)
		{
			for (int i = 0; i < Count; i += 1)
				if (list [i] == value)
					return i;
			return -1;
		}
#endif

		public
#if NET_2_0
		override
#endif
		int IndexOf (string parameterName)
		{
#if NET_2_0
			// case-sensitive lookup
			for (int i = 0; i < Count; i += 1) {
				OracleParameter param = (OracleParameter) list [i];
				if (string.Compare (param.ParameterName, parameterName, false, CultureInfo.CurrentCulture) == 0)
					return i;
			}
#endif

			// case-insensitive lookup
			for (int i = 0; i < Count; i += 1) {
				OracleParameter param = (OracleParameter) list [i];
				if (string.Compare (param.ParameterName, parameterName, true, CultureInfo.CurrentCulture) == 0)
					return i;
			}

			return -1;
		}

		public
#if NET_2_0
		override
#endif
		void Insert (int index, object value)
		{
			AssertParameterValid (value);

			OracleParameter new_value = (OracleParameter) value;

			if (new_value.Container != null) {
				if (new_value.Container != this)
					throw ParameterAlreadyOwnedException ();
				if (IndexOf (value) != -1)
					throw ParameterAlreadyOwnedException ();
			}

			list.Insert (index, new_value);
			new_value.Container = this;
		}

#if NET_2_0
		public void Insert (int index, OracleParameter value)
		{
			Insert (index, (object) value);
		}
#endif

		public
#if NET_2_0
		override
#endif
		void Remove (object value)
		{
			AssertParameterValid (value);

			int index = IndexOf (value);
			if (index == -1)
				throw ParameterNotOwnedException ();

			((OracleParameter) value).Container = null;
			list.RemoveAt (index);
		}

#if NET_2_0
		public void Remove (OracleParameter value)
		{
			if (value == null)
				throw CreateParameterNullException ();

			int index = IndexOf (value);
			if (index == -1)
				throw ParameterNotOwnedException ();

			value.Container = null;
			list.RemoveAt (index);
		}
#endif

		public
#if NET_2_0
		override
#endif
		void RemoveAt (int index)
		{
			AssertIndex (index);

			OracleParameter param = (OracleParameter) list [index];
			param.Container = null;
			list.RemoveAt (index);
		}

		public
#if NET_2_0
		override
#endif
		void RemoveAt (string parameterName)
		{
			int index = IndexOf (parameterName);
			if (index == -1)
				throw ParameterNotOwnedException (parameterName);

			OracleParameter param = (OracleParameter) list [index];
			param.Container = null;
			list.RemoveAt (index);
		}

		static void AssertParameterValid (object value)
		{
			if (value == null)
				throw CreateParameterNullException ();

			if (value is OracleParameter)
				return;

			string msg = string.Format (CultureInfo.InvariantCulture,
#if NET_2_0
				"Only non-null {0} instances are valid for " +
				"the {1}, not {2} instances.",
				typeof (OracleParameter).Name,
				typeof (OracleParameterCollection).Name,
				value.GetType ().Name);
#else
				"Value is not {0}.",
				typeof (OracleParameter).Name);
#endif
			throw new InvalidCastException (msg);
		}

		static Exception CreateParameterNullException ()
		{
#if NET_2_0
			string msg = string.Format (CultureInfo.InvariantCulture,
				"Only non-null {0} instances are valid for " +
				"{1}.", typeof (OracleParameter).Name,
				typeof (OracleParameterCollection).Name);
			return new ArgumentNullException ("value", msg);
#else
			return new ArgumentNullException ("value");
#endif
		}

		static Exception ParameterAlreadyOwnedException ()
		{
			string msg = string.Format (CultureInfo.InvariantCulture,
				"The specified {0} is already owned by this " +
				"or another {1}.", typeof (OracleParameter).Name,
				typeof (OracleParameterCollection).Name);
			throw new ArgumentException (msg);
		}

		Exception ParameterNotFoundException (string name, int index)
		{
			string msg = string.Format (CultureInfo.InvariantCulture,
#if NET_2_0
				"Index {0} is not valid for this {1}.",
				index, typeof (OracleParameterCollection).Name);
#else
				"Parameter '{0}' not found.", name);
#endif
			throw new IndexOutOfRangeException (msg);
		}

		Exception ParameterNotOwnedException ()
		{
			throw new ArgumentException (string.Format (
				CultureInfo.InvariantCulture,
				"An {0} instance that is not contained " +
				"by this {1} cannot be removed.",
				typeof (OracleParameter).Name,
				this.GetType ().Name));
		}

		Exception ParameterNotOwnedException (string name)
		{
#if NET_2_0
			throw new IndexOutOfRangeException (string.Format (
				CultureInfo.InvariantCulture,
				"{0} parameter '{1}' is not contained by " +
				"this {2}.", typeof (OracleParameter).Name,
				name, this.GetType ().Name));
#else
			throw new IndexOutOfRangeException (string.Format (
				CultureInfo.InvariantCulture,
				"Parameter '{0}' does not exist.", name));
#endif
		}

		void AssertIndex (int index)
		{
			if (index < 0 || index >= Count)
				throw new IndexOutOfRangeException (string.Format (
					CultureInfo.InvariantCulture, "Index {0} " +
					"is not valid for this {1}.", index,
					typeof (OracleParameterCollection).Name));
		}

		#endregion // Methods
	}
}