2
0

ObjectDataSourceViewTest.cs 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931
  1. //
  2. // Tests for System.Web.UI.WebControls.ObjectDataSourceView
  3. //
  4. // Author:
  5. // Chris Toshok ([email protected])
  6. // Konstantin Triger ([email protected])
  7. // Yoni Klain ([email protected])
  8. //
  9. //
  10. // Copyright (C) 2006 Novell, Inc (http://www.novell.com)
  11. //
  12. // Permission is hereby granted, free of charge, to any person obtaining
  13. // a copy of this software and associated documentation files (the
  14. // "Software"), to deal in the Software without restriction, including
  15. // without limitation the rights to use, copy, modify, merge, publish,
  16. // distribute, sublicense, and/or sell copies of the Software, and to
  17. // permit persons to whom the Software is furnished to do so, subject to
  18. // the following conditions:
  19. //
  20. // The above copyright notice and this permission notice shall be
  21. // included in all copies or substantial portions of the Software.
  22. //
  23. // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  24. // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  25. // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  26. // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  27. // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  28. // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  29. // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  30. //
  31. // WARNING NOTES : ALL NUNITWEB TESTS DOING UNLOAD BETWEEN TESTS FOR RELOAD
  32. // OBJECT DATA SOURCE DEFAULT DATA
  33. #if NET_2_0
  34. using NUnit.Framework;
  35. using System;
  36. using System.Configuration;
  37. using System.Data.Common;
  38. using System.IO;
  39. using System.Globalization;
  40. using System.Web;
  41. using System.Web.UI;
  42. using System.Web.UI.WebControls;
  43. using System.Data;
  44. using System.Collections;
  45. using MonoTests.SystemWeb.Framework;
  46. using MonoTests.stand_alone.WebHarness;
  47. using System.Threading;
  48. namespace MonoTests.System.Web.UI.WebControls
  49. {
  50. class ObjectViewPoker : ObjectDataSourceView
  51. {
  52. public ObjectViewPoker (ObjectDataSource ds, string name, HttpContext context)
  53. : base (ds, name, context)
  54. {
  55. TrackViewState ();
  56. }
  57. public bool IsTrackingViewState ()
  58. {
  59. return base.IsTrackingViewState;
  60. }
  61. public object SaveToViewState ()
  62. {
  63. return SaveViewState ();
  64. }
  65. public void LoadFromViewState (object savedState)
  66. {
  67. LoadViewState (savedState);
  68. }
  69. public void DoOnDeleting (ObjectDataSourceMethodEventArgs e)
  70. {
  71. base.OnDeleting (e);
  72. }
  73. public void DoOnInserting (ObjectDataSourceMethodEventArgs e)
  74. {
  75. base.OnInserting (e);
  76. }
  77. public void DoOnFiltering (ObjectDataSourceFilteringEventArgs e)
  78. {
  79. base.OnFiltering (e);
  80. }
  81. public void DoOnObjectCreating (ObjectDataSourceEventArgs e)
  82. {
  83. base.OnObjectCreating (e);
  84. }
  85. public void DoOnObjectCreated (ObjectDataSourceEventArgs e)
  86. {
  87. base.OnObjectCreated (e);
  88. }
  89. public void DoOnObjectDisposing (ObjectDataSourceDisposingEventArgs e)
  90. {
  91. base.OnObjectDisposing (e);
  92. }
  93. public void DoOnSelecting (ObjectDataSourceSelectingEventArgs e)
  94. {
  95. base.OnSelecting (e);
  96. }
  97. public void DoOnUpdating (ObjectDataSourceMethodEventArgs e)
  98. {
  99. base.OnUpdating (e);
  100. }
  101. public void DoOnUpdated (ObjectDataSourceStatusEventArgs e)
  102. {
  103. base.OnUpdated (e);
  104. }
  105. public void DoOnDeleted (ObjectDataSourceStatusEventArgs e)
  106. {
  107. base.OnDeleted (e);
  108. }
  109. public void DoOnInserted (ObjectDataSourceStatusEventArgs e)
  110. {
  111. base.OnInserted (e);
  112. }
  113. public void DoOnSelected (ObjectDataSourceStatusEventArgs e)
  114. {
  115. base.OnSelected (e);
  116. }
  117. public int DoExecuteDelete (IDictionary keys, IDictionary oldValues)
  118. {
  119. return base.ExecuteDelete (keys, oldValues);
  120. }
  121. }
  122. [TestFixture]
  123. public class ObjectDataSourceViewTest
  124. {
  125. [SetUp]
  126. public void SetupTestCase ()
  127. {
  128. Thread.Sleep (100);
  129. }
  130. [Test]
  131. public void Defaults ()
  132. {
  133. ObjectDataSource ds = new ObjectDataSource ();
  134. ObjectViewPoker sql = new ObjectViewPoker (ds, "DefaultView", null);
  135. Assert.IsFalse (sql.CanDelete, "CanDelete");
  136. Assert.IsFalse (sql.CanInsert, "CanInsert");
  137. Assert.IsFalse (sql.CanPage, "CanPage");
  138. Assert.IsTrue (sql.CanSort, "CanSort");
  139. Assert.IsFalse (sql.CanUpdate, "CanUpdate");
  140. Assert.AreEqual (ConflictOptions.OverwriteChanges, sql.ConflictDetection, "ConflictDetection");
  141. Assert.IsFalse (sql.ConvertNullToDBNull, "ConvertNullToDBNull");
  142. Assert.AreEqual ("", sql.DataObjectTypeName, "DataObjectTypeName");
  143. Assert.AreEqual ("", sql.DeleteMethod, "DeleteMethod");
  144. Assert.IsNotNull (sql.DeleteParameters, "DeleteParameters");
  145. Assert.AreEqual (0, sql.DeleteParameters.Count, "DeleteParameters.Count");
  146. Assert.IsFalse (sql.EnablePaging, "EnablePaging");
  147. Assert.AreEqual ("", sql.InsertMethod, "InsertMethod");
  148. Assert.IsNotNull (sql.InsertParameters, "InsertParameters");
  149. Assert.AreEqual (0, sql.InsertParameters.Count, "InsertParameters.Count");
  150. Assert.AreEqual ("", sql.FilterExpression, "FilterExpression");
  151. Assert.IsNotNull (sql.FilterParameters, "FilterParameters");
  152. Assert.AreEqual (0, sql.FilterParameters.Count, "FilterParameters.Count");
  153. Assert.AreEqual ("maximumRows", sql.MaximumRowsParameterName, "MaximumRowsParameterName");
  154. Assert.AreEqual ("", sql.SelectCountMethod, "SelectCountMethod");
  155. Assert.AreEqual ("", sql.SelectMethod, "SelectMethod");
  156. Assert.AreEqual ("{0}", sql.OldValuesParameterFormatString, "OldValuesParameterFormatString");
  157. Assert.IsNotNull (sql.SelectParameters, "SelectParameters");
  158. Assert.AreEqual (0, sql.SelectParameters.Count, "SelectParameters.Count");
  159. Assert.AreEqual ("", sql.SortParameterName, "SortParameterName");
  160. Assert.IsNotNull (sql.UpdateParameters, "UpdateParameters");
  161. Assert.AreEqual (0, sql.UpdateParameters.Count, "UpdateParameters.Count");
  162. Assert.AreEqual ("startRowIndex", sql.StartRowIndexParameterName, "StartRowIndexParameterName");
  163. Assert.AreEqual ("", sql.TypeName, "TypeName");
  164. Assert.AreEqual ("", sql.UpdateMethod, "UpdateMethod");
  165. Assert.AreEqual (true, sql.IsTrackingViewState (), "IsTrackingViewState");
  166. }
  167. [Test]
  168. public void DefaultsNotWorking ()
  169. {
  170. ObjectDataSource ds = new ObjectDataSource ();
  171. ObjectViewPoker sql = new ObjectViewPoker (ds, "DefaultView", null);
  172. Assert.IsTrue (sql.CanRetrieveTotalRowCount, "CanRetrieveTotalRowCount");
  173. }
  174. [Test]
  175. public void DefaultsAssignProperties ()
  176. {
  177. ObjectDataSource ds = new ObjectDataSource ();
  178. ObjectViewPoker sql = new ObjectViewPoker (ds, "DefaultView", null);
  179. sql.ConflictDetection = ConflictOptions.CompareAllValues;
  180. Assert.AreEqual (ConflictOptions.CompareAllValues, sql.ConflictDetection, "ConflictDetection");
  181. sql.ConvertNullToDBNull = true;
  182. Assert.IsTrue (sql.ConvertNullToDBNull, "ConvertNullToDBNull");
  183. sql.DataObjectTypeName = "test";
  184. Assert.AreEqual ("test", sql.DataObjectTypeName, "DataObjectTypeName");
  185. sql.DeleteMethod = "test";
  186. Assert.AreEqual ("test", sql.DeleteMethod, "DeleteMethod");
  187. sql.EnablePaging = true;
  188. Assert.IsTrue (sql.EnablePaging, "EnablePaging");
  189. sql.InsertMethod = "test";
  190. Assert.AreEqual ("test", sql.InsertMethod, "InsertMethod");
  191. sql.FilterExpression = "test";
  192. Assert.AreEqual ("test", sql.FilterExpression, "FilterExpression");
  193. sql.MaximumRowsParameterName = "test";
  194. Assert.AreEqual ("test", sql.MaximumRowsParameterName, "MaximumRowsParameterName");
  195. sql.SelectCountMethod = "test";
  196. Assert.AreEqual ("test", sql.SelectCountMethod, "SelectCountMethod");
  197. sql.SelectMethod = "test";
  198. Assert.AreEqual ("test", sql.SelectMethod, "SelectMethod");
  199. sql.OldValuesParameterFormatString = "test";
  200. Assert.AreEqual ("test", sql.OldValuesParameterFormatString, "OldValuesParameterFormatString");
  201. sql.StartRowIndexParameterName = "test";
  202. Assert.AreEqual ("test", sql.StartRowIndexParameterName, "StartRowIndexParameterName");
  203. sql.TypeName = "test";
  204. Assert.AreEqual ("test", sql.TypeName, "TypeName");
  205. sql.UpdateMethod = "test";
  206. Assert.AreEqual ("test", sql.UpdateMethod, "UpdateMethod");
  207. Assert.AreEqual ("DefaultView", sql.Name, "Name");
  208. }
  209. [Test]
  210. public void ViewState ()
  211. {
  212. // Note :
  213. // IStateManager implementation allows public access to control state
  214. // Nothing added to viewstate
  215. ObjectDataSourceView view;
  216. MyDataSource ds = new MyDataSource ();
  217. ds.ID = "ObjectDataSource2";
  218. ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
  219. ds.SelectMethod = "Select";
  220. ds.SelectCountMethod = "SelectCount";
  221. Parameter p1 = new Parameter ("test", TypeCode.String);
  222. ds.SelectParameters.Add (p1);
  223. ds.FilterParameters.Add (p1);
  224. view = (ObjectDataSourceView) ds.DoGetView ("DefaultView");
  225. view.ConflictDetection = ConflictOptions.CompareAllValues;
  226. view.ConvertNullToDBNull = true;
  227. view.DataObjectTypeName = "test";
  228. view.DeleteMethod = "test";
  229. view.EnablePaging = true;
  230. view.InsertMethod = "test";
  231. view.FilterExpression = "test";
  232. view.MaximumRowsParameterName = "test";
  233. view.SelectCountMethod = "test";
  234. view.SelectMethod = "test";
  235. view.OldValuesParameterFormatString = "test";
  236. view.StartRowIndexParameterName = "test";
  237. view.TypeName = "test";
  238. view.UpdateMethod = "test";
  239. ((IStateManager) view).TrackViewState ();
  240. object state = ((IStateManager) view).SaveViewState ();
  241. ObjectDataSourceView copy = new ObjectDataSourceView (ds, "DefaultView", null);
  242. ((IStateManager) copy).LoadViewState (state);
  243. Assert.AreEqual (null, state, "ViewState#1");
  244. }
  245. [Test]
  246. public void CanDelete ()
  247. {
  248. ObjectDataSource ds = new ObjectDataSource ();
  249. ObjectViewPoker sql = new ObjectViewPoker (ds, "DefaultView", null);
  250. sql.DeleteMethod = "DeleteMethod";
  251. Assert.IsTrue (sql.CanDelete, "A1");
  252. sql.DeleteMethod = "";
  253. Assert.IsFalse (sql.CanDelete, "A2");
  254. sql.DeleteMethod = null;
  255. Assert.IsFalse (sql.CanDelete, "A3");
  256. }
  257. [Test]
  258. public void CanInsert ()
  259. {
  260. ObjectDataSource ds = new ObjectDataSource ();
  261. ObjectViewPoker sql = new ObjectViewPoker (ds, "DefaultView", null);
  262. sql.InsertMethod = "InsertMethod";
  263. Assert.IsTrue (sql.CanInsert, "A1");
  264. sql.InsertMethod = "";
  265. Assert.IsFalse (sql.CanInsert, "A2");
  266. sql.InsertMethod = null;
  267. Assert.IsFalse (sql.CanInsert, "A3");
  268. }
  269. [Test]
  270. public void CanUpdate ()
  271. {
  272. ObjectDataSource ds = new ObjectDataSource ();
  273. ObjectViewPoker sql = new ObjectViewPoker (ds, "DefaultView", null);
  274. sql.UpdateMethod = "UpdateMethod";
  275. Assert.IsTrue (sql.CanUpdate, "A1");
  276. sql.UpdateMethod = "";
  277. Assert.IsFalse (sql.CanUpdate, "A2");
  278. sql.UpdateMethod = null;
  279. Assert.IsFalse (sql.CanUpdate, "A3");
  280. }
  281. [Test]
  282. public void CanRetrieveTotalRowCount () {
  283. ObjectDataSource ds = new ObjectDataSource ();
  284. ObjectDataSourceView view = new ObjectDataSourceView (ds, "DefaultView", null);
  285. Assert.IsFalse (view.CanPage, "CanPage#1");
  286. Assert.IsTrue (view.CanRetrieveTotalRowCount, "CanRetrieveTotalRowCount#1");
  287. view.EnablePaging = true;
  288. Assert.IsTrue (view.CanPage, "CanPage#2");
  289. Assert.IsFalse (view.CanRetrieveTotalRowCount, "CanRetrieveTotalRowCount#2");
  290. view.SelectCountMethod = "SelectCountMethod";
  291. Assert.IsTrue (view.CanPage, "CanPage#3");
  292. Assert.IsTrue (view.CanRetrieveTotalRowCount, "CanRetrieveTotalRowCount#3");
  293. view.EnablePaging = false;
  294. Assert.IsFalse (view.CanPage, "CanPage#4");
  295. Assert.IsTrue (view.CanRetrieveTotalRowCount, "CanRetrieveTotalRowCount#4");
  296. }
  297. [Test]
  298. public void OldValuesParameterFormatString ()
  299. {
  300. ObjectDataSource ds = new ObjectDataSource ();
  301. Assert.AreEqual ("{0}", ds.OldValuesParameterFormatString, "A1");
  302. ds.OldValuesParameterFormatString = "hi {0}";
  303. ObjectViewPoker sql = new ObjectViewPoker (ds, "DefaultView", null);
  304. Assert.AreEqual ("{0}", sql.OldValuesParameterFormatString, "A2");
  305. ds.OldValuesParameterFormatString = "hi {0}";
  306. Assert.AreEqual ("{0}", sql.OldValuesParameterFormatString, "A3");
  307. ds.OldValuesParameterFormatString = "{0}";
  308. sql.OldValuesParameterFormatString = "hi {0}";
  309. Assert.AreEqual ("{0}", ds.OldValuesParameterFormatString, "A4");
  310. }
  311. [Test]
  312. [Category("NunitWeb")]
  313. public void DeleteMethod ()
  314. {
  315. WebTest t = new WebTest (PageInvoker.CreateOnLoad (delete));
  316. string html = t.Run ();
  317. Assert.AreEqual (-1, html.IndexOf("Yonik"), "ObjectDataSourceViewDelete");
  318. WebTest.Unload ();
  319. }
  320. public static void delete (Page p)
  321. {
  322. LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG);
  323. LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG);
  324. ObjectDataSourceView view;
  325. GridView grid = new GridView ();
  326. MyDataSource ds = new MyDataSource ();
  327. ds.ID = "ObjectDataSource2";
  328. ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
  329. ds.SelectMethod = "Select";
  330. ds.DeleteMethod = "Delete";
  331. ds.InsertMethod = "Insert";
  332. ds.UpdateMethod = "Update";
  333. Parameter p1 = new Parameter ("ID", TypeCode.String);
  334. Parameter p2 = new Parameter ("FName", TypeCode.String);
  335. Parameter p3 = new Parameter ("LName", TypeCode.String);
  336. ds.DeleteParameters.Add (p1);
  337. ds.DeleteParameters.Add (p2);
  338. ds.DeleteParameters.Add (p3);
  339. grid.ID = "Grid";
  340. grid.DataKeyNames = new string[] { "ID", "FName", "LName" };
  341. grid.DataSourceID = "ObjectDataSource2";
  342. p.Form.Controls.Add (lcb);
  343. p.Form.Controls.Add (ds);
  344. p.Form.Controls.Add (grid);
  345. p.Form.Controls.Add (lce);
  346. view = (ObjectDataSourceView) ds.DoGetView ("DefaultView");
  347. view.Deleting += new ObjectDataSourceMethodEventHandler (Event);
  348. Hashtable table = new Hashtable ();
  349. table.Add ("ID", "1001");
  350. table.Add ("FName", "Yonik");
  351. table.Add ("LName", "Laim");
  352. view.Delete (table, null);
  353. Assert.AreEqual (true, view.CanDelete, "CanDelete");
  354. Assert.AreEqual ("Delete", view.DeleteMethod, "DeleteMethod");
  355. Assert.AreEqual (3, view.DeleteParameters.Count, "DeleteParameters.Count");
  356. Assert.AreEqual ("ID", view.DeleteParameters[0].Name, "DeleteParametersName#1");
  357. Assert.AreEqual ("FName", view.DeleteParameters[1].Name, "DeleteParametersName#2");
  358. Assert.AreEqual ("LName", view.DeleteParameters[2].Name, "DeleteParametersName#3");
  359. ObjectDataSourceViewTest.Eventassert ("Delete event has not fired");
  360. }
  361. [Test]
  362. [Category ("NunitWeb")]
  363. public void SelectMethod ()
  364. {
  365. WebTest t = new WebTest (PageInvoker.CreateOnLoad (select));
  366. string html = t.Run ();
  367. string origin = @"<div>
  368. <table cellspacing=""0"" rules=""all"" border=""1"" id=""Grid"" style=""border-collapse:collapse;"">
  369. <tr>
  370. <th scope=""col"">ID</th><th scope=""col"">FName</th><th scope=""col"">LName</th>
  371. </tr><tr>
  372. <td>1001</td><td>Mahesh</td><td>Chand</td>
  373. </tr>
  374. </table>
  375. </div>";
  376. HtmlDiff.AssertAreEqual (origin, HtmlDiff.GetControlFromPageHtml (html), "ObjectDataSourceViewSelect");
  377. WebTest.Unload ();
  378. }
  379. public static void select (Page p)
  380. {
  381. LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG);
  382. LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG);
  383. ObjectDataSourceView view;
  384. GridView grid = new GridView ();
  385. MyDataSource ds = new MyDataSource ();
  386. ds.ID = "ObjectDataSource2";
  387. ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
  388. ds.SelectMethod = "Select";
  389. grid.ID = "Grid";
  390. grid.DataKeyNames = new string[] { "ID" };
  391. grid.DataSourceID = "ObjectDataSource2";
  392. p.Form.Controls.Add (lcb);
  393. p.Form.Controls.Add (ds);
  394. p.Form.Controls.Add (grid);
  395. p.Form.Controls.Add (lce);
  396. view = (ObjectDataSourceView) ds.DoGetView ("DefaultView");
  397. view.Selecting += new ObjectDataSourceSelectingEventHandler (view_Selecting);
  398. DataView view1 = (DataView) view.Select (new DataSourceSelectArguments ());
  399. Assert.AreEqual (1, view1.Count, "SelectedRowsCount");
  400. Assert.AreEqual (1001, view1[0].Row["ID"], "SelectedRowsValue#1");
  401. Assert.AreEqual ("Mahesh", view1[0].Row["FName"], "SelectedRowsValue#2");
  402. Assert.AreEqual ("Chand", view1[0].Row["LName"], "SelectedRowsValue#3");
  403. ObjectDataSourceViewTest.Eventassert ("Select event has not fired");
  404. }
  405. [Test]
  406. [Category ("NunitWeb")]
  407. public void SelectCountMethod ()
  408. {
  409. // This method will render grid view with paging
  410. // Note : ObjectDataSource will return page counter 5 hard coded
  411. WebTest t = new WebTest (PageInvoker.CreateOnLoad (selectcount));
  412. string html = t.Run ();
  413. string origin = @"<div>
  414. <table cellspacing=""0"" rules=""all"" border=""1"" id=""Grid"" style=""border-collapse:collapse;"">
  415. <tr>
  416. <th scope=""col"">ID</th><th scope=""col"">FName</th><th scope=""col"">LName</th>
  417. </tr><tr>
  418. <td>1001</td><td>Mahesh</td><td>Chand</td>
  419. </tr><tr>
  420. <td colspan=""3""><table border=""0"">
  421. <tr>
  422. <td><span>1</span></td><td><a href=""javascript:__doPostBack('Grid','Page$2')"">2</a></td><td><a href=""javascript:__doPostBack('Grid','Page$3')"">3</a></td><td><a href=""javascript:__doPostBack('Grid','Page$4')"">4</a></td><td><a href=""javascript:__doPostBack('Grid','Page$5')"">5</a></td>
  423. </tr>
  424. </table></td>
  425. </tr>
  426. </table>
  427. </div>";
  428. HtmlDiff.AssertAreEqual (origin, HtmlDiff.GetControlFromPageHtml (html), "ObjectDataSourceViewSelectCount");
  429. WebTest.Unload ();
  430. }
  431. public static void selectcount (Page p)
  432. {
  433. // This method will render grid view with paging
  434. // Note : ObjectDataSource will return page counter 5 hard coded
  435. LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG);
  436. LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG);
  437. ObjectDataSourceView view;
  438. GridView grid = new GridView ();
  439. MyDataSource ds = new MyDataSource ();
  440. ds.ID = "ObjectDataSource2";
  441. ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
  442. ds.SelectMethod = "Select";
  443. ds.SelectCountMethod = "SelectCount";
  444. grid.ID = "Grid";
  445. grid.DataKeyNames = new string[] { "ID" };
  446. grid.DataSourceID = "ObjectDataSource2";
  447. grid.AllowPaging = true;
  448. grid.PageSize = 1;
  449. p.Form.Controls.Add (lcb);
  450. p.Form.Controls.Add (ds);
  451. p.Form.Controls.Add (grid);
  452. p.Form.Controls.Add (lce);
  453. view = (ObjectDataSourceView) ds.DoGetView ("DefaultView");
  454. Assert.IsTrue (view.CanRetrieveTotalRowCount, "CanRetrieveTotalRowCount");
  455. }
  456. [Test]
  457. [Category ("NunitWeb")]
  458. public void InsertMethod ()
  459. {
  460. WebTest t = new WebTest (PageInvoker.CreateOnLoad (insert));
  461. string html = t.Run ();
  462. string origin = @"<div>
  463. <table cellspacing=""0"" rules=""all"" border=""1"" id=""Grid"" style=""border-collapse:collapse;"">
  464. <tr>
  465. <th scope=""col"">ID</th><th scope=""col"">FName</th><th scope=""col"">LName</th>
  466. </tr><tr>
  467. <td>1001</td><td>Mahesh</td><td>Chand</td>
  468. </tr><tr>
  469. <td>1000</td><td>Yonik</td><td>Laim</td>
  470. </tr>
  471. </table>
  472. </div>";
  473. HtmlDiff.AssertAreEqual (origin, HtmlDiff.GetControlFromPageHtml (html), "ObjectDataSourceViewInsert");
  474. WebTest.Unload ();
  475. }
  476. public static void insert (Page p)
  477. {
  478. LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG);
  479. LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG);
  480. ObjectDataSourceView view;
  481. GridView grid = new GridView ();
  482. MyDataSource ds = new MyDataSource ();
  483. ds.ID = "ObjectDataSource1";
  484. ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
  485. ds.SelectMethod = "Select";
  486. ds.InsertMethod = "Insert";
  487. Parameter p1 = new Parameter ("ID", TypeCode.String);
  488. Parameter p2 = new Parameter ("FName", TypeCode.String);
  489. Parameter p3 = new Parameter ("LName", TypeCode.String);
  490. ds.InsertParameters.Add (p1);
  491. ds.InsertParameters.Add (p2);
  492. ds.InsertParameters.Add (p3);
  493. grid.ID = "Grid";
  494. grid.DataSourceID = "ObjectDataSource1";
  495. p.Form.Controls.Add (lcb);
  496. p.Form.Controls.Add (ds);
  497. p.Form.Controls.Add (grid);
  498. p.Form.Controls.Add (lce);
  499. view = (ObjectDataSourceView) ds.DoGetView ("DefaultView");
  500. view.Inserting += new ObjectDataSourceMethodEventHandler (Event);
  501. Hashtable table = new Hashtable ();
  502. table.Add ("ID", "1000");
  503. table.Add ("FName", "Yonik");
  504. table.Add ("LName", "Laim");
  505. view.Insert (table);
  506. Assert.AreEqual (true, view.CanInsert, "CanInsert");
  507. Assert.AreEqual ("Insert", view.InsertMethod, "InsertMethod");
  508. Assert.AreEqual (3, view.InsertParameters.Count, "InsertParameters.Count");
  509. Assert.AreEqual ("ID", view.InsertParameters[0].Name, "InsertParametersName#1");
  510. Assert.AreEqual ("FName", view.InsertParameters[1].Name, "InsertParametersName#2");
  511. Assert.AreEqual ("LName", view.InsertParameters[2].Name, "InsertParametersName#3");
  512. ObjectDataSourceViewTest.Eventassert ("Insert event has not fired");
  513. }
  514. [Test]
  515. [Category ("NunitWeb")]
  516. public void UpdateMethod ()
  517. {
  518. WebTest t = new WebTest (PageInvoker.CreateOnLoad (update));
  519. string html = t.Run ();
  520. string origin = @"<div>
  521. <table cellspacing=""0"" rules=""all"" border=""1"" id=""Grid"" style=""border-collapse:collapse;"">
  522. <tr>
  523. <th scope=""col"">ID</th><th scope=""col"">FName</th><th scope=""col"">LName</th>
  524. </tr><tr>
  525. <td>1001</td><td>Yonik</td><td>Laim</td>
  526. </tr>
  527. </table>
  528. </div>";
  529. HtmlDiff.AssertAreEqual (origin, HtmlDiff.GetControlFromPageHtml (html), "ObjectDataSourceViewUpdate");
  530. WebTest.Unload ();
  531. }
  532. public static void update (Page p)
  533. {
  534. LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG);
  535. LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG);
  536. ObjectDataSourceView view;
  537. GridView grid = new GridView ();
  538. MyDataSource ds = new MyDataSource ();
  539. ds.ID = "ObjectDataSource1";
  540. ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
  541. ds.SelectMethod = "Select";
  542. ds.DeleteMethod = "Delete";
  543. ds.InsertMethod = "Insert";
  544. ds.UpdateMethod = "Update";
  545. Parameter p1 = new Parameter ("ID", TypeCode.String);
  546. Parameter p2 = new Parameter ("FName", TypeCode.String);
  547. Parameter p3 = new Parameter ("LName", TypeCode.String);
  548. ds.UpdateParameters.Add (p1);
  549. ds.UpdateParameters.Add (p2);
  550. ds.UpdateParameters.Add (p3);
  551. grid.ID = "Grid";
  552. grid.DataSourceID = "ObjectDataSource1";
  553. p.Form.Controls.Add (lcb);
  554. p.Form.Controls.Add (ds);
  555. p.Form.Controls.Add (grid);
  556. p.Form.Controls.Add (lce);
  557. view = (ObjectDataSourceView) ds.DoGetView ("defaultView");
  558. view.Updating += new ObjectDataSourceMethodEventHandler (Event);
  559. Hashtable table = new Hashtable ();
  560. table.Add ("ID", "1001");
  561. table.Add ("FName", "Yonik");
  562. table.Add ("LName", "Laim");
  563. view.Update (null, table, null);
  564. Assert.AreEqual (true, view.CanUpdate, "CanUpdate");
  565. Assert.AreEqual ("Update", view.UpdateMethod, "UpdateMethod");
  566. Assert.AreEqual (3, view.UpdateParameters.Count, "UpdateParameters.Count");
  567. Assert.AreEqual ("ID", view.UpdateParameters[0].Name, "UpdateParametersName#1");
  568. Assert.AreEqual ("FName", view.UpdateParameters[1].Name, "UpdateParametersName#2");
  569. Assert.AreEqual ("LName", view.UpdateParameters[2].Name, "UpdateParametersName#3");
  570. ObjectDataSourceViewTest.Eventassert ("Update event has not fired");
  571. }
  572. //Events
  573. [Test]
  574. public void UpdateEvent ()
  575. {
  576. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  577. view.Updating += new ObjectDataSourceMethodEventHandler (Event);
  578. view.DoOnUpdating (new ObjectDataSourceMethodEventArgs (null));
  579. Eventassert ("UpdateEvent");
  580. view.Updated += new ObjectDataSourceStatusEventHandler (view_Status);
  581. view.DoOnUpdated (new ObjectDataSourceStatusEventArgs (null, null));
  582. Eventassert ("UpdateEvent");
  583. }
  584. [Test]
  585. public void SelectEvent ()
  586. {
  587. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  588. view.Selecting += new ObjectDataSourceSelectingEventHandler (view_Selecting);
  589. view.DoOnSelecting (new ObjectDataSourceSelectingEventArgs (null, new DataSourceSelectArguments (), false));
  590. Eventassert ("SelectingEvent");
  591. view.Selected += new ObjectDataSourceStatusEventHandler (view_Status);
  592. view.DoOnSelected (new ObjectDataSourceStatusEventArgs (null, null));
  593. Eventassert ("SelectedEvent");
  594. }
  595. [Test]
  596. public void InsertEvent ()
  597. {
  598. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  599. view.Inserting += new ObjectDataSourceMethodEventHandler (Event);
  600. view.DoOnInserting (new ObjectDataSourceMethodEventArgs (null));
  601. Eventassert ("InsertingEvent");
  602. view.Inserted += new ObjectDataSourceStatusEventHandler (view_Status);
  603. view.DoOnInserted (new ObjectDataSourceStatusEventArgs (null, null));
  604. Eventassert ("InsertedEvent");
  605. }
  606. [Test]
  607. public void DeleteEvent ()
  608. {
  609. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  610. view.Deleting += new ObjectDataSourceMethodEventHandler (Event);
  611. view.DoOnDeleting (new ObjectDataSourceMethodEventArgs (null));
  612. Eventassert ("DeletingEvent");
  613. view.Deleted += new ObjectDataSourceStatusEventHandler (view_Status);
  614. view.DoOnDeleted (new ObjectDataSourceStatusEventArgs (null, null));
  615. Eventassert ("DeletedEvent");
  616. }
  617. [Test]
  618. public void FilterEvent ()
  619. {
  620. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  621. view.Filtering += new ObjectDataSourceFilteringEventHandler (view_Filtering);
  622. view.DoOnFiltering (new ObjectDataSourceFilteringEventArgs (null));
  623. Eventassert ("FilterEvent");
  624. }
  625. [Test]
  626. public void ObjectCreatingEvent ()
  627. {
  628. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  629. view.ObjectCreating += new ObjectDataSourceObjectEventHandler (view_ObjectCreate);
  630. view.DoOnObjectCreating (new ObjectDataSourceEventArgs (null));
  631. Eventassert ("ObjectCreatingEvent");
  632. view.ObjectCreated += new ObjectDataSourceObjectEventHandler (view_ObjectCreate);
  633. view.DoOnObjectCreated (new ObjectDataSourceEventArgs (null));
  634. Eventassert ("ObjectCreatedEvent");
  635. view.ObjectDisposing += new ObjectDataSourceDisposingEventHandler (view_ObjectDisposing);
  636. }
  637. [Test]
  638. public void ObjectDisposing ()
  639. {
  640. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  641. view.ObjectDisposing += new ObjectDataSourceDisposingEventHandler (view_ObjectDisposing);
  642. view.DoOnObjectDisposing (new ObjectDataSourceDisposingEventArgs (null));
  643. Eventassert ("ObjectDisposing");
  644. }
  645. /// <summary>
  646. /// Helper methods
  647. /// </summary>
  648. private static bool event_checker;
  649. private static void Eventassert (string message)
  650. {
  651. Assert.IsTrue (ObjectDataSourceViewTest.event_checker, message);
  652. ObjectDataSourceViewTest.event_checker = false;
  653. }
  654. static void Event (object sender, ObjectDataSourceMethodEventArgs e)
  655. {
  656. ObjectDataSourceViewTest.event_checker = true;
  657. }
  658. static void view_Selecting (object sender, ObjectDataSourceSelectingEventArgs e)
  659. {
  660. event_checker = true;
  661. }
  662. void view_Filtering (object sender, ObjectDataSourceFilteringEventArgs e)
  663. {
  664. event_checker = true;
  665. }
  666. void view_ObjectCreate (object sender, ObjectDataSourceEventArgs e)
  667. {
  668. event_checker = true;
  669. }
  670. void view_Status (object sender, ObjectDataSourceStatusEventArgs e)
  671. {
  672. event_checker = true;
  673. }
  674. void view_ObjectDisposing (object sender, ObjectDataSourceDisposingEventArgs e)
  675. {
  676. event_checker = true;
  677. }
  678. private class MyDataSource : ObjectDataSource
  679. {
  680. public DataSourceView DoGetView (string viewName)
  681. {
  682. return base.GetView (viewName);
  683. }
  684. public void DoTrackViewState ()
  685. {
  686. base.TrackViewState ();
  687. }
  688. }
  689. }
  690. public class DataSourceObject
  691. {
  692. private static int maximumRows;
  693. public static DataTable ds = CreateDataTable ();
  694. public static DataTable Select ()
  695. {
  696. return ds;
  697. }
  698. public static DataTable Select (int maximumRows, int startRowIndex)
  699. {
  700. DataSourceObject.maximumRows = maximumRows;
  701. if (ds.Rows.Count > maximumRows) {
  702. DataTable temp = ds.Clone ();
  703. int i = 0;
  704. while (i < maximumRows && startRowIndex <= ds.Rows.Count) {
  705. object[] o = ds.Rows[startRowIndex].ItemArray;
  706. temp.Rows.Add (o);
  707. i++;
  708. startRowIndex++;
  709. }
  710. return temp;
  711. }
  712. return ds;
  713. }
  714. public static DataTable Delete (string ID, string FName, string LName)
  715. {
  716. DataRow dr = ds.Rows.Find (ID);
  717. if (dr != null) {
  718. ds.Rows.Remove (dr);
  719. }
  720. return ds;
  721. }
  722. public static DataTable Insert (string ID, string FName, string LName)
  723. {
  724. DataRow dr = ds.NewRow ();
  725. dr["ID"] = ID;
  726. dr["FName"] = FName;
  727. dr["LName"] = LName;
  728. ds.Rows.Add (dr);
  729. return ds;
  730. }
  731. public static DataTable Update (string ID, string FName, string LName)
  732. {
  733. foreach (DataRow row in ds.Rows) {
  734. if (row["ID"].ToString () == ID) {
  735. row["FName"] = FName;
  736. row["LName"] = LName;
  737. }
  738. }
  739. return ds;
  740. }
  741. public static int SelectCount ()
  742. {
  743. //Note: This is return 5 only for test goal
  744. return 5;
  745. }
  746. public static DataTable CreateDataTable ()
  747. {
  748. DataTable aTable = new DataTable ("A");
  749. DataColumn dtCol;
  750. DataRow dtRow;
  751. // Create ID column and add to the DataTable.
  752. dtCol = new DataColumn ();
  753. dtCol.DataType = Type.GetType ("System.Int32");
  754. dtCol.ColumnName = "ID";
  755. dtCol.AutoIncrement = true;
  756. dtCol.Caption = "ID";
  757. dtCol.ReadOnly = true;
  758. dtCol.Unique = true;
  759. aTable.Columns.Add (dtCol);
  760. // Create Name column and add to the table
  761. dtCol = new DataColumn ();
  762. dtCol.DataType = Type.GetType ("System.String");
  763. dtCol.ColumnName = "FName";
  764. dtCol.AutoIncrement = false;
  765. dtCol.Caption = "First Name";
  766. dtCol.ReadOnly = false;
  767. dtCol.Unique = false;
  768. aTable.Columns.Add (dtCol);
  769. // Create Last Name column and add to the table.
  770. dtCol = new DataColumn ();
  771. dtCol.DataType = Type.GetType ("System.String");
  772. dtCol.ColumnName = "LName";
  773. dtCol.AutoIncrement = false;
  774. dtCol.Caption = "Last Name";
  775. dtCol.ReadOnly = false;
  776. dtCol.Unique = false;
  777. aTable.Columns.Add (dtCol);
  778. // Create three rows to the table
  779. dtRow = aTable.NewRow ();
  780. dtRow["ID"] = 1001;
  781. dtRow["FName"] = "Mahesh";
  782. dtRow["LName"] = "Chand";
  783. aTable.Rows.Add (dtRow);
  784. aTable.PrimaryKey = new DataColumn[] { aTable.Columns["ID"] };
  785. return aTable;
  786. }
  787. }
  788. }
  789. #endif