CurrencyManagerTest.cs 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988
  1. // Permission is hereby granted, free of charge, to any person obtaining
  2. // a copy of this software and associated documentation files (the
  3. // "Software"), to deal in the Software without restriction, including
  4. // without limitation the rights to use, copy, modify, merge, publish,
  5. // distribute, sublicense, and/or sell copies of the Software, and to
  6. // permit persons to whom the Software is furnished to do so, subject to
  7. // the following conditions:
  8. //
  9. // The above copyright notice and this permission notice shall be
  10. // included in all copies or substantial portions of the Software.
  11. //
  12. // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  13. // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  14. // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  15. // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  16. // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  17. // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  18. // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  19. //
  20. // Copyright (c) 2006 Novell, Inc.
  21. //
  22. // Authors:
  23. // Jackson Harper [email protected]
  24. using System;
  25. using System.Collections;
  26. using System.ComponentModel;
  27. using System.Data;
  28. using System.Reflection;
  29. using System.Windows.Forms;
  30. using NUnit.Framework;
  31. namespace MonoTests.System.Windows.Forms
  32. {
  33. [TestFixture]
  34. public class CurrencyManagerTest
  35. {
  36. [Test]
  37. public void Defaults ()
  38. {
  39. BindingContext bc = new BindingContext ();
  40. ArrayList data_source = new ArrayList ();
  41. CurrencyManager cm = bc [data_source] as CurrencyManager;
  42. Assert.AreSame (data_source, cm.List, "DEFAULTS1");
  43. Assert.AreEqual (0, cm.Count, "DEFAULTS2");
  44. Assert.AreEqual (-1, cm.Position, "DEFAULTS3");
  45. }
  46. [Test]
  47. [ExpectedException (typeof (IndexOutOfRangeException))]
  48. public void UninitializedCurrent ()
  49. {
  50. BindingContext bc = new BindingContext ();
  51. ArrayList data_source = new ArrayList ();
  52. CurrencyManager cm = bc [data_source] as CurrencyManager;
  53. // This line should throw
  54. Assert.AreSame (null, cm.Current, "CurrentOfEmpty");
  55. }
  56. [Test]
  57. public void DataSetList ()
  58. {
  59. DataSet dataset = new DataSet ("DataSet");
  60. DataTable table = new DataTable ("Table");
  61. BindingContext bc = new BindingContext ();
  62. CurrencyManager cm;
  63. dataset.Tables.Add (table);
  64. cm = bc [dataset] as CurrencyManager;
  65. Assert.AreEqual (typeof (DataViewManager), cm.List.GetType (), "DATASETLIST1");
  66. Assert.AreEqual (1, cm.Count, "DATASETLIST2");
  67. Assert.AreEqual (0, cm.Position, "DATASETLIST3");
  68. // Assert.AreEqual (typeof (DataViewManagerListItemTypeDescriptor), cm.Current.GetType (),
  69. // "DATASETLIST4");
  70. }
  71. [Test]
  72. public void DataSetListTable ()
  73. {
  74. DataSet dataset = new DataSet ("DataSet");
  75. DataTable table = new DataTable ("Table");
  76. BindingContext bc = new BindingContext ();
  77. CurrencyManager cm;
  78. dataset.Tables.Add (table);
  79. cm = bc [dataset, "Table"] as CurrencyManager;
  80. Assert.AreEqual (typeof (DataView), cm.List.GetType (), "DATASETLIST1");
  81. Assert.AreEqual (0, cm.Count, "DATASETLIST2");
  82. Assert.AreEqual (-1, cm.Position, "DATASETLIST3");
  83. }
  84. [Test]
  85. [ExpectedException (typeof (ArgumentException))]
  86. public void DataSetListTableBogusField ()
  87. {
  88. DataSet dataset = new DataSet ("DataSet");
  89. DataTable table = new DataTable ("Table.Column");
  90. BindingContext bc = new BindingContext ();
  91. CurrencyManager cm;
  92. dataset.Tables.Add (table);
  93. // child list can't be created
  94. cm = bc [dataset, "Table"] as CurrencyManager;
  95. }
  96. [Test] // bug #80107
  97. public void DataView ()
  98. {
  99. DataView dv = new DataView ();
  100. BindingContext bc = new BindingContext ();
  101. CurrencyManager cm = bc [dv, string.Empty] as CurrencyManager;
  102. Assert.IsNotNull (cm, "#A1");
  103. Assert.AreEqual (0, cm.Count, "#A2");
  104. Assert.AreEqual (-1, cm.Position, "#A3");
  105. DataTable dt = new DataTable ("Testdata");
  106. dt.Columns.Add ("A");
  107. dt.Columns.Add ("B");
  108. dt.Rows.Add (new object [] { "A1", "B1" });
  109. dt.Rows.Add (new object [] { "A2", "B2" });
  110. dv.Table = dt;
  111. Assert.AreEqual (2, cm.Count, "#B1");
  112. Assert.AreEqual (0, cm.Position, "#B2");
  113. }
  114. [Test]
  115. public void MoveArrayListForward ()
  116. {
  117. ArrayList data_source = new ArrayList ();
  118. BindingContext bc = new BindingContext ();
  119. for (int i = 0; i < 10; i++)
  120. data_source.Add (new object ());
  121. CurrencyManager cm = bc [data_source] as CurrencyManager;
  122. for (int i = 0; i < 10; i++) {
  123. Assert.AreSame (data_source [i], cm.Current, "MOVEALF" + i);
  124. cm.Position++;
  125. }
  126. cm.Position++;
  127. cm.Position++;
  128. Assert.AreSame (data_source [9], cm.Current, "MOVEALFEND");
  129. }
  130. [Test]
  131. public void MoveArrayListBackward ()
  132. {
  133. ArrayList data_source = new ArrayList ();
  134. BindingContext bc = new BindingContext ();
  135. for (int i = 0; i < 10; i++)
  136. data_source.Add (new object ());
  137. CurrencyManager cm = bc [data_source] as CurrencyManager;
  138. cm.Position = 9;
  139. for (int i = 9; i >= 0; i--) {
  140. Assert.AreSame (data_source [i], cm.Current, "MOVEALB" + i);
  141. cm.Position--;
  142. }
  143. cm.Position--;
  144. cm.Position--;
  145. Assert.AreSame (data_source [0], cm.Current, "MOVEALBSTART");
  146. }
  147. [Test]
  148. public void SetPositionArrayList ()
  149. {
  150. ArrayList data_source = new ArrayList ();
  151. BindingContext bc = new BindingContext ();
  152. for (int i = 0; i < 10; i++)
  153. data_source.Add (new object ());
  154. CurrencyManager cm = bc [data_source] as CurrencyManager;
  155. for (int i = 3; i >= 0; i--) {
  156. cm.Position = i;
  157. Assert.AreSame (data_source [i], cm.Current, "MOVEAL1-" + i);
  158. }
  159. cm.Position--;
  160. for (int i = 0; i < 10; i++) {
  161. cm.Position = i;
  162. Assert.AreSame (data_source [i], cm.Current, "MOVEAL2-" + i);
  163. }
  164. for (int i = 5; i < 10; i++) {
  165. cm.Position = i;
  166. Assert.AreSame (data_source [i], cm.Current, "MOVEAL3-" + i);
  167. }
  168. }
  169. [Test]
  170. public void LateBuildDataTable ()
  171. {
  172. DataTable data_source = new DataTable ("Table");
  173. BindingContext bc = new BindingContext ();
  174. CurrencyManager cm = bc [data_source] as CurrencyManager;
  175. Assert.AreEqual (-1, cm.Position, "LATEBUILDTABLE1");
  176. Assert.AreEqual (0, cm.Count, "LATEBUILDTABLE2");
  177. DataColumn column = new DataColumn ("Column");
  178. column.DataType = typeof (int);
  179. data_source.Columns.Add (column);
  180. for (int i = 0; i < 10; i++) {
  181. DataRow row = data_source.NewRow ();
  182. row ["Column"] = i;
  183. data_source.Rows.Add (row);
  184. }
  185. Assert.AreEqual (0, cm.Position, "LATEBUILDTABLE3");
  186. Assert.AreEqual (10, cm.Count, "LATEBUILDTABLE4");
  187. }
  188. [Test]
  189. public void LateBuildArrayList ()
  190. {
  191. ArrayList data_source = new ArrayList ();
  192. BindingContext bc = new BindingContext ();
  193. CurrencyManager cm = bc [data_source] as CurrencyManager;
  194. Assert.AreEqual (-1, cm.Position, "LATEBUILDLIST1");
  195. Assert.AreEqual (0, cm.Count, "LATEBUILDLIST2");
  196. data_source.AddRange (new object [] { 1, 2, 3, 4, 5, 6, 7 });
  197. Assert.AreEqual (-1, cm.Position, "LATEBUILDLIST3");
  198. Assert.AreEqual (7, cm.Count, "LATEBUILDLIST4");
  199. }
  200. [Test]
  201. public void MoveDataTableForward ()
  202. {
  203. DataTable data_source = new DataTable ("Table");
  204. BindingContext bc = new BindingContext ();
  205. CurrencyManager cm = bc [data_source] as CurrencyManager;
  206. DataColumn column = new DataColumn ("Column");
  207. column.DataType = typeof (int);
  208. data_source.Columns.Add (column);
  209. for (int i = 0; i < 10; i++) {
  210. DataRow row = data_source.NewRow ();
  211. row ["Column"] = i;
  212. data_source.Rows.Add (row);
  213. }
  214. for (int i = 0; i < 10; i++) {
  215. DataRowView row = cm.Current as DataRowView;
  216. Assert.IsFalse (row == null, "MOVETABLEF-NULL-" + i);
  217. Assert.AreEqual (row ["Column"], i, "MOVETABLEF-" + i);
  218. cm.Position++;
  219. }
  220. cm.Position++;
  221. cm.Position++;
  222. Assert.AreEqual (9, ((DataRowView) cm.Current) ["Column"], "MOVETABLEF-END");
  223. }
  224. [Test]
  225. public void MoveDataTableBackward ()
  226. {
  227. DataTable data_source = new DataTable ("Table");
  228. BindingContext bc = new BindingContext ();
  229. CurrencyManager cm = bc [data_source] as CurrencyManager;
  230. DataColumn column = new DataColumn ("Column");
  231. column.DataType = typeof (int);
  232. data_source.Columns.Add (column);
  233. for (int i = 0; i < 10; i++) {
  234. DataRow row = data_source.NewRow ();
  235. row ["Column"] = i;
  236. data_source.Rows.Add (row);
  237. }
  238. cm.Position = 9;
  239. for (int i = 9; i >= 0; i--) {
  240. DataRowView row = cm.Current as DataRowView;
  241. Assert.IsFalse (row == null, "MOVETABLEB-NULL-" + i);
  242. Assert.AreEqual (row ["Column"], i, "MOVETABLEB-" + i);
  243. cm.Position--;
  244. }
  245. cm.Position--;
  246. cm.Position--;
  247. Assert.AreEqual (0, ((DataRowView) cm.Current) ["Column"], "MOVETABLEB-START");
  248. }
  249. [Test]
  250. public void SetPositionDataTable ()
  251. {
  252. DataTable data_source = new DataTable ("Table");
  253. BindingContext bc = new BindingContext ();
  254. CurrencyManager cm = bc [data_source] as CurrencyManager;
  255. DataColumn column = new DataColumn ("Column");
  256. column.DataType = typeof (int);
  257. data_source.Columns.Add (column);
  258. for (int i = 0; i < 10; i++) {
  259. DataRow row = data_source.NewRow ();
  260. row ["Column"] = i;
  261. data_source.Rows.Add (row);
  262. }
  263. for (int i = 5; i < 10; i++) {
  264. cm.Position = i;
  265. DataRowView row = cm.Current as DataRowView;
  266. Assert.IsFalse (row == null, "SETTABLE1-NULL-" + i);
  267. Assert.AreEqual (row ["Column"], i, "SETTABLE1-" + i);
  268. }
  269. for (int i = 5; i >= 0; i--) {
  270. cm.Position = i;
  271. DataRowView row = cm.Current as DataRowView;
  272. Assert.IsFalse (row == null, "SETTABLE2-NULL-" + i);
  273. Assert.AreEqual (row ["Column"], i, "SETTABLE2-" + i);
  274. }
  275. }
  276. [Test]
  277. public void NavigateDataSetToTable ()
  278. {
  279. DataSet data_source = new DataSet ("DataSet");
  280. DataTable table = new DataTable ("Table");
  281. DataColumn column = new DataColumn ("Column");
  282. BindingContext bc = new BindingContext ();
  283. data_source.Tables.Add (table);
  284. column.DataType = typeof (int);
  285. table.Columns.Add (column);
  286. for (int i = 0; i < 10; i++) {
  287. DataRow row = table.NewRow ();
  288. row ["Column"] = i;
  289. table.Rows.Add (row);
  290. }
  291. CurrencyManager cm = bc [data_source, "Table"] as CurrencyManager;
  292. Assert.AreEqual (0, cm.Position, "NAVSETTOTABLE1");
  293. Assert.AreEqual (10, cm.Count, "NAVSETTOTABLE2");
  294. Assert.AreEqual (typeof (DataView), cm.List.GetType (), "NAVSETTOTABLE3");
  295. for (int i = 0; i < 10; i++) {
  296. DataRowView row = cm.Current as DataRowView;
  297. Assert.IsFalse (row == null, "NAVSETTOTABLE-NULL-" + i);
  298. Assert.AreEqual (i, row ["Column"], "NAVSETTOTABLE-" + i);
  299. cm.Position++;
  300. }
  301. cm.Position++;
  302. cm.Position++;
  303. Assert.AreEqual (9, ((DataRowView) cm.Current) ["Column"], "NAVSETTOTABLE-END");
  304. }
  305. [Test]
  306. public void NavigateDataSetToColumn ()
  307. {
  308. DataSet data_source = new DataSet ("DataSet");
  309. DataTable table = new DataTable ("Table");
  310. DataColumn column = new DataColumn ("Column");
  311. BindingContext bc = new BindingContext ();
  312. data_source.Tables.Add (table);
  313. column.DataType = typeof (int);
  314. table.Columns.Add (column);
  315. for (int i = 0; i < 10; i++) {
  316. DataRow row = table.NewRow ();
  317. row ["Column"] = i;
  318. table.Rows.Add (row);
  319. }
  320. CurrencyManager cm = bc [data_source, "Table.Column"] as CurrencyManager;
  321. Assert.AreEqual (null, cm, "NAVSETTOCOLUMN1");
  322. }
  323. [Test]
  324. public void NavigateDataSetToParentRelation ()
  325. {
  326. DataSet data_source = CreateRelatedDataSet ();
  327. BindingContext bc = new BindingContext ();
  328. CurrencyManager cm = bc [data_source, "Table1.Relation"] as CurrencyManager;
  329. Assert.AreEqual (0, cm.Position, "NAVSETTORELATION1");
  330. Assert.AreEqual (1, cm.Count, "NAVSETTORELATION2");
  331. Assert.IsTrue (cm.List is DataView, "NAVSETTORELATION3");
  332. DataRowView row = cm.Current as DataRowView;
  333. Assert.IsFalse (row == null, "NAVSETTORELATION-NULL-VALUE");
  334. Assert.AreEqual (0, row ["Two"], "NAVSETTORELATION-VALUE");
  335. cm.Position++;
  336. cm.Position++;
  337. Assert.AreEqual (0, ((DataRowView) cm.Current) ["Two"], "NAVSETTORELATION-END");
  338. }
  339. [Test]
  340. [ExpectedException (typeof (ArgumentException))]
  341. public void DataSetToChildRelation ()
  342. {
  343. DataSet data_source = CreateRelatedDataSet ();
  344. BindingContext bc = new BindingContext ();
  345. // Can't create a list on a child relation
  346. CurrencyManager cm = bc [data_source, "Table2.Relation"] as CurrencyManager;
  347. }
  348. [Test]
  349. public void DataSetToParentRelationField ()
  350. {
  351. DataSet data_source = CreateRelatedDataSet ();
  352. BindingContext bc = new BindingContext ();
  353. CurrencyManager cm = bc [data_source, "Table1.Relation.Two"] as CurrencyManager;
  354. Assert.AreEqual (null, cm, "SETTOPARENTRELATIONFIELD");
  355. }
  356. [Test]
  357. public void MultiColumnedRelation ()
  358. {
  359. DataSet dataset = new DataSet ();
  360. DataTable sports = new DataTable ("Sports");
  361. DataTable athletes = new DataTable ("Athletes");
  362. DataColumn column;
  363. DataRow row;
  364. column = new DataColumn ();
  365. column.DataType = typeof (int);
  366. column.ColumnName = "SportID";
  367. column.Unique = true;
  368. sports.Columns.Add (column);
  369. column = new DataColumn ();
  370. column.DataType = typeof (string);
  371. column.ColumnName = "SportName";
  372. sports.Columns.Add (column);
  373. string [] sports_names = new string [] { "Hockey", "Baseball", "Basketball", "Football", "Boxing", "Surfing" };
  374. for (int i = 0; i < sports_names.Length; i++) {
  375. row = sports.NewRow ();
  376. row ["SportID"] = i;
  377. row ["SportName"] = sports_names [i];
  378. sports.Rows.Add (row);
  379. }
  380. // Athletes table
  381. column = new DataColumn ();
  382. column.DataType = typeof (int);
  383. column.ColumnName = "AthleteID";
  384. column.Unique = true;
  385. athletes.Columns.Add (column);
  386. column = new DataColumn ();
  387. column.DataType = typeof (int);
  388. column.ColumnName = "Sport";
  389. athletes.Columns.Add (column);
  390. column = new DataColumn ();
  391. column.DataType = typeof (string);
  392. column.ColumnName = "AthleteName";
  393. athletes.Columns.Add (column);
  394. string [] athlete_names = new string [] { "@alp", "@lupus", "@tjfontaine", "duncan", "marv", "WindowsUninstall",
  395. "@jackson", "@migHome", "_Synced[work]", "GodZhila", "Raboo",
  396. "@jchambers", "@mkestner", "barbosa", "IzeBurn", "squinky86",
  397. "@kangaroo", "@paco", "Demian", "logiclrd", "tenshiKur0" };
  398. for (int i = 0; i < athlete_names.Length; i++) {
  399. row = athletes.NewRow ();
  400. row ["AthleteID"] = i;
  401. row ["Sport"] = i % sports_names.Length;
  402. row ["AthleteName"] = athlete_names [i];
  403. athletes.Rows.Add (row);
  404. }
  405. dataset.Tables.Add (sports);
  406. dataset.Tables.Add (athletes);
  407. dataset.Relations.Add ("AthletesSports", sports.Columns ["SportID"], athletes.Columns ["Sport"]);
  408. BindingContext bc = new BindingContext ();
  409. CurrencyManager cm = bc [dataset, "Sports.AthletesSports"] as CurrencyManager;
  410. Assert.AreEqual (0, cm.Position, "MC1");
  411. Assert.AreEqual (4, cm.Count, "MC2");
  412. DataRowView rowview = cm.Current as DataRowView;
  413. Assert.IsFalse (rowview == null, "MC3");
  414. Assert.AreEqual (0, rowview ["AthleteID"], "MC4");
  415. Assert.AreEqual ("@alp", rowview ["AthleteName"], "MC5");
  416. Assert.AreEqual (0, rowview ["Sport"], "MC6");
  417. cm.Position++;
  418. rowview = cm.Current as DataRowView;
  419. Assert.IsFalse (rowview == null, "MC7");
  420. Assert.AreEqual (6, rowview ["AthleteID"], "MC8");
  421. Assert.AreEqual ("@jackson", rowview ["AthleteName"], "MC9");
  422. Assert.AreEqual (0, rowview ["Sport"], "MC10");
  423. cm.Position++;
  424. rowview = cm.Current as DataRowView;
  425. Assert.IsFalse (rowview == null, "MC11");
  426. Assert.AreEqual (12, rowview ["AthleteID"], "MC12");
  427. Assert.AreEqual ("@mkestner", rowview ["AthleteName"], "MC13");
  428. Assert.AreEqual (0, rowview ["Sport"], "MC14");
  429. cm.Position++;
  430. rowview = cm.Current as DataRowView;
  431. Assert.IsFalse (rowview == null, "MC15");
  432. Assert.AreEqual (18, rowview ["AthleteID"], "MC16");
  433. Assert.AreEqual ("Demian", rowview ["AthleteName"], "MC17");
  434. Assert.AreEqual (0, rowview ["Sport"], "MC18");
  435. cm.Position++;
  436. rowview = cm.Current as DataRowView;
  437. Assert.IsFalse (rowview == null, "MC19");
  438. Assert.AreEqual (18, rowview ["AthleteID"], "MC20");
  439. Assert.AreEqual ("Demian", rowview ["AthleteName"], "MC21");
  440. Assert.AreEqual (0, rowview ["Sport"], "MC22");
  441. }
  442. private DataSet CreateRelatedDataSet ()
  443. {
  444. DataSet dataset = new DataSet ("DataSet");
  445. DataTable dt1 = new DataTable ("Table1");
  446. DataTable dt2 = new DataTable ("Table2");
  447. DataColumn column;
  448. column = new DataColumn ("One");
  449. column.DataType = typeof (int);
  450. column.Unique = true;
  451. dt1.Columns.Add (column);
  452. for (int i = 0; i < 10; i++) {
  453. DataRow row = dt1.NewRow ();
  454. row ["One"] = i;
  455. dt1.Rows.Add (row);
  456. }
  457. column = new DataColumn ("Two");
  458. column.DataType = typeof (int);
  459. column.Unique = true;
  460. dt2.Columns.Add (column);
  461. for (int i = 0; i < 10; i++) {
  462. DataRow row = dt2.NewRow ();
  463. row ["Two"] = i;
  464. dt2.Rows.Add (row);
  465. }
  466. dataset.Tables.Add (dt1);
  467. dataset.Tables.Add (dt2);
  468. dataset.Relations.Add ("Relation", dt1.Columns ["One"], dt2.Columns ["Two"]);
  469. return dataset;
  470. }
  471. [Test]
  472. public void EndUninitializedEdit ()
  473. {
  474. ArrayList list = new ArrayList ();
  475. BindingContext bc = new BindingContext ();
  476. CurrencyManager cm = bc [list] as CurrencyManager;
  477. cm.EndCurrentEdit ();
  478. }
  479. [Test]
  480. public void CancelUninitializedEdit ()
  481. {
  482. ArrayList list = new ArrayList ();
  483. BindingContext bc = new BindingContext ();
  484. CurrencyManager cm = bc [list] as CurrencyManager;
  485. cm.CancelCurrentEdit ();
  486. }
  487. [Test]
  488. public void CheckPositionOfRelatedSibling1 ()
  489. {
  490. DataSet data_source = CreateRelatedDataSet ();
  491. BindingContext bc = new BindingContext ();
  492. CurrencyManager cm = bc [data_source, "Table1.Relation"] as CurrencyManager;
  493. CurrencyManager scm = bc [data_source, "Table1"] as CurrencyManager;
  494. cm.Position++;
  495. cm.Position++;
  496. // position is not updated
  497. Assert.AreEqual (0, scm.Position, "#8");
  498. }
  499. [Test]
  500. public void CheckPositionOfRelatedSibling2 ()
  501. {
  502. DataSet data_source = CreateRelatedDataSet ();
  503. BindingContext bc = new BindingContext ();
  504. CurrencyManager cm = bc [data_source, "Table1.Relation"] as CurrencyManager;
  505. CurrencyManager scm = bc [data_source, "Table1"] as CurrencyManager;
  506. Assert.AreEqual (0, cm.Position, "#1");
  507. scm.Position++;
  508. Assert.AreEqual (0, cm.Position, "#2");
  509. }
  510. int event_num;
  511. int current_changed;
  512. int position_changed;
  513. int item_changed;
  514. ItemChangedEventArgs item_changed_args;
  515. void CurrentChanged (object sender, EventArgs args) { current_changed = ++event_num; /*Console.WriteLine ("current_changed = {0}", current_changed); Console.WriteLine (Environment.StackTrace);*/ }
  516. void PositionChanged (object sender, EventArgs args) { position_changed = ++event_num; /*Console.WriteLine ("position_changed = {0}", position_changed); Console.WriteLine (Environment.StackTrace);*/}
  517. void ItemChanged (object sender, ItemChangedEventArgs args) { item_changed = ++event_num; item_changed_args = args; /*Console.WriteLine ("item_changed = {0}, index = {1}", item_changed, args.Index); Console.WriteLine (Environment.StackTrace);*/ }
  518. void ListChanged (object sender, ListChangedEventArgs args) { /*Console.WriteLine ("ListChanged ({0},{1},{2})", args.ListChangedType, args.OldIndex, args.NewIndex); Console.WriteLine (Environment.StackTrace);*/ }
  519. [Test]
  520. public void AddNew ()
  521. {
  522. DataSet data_source = CreateRelatedDataSet ();
  523. BindingContext bc = new BindingContext ();
  524. CurrencyManager cm = bc [data_source, "Table1"] as CurrencyManager;
  525. event_num = current_changed = position_changed = -1;
  526. cm.CurrentChanged += new EventHandler (CurrentChanged);
  527. cm.PositionChanged += new EventHandler (PositionChanged);
  528. cm.ItemChanged += new ItemChangedEventHandler (ItemChanged);
  529. Assert.AreEqual (0, cm.Position, "AddNew1");
  530. Assert.AreEqual (10, cm.Count, "AddNew2");
  531. Assert.AreEqual (cm.Count, cm.List.Count, "AddNew2.5");
  532. cm.AddNew ();
  533. Assert.AreEqual (10, cm.Position, "AddNew3");
  534. Assert.AreEqual (11, cm.Count, "AddNew4");
  535. Assert.AreEqual (cm.Count, cm.List.Count, "AddNew4.5");
  536. Assert.AreEqual (0, item_changed, "AddNew5");
  537. Assert.AreEqual (-1, item_changed_args.Index, "AddNew6");
  538. Assert.AreEqual (1, current_changed, "AddNew7");
  539. Assert.AreEqual (2, position_changed, "AddNew8");
  540. cm.CurrentChanged -= new EventHandler (CurrentChanged);
  541. cm.PositionChanged -= new EventHandler (PositionChanged);
  542. }
  543. [Test]
  544. public void CancelAddNew ()
  545. {
  546. DataSet data_source = CreateRelatedDataSet ();
  547. BindingContext bc = new BindingContext ();
  548. CurrencyManager cm = bc [data_source, "Table1"] as CurrencyManager;
  549. DataView dv = cm.List as DataView;
  550. event_num = current_changed = position_changed = -1;
  551. cm.CurrentChanged += new EventHandler (CurrentChanged);
  552. cm.PositionChanged += new EventHandler (PositionChanged);
  553. cm.ItemChanged += new ItemChangedEventHandler (ItemChanged);
  554. dv.ListChanged += new ListChangedEventHandler (ListChanged);
  555. Assert.AreEqual (0, cm.Position, "CancelAddNew1");
  556. Assert.AreEqual (10, cm.Count, "CancelAddNew2");
  557. Assert.AreEqual (cm.Count, cm.List.Count, "AddNew2.5");
  558. cm.AddNew ();
  559. Assert.AreEqual (0, item_changed, "CancelAddNew3");
  560. Assert.AreEqual (-1, item_changed_args.Index, "CancelAddNew4");
  561. Assert.AreEqual (1, current_changed, "CancelAddNew5");
  562. Assert.AreEqual (2, position_changed, "CancelAddNew6");
  563. cm.CancelCurrentEdit ();
  564. Assert.AreEqual (6, item_changed, "CancelAddNew7");
  565. Assert.AreEqual (9, item_changed_args.Index, "CancelAddNew8");
  566. Assert.AreEqual (3, current_changed, "CancelAddNew9");
  567. Assert.AreEqual (4, position_changed, "CancelAddNew10");
  568. Assert.AreEqual (9, cm.Position, "CancelAddNew11");
  569. Assert.AreEqual (10, cm.Count, "CancelAddNew12");
  570. Assert.AreEqual (cm.Count, cm.List.Count, "AddNew12.5");
  571. cm.CurrentChanged -= new EventHandler (CurrentChanged);
  572. cm.PositionChanged -= new EventHandler (PositionChanged);
  573. }
  574. [Test]
  575. public void EndAddNew ()
  576. {
  577. DataSet data_source = CreateRelatedDataSet ();
  578. BindingContext bc = new BindingContext ();
  579. CurrencyManager cm = bc [data_source, "Table1"] as CurrencyManager;
  580. event_num = current_changed = position_changed = -1;
  581. cm.CurrentChanged += new EventHandler (CurrentChanged);
  582. cm.PositionChanged += new EventHandler (PositionChanged);
  583. cm.ItemChanged += new ItemChangedEventHandler (ItemChanged);
  584. Assert.AreEqual (0, cm.Position, "EndAddNew1");
  585. Assert.AreEqual (10, cm.Count, "EndAddNew2");
  586. cm.AddNew ();
  587. Assert.AreEqual (0, item_changed, "EndAddNew3");
  588. Assert.AreEqual (-1, item_changed_args.Index, "EndAddNew4");
  589. Assert.AreEqual (1, current_changed, "EndAddNew5");
  590. Assert.AreEqual (2, position_changed, "EndAddNew6");
  591. cm.EndCurrentEdit ();
  592. // Assert.AreEqual (3, item_changed, "EndAddNew7");
  593. // Assert.AreEqual (-1, item_changed_args.Index, "EndAddNew8");
  594. Assert.AreEqual (1, current_changed, "EndAddNew9");
  595. Assert.AreEqual (2, position_changed, "EndAddNew10");
  596. Assert.AreEqual (10, cm.Position, "EndAddNew11");
  597. Assert.AreEqual (11, cm.Count, "EndAddNew12");
  598. cm.CurrentChanged -= new EventHandler (CurrentChanged);
  599. cm.PositionChanged -= new EventHandler (PositionChanged);
  600. }
  601. [Test]
  602. public void AddNew2 ()
  603. {
  604. DataSet data_source = CreateRelatedDataSet ();
  605. BindingContext bc = new BindingContext ();
  606. CurrencyManager cm = bc [data_source, "Table1"] as CurrencyManager;
  607. DataView dv = cm.List as DataView;
  608. event_num = current_changed = position_changed = -1;
  609. cm.CurrentChanged += new EventHandler (CurrentChanged);
  610. cm.PositionChanged += new EventHandler (PositionChanged);
  611. cm.ItemChanged += new ItemChangedEventHandler (ItemChanged);
  612. dv.ListChanged += new ListChangedEventHandler (ListChanged);
  613. Assert.AreEqual (0, cm.Position, "AddNew1");
  614. Assert.AreEqual (10, cm.Count, "AddNew2");
  615. cm.AddNew ();
  616. Assert.AreEqual (10, cm.Position, "AddNew3");
  617. Assert.AreEqual (11, cm.Count, "AddNew4");
  618. // this does an implicit EndCurrentEdit
  619. cm.AddNew ();
  620. Assert.AreEqual (11, cm.Position, "AddNew5");
  621. Assert.AreEqual (12, cm.Count, "AddNew6");
  622. }
  623. DataSet CreateRelatedDataSetLarge ()
  624. {
  625. DataSet dataset = new DataSet ("CustomerSet");
  626. DataTable dt1 = new DataTable ("Customers");
  627. DataTable dt2 = new DataTable ("Orders");
  628. DataTable dt3 = new DataTable ("Addresses");
  629. DataColumn column;
  630. // customer table
  631. column = new DataColumn ("CustomerID");
  632. column.DataType = typeof (int);
  633. column.Unique = true;
  634. dt1.Columns.Add (column);
  635. column = new DataColumn ("CustomerName");
  636. column.DataType = typeof (string);
  637. column.Unique = false;
  638. dt1.Columns.Add (column);
  639. // order table
  640. column = new DataColumn ("OrderID");
  641. column.DataType = typeof (int);
  642. column.Unique = true;
  643. dt2.Columns.Add (column);
  644. column = new DataColumn ("ItemName");
  645. column.DataType = typeof (string);
  646. column.Unique = false;
  647. dt2.Columns.Add (column);
  648. column = new DataColumn ("CustomerID");
  649. column.DataType = typeof (int);
  650. column.Unique = false;
  651. dt2.Columns.Add (column);
  652. column = new DataColumn ("AddressID");
  653. column.DataType = typeof (int);
  654. column.Unique = false;
  655. dt2.Columns.Add (column);
  656. // address table
  657. column = new DataColumn ("AddressID");
  658. column.DataType = typeof (int);
  659. column.Unique = true;
  660. dt3.Columns.Add (column);
  661. column = new DataColumn ("AddressString");
  662. column.DataType = typeof (string);
  663. column.Unique = false;
  664. dt3.Columns.Add (column);
  665. column = new DataColumn ("CustomerID");
  666. column.DataType = typeof (int);
  667. column.Unique = false;
  668. dt3.Columns.Add (column);
  669. for (int i = 0; i < 10; i ++) {
  670. DataRow row = dt1.NewRow ();
  671. row["CustomerID"] = i;
  672. row["CustomerName"] = String.Format ("Customer Name #{0}", i);
  673. dt1.Rows.Add (row);
  674. }
  675. int ordernum = 0;
  676. for (int i = 0; i < 10; i ++) {
  677. for (int j = 0; j < (i < 5 ? 3 : 5); j ++) {
  678. DataRow row = dt2.NewRow ();
  679. row["OrderID"] = ordernum++;
  680. row["ItemName"] = String.Format ("Item order #{0}", j);
  681. row["CustomerID"] = i;
  682. row["AddressID"] = j;
  683. dt2.Rows.Add (row);
  684. }
  685. }
  686. int addressid = 0;
  687. for (int i = 0; i < 4; i ++) {
  688. for (int j = 0; j < 4; j ++) {
  689. DataRow row = dt3.NewRow ();
  690. row["AddressID"] = addressid++;
  691. row["AddressString"] = String.Format ("Customer Address {0}", j);
  692. row["CustomerID"] = i;
  693. dt3.Rows.Add (row);
  694. }
  695. }
  696. dataset.Tables.Add (dt1);
  697. dataset.Tables.Add (dt2);
  698. dataset.Tables.Add (dt3);
  699. dataset.Relations.Add ("Customer_Orders", dt1.Columns["CustomerID"], dt2.Columns["CustomerID"]);
  700. dataset.Relations.Add ("Customer_Addresses", dt1.Columns["CustomerID"], dt3.Columns["CustomerID"]);
  701. dataset.Relations.Add ("Address_Orders", dt3.Columns["AddressID"], dt2.Columns["AddressID"]);
  702. return dataset;
  703. }
  704. [Test]
  705. public void RelatedCurrencyManagerTest ()
  706. {
  707. DataSet data_source = CreateRelatedDataSetLarge ();
  708. BindingContext bc = new BindingContext ();
  709. CurrencyManager cm = bc [data_source, "Customers"] as CurrencyManager;
  710. CurrencyManager rcm = bc [data_source, "Customers.Customer_Orders"] as CurrencyManager;
  711. IList list = rcm.List;
  712. Assert.AreEqual (3, rcm.Count, "count1");
  713. Assert.AreEqual (3, list.Count, "listcount1");
  714. cm.Position = 1;
  715. Assert.AreEqual (3, rcm.Count, "count2");
  716. Assert.AreEqual (3, list.Count, "listcount2");
  717. cm.Position = 5;
  718. Assert.AreEqual (5, rcm.Count, "count3");
  719. Assert.AreEqual (3, list.Count, "listcount3");
  720. }
  721. [Test]
  722. public void TestCurrencyManagerBindings ()
  723. {
  724. DataSet data_source = CreateRelatedDataSetLarge ();
  725. BindingContext bc = new BindingContext ();
  726. CurrencyManager cm = bc [data_source] as CurrencyManager;
  727. Console.WriteLine ("cm properties:");
  728. foreach (PropertyDescriptor pd in cm.GetItemProperties ())
  729. Console.WriteLine (" + {0}", pd.Name);
  730. Console.WriteLine ();
  731. Console.WriteLine ("dataset:");
  732. Console.WriteLine ("cm = {0}", cm.GetType());
  733. Console.WriteLine ("cm.Count = {0}", cm.Count);
  734. cm.Position = 0;
  735. Console.WriteLine ("cm.Current = {0}", cm.Current);
  736. Console.WriteLine ("cm.Current properties");
  737. foreach (PropertyDescriptor pd in ((ICustomTypeDescriptor)cm.Current).GetProperties ())
  738. Console.WriteLine (" + {0}", pd.Name);
  739. Console.WriteLine ();
  740. cm = bc [data_source.Tables["Customers"]] as CurrencyManager;
  741. Console.WriteLine ("datatable:");
  742. Console.WriteLine ("cm = {0}", cm.GetType());
  743. Console.WriteLine ("cm.Count = {0}", cm.Count);
  744. cm.Position = 0;
  745. Console.WriteLine ("cm.Current = {0}", cm.Current);
  746. Console.WriteLine ("cm.Current properties");
  747. foreach (PropertyDescriptor pd in ((ICustomTypeDescriptor)cm.Current).GetProperties ())
  748. Console.WriteLine (" + {0}", pd.Name);
  749. Console.WriteLine ();
  750. DataViewManager vm = new DataViewManager (data_source);
  751. Console.WriteLine ("vm properties:");
  752. foreach (PropertyDescriptor pd in ((ITypedList)vm).GetItemProperties (null))
  753. Console.WriteLine (" + {0}", pd.Name);
  754. Console.WriteLine ();
  755. }
  756. Type GetFinalType (CurrencyManager cm)
  757. {
  758. FieldInfo fi = cm.GetType().GetField ("finalType", BindingFlags.NonPublic | BindingFlags.Instance);
  759. return (Type)fi.GetValue (cm);
  760. }
  761. [Test]
  762. public void FinalTypeTest ()
  763. {
  764. BindingContext bc = new BindingContext ();
  765. CurrencyManager cm;
  766. ArrayList al;
  767. DataSet data_source = CreateRelatedDataSetLarge ();
  768. /* empty arraylist */
  769. al = new ArrayList ();
  770. cm = bc[al] as CurrencyManager;
  771. Assert.AreEqual (typeof (ArrayList), GetFinalType (cm), "A1");
  772. /* arraylist with a string element*/
  773. al = new ArrayList ();
  774. al.Add ("hi");
  775. cm = bc[al] as CurrencyManager;
  776. Assert.AreEqual (typeof (ArrayList), GetFinalType (cm), "A2");
  777. /* string array */
  778. string[] s = new string[1];
  779. s[0] = "hi";
  780. cm = bc[s] as CurrencyManager;
  781. Assert.AreEqual (typeof (string[]), GetFinalType (cm), "A3");
  782. /* dataview */
  783. cm = bc [data_source, "Customers"] as CurrencyManager;
  784. Assert.AreEqual (typeof (DataView), GetFinalType (cm), "A4");
  785. /* relatedview */
  786. cm = bc [data_source, "Customers.Customer_Orders"] as CurrencyManager;
  787. /* on MS this is a RelatedView, on Mono a RelatedDataView. both subclass from DataView, so let's check that. */
  788. Assert.IsFalse (typeof (DataView) == GetFinalType (cm), "A5");
  789. Assert.IsTrue (typeof (DataView).IsAssignableFrom (GetFinalType (cm)), "A6");
  790. }
  791. }
  792. }