mcs/class/System.Data/System.Data.Odbc/OdbcParameterCollection.cs

   1 //
   2 // System.Data.Odbc.OdbcParameterCollection
   3 //
   4 // Authors:
   5 //   Brian Ritchie (brianlritchie@hotmail.com)
   6 //   Umadevi S (sumadevi@novell.com)
   7 //
   8 // Copyright (C) Brian Ritchie, 2002
   9 // Copyright (C) Novell,Inc
  10 //
  11
  12 //
  13 // Copyright (C) 2004 Novell, Inc (http://www.novell.com)
  14 //
  15 // Permission is hereby granted, free of charge, to any person obtaining
  16 // a copy of this software and associated documentation files (the
  17 // "Software"), to deal in the Software without restriction, including
  18 // without limitation the rights to use, copy, modify, merge, publish,
  19 // distribute, sublicense, and/or sell copies of the Software, and to
  20 // permit persons to whom the Software is furnished to do so, subject to
  21 // the following conditions:
  22 //
  23 // The above copyright notice and this permission notice shall be
  24 // included in all copies or substantial portions of the Software.
  25 //
  26 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  27 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  28 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  29 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  30 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  31 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  32 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  33 //
  34
  35 using System.Collections;
  36 using System.Data;
  37 using System.ComponentModel;
  38 using System.Data.Common;
  39
  40 namespace System.Data.Odbc
  41 {
  42         [ListBindable (false)]
  43         [EditorAttribute ("Microsoft.VSDesigner.Data.Design.DBParametersEditor, "+ Consts.AssemblyMicrosoft_VSDesigner, "System.Drawing.Design.UITypeEditor, "+ Consts.AssemblySystem_Drawing )]
  44         public sealed class OdbcParameterCollection : MarshalByRefObject,
  45                 IDataParameterCollection, IList, ICollection, IEnumerable
  46         {
  47                 #region Fields
  48
  49                 ArrayList list = new ArrayList ();
  50
  51                 #endregion // Fields
  52
  53                 #region Constructors
  54
  55                 internal OdbcParameterCollection () {
  56                 }
  57
  58                 #endregion // Constructors
  59
  60                 #region Properties
  61
  62                 [Browsable (false)]
  63                 [DesignerSerializationVisibility (DesignerSerializationVisibility.Hidden)]
  64                 public int Count {
  65                         get { return list.Count; }
  66                 }
  67
  68                 [Browsable (false)]
  69                 [DesignerSerializationVisibility (DesignerSerializationVisibility.Hidden)]
  70                 public OdbcParameter this[int index] {
  71                         get { return (OdbcParameter) list[index]; }
  72                         set { list[index] = value; }
  73                 }
  74
  75                 [Browsable (false)]
  76                 [DesignerSerializationVisibility (DesignerSerializationVisibility.Hidden)]
  77                 public OdbcParameter this[string parameterName] {
  78                         get {
  79                                 foreach (OdbcParameter p in list)
  80                                         if (p.ParameterName.Equals (parameterName))
  81                                                 return p;
  82                                 throw new IndexOutOfRangeException ("The specified name does not exist: " + parameterName);
  83                         }
  84                         set {
  85                                 if (!Contains (parameterName))
  86                                         throw new IndexOutOfRangeException("The specified name does not exist: " + parameterName);
  87                                 this [IndexOf (parameterName)] = value;
  88                         }
  89
  90                 }
  91
  92                 int ICollection.Count {
  93                         get { return list.Count; }
  94                 }
  95
  96                 bool IList.IsFixedSize {
  97                         get { return false; }
  98                 }
  99
 100                 bool IList.IsReadOnly {
 101                         get { return false; }
 102                 }
 103
 104                 bool ICollection.IsSynchronized {
 105                         get { return list.IsSynchronized; }
 106                 }
 107
 108                 object ICollection.SyncRoot {
 109                         get { return list.SyncRoot; }
 110                 }
 111
 112                 object IList.this[int index] {
 113                         get { return list[index]; }
 114                         set { list[index] = value; }
 115                 }
 116
 117                 object IDataParameterCollection.this[string name]
 118                 {
 119                         get { return this[name]; }
 120                         set {
 121                                 if (!(value is OdbcParameter))
 122                                         throw new InvalidCastException ("Only OdbcParameter objects can be used.");
 123                                 this [name] = (OdbcParameter) value;
 124                         }
 125
 126                 }
 127
 128                 #endregion // Properties
 129
 130                 #region Methods
 131
 132                 public int Add (object value)
 133                 {
 134                          if (!(value is OdbcParameter))
 135                                 throw new InvalidCastException ("The parameter was not an OdbcParameter.");
 136                         Add ((OdbcParameter) value);
 137                         return IndexOf (value);
 138                 }
 139
 140
 141
 142                 public OdbcParameter Add (OdbcParameter parameter)
 143                 {
 144                         if (parameter.Container != null)
 145                                 throw new ArgumentException ("The OdbcParameter specified in the value parameter is already added to this or another OdbcParameterCollection.");
 146
 147                         parameter.Container = this;
 148                         list.Add (parameter);
 149                         return parameter;
 150                 }
 151
 152                 public OdbcParameter Add (string name, object value)
 153                 {
 154                         return Add (new OdbcParameter (name, value));
 155                 }
 156
 157                 public OdbcParameter Add (string name, OdbcType type)
 158                 {
 159                         return Add (new OdbcParameter (name, type));
 160                 }
 161
 162                 public OdbcParameter Add (string name, OdbcType type, int width)
 163                 {
 164                         return Add (new OdbcParameter (name, type, width));
 165                 }
 166
 167                 public OdbcParameter Add (string name, OdbcType type,
 168                                            int width, string src_col)
 169                 {
 170                         return Add (new OdbcParameter (name, type, width, src_col));
 171                 }
 172
 173                 internal void Bind(IntPtr hstmt)
 174                 {
 175                         for (int i=0;i<Count;i++)
 176                         {
 177                                 this[i].Bind(hstmt,i+1);
 178
 179                         }
 180                 }
 181
 182                 int IList.Add (object value)
 183                 {
 184                         if (!(value is IDataParameter))
 185                                 throw new InvalidCastException ();
 186
 187
 188                         list.Add (value);
 189                         return list.IndexOf (value);
 190                 }
 191
 192                 void IList.Clear ()
 193                 {
 194                         list.Clear ();
 195                 }
 196
 197                 bool IList.Contains (object value)
 198                 {
 199                         return list.Contains (value);
 200                 }
 201
 202                 bool IDataParameterCollection.Contains (string value)
 203                 {
 204                         for (int i = 0; i < list.Count; i++) {
 205                                 IDataParameter parameter;
 206
 207                                 parameter = (IDataParameter) list[i];
 208                                 if (parameter.ParameterName == value)
 209                                         return true;
 210                         }
 211
 212                         return false;
 213                 }
 214
 215                 void ICollection.CopyTo (Array array, int index)
 216                 {
 217                         ((OdbcParameter[])(list.ToArray ())).CopyTo (array, index);
 218                 }
 219
 220                 IEnumerator IEnumerable.GetEnumerator ()
 221                 {
 222                         return list.GetEnumerator ();
 223                 }
 224
 225                 int IList.IndexOf (object value)
 226                 {
 227                         return list.IndexOf (value);
 228                 }
 229
 230                 int IDataParameterCollection.IndexOf (string name)
 231                 {
 232                         return list.IndexOf (((IDataParameterCollection) this)[name]);
 233                 }
 234
 235                 void IList.Insert (int index, object value)
 236                 {
 237                         list.Insert (index, value);
 238                 }
 239
 240                 void IList.Remove (object value)
 241                 {
 242                         list.Remove (value);
 243                 }
 244
 245                 void IList.RemoveAt (int index)
 246                 {
 247                         list.Remove ((object) list[index]);
 248                 }
 249
 250                 void IDataParameterCollection.RemoveAt (string name)
 251                 {
 252                         list.Remove (((IDataParameterCollection) this)[name]);
 253                 }
 254
 255                 public void Clear()
 256                 {
 257                         foreach (OdbcParameter p in list)
 258                                 p.Container = null;
 259
 260                         list.Clear ();
 261                 }
 262
 263                 public bool Contains (object value)
 264                 {
 265                         if (!(value is OdbcParameter))
 266                                 throw new InvalidCastException ("The parameter was not an OdbcParameter.");
 267                         return Contains (((OdbcParameter) value).ParameterName);
 268                 }
 269
 270                 public bool Contains (string value)
 271                 {
 272                         foreach (OdbcParameter p in list)
 273                                 if (p.ParameterName.Equals (value))
 274                                         return true;
 275                         return false;
 276                 }
 277
 278                 public void CopyTo (Array array, int index)
 279                 {
 280                         list.CopyTo (array, index);
 281                 }
 282
 283                 public IEnumerator GetEnumerator()
 284                 {
 285                         return list.GetEnumerator ();
 286                 }
 287
 288                 public int IndexOf (object value)
 289                 {
 290                         if (!(value is OdbcParameter))
 291                                 throw new InvalidCastException ("The parameter was not an OdbcParameter.");
 292                         return IndexOf (((OdbcParameter) value).ParameterName);
 293                 }
 294
 295                 public int IndexOf (string parameterName)
 296                 {
 297                         for (int i = 0; i < Count; i += 1)
 298                                 if (this [i].ParameterName.Equals (parameterName))
 299                                         return i;
 300                         return -1;
 301                 }
 302
 303                 public void Insert (int index, object value)
 304                 {
 305                         list.Insert (index, value);
 306                 }
 307
 308                 public void Remove (object value)
 309                 {
 310                         ((OdbcParameter) value).Container = null;
 311                         list.Remove (value);
 312                 }
 313
 314                 public void RemoveAt (int index)
 315                 {
 316                         this [index].Container = null;
 317                         list.RemoveAt (index);
 318                 }
 319
 320                 public void RemoveAt (string parameterName)
 321                 {
 322                         RemoveAt (IndexOf (parameterName));
 323                 }
 324
 325
 326
 327                 #endregion // Methods
 328
 329         }
 330 }