DataColumnMappingCollection.cs 8.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284
  1. //
  2. // System.Data.Common.DataColumnMappingCollection
  3. //
  4. // Authors:
  5. // Rodrigo Moya ([email protected])
  6. // Tim Coleman ([email protected])
  7. //
  8. // (C) Ximian, Inc
  9. // Copyright (C) Tim Coleman, 2002-2003
  10. //
  11. using System;
  12. using System.Collections;
  13. using System.ComponentModel;
  14. using System.Data;
  15. namespace System.Data.Common {
  16. public sealed class DataColumnMappingCollection : MarshalByRefObject, IColumnMappingCollection , IList, ICollection, IEnumerable
  17. {
  18. #region Fields
  19. ArrayList list;
  20. Hashtable sourceColumns;
  21. Hashtable dataSetColumns;
  22. #endregion // Fields
  23. #region Constructors
  24. public DataColumnMappingCollection ()
  25. {
  26. list = new ArrayList ();
  27. sourceColumns = new Hashtable ();
  28. dataSetColumns = new Hashtable ();
  29. }
  30. #endregion // Constructors
  31. #region Properties
  32. [Browsable (false)]
  33. [DataSysDescription ("The number of items in the collection")]
  34. [DesignerSerializationVisibility (DesignerSerializationVisibility.Hidden)]
  35. public int Count {
  36. get { return list.Count; }
  37. }
  38. [Browsable (false)]
  39. [DataSysDescription ("The specified DataColumnMapping object.")]
  40. [DesignerSerializationVisibility (DesignerSerializationVisibility.Hidden)]
  41. public DataColumnMapping this [int index] {
  42. get { return (DataColumnMapping)(list[index]); }
  43. set {
  44. DataColumnMapping mapping = (DataColumnMapping)(list[index]);
  45. sourceColumns[mapping] = value;
  46. dataSetColumns[mapping] = value;
  47. list[index] = value;
  48. }
  49. }
  50. [Browsable (false)]
  51. [DataSysDescription ("DataTableMappings_Item")]
  52. [DesignerSerializationVisibility (DesignerSerializationVisibility.Hidden)]
  53. public DataColumnMapping this [string sourceColumn] {
  54. get {
  55. if (!Contains(sourceColumn)) {
  56. throw new IndexOutOfRangeException("DataColumnMappingCollection doesn't contains DataColumnMapping with SourceColumn '" + sourceColumn + "'.");
  57. }
  58. return (DataColumnMapping) sourceColumns[sourceColumn]; }
  59. set { this [list.IndexOf (sourceColumns[sourceColumn])] = value; }
  60. }
  61. object ICollection.SyncRoot {
  62. get { return list.SyncRoot; }
  63. }
  64. bool ICollection.IsSynchronized {
  65. get { return list.IsSynchronized; }
  66. }
  67. object IColumnMappingCollection.this [string sourceColumn] {
  68. get { return this [sourceColumn]; }
  69. set {
  70. if (!(value is DataColumnMapping))
  71. throw new ArgumentException ();
  72. this [sourceColumn] = (DataColumnMapping) value;
  73. }
  74. }
  75. object IList.this [int index] {
  76. get { return this[index]; }
  77. set {
  78. if (!(value is DataColumnMapping))
  79. throw new ArgumentException ();
  80. this [index] = (DataColumnMapping) value;
  81. }
  82. }
  83. bool IList.IsReadOnly {
  84. get { return false; }
  85. }
  86. bool IList.IsFixedSize {
  87. get { return false; }
  88. }
  89. #endregion // Properties
  90. #region Methods
  91. public int Add (object value)
  92. {
  93. if (!(value is DataColumnMapping))
  94. throw new InvalidCastException ();
  95. list.Add (value);
  96. sourceColumns[((DataColumnMapping)value).SourceColumn] = value;
  97. dataSetColumns[((DataColumnMapping)value).DataSetColumn] = value;
  98. return list.IndexOf (value);
  99. }
  100. public DataColumnMapping Add (string sourceColumn, string dataSetColumn)
  101. {
  102. DataColumnMapping mapping = new DataColumnMapping (sourceColumn, dataSetColumn);
  103. Add (mapping);
  104. return mapping;
  105. }
  106. #if NET_2_0
  107. [MonoTODO]
  108. public void AddRange (Array values)
  109. {
  110. throw new NotImplementedException ();
  111. }
  112. #endif
  113. public void AddRange (DataColumnMapping[] values)
  114. {
  115. foreach (DataColumnMapping mapping in values)
  116. Add (mapping);
  117. }
  118. public void Clear ()
  119. {
  120. list.Clear ();
  121. }
  122. public bool Contains (object value)
  123. {
  124. if (!(value is DataColumnMapping))
  125. throw new InvalidCastException("Object is not of type DataColumnMapping");
  126. return (list.Contains (value));
  127. }
  128. public bool Contains (string value)
  129. {
  130. return (sourceColumns.Contains (value));
  131. }
  132. public void CopyTo (Array array, int index)
  133. {
  134. (list.ToArray()).CopyTo(array,index);
  135. }
  136. public DataColumnMapping GetByDataSetColumn (string value)
  137. {
  138. // this should work case-insenstive.
  139. if (!(dataSetColumns[value] == null))
  140. return (DataColumnMapping)(dataSetColumns[value]);
  141. else {
  142. string lowcasevalue = value.ToLower();
  143. object [] keyarray = new object[dataSetColumns.Count];
  144. dataSetColumns.Keys.CopyTo(keyarray,0);
  145. for (int i=0; i<keyarray.Length; i++) {
  146. string temp = (string) keyarray[i];
  147. if (lowcasevalue.Equals(temp.ToLower()))
  148. return (DataColumnMapping)(dataSetColumns[keyarray[i]]);
  149. }
  150. return null;
  151. }
  152. }
  153. [EditorBrowsable (EditorBrowsableState.Advanced)]
  154. public static DataColumnMapping GetColumnMappingBySchemaAction (DataColumnMappingCollection columnMappings, string sourceColumn, MissingMappingAction mappingAction)
  155. {
  156. if (columnMappings.Contains (sourceColumn))
  157. return columnMappings[sourceColumn];
  158. if (mappingAction == MissingMappingAction.Ignore)
  159. return null;
  160. if (mappingAction == MissingMappingAction.Error)
  161. throw new InvalidOperationException (String.Format ("Missing SourceColumn mapping for '{0}'", sourceColumn));
  162. return new DataColumnMapping (sourceColumn, sourceColumn);
  163. }
  164. #if NET_2_0
  165. [MonoTODO]
  166. public static DataColumn GetDataColumn (DataColumnMappingCollection columnMappings, string sourceColumn, Type dataType, DataTable dataTable, MissingMappingAction mappingAction, MissingSchemaAction schemaAction)
  167. {
  168. throw new NotImplementedException ();
  169. }
  170. #endif
  171. public IEnumerator GetEnumerator ()
  172. {
  173. return list.GetEnumerator ();
  174. }
  175. IColumnMapping IColumnMappingCollection.Add (string sourceColumnName, string dataSetColumnName)
  176. {
  177. return Add (sourceColumnName, dataSetColumnName);
  178. }
  179. IColumnMapping IColumnMappingCollection.GetByDataSetColumn (string dataSetColumnName)
  180. {
  181. return GetByDataSetColumn (dataSetColumnName);
  182. }
  183. public int IndexOf (object value)
  184. {
  185. return list.IndexOf (value);
  186. }
  187. public int IndexOf (string sourceColumn)
  188. {
  189. return list.IndexOf (sourceColumns[sourceColumn]);
  190. }
  191. public int IndexOfDataSetColumn (string value)
  192. {
  193. // this should work case-insensitive
  194. if (!(dataSetColumns[value] == null))
  195. return list.IndexOf (dataSetColumns[value]);
  196. else {
  197. string lowcasevalue = value.ToLower();
  198. object [] keyarray = new object[dataSetColumns.Count];
  199. dataSetColumns.Keys.CopyTo(keyarray,0);
  200. for (int i=0; i<keyarray.Length; i++) {
  201. string temp = (string) keyarray[i];
  202. if (lowcasevalue.Equals(temp.ToLower()))
  203. return list.IndexOf (dataSetColumns[keyarray[i]]);
  204. }
  205. return -1;
  206. }
  207. }
  208. public void Insert (int index, object value)
  209. {
  210. list.Insert (index, value);
  211. sourceColumns[((DataColumnMapping)value).SourceColumn] = value;
  212. dataSetColumns[((DataColumnMapping)value).DataSetColumn] = value;
  213. }
  214. public void Remove (object value)
  215. {
  216. int index = list.IndexOf (value);
  217. sourceColumns.Remove(((DataColumnMapping)value).SourceColumn);
  218. dataSetColumns.Remove(((DataColumnMapping)value).DataSetColumn);
  219. if (( index < 0 ) || (index >=list.Count))
  220. throw new ArgumentException("There is no such element in collection.");
  221. list.Remove (value);
  222. }
  223. public void RemoveAt (int index)
  224. {
  225. if (( index < 0 ) || (index >=list.Count))
  226. throw new IndexOutOfRangeException("There is no element in collection.");
  227. Remove (list[index]);
  228. }
  229. public void RemoveAt (string sourceColumn)
  230. {
  231. RemoveAt (list.IndexOf (sourceColumns[sourceColumn]));
  232. }
  233. #endregion // Methods
  234. }
  235. }