OracleParameterCollection.cs 5.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232
  1. //
  2. // OracleParameterCollection.cs
  3. //
  4. // Part of the Mono class libraries at
  5. // mcs/class/System.Data.OracleClient/System.Data.OracleClient
  6. //
  7. // Assembly: System.Data.OracleClient.dll
  8. // Namespace: System.Data.OracleClient
  9. //
  10. // Authors:
  11. // Tim Coleman <[email protected]>
  12. //
  13. // Copyright (C) Tim Coleman , 2003
  14. //
  15. // Licensed under the MIT/X11 License.
  16. //
  17. using System;
  18. using System.Collections;
  19. using System.ComponentModel;
  20. using System.Data;
  21. using System.Data.OracleClient.Oci;
  22. namespace System.Data.OracleClient {
  23. public class OracleParameterCollection : MarshalByRefObject, IDataParameterCollection, IList, ICollection, IEnumerable
  24. {
  25. #region Fields
  26. OracleCommand command;
  27. ArrayList list;
  28. #endregion // Fields
  29. #region Constructors
  30. internal OracleParameterCollection (OracleCommand command)
  31. : this ()
  32. {
  33. this.command = command;
  34. }
  35. public OracleParameterCollection ()
  36. {
  37. list = new ArrayList ();
  38. }
  39. #endregion // Constructors
  40. #region Properties
  41. public int Count {
  42. get { return list.Count; }
  43. }
  44. public bool IsFixedSize {
  45. get { return false; }
  46. }
  47. public bool IsReadOnly {
  48. get { return false; }
  49. }
  50. public bool IsSynchronized {
  51. get { return false; }
  52. }
  53. public OracleParameter this [string parameterName] {
  54. get {
  55. foreach (OracleParameter p in list)
  56. if (p.ParameterName.Equals (parameterName))
  57. return p;
  58. throw new IndexOutOfRangeException ("The specified name does not exist: " + parameterName);
  59. }
  60. set {
  61. if (!Contains (parameterName))
  62. throw new IndexOutOfRangeException ("The specified name does not exist: " + parameterName);
  63. this [IndexOf (parameterName)] = value;
  64. }
  65. }
  66. object IList.this [int index] {
  67. get { return (OracleParameter) this [index]; }
  68. set { this [index] = (OracleParameter) value; }
  69. }
  70. bool IList.IsFixedSize {
  71. get { return IsFixedSize; }
  72. }
  73. bool IList.IsReadOnly {
  74. get { return IsReadOnly; }
  75. }
  76. bool ICollection.IsSynchronized {
  77. get { return IsSynchronized; }
  78. }
  79. object ICollection.SyncRoot {
  80. get { return SyncRoot; }
  81. }
  82. public OracleParameter this [int index] {
  83. get { return (OracleParameter) list [index]; }
  84. set { list [index] = value; }
  85. }
  86. object IDataParameterCollection.this [string parameterName] {
  87. get { return this [parameterName]; }
  88. set {
  89. if (!(value is OracleParameter))
  90. throw new InvalidCastException ("The parameter was not an OracleParameter.");
  91. this [parameterName] = (OracleParameter) value;
  92. }
  93. }
  94. public object SyncRoot {
  95. get { return this; }
  96. }
  97. #endregion // Properties
  98. #region Methods
  99. public int Add (object value)
  100. {
  101. if (!(value is OracleParameter))
  102. throw new InvalidCastException ("The parameter was not an OracleParameter.");
  103. Add ((OracleParameter) value);
  104. return IndexOf (value);
  105. }
  106. public OracleParameter Add (OracleParameter value)
  107. {
  108. if (value.Container != null)
  109. throw new ArgumentException ("The OracleParameter specified in the value parameter is already added to this or another OracleParameterCollection.");
  110. value.Container = this;
  111. list.Add (value);
  112. return value;
  113. }
  114. public OracleParameter Add (string parameterName, object value)
  115. {
  116. return Add (new OracleParameter (parameterName, value));
  117. }
  118. public OracleParameter Add (string parameterName, OracleType dataType)
  119. {
  120. return Add (new OracleParameter (parameterName, dataType));
  121. }
  122. public OracleParameter Add (string parameterName, OracleType dataType, int size)
  123. {
  124. return Add (new OracleParameter (parameterName, dataType, size));
  125. }
  126. public OracleParameter Add (string parameterName, OracleType dataType, int size, string srcColumn)
  127. {
  128. return Add (new OracleParameter (parameterName, dataType, size, srcColumn));
  129. }
  130. public void Clear ()
  131. {
  132. list.Clear ();
  133. }
  134. public bool Contains (object value)
  135. {
  136. if (!(value is OracleParameter))
  137. throw new InvalidCastException ("The parameter was not an OracleParameter.");
  138. return Contains (((OracleParameter) value).ParameterName);
  139. }
  140. public bool Contains (string parameterName)
  141. {
  142. foreach (OracleParameter p in list)
  143. if (p.ParameterName.Equals (parameterName))
  144. return true;
  145. return false;
  146. }
  147. public void CopyTo (Array array, int index)
  148. {
  149. list.CopyTo (array, index);
  150. }
  151. public IEnumerator GetEnumerator ()
  152. {
  153. return list.GetEnumerator ();
  154. }
  155. public int IndexOf (object value)
  156. {
  157. if (!(value is OracleParameter))
  158. throw new InvalidCastException ("The parameter was not an OracleParameter.");
  159. return IndexOf (((OracleParameter) value).ParameterName);
  160. }
  161. public int IndexOf (string parameterName)
  162. {
  163. for (int i = 0; i < Count; i += 1)
  164. if (this [i].ParameterName.Equals (parameterName))
  165. return i;
  166. return -1;
  167. }
  168. public void Insert (int index, object value)
  169. {
  170. if (!(value is OracleParameter))
  171. throw new InvalidCastException ("The parameter was not an OracleParameter.");
  172. list.Insert (index, value);
  173. }
  174. public void Remove (object value)
  175. {
  176. if (!(value is OracleParameter))
  177. throw new InvalidCastException ("The parameter was not an OracleParameter.");
  178. list.Remove (value);
  179. }
  180. public void RemoveAt (int index)
  181. {
  182. list.RemoveAt (index);
  183. }
  184. public void RemoveAt (string parameterName)
  185. {
  186. list.RemoveAt (IndexOf (parameterName));
  187. }
  188. #endregion // Methods
  189. }
  190. }