ObjectDataSourceViewTest.cs 48 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406
  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 Sys = System;
  37. using System.Configuration;
  38. using System.Data.Common;
  39. using System.IO;
  40. using System.Globalization;
  41. using System.Web;
  42. using System.Web.UI;
  43. using System.Web.UI.WebControls;
  44. using System.Data;
  45. using System.Collections;
  46. using MonoTests.SystemWeb.Framework;
  47. using MonoTests.stand_alone.WebHarness;
  48. using System.Threading;
  49. namespace MonoTests.System.Web.UI.WebControls
  50. {
  51. class ObjectViewPoker : ObjectDataSourceView
  52. {
  53. public ObjectViewPoker (ObjectDataSource ds, string name, HttpContext context)
  54. : base (ds, name, context)
  55. {
  56. TrackViewState ();
  57. }
  58. public bool GetIsTrackingViewState ()
  59. {
  60. return base.IsTrackingViewState;
  61. }
  62. public object SaveToViewState ()
  63. {
  64. return SaveViewState ();
  65. }
  66. public void LoadFromViewState (object savedState)
  67. {
  68. LoadViewState (savedState);
  69. }
  70. public void DoOnDeleting (ObjectDataSourceMethodEventArgs e)
  71. {
  72. base.OnDeleting (e);
  73. }
  74. public void DoOnInserting (ObjectDataSourceMethodEventArgs e)
  75. {
  76. base.OnInserting (e);
  77. }
  78. public void DoOnFiltering (ObjectDataSourceFilteringEventArgs e)
  79. {
  80. base.OnFiltering (e);
  81. }
  82. public void DoOnObjectCreating (ObjectDataSourceEventArgs e)
  83. {
  84. base.OnObjectCreating (e);
  85. }
  86. public void DoOnObjectCreated (ObjectDataSourceEventArgs e)
  87. {
  88. base.OnObjectCreated (e);
  89. }
  90. public void DoOnObjectDisposing (ObjectDataSourceDisposingEventArgs e)
  91. {
  92. base.OnObjectDisposing (e);
  93. }
  94. public void DoOnSelecting (ObjectDataSourceSelectingEventArgs e)
  95. {
  96. base.OnSelecting (e);
  97. }
  98. public void DoOnUpdating (ObjectDataSourceMethodEventArgs e)
  99. {
  100. base.OnUpdating (e);
  101. }
  102. public void DoOnUpdated (ObjectDataSourceStatusEventArgs e)
  103. {
  104. base.OnUpdated (e);
  105. }
  106. public void DoOnDeleted (ObjectDataSourceStatusEventArgs e)
  107. {
  108. base.OnDeleted (e);
  109. }
  110. public void DoOnInserted (ObjectDataSourceStatusEventArgs e)
  111. {
  112. base.OnInserted (e);
  113. }
  114. public void DoOnSelected (ObjectDataSourceStatusEventArgs e)
  115. {
  116. base.OnSelected (e);
  117. }
  118. public int DoExecuteDelete (IDictionary keys, IDictionary oldValues)
  119. {
  120. return base.ExecuteDelete (keys, oldValues);
  121. }
  122. }
  123. [TestFixture]
  124. public class ObjectDataSourceViewTest
  125. {
  126. [TestFixtureTearDown]
  127. public void TearDown ()
  128. {
  129. WebTest.Unload ();
  130. }
  131. [SetUp()]
  132. public void Setup ()
  133. {
  134. eventsCalled = null;
  135. }
  136. [Test]
  137. public void Defaults ()
  138. {
  139. ObjectDataSource ds = new ObjectDataSource ();
  140. ObjectViewPoker sql = new ObjectViewPoker (ds, "DefaultView", null);
  141. Assert.IsFalse (sql.CanDelete, "CanDelete");
  142. Assert.IsFalse (sql.CanInsert, "CanInsert");
  143. Assert.IsFalse (sql.CanPage, "CanPage");
  144. Assert.IsTrue (sql.CanSort, "CanSort");
  145. Assert.IsFalse (sql.CanUpdate, "CanUpdate");
  146. Assert.AreEqual (ConflictOptions.OverwriteChanges, sql.ConflictDetection, "ConflictDetection");
  147. Assert.IsFalse (sql.ConvertNullToDBNull, "ConvertNullToDBNull");
  148. Assert.AreEqual ("", sql.DataObjectTypeName, "DataObjectTypeName");
  149. Assert.AreEqual ("", sql.DeleteMethod, "DeleteMethod");
  150. Assert.IsNotNull (sql.DeleteParameters, "DeleteParameters");
  151. Assert.AreEqual (0, sql.DeleteParameters.Count, "DeleteParameters.Count");
  152. Assert.IsFalse (sql.EnablePaging, "EnablePaging");
  153. Assert.AreEqual ("", sql.InsertMethod, "InsertMethod");
  154. Assert.IsNotNull (sql.InsertParameters, "InsertParameters");
  155. Assert.AreEqual (0, sql.InsertParameters.Count, "InsertParameters.Count");
  156. Assert.AreEqual ("", sql.FilterExpression, "FilterExpression");
  157. Assert.IsNotNull (sql.FilterParameters, "FilterParameters");
  158. Assert.AreEqual (0, sql.FilterParameters.Count, "FilterParameters.Count");
  159. Assert.AreEqual ("maximumRows", sql.MaximumRowsParameterName, "MaximumRowsParameterName");
  160. Assert.AreEqual ("", sql.SelectCountMethod, "SelectCountMethod");
  161. Assert.AreEqual ("", sql.SelectMethod, "SelectMethod");
  162. Assert.AreEqual ("{0}", sql.OldValuesParameterFormatString, "OldValuesParameterFormatString");
  163. Assert.IsNotNull (sql.SelectParameters, "SelectParameters");
  164. Assert.AreEqual (0, sql.SelectParameters.Count, "SelectParameters.Count");
  165. Assert.AreEqual ("", sql.SortParameterName, "SortParameterName");
  166. Assert.IsNotNull (sql.UpdateParameters, "UpdateParameters");
  167. Assert.AreEqual (0, sql.UpdateParameters.Count, "UpdateParameters.Count");
  168. Assert.AreEqual ("startRowIndex", sql.StartRowIndexParameterName, "StartRowIndexParameterName");
  169. Assert.AreEqual ("", sql.TypeName, "TypeName");
  170. Assert.AreEqual ("", sql.UpdateMethod, "UpdateMethod");
  171. Assert.AreEqual (true, sql.GetIsTrackingViewState (), "IsTrackingViewState");
  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 ViewStateSupport ()
  211. {
  212. ObjectDataSourceView view;
  213. MyDataSource ds = new MyDataSource ();
  214. ds.ID = "ObjectDataSource2";
  215. ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
  216. ds.SelectMethod = "Select";
  217. ds.SelectCountMethod = "SelectCount";
  218. view = (ObjectDataSourceView) ds.DoGetView ("DefaultView");
  219. ((IStateManager) view).TrackViewState ();
  220. Parameter p1 = new Parameter ("test", TypeCode.String);
  221. Assert.IsTrue (((IStateManager) view).IsTrackingViewState, "IsTrackingViewState");
  222. Assert.IsTrue (((IStateManager) view.FilterParameters).IsTrackingViewState, "FilterParameters.IsTrackingViewState");
  223. Assert.IsTrue (((IStateManager) view.SelectParameters).IsTrackingViewState, "SelecteParameters.IsTrackingViewState");
  224. Assert.IsFalse (((IStateManager) view.DeleteParameters).IsTrackingViewState, "DeleteParameters.IsTrackingViewState");
  225. Assert.IsFalse (((IStateManager) view.InsertParameters).IsTrackingViewState, "InsertParameters.IsTrackingViewState");
  226. Assert.IsFalse (((IStateManager) view.UpdateParameters).IsTrackingViewState, "UpdateParameters.IsTrackingViewState");
  227. object state = ((IStateManager) view).SaveViewState ();
  228. Assert.IsNull (state, "view ViewState not null");
  229. view.DeleteParameters.Add (p1);
  230. view.InsertParameters.Add (p1);
  231. //view.UpdateParameters.Add (p1);
  232. state = ((IStateManager) view).SaveViewState ();
  233. Assert.IsNull (state, "view ViewState not null");
  234. view.FilterParameters.Add (p1);
  235. //view.SelectParameters.Add (p1);
  236. state = ((IStateManager) view).SaveViewState ();
  237. Assert.IsNotNull (state, "view ViewState not null");
  238. state = ((IStateManager) view.FilterParameters).SaveViewState ();
  239. Assert.IsNotNull (state, "FilterParamenters ViewState not null");
  240. state = ((IStateManager) view.SelectParameters).SaveViewState ();
  241. Assert.IsNull (state, "SelectParameters ViewState not null");
  242. state = ((IStateManager) view.DeleteParameters).SaveViewState ();
  243. Assert.IsNotNull (state, "DeleteParameters ViewState not null");
  244. state = ((IStateManager) view.InsertParameters).SaveViewState ();
  245. Assert.IsNotNull (state, "InsertParameters ViewState not null");
  246. state = ((IStateManager) view.UpdateParameters).SaveViewState ();
  247. Assert.IsNull (state, "UpdateParameters ViewState not null");
  248. }
  249. [Test]
  250. public void ViewState ()
  251. {
  252. // Note :
  253. // IStateManager implementation allows public access to control state
  254. // Nothing added to viewstate
  255. ObjectDataSourceView view;
  256. MyDataSource ds = new MyDataSource ();
  257. ds.ID = "ObjectDataSource2";
  258. ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
  259. ds.SelectMethod = "Select";
  260. ds.SelectCountMethod = "SelectCount";
  261. view = (ObjectDataSourceView) ds.DoGetView ("DefaultView");
  262. ((IStateManager) view).TrackViewState ();
  263. view.ConflictDetection = ConflictOptions.CompareAllValues;
  264. view.ConvertNullToDBNull = true;
  265. view.DataObjectTypeName = "test";
  266. view.DeleteMethod = "test";
  267. view.EnablePaging = true;
  268. view.InsertMethod = "test";
  269. view.FilterExpression = "test";
  270. view.MaximumRowsParameterName = "test";
  271. view.SelectCountMethod = "test";
  272. view.SelectMethod = "test";
  273. view.OldValuesParameterFormatString = "test";
  274. view.StartRowIndexParameterName = "test";
  275. view.TypeName = "test";
  276. view.UpdateMethod = "test";
  277. object state = ((IStateManager) view).SaveViewState ();
  278. Assert.IsNull (state, "ViewState#1");
  279. ObjectDataSourceView copy = new ObjectDataSourceView (ds, "DefaultView", null);
  280. ((IStateManager) copy).LoadViewState (state);
  281. }
  282. [Test]
  283. public void CanDelete ()
  284. {
  285. ObjectDataSource ds = new ObjectDataSource ();
  286. ObjectViewPoker sql = new ObjectViewPoker (ds, "DefaultView", null);
  287. sql.DeleteMethod = "DeleteMethod";
  288. Assert.IsTrue (sql.CanDelete, "A1");
  289. sql.DeleteMethod = "";
  290. Assert.IsFalse (sql.CanDelete, "A2");
  291. sql.DeleteMethod = null;
  292. Assert.IsFalse (sql.CanDelete, "A3");
  293. }
  294. [Test]
  295. public void CanInsert ()
  296. {
  297. ObjectDataSource ds = new ObjectDataSource ();
  298. ObjectViewPoker sql = new ObjectViewPoker (ds, "DefaultView", null);
  299. sql.InsertMethod = "InsertMethod";
  300. Assert.IsTrue (sql.CanInsert, "A1");
  301. sql.InsertMethod = "";
  302. Assert.IsFalse (sql.CanInsert, "A2");
  303. sql.InsertMethod = null;
  304. Assert.IsFalse (sql.CanInsert, "A3");
  305. }
  306. [Test]
  307. public void CanUpdate ()
  308. {
  309. ObjectDataSource ds = new ObjectDataSource ();
  310. ObjectViewPoker sql = new ObjectViewPoker (ds, "DefaultView", null);
  311. sql.UpdateMethod = "UpdateMethod";
  312. Assert.IsTrue (sql.CanUpdate, "A1");
  313. sql.UpdateMethod = "";
  314. Assert.IsFalse (sql.CanUpdate, "A2");
  315. sql.UpdateMethod = null;
  316. Assert.IsFalse (sql.CanUpdate, "A3");
  317. }
  318. [Test]
  319. public void CanRetrieveTotalRowCount ()
  320. {
  321. ObjectDataSource ds = new ObjectDataSource ();
  322. ObjectDataSourceView view = new ObjectDataSourceView (ds, "DefaultView", null);
  323. Assert.IsFalse (view.CanPage, "CanPage#1");
  324. Assert.IsTrue (view.CanRetrieveTotalRowCount, "CanRetrieveTotalRowCount#1");
  325. view.EnablePaging = true;
  326. Assert.IsTrue (view.CanPage, "CanPage#2");
  327. Assert.IsFalse (view.CanRetrieveTotalRowCount, "CanRetrieveTotalRowCount#2");
  328. view.SelectCountMethod = "SelectCountMethod";
  329. Assert.IsTrue (view.CanPage, "CanPage#3");
  330. Assert.IsTrue (view.CanRetrieveTotalRowCount, "CanRetrieveTotalRowCount#3");
  331. view.EnablePaging = false;
  332. Assert.IsFalse (view.CanPage, "CanPage#4");
  333. Assert.IsTrue (view.CanRetrieveTotalRowCount, "CanRetrieveTotalRowCount#4");
  334. }
  335. [Test]
  336. public void OldValuesParameterFormatString ()
  337. {
  338. ObjectDataSource ds = new ObjectDataSource ();
  339. Assert.AreEqual ("{0}", ds.OldValuesParameterFormatString, "A1");
  340. ds.OldValuesParameterFormatString = "hi {0}";
  341. ObjectViewPoker sql = new ObjectViewPoker (ds, "DefaultView", null);
  342. Assert.AreEqual ("{0}", sql.OldValuesParameterFormatString, "A2");
  343. ds.OldValuesParameterFormatString = "hi {0}";
  344. Assert.AreEqual ("{0}", sql.OldValuesParameterFormatString, "A3");
  345. ds.OldValuesParameterFormatString = "{0}";
  346. sql.OldValuesParameterFormatString = "hi {0}";
  347. Assert.AreEqual ("{0}", ds.OldValuesParameterFormatString, "A4");
  348. }
  349. [Test]
  350. [Category("NunitWeb")]
  351. public void DeleteMethod ()
  352. {
  353. WebTest t = new WebTest (PageInvoker.CreateOnLoad (delete));
  354. string html = t.Run ();
  355. Assert.AreEqual (-1, html.IndexOf("Yonik"), "ObjectDataSourceViewDelete");
  356. }
  357. public static void delete (Page p)
  358. {
  359. LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG);
  360. LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG);
  361. ObjectDataSourceView view;
  362. GridView grid = new GridView ();
  363. MyDataSource ds = new MyDataSource ();
  364. ds.ID = "ObjectDataSource2";
  365. ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
  366. ds.SelectMethod = "Select";
  367. ds.DeleteMethod = "Delete";
  368. ds.InsertMethod = "Insert";
  369. ds.UpdateMethod = "Update";
  370. Parameter p1 = new Parameter ("ID", TypeCode.String);
  371. Parameter p2 = new Parameter ("FName", TypeCode.String);
  372. Parameter p3 = new Parameter ("LName", TypeCode.String);
  373. ds.DeleteParameters.Add (p1);
  374. ds.DeleteParameters.Add (p2);
  375. ds.DeleteParameters.Add (p3);
  376. grid.ID = "Grid";
  377. grid.DataKeyNames = new string[] { "ID", "FName", "LName" };
  378. grid.DataSourceID = "ObjectDataSource2";
  379. p.Form.Controls.Add (lcb);
  380. p.Form.Controls.Add (ds);
  381. p.Form.Controls.Add (grid);
  382. p.Form.Controls.Add (lce);
  383. view = (ObjectDataSourceView) ds.DoGetView ("DefaultView");
  384. view.Deleting += new ObjectDataSourceMethodEventHandler (Event);
  385. DataSourceObject.InitDS ();
  386. Hashtable table = new Hashtable ();
  387. table.Add ("ID", "1001");
  388. table.Add ("FName", "Yonik");
  389. table.Add ("LName", "Laim");
  390. view.Delete (table, null);
  391. Assert.AreEqual (true, view.CanDelete, "CanDelete");
  392. Assert.AreEqual ("Delete", view.DeleteMethod, "DeleteMethod");
  393. Assert.AreEqual (3, view.DeleteParameters.Count, "DeleteParameters.Count");
  394. Assert.AreEqual ("ID", view.DeleteParameters[0].Name, "DeleteParametersName#1");
  395. Assert.AreEqual ("FName", view.DeleteParameters[1].Name, "DeleteParametersName#2");
  396. Assert.AreEqual ("LName", view.DeleteParameters[2].Name, "DeleteParametersName#3");
  397. ObjectDataSourceViewTest.Eventassert ("Delete event has not fired");
  398. }
  399. [Test]
  400. [Category ("NunitWeb")]
  401. public void SelectMethod ()
  402. {
  403. WebTest t = new WebTest (PageInvoker.CreateOnLoad (select));
  404. string html = t.Run ();
  405. string origin = @"<div>
  406. <table cellspacing=""0"" rules=""all"" border=""1"" id=""Grid"" style=""border-collapse:collapse;"">
  407. <tr>
  408. <th scope=""col"">ID</th><th scope=""col"">FName</th><th scope=""col"">LName</th>
  409. </tr><tr>
  410. <td>1001</td><td>Mahesh</td><td>Chand</td>
  411. </tr>
  412. </table>
  413. </div>";
  414. HtmlDiff.AssertAreEqual (origin, HtmlDiff.GetControlFromPageHtml (html), "ObjectDataSourceViewSelect");
  415. }
  416. public static void select (Page p)
  417. {
  418. LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG);
  419. LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG);
  420. ObjectDataSourceView view;
  421. GridView grid = new GridView ();
  422. MyDataSource ds = new MyDataSource ();
  423. ds.ID = "ObjectDataSource2";
  424. ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
  425. ds.SelectMethod = "Select";
  426. grid.ID = "Grid";
  427. grid.DataKeyNames = new string[] { "ID" };
  428. grid.DataSourceID = "ObjectDataSource2";
  429. p.Form.Controls.Add (lcb);
  430. p.Form.Controls.Add (ds);
  431. p.Form.Controls.Add (grid);
  432. p.Form.Controls.Add (lce);
  433. view = (ObjectDataSourceView) ds.DoGetView ("DefaultView");
  434. view.Selecting += new ObjectDataSourceSelectingEventHandler (view_Selecting);
  435. DataSourceObject.InitDS ();
  436. DataView view1 = (DataView) view.Select (new DataSourceSelectArguments ());
  437. Assert.AreEqual (1, view1.Count, "SelectedRowsCount");
  438. Assert.AreEqual (1001, view1[0].Row["ID"], "SelectedRowsValue#1");
  439. Assert.AreEqual ("Mahesh", view1[0].Row["FName"], "SelectedRowsValue#2");
  440. Assert.AreEqual ("Chand", view1[0].Row["LName"], "SelectedRowsValue#3");
  441. ObjectDataSourceViewTest.Eventassert ("Select event has not fired");
  442. }
  443. [Test]
  444. [Category ("NunitWeb")]
  445. public void SelectCountMethod ()
  446. {
  447. // This method will render grid view with paging
  448. // Note : ObjectDataSource will return page counter 5 hard coded
  449. WebTest t = new WebTest (PageInvoker.CreateOnLoad (selectcount));
  450. string html = t.Run ();
  451. string origin = @"<div>
  452. <table cellspacing=""0"" rules=""all"" border=""1"" id=""Grid"" style=""border-collapse:collapse;"">
  453. <tr>
  454. <th scope=""col"">ID</th><th scope=""col"">FName</th><th scope=""col"">LName</th>
  455. </tr><tr>
  456. <td>1001</td><td>Mahesh</td><td>Chand</td>
  457. </tr><tr>
  458. <td colspan=""3""><table border=""0"">
  459. <tr>
  460. <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>
  461. </tr>
  462. </table></td>
  463. </tr>
  464. </table>
  465. </div>";
  466. HtmlDiff.AssertAreEqual (origin, HtmlDiff.GetControlFromPageHtml (html), "ObjectDataSourceViewSelectCount");
  467. }
  468. public static void selectcount (Page p)
  469. {
  470. // This method will render grid view with paging
  471. // Note : ObjectDataSource will return page counter 5 hard coded
  472. LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG);
  473. LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG);
  474. ObjectDataSourceView view;
  475. GridView grid = new GridView ();
  476. MyDataSource ds = new MyDataSource ();
  477. ds.ID = "ObjectDataSource2";
  478. ds.EnablePaging = true;
  479. ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
  480. ds.SelectMethod = "Select";
  481. ds.SelectCountMethod = "SelectCount";
  482. grid.ID = "Grid";
  483. grid.DataKeyNames = new string[] { "ID" };
  484. grid.DataSourceID = "ObjectDataSource2";
  485. grid.AllowPaging = true;
  486. grid.PageSize = 1;
  487. p.Form.Controls.Add (lcb);
  488. p.Form.Controls.Add (ds);
  489. p.Form.Controls.Add (grid);
  490. p.Form.Controls.Add (lce);
  491. view = (ObjectDataSourceView) ds.DoGetView ("DefaultView");
  492. Assert.IsTrue (view.CanRetrieveTotalRowCount, "CanRetrieveTotalRowCount");
  493. }
  494. [Test]
  495. [Category ("NunitWeb")]
  496. public void InsertMethod ()
  497. {
  498. WebTest t = new WebTest (PageInvoker.CreateOnLoad (insert));
  499. string html = t.Run ();
  500. string origin = @"<div>
  501. <table cellspacing=""0"" rules=""all"" border=""1"" id=""Grid"" style=""border-collapse:collapse;"">
  502. <tr>
  503. <th scope=""col"">ID</th><th scope=""col"">FName</th><th scope=""col"">LName</th>
  504. </tr><tr>
  505. <td>1001</td><td>Mahesh</td><td>Chand</td>
  506. </tr><tr>
  507. <td>1000</td><td>Yonik</td><td>Laim</td>
  508. </tr>
  509. </table>
  510. </div>";
  511. HtmlDiff.AssertAreEqual (origin, HtmlDiff.GetControlFromPageHtml (html), "ObjectDataSourceViewInsert");
  512. }
  513. public static void insert (Page p)
  514. {
  515. DataSourceObject.InitDS ();
  516. LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG);
  517. LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG);
  518. ObjectDataSourceView view;
  519. GridView grid = new GridView ();
  520. MyDataSource ds = new MyDataSource ();
  521. ds.ID = "ObjectDataSource1";
  522. ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
  523. ds.SelectMethod = "Select";
  524. ds.InsertMethod = "Insert";
  525. Parameter p1 = new Parameter ("ID", TypeCode.String);
  526. Parameter p2 = new Parameter ("FName", TypeCode.String);
  527. Parameter p3 = new Parameter ("LName", TypeCode.String);
  528. ds.InsertParameters.Add (p1);
  529. ds.InsertParameters.Add (p2);
  530. ds.InsertParameters.Add (p3);
  531. grid.ID = "Grid";
  532. grid.DataSourceID = "ObjectDataSource1";
  533. p.Form.Controls.Add (lcb);
  534. p.Form.Controls.Add (ds);
  535. p.Form.Controls.Add (grid);
  536. p.Form.Controls.Add (lce);
  537. view = (ObjectDataSourceView) ds.DoGetView ("DefaultView");
  538. view.Inserting += new ObjectDataSourceMethodEventHandler (Event);
  539. Hashtable table = new Hashtable ();
  540. table.Add ("ID", "1000");
  541. table.Add ("FName", "Yonik");
  542. table.Add ("LName", "Laim");
  543. view.Insert (table);
  544. Assert.AreEqual (true, view.CanInsert, "CanInsert");
  545. Assert.AreEqual ("Insert", view.InsertMethod, "InsertMethod");
  546. Assert.AreEqual (3, view.InsertParameters.Count, "InsertParameters.Count");
  547. Assert.AreEqual ("ID", view.InsertParameters[0].Name, "InsertParametersName#1");
  548. Assert.AreEqual ("FName", view.InsertParameters[1].Name, "InsertParametersName#2");
  549. Assert.AreEqual ("LName", view.InsertParameters[2].Name, "InsertParametersName#3");
  550. ObjectDataSourceViewTest.Eventassert ("Insert event has not fired");
  551. }
  552. [Test]
  553. [Category ("NunitWeb")]
  554. public void UpdateMethod ()
  555. {
  556. WebTest t = new WebTest (PageInvoker.CreateOnLoad (update));
  557. string html = t.Run ();
  558. string origin = @"<div>
  559. <table cellspacing=""0"" rules=""all"" border=""1"" id=""Grid"" style=""border-collapse:collapse;"">
  560. <tr>
  561. <th scope=""col"">ID</th><th scope=""col"">FName</th><th scope=""col"">LName</th>
  562. </tr><tr>
  563. <td>1001</td><td>Yonik</td><td>Laim</td>
  564. </tr>
  565. </table>
  566. </div>";
  567. HtmlDiff.AssertAreEqual (origin, HtmlDiff.GetControlFromPageHtml (html), "ObjectDataSourceViewUpdate");
  568. }
  569. public static void update (Page p)
  570. {
  571. LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG);
  572. LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG);
  573. ObjectDataSourceView view;
  574. GridView grid = new GridView ();
  575. MyDataSource ds = new MyDataSource ();
  576. ds.ID = "ObjectDataSource1";
  577. ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
  578. ds.SelectMethod = "Select";
  579. ds.DeleteMethod = "Delete";
  580. ds.InsertMethod = "Insert";
  581. ds.UpdateMethod = "Update";
  582. Parameter p1 = new Parameter ("ID", TypeCode.String);
  583. Parameter p2 = new Parameter ("FName", TypeCode.String);
  584. Parameter p3 = new Parameter ("LName", TypeCode.String);
  585. ds.UpdateParameters.Add (p1);
  586. ds.UpdateParameters.Add (p2);
  587. ds.UpdateParameters.Add (p3);
  588. grid.ID = "Grid";
  589. grid.DataSourceID = "ObjectDataSource1";
  590. p.Form.Controls.Add (lcb);
  591. p.Form.Controls.Add (ds);
  592. p.Form.Controls.Add (grid);
  593. p.Form.Controls.Add (lce);
  594. view = (ObjectDataSourceView) ds.DoGetView ("defaultView");
  595. view.Updating += new ObjectDataSourceMethodEventHandler (Event);
  596. DataSourceObject.InitDS ();
  597. Hashtable table = new Hashtable ();
  598. table.Add ("ID", "1001");
  599. table.Add ("FName", "Yonik");
  600. table.Add ("LName", "Laim");
  601. view.Update (null, table, null);
  602. Assert.AreEqual (true, view.CanUpdate, "CanUpdate");
  603. Assert.AreEqual ("Update", view.UpdateMethod, "UpdateMethod");
  604. Assert.AreEqual (3, view.UpdateParameters.Count, "UpdateParameters.Count");
  605. Assert.AreEqual ("ID", view.UpdateParameters[0].Name, "UpdateParametersName#1");
  606. Assert.AreEqual ("FName", view.UpdateParameters[1].Name, "UpdateParametersName#2");
  607. Assert.AreEqual ("LName", view.UpdateParameters[2].Name, "UpdateParametersName#3");
  608. ObjectDataSourceViewTest.Eventassert ("Update event has not fired");
  609. }
  610. //Events
  611. [Test]
  612. public void UpdateEvent ()
  613. {
  614. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  615. view.Updating += new ObjectDataSourceMethodEventHandler (Event);
  616. view.DoOnUpdating (new ObjectDataSourceMethodEventArgs (null));
  617. Eventassert ("UpdateEvent");
  618. view.Updated += new ObjectDataSourceStatusEventHandler (view_Status);
  619. view.DoOnUpdated (new ObjectDataSourceStatusEventArgs (null, null));
  620. Eventassert ("UpdateEvent");
  621. }
  622. [Test]
  623. public void SelectEvent ()
  624. {
  625. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  626. view.Selecting += new ObjectDataSourceSelectingEventHandler (view_Selecting);
  627. view.DoOnSelecting (new ObjectDataSourceSelectingEventArgs (null, new DataSourceSelectArguments (), false));
  628. Eventassert ("SelectingEvent");
  629. view.Selected += new ObjectDataSourceStatusEventHandler (view_Status);
  630. view.DoOnSelected (new ObjectDataSourceStatusEventArgs (null, null));
  631. Eventassert ("SelectedEvent");
  632. }
  633. [Test]
  634. public void InsertEvent ()
  635. {
  636. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  637. view.Inserting += new ObjectDataSourceMethodEventHandler (Event);
  638. view.DoOnInserting (new ObjectDataSourceMethodEventArgs (null));
  639. Eventassert ("InsertingEvent");
  640. view.Inserted += new ObjectDataSourceStatusEventHandler (view_Status);
  641. view.DoOnInserted (new ObjectDataSourceStatusEventArgs (null, null));
  642. Eventassert ("InsertedEvent");
  643. }
  644. [Test]
  645. public void DeleteEvent ()
  646. {
  647. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  648. view.Deleting += new ObjectDataSourceMethodEventHandler (Event);
  649. view.DoOnDeleting (new ObjectDataSourceMethodEventArgs (null));
  650. Eventassert ("DeletingEvent");
  651. view.Deleted += new ObjectDataSourceStatusEventHandler (view_Status);
  652. view.DoOnDeleted (new ObjectDataSourceStatusEventArgs (null, null));
  653. Eventassert ("DeletedEvent");
  654. }
  655. [Test]
  656. public void FilterEvent ()
  657. {
  658. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  659. view.Filtering += new ObjectDataSourceFilteringEventHandler (view_Filtering);
  660. view.DoOnFiltering (new ObjectDataSourceFilteringEventArgs (null));
  661. Eventassert ("FilterEvent");
  662. }
  663. [Test]
  664. public void ObjectCreatingEvent ()
  665. {
  666. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  667. view.ObjectCreating += new ObjectDataSourceObjectEventHandler (view_ObjectCreate);
  668. view.DoOnObjectCreating (new ObjectDataSourceEventArgs (null));
  669. Eventassert ("ObjectCreatingEvent");
  670. view.ObjectCreated += new ObjectDataSourceObjectEventHandler (view_ObjectCreate);
  671. view.DoOnObjectCreated (new ObjectDataSourceEventArgs (null));
  672. Eventassert ("ObjectCreatedEvent");
  673. view.ObjectDisposing += new ObjectDataSourceDisposingEventHandler (view_ObjectDisposing);
  674. }
  675. [Test]
  676. public void ObjectDisposing ()
  677. {
  678. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  679. view.ObjectDisposing += new ObjectDataSourceDisposingEventHandler (view_ObjectDisposing);
  680. view.DoOnObjectDisposing (new ObjectDataSourceDisposingEventArgs (null));
  681. Eventassert ("ObjectDisposing");
  682. }
  683. enum InitViewType
  684. {
  685. MatchParamsToValues,
  686. MatchParamsToOldValues,
  687. DontMatchParams,
  688. }
  689. public class DummyDataSourceObject
  690. {
  691. public static IEnumerable Select (string filter)
  692. {
  693. if (eventsCalled == null) {
  694. eventsCalled = new ArrayList ();
  695. }
  696. eventsCalled.Add (String.Format ("Select(filter = {0})", filter));
  697. return new string [] { "one", "two", "three" };
  698. }
  699. public static int Update (string ID)
  700. {
  701. if (eventsCalled == null) {
  702. eventsCalled = new ArrayList ();
  703. }
  704. eventsCalled.Add (String.Format ("Update(ID = {0})", ID));
  705. return 1;
  706. }
  707. public static int Update (string ID, string oldvalue_ID)
  708. {
  709. if (eventsCalled == null) {
  710. eventsCalled = new ArrayList ();
  711. }
  712. eventsCalled.Add (String.Format ("Update(ID = {0}, oldvalue_ID = {1})", ID, oldvalue_ID));
  713. return 1;
  714. }
  715. public static int UpdateOther (string ID, string OtherValue, string oldvalue_ID)
  716. {
  717. if (eventsCalled == null) {
  718. eventsCalled = new ArrayList ();
  719. }
  720. eventsCalled.Add (String.Format ("UpdateOther(ID = {0}, OtherValue = {1}, oldvalue_ID = {2})", ID, OtherValue, oldvalue_ID));
  721. return 1;
  722. }
  723. public static int Insert (string ID)
  724. {
  725. if (eventsCalled == null) {
  726. eventsCalled = new ArrayList ();
  727. }
  728. eventsCalled.Add (String.Format ("Insert(ID = {0})", ID));
  729. return 1;
  730. }
  731. public static int Insert (string ID, string oldvalue_ID)
  732. {
  733. if (eventsCalled == null) {
  734. eventsCalled = new ArrayList ();
  735. }
  736. eventsCalled.Add (String.Format ("Insert(ID = {0}, oldvalue_ID = {1})", ID, oldvalue_ID));
  737. return 1;
  738. }
  739. public static int InsertOther (string ID, string OtherValue)
  740. {
  741. if (eventsCalled == null) {
  742. eventsCalled = new ArrayList ();
  743. }
  744. eventsCalled.Add (String.Format ("InsertOther(ID = {0}, OtherValue = {1})", ID, OtherValue));
  745. return 1;
  746. }
  747. public static int Delete (string ID, string oldvalue_ID)
  748. {
  749. if (eventsCalled == null) {
  750. eventsCalled = new ArrayList ();
  751. }
  752. eventsCalled.Add (String.Format ("Delete(ID = {0}, oldvalue_ID = {1})", ID, oldvalue_ID));
  753. return 1;
  754. }
  755. public static int Delete (string oldvalue_ID)
  756. {
  757. if (eventsCalled == null) {
  758. eventsCalled = new ArrayList ();
  759. }
  760. eventsCalled.Add (String.Format ("Delete(oldvalue_ID = {0})", oldvalue_ID));
  761. return 1;
  762. }
  763. public static int DeleteOther (string oldvalue_ID, string OtherValue)
  764. {
  765. if (eventsCalled == null) {
  766. eventsCalled = new ArrayList ();
  767. }
  768. eventsCalled.Add (String.Format ("DeleteOther(oldvalue_ID = {0}, OtherValue = {1})", oldvalue_ID, OtherValue));
  769. return 1;
  770. }
  771. }
  772. public class AlwaysChangingParameter : Parameter
  773. {
  774. int evaluateCount;
  775. public AlwaysChangingParameter (string name, TypeCode type, string defaultValue)
  776. : base (name, type, defaultValue)
  777. {
  778. evaluateCount = 0;
  779. }
  780. protected override object Evaluate (HttpContext context, Control control)
  781. {
  782. evaluateCount++;
  783. return String.Format ("{0}{1}", DefaultValue, evaluateCount);
  784. }
  785. }
  786. private static void InitializeView (ObjectViewPoker view, InitViewType initType, out Hashtable keys, out Hashtable old_value, out Hashtable new_value)
  787. {
  788. view.TypeName = typeof (DummyDataSourceObject).AssemblyQualifiedName;
  789. view.OldValuesParameterFormatString = "oldvalue_{0}";
  790. view.SelectMethod = "Select";
  791. if (initType == InitViewType.DontMatchParams) {
  792. view.UpdateMethod = "UpdateOther";
  793. view.InsertMethod = "InsertOther";
  794. view.DeleteMethod = "DeleteOther";
  795. }
  796. else {
  797. view.UpdateMethod = "Update";
  798. view.InsertMethod = "Insert";
  799. view.DeleteMethod = "Delete";
  800. }
  801. Parameter selectParameter = null;
  802. Parameter insertParameter = null;
  803. Parameter updateParameter = null;
  804. Parameter deleteParameter = null;
  805. selectParameter = new AlwaysChangingParameter ("filter", TypeCode.String, "p_ValueSelect");
  806. view.SelectParameters.Add (selectParameter);
  807. switch (initType) {
  808. case InitViewType.MatchParamsToOldValues:
  809. insertParameter = new AlwaysChangingParameter ("oldvalue_ID", TypeCode.String, "p_OldValueInsert");
  810. view.InsertParameters.Add (insertParameter);
  811. updateParameter = new AlwaysChangingParameter ("oldvalue_ID", TypeCode.String, "p_OldValueUpdate");
  812. view.UpdateParameters.Add (updateParameter);
  813. deleteParameter = new AlwaysChangingParameter ("oldvalue_ID", TypeCode.String, "p_OldValueDelete");
  814. view.DeleteParameters.Add (deleteParameter);
  815. break;
  816. case InitViewType.MatchParamsToValues:
  817. insertParameter = new AlwaysChangingParameter ("ID", TypeCode.String, "p_ValueInsert");
  818. view.InsertParameters.Add (insertParameter);
  819. updateParameter = new AlwaysChangingParameter ("ID", TypeCode.String, "p_ValueUpdate");
  820. view.UpdateParameters.Add (updateParameter);
  821. deleteParameter = new AlwaysChangingParameter ("ID", TypeCode.String, "p_ValueDelete");
  822. view.DeleteParameters.Add (deleteParameter);
  823. break;
  824. case InitViewType.DontMatchParams:
  825. insertParameter = new AlwaysChangingParameter ("OtherValue", TypeCode.String, "p_OtherValueInsert");
  826. view.InsertParameters.Add (insertParameter);
  827. updateParameter = new AlwaysChangingParameter ("OtherValue", TypeCode.String, "p_OtherValueUpdate");
  828. view.UpdateParameters.Add (updateParameter);
  829. deleteParameter = new AlwaysChangingParameter ("OtherValue", TypeCode.String, "p_OtherValueDelete");
  830. view.DeleteParameters.Add (deleteParameter);
  831. break;
  832. }
  833. view.SelectParameters.ParametersChanged += new EventHandler (SelectParameters_ParametersChanged);
  834. view.InsertParameters.ParametersChanged += new EventHandler (InsertParameters_ParametersChanged);
  835. view.UpdateParameters.ParametersChanged += new EventHandler (UpdateParameters_ParametersChanged);
  836. view.DeleteParameters.ParametersChanged += new EventHandler (DeleteParameters_ParametersChanged);
  837. keys = new Hashtable ();
  838. keys.Add ("ID", "k_1001");
  839. old_value = new Hashtable ();
  840. old_value.Add ("ID", "ov_1001");
  841. new_value = new Hashtable ();
  842. new_value.Add ("ID", "n_1001");
  843. view.DataSourceViewChanged += new EventHandler (view_DataSourceViewChanged);
  844. }
  845. private static IList eventsCalled;
  846. static void view_DataSourceViewChanged (object sender, EventArgs e)
  847. {
  848. if (eventsCalled == null) {
  849. eventsCalled = new ArrayList ();
  850. }
  851. eventsCalled.Add ("view_DataSourceViewChanged");
  852. }
  853. static void SelectParameters_ParametersChanged (object sender, EventArgs e)
  854. {
  855. if (eventsCalled == null) {
  856. eventsCalled = new ArrayList ();
  857. }
  858. eventsCalled.Add ("SelectParameters_ParametersChanged");
  859. }
  860. static void InsertParameters_ParametersChanged (object sender, EventArgs e)
  861. {
  862. if (eventsCalled == null) {
  863. eventsCalled = new ArrayList ();
  864. }
  865. eventsCalled.Add ("InsertParameters_ParametersChanged");
  866. }
  867. static void UpdateParameters_ParametersChanged (object sender, EventArgs e)
  868. {
  869. if (eventsCalled == null) {
  870. eventsCalled = new ArrayList ();
  871. }
  872. eventsCalled.Add ("UpdateParameters_ParametersChanged");
  873. }
  874. static void DeleteParameters_ParametersChanged (object sender, EventArgs e)
  875. {
  876. if (eventsCalled == null) {
  877. eventsCalled = new ArrayList ();
  878. }
  879. eventsCalled.Add ("DeleteParameters_ParametersChanged");
  880. }
  881. [Test]
  882. public void ParametersAndViewChangedEvent_Select ()
  883. {
  884. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  885. Hashtable keys = null;
  886. Hashtable old_values = null;
  887. Hashtable new_values = null;
  888. InitializeView (view, InitViewType.MatchParamsToValues, out keys, out old_values, out new_values);
  889. view.Select (DataSourceSelectArguments.Empty);
  890. Assert.IsNotNull (eventsCalled, "Events not raized");
  891. Assert.AreEqual (3, eventsCalled.Count, "Events Count");
  892. Assert.AreEqual ("view_DataSourceViewChanged", eventsCalled [0], "view_DataSourceViewChanged");
  893. Assert.AreEqual ("SelectParameters_ParametersChanged", eventsCalled [1], "SelectParameters_ParametersChanged");
  894. Assert.AreEqual ("Select(filter = p_ValueSelect1)", eventsCalled [2], "DataSource Method params");
  895. }
  896. [Test]
  897. public void ParametersAndViewChangedEvent_MatchInsert ()
  898. {
  899. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  900. Hashtable keys = null;
  901. Hashtable old_values = null;
  902. Hashtable new_values = null;
  903. InitializeView (view, InitViewType.MatchParamsToValues, out keys, out old_values, out new_values);
  904. view.Insert (new_values);
  905. Assert.IsNotNull (eventsCalled, "Events not raized");
  906. Assert.AreEqual (3, eventsCalled.Count, "Events Count");
  907. Assert.AreEqual ("InsertParameters_ParametersChanged", eventsCalled [0], "InsertParameters_ParametersChanged");
  908. Assert.AreEqual ("Insert(ID = n_1001)", eventsCalled [1], "DataSource Method params");
  909. Assert.AreEqual ("view_DataSourceViewChanged", eventsCalled [2], "view_DataSourceViewChanged");
  910. }
  911. [Test]
  912. public void ParametersAndViewChangedEvent_MatchOldInsert ()
  913. {
  914. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  915. Hashtable keys = null;
  916. Hashtable old_values = null;
  917. Hashtable new_values = null;
  918. InitializeView (view, InitViewType.MatchParamsToOldValues, out keys, out old_values, out new_values);
  919. view.Insert (new_values);
  920. Assert.IsNotNull (eventsCalled, "Events not raized");
  921. Assert.AreEqual (3, eventsCalled.Count, "Events Count");
  922. Assert.AreEqual ("InsertParameters_ParametersChanged", eventsCalled [0], "InsertParameters_ParametersChanged");
  923. Assert.AreEqual ("Insert(ID = n_1001, oldvalue_ID = p_OldValueInsert1)", eventsCalled [1], "DataSource Method params");
  924. Assert.AreEqual ("view_DataSourceViewChanged", eventsCalled [2], "view_DataSourceViewChanged");
  925. }
  926. [Test]
  927. public void ParametersAndViewChangedEvent_DontMatchInsert ()
  928. {
  929. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  930. Hashtable keys = null;
  931. Hashtable old_values = null;
  932. Hashtable new_values = null;
  933. InitializeView (view, InitViewType.DontMatchParams, out keys, out old_values, out new_values);
  934. view.Insert (new_values);
  935. Assert.IsNotNull (eventsCalled, "Events not raized");
  936. Assert.AreEqual (3, eventsCalled.Count, "Events Count");
  937. Assert.AreEqual ("InsertParameters_ParametersChanged", eventsCalled [0], "InsertParameters_ParametersChanged");
  938. Assert.AreEqual ("InsertOther(ID = n_1001, OtherValue = p_OtherValueInsert1)", eventsCalled [1], "DataSource Method params");
  939. Assert.AreEqual ("view_DataSourceViewChanged", eventsCalled [2], "view_DataSourceViewChanged");
  940. }
  941. [Test]
  942. public void ParametersAndViewChangedEvent_MatchUpdate ()
  943. {
  944. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  945. Hashtable keys = null;
  946. Hashtable old_values = null;
  947. Hashtable new_values = null;
  948. InitializeView (view, InitViewType.MatchParamsToValues, out keys, out old_values, out new_values);
  949. view.Update (keys, new_values, old_values);
  950. Assert.IsNotNull (eventsCalled, "Events not raized");
  951. Assert.AreEqual (3, eventsCalled.Count, "Events Count");
  952. Assert.AreEqual ("UpdateParameters_ParametersChanged", eventsCalled [0], "UpdateParameters_ParametersChanged");
  953. Assert.AreEqual ("Update(ID = n_1001, oldvalue_ID = k_1001)", eventsCalled [1], "DataSource Method params");
  954. Assert.AreEqual ("view_DataSourceViewChanged", eventsCalled [2], "view_DataSourceViewChanged");
  955. }
  956. [Test]
  957. public void ParametersAndViewChangedEvent_MatchOldUpdate ()
  958. {
  959. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  960. Hashtable keys = null;
  961. Hashtable old_values = null;
  962. Hashtable new_values = null;
  963. InitializeView (view, InitViewType.MatchParamsToOldValues, out keys, out old_values, out new_values);
  964. view.Update (keys, new_values, old_values);
  965. Assert.IsNotNull (eventsCalled, "Events not raized");
  966. Assert.AreEqual (3, eventsCalled.Count, "Events Count");
  967. Assert.AreEqual ("UpdateParameters_ParametersChanged", eventsCalled [0], "UpdateParameters_ParametersChanged");
  968. Assert.AreEqual ("Update(ID = n_1001, oldvalue_ID = k_1001)", eventsCalled [1], "DataSource Method params");
  969. Assert.AreEqual ("view_DataSourceViewChanged", eventsCalled [2], "view_DataSourceViewChanged");
  970. }
  971. [Test]
  972. public void ParametersAndViewChangedEvent_DontMatchUpdate ()
  973. {
  974. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  975. Hashtable keys = null;
  976. Hashtable old_values = null;
  977. Hashtable new_values = null;
  978. InitializeView (view, InitViewType.DontMatchParams, out keys, out old_values, out new_values);
  979. view.Update (keys, new_values, old_values);
  980. Assert.IsNotNull (eventsCalled, "Events not raized");
  981. Assert.AreEqual (3, eventsCalled.Count, "Events Count");
  982. Assert.AreEqual ("UpdateParameters_ParametersChanged", eventsCalled [0], "UpdateParameters_ParametersChanged");
  983. Assert.AreEqual ("UpdateOther(ID = n_1001, OtherValue = p_OtherValueUpdate1, oldvalue_ID = k_1001)", eventsCalled [1], "DataSource Method params");
  984. Assert.AreEqual ("view_DataSourceViewChanged", eventsCalled [2], "view_DataSourceViewChanged");
  985. }
  986. [Test]
  987. public void ParametersAndViewChangedEvent_MatchDelete ()
  988. {
  989. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  990. Hashtable keys = null;
  991. Hashtable old_values = null;
  992. Hashtable new_values = null;
  993. InitializeView (view, InitViewType.MatchParamsToValues, out keys, out old_values, out new_values);
  994. view.Delete (keys, old_values);
  995. Assert.IsNotNull (eventsCalled, "Events not raized");
  996. Assert.AreEqual (3, eventsCalled.Count, "Events Count");
  997. Assert.AreEqual ("DeleteParameters_ParametersChanged", eventsCalled [0], "DeleteParameters_ParametersChanged");
  998. Assert.AreEqual ("Delete(ID = p_ValueDelete1, oldvalue_ID = k_1001)", eventsCalled [1], "DataSource Method params");
  999. Assert.AreEqual ("view_DataSourceViewChanged", eventsCalled [2], "view_DataSourceViewChanged");
  1000. }
  1001. [Test]
  1002. public void ParametersAndViewChangedEvent_MatchOldDelete ()
  1003. {
  1004. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  1005. Hashtable keys = null;
  1006. Hashtable old_values = null;
  1007. Hashtable new_values = null;
  1008. InitializeView (view, InitViewType.MatchParamsToOldValues, out keys, out old_values, out new_values);
  1009. view.Delete (keys, old_values);
  1010. Assert.IsNotNull (eventsCalled, "Events not raized");
  1011. Assert.AreEqual (3, eventsCalled.Count, "Events Count");
  1012. Assert.AreEqual ("DeleteParameters_ParametersChanged", eventsCalled [0], "DeleteParameters_ParametersChanged");
  1013. Assert.AreEqual ("Delete(oldvalue_ID = k_1001)", eventsCalled [1], "DataSource Method params");
  1014. Assert.AreEqual ("view_DataSourceViewChanged", eventsCalled [2], "view_DataSourceViewChanged");
  1015. }
  1016. [Test]
  1017. public void ParametersAndViewChangedEvent_DontMatchDelete ()
  1018. {
  1019. ObjectViewPoker view = new ObjectViewPoker (new ObjectDataSource (), "", null);
  1020. Hashtable keys = null;
  1021. Hashtable old_values = null;
  1022. Hashtable new_values = null;
  1023. InitializeView (view, InitViewType.DontMatchParams, out keys, out old_values, out new_values);
  1024. view.Delete (keys, old_values);
  1025. Assert.IsNotNull (eventsCalled, "Events not raized");
  1026. Assert.AreEqual (3, eventsCalled.Count, "Events Count");
  1027. Assert.AreEqual ("DeleteParameters_ParametersChanged", eventsCalled [0], "DeleteParameters_ParametersChanged");
  1028. Assert.AreEqual ("DeleteOther(oldvalue_ID = k_1001, OtherValue = p_OtherValueDelete1)", eventsCalled [1], "DataSource Method params");
  1029. Assert.AreEqual ("view_DataSourceViewChanged", eventsCalled [2], "view_DataSourceViewChanged");
  1030. }
  1031. /// <summary>
  1032. /// Helper methods
  1033. /// </summary>
  1034. private static bool event_checker;
  1035. private static void Eventassert (string message)
  1036. {
  1037. Assert.IsTrue (ObjectDataSourceViewTest.event_checker, message);
  1038. ObjectDataSourceViewTest.event_checker = false;
  1039. }
  1040. static void Event (object sender, ObjectDataSourceMethodEventArgs e)
  1041. {
  1042. ObjectDataSourceViewTest.event_checker = true;
  1043. }
  1044. static void view_Selecting (object sender, ObjectDataSourceSelectingEventArgs e)
  1045. {
  1046. event_checker = true;
  1047. }
  1048. void view_Filtering (object sender, ObjectDataSourceFilteringEventArgs e)
  1049. {
  1050. event_checker = true;
  1051. }
  1052. void view_ObjectCreate (object sender, ObjectDataSourceEventArgs e)
  1053. {
  1054. event_checker = true;
  1055. }
  1056. void view_Status (object sender, ObjectDataSourceStatusEventArgs e)
  1057. {
  1058. event_checker = true;
  1059. }
  1060. void view_ObjectDisposing (object sender, ObjectDataSourceDisposingEventArgs e)
  1061. {
  1062. event_checker = true;
  1063. }
  1064. private class MyDataSource : ObjectDataSource
  1065. {
  1066. public DataSourceView DoGetView (string viewName)
  1067. {
  1068. return base.GetView (viewName);
  1069. }
  1070. public void DoTrackViewState ()
  1071. {
  1072. base.TrackViewState ();
  1073. }
  1074. }
  1075. }
  1076. public class DataSourceObject
  1077. {
  1078. private static int maximumRows;
  1079. public static DataTable ds = CreateDataTable ();
  1080. public static void InitDS ()
  1081. {
  1082. ds = CreateDataTable ();
  1083. }
  1084. public static DataTable Select ()
  1085. {
  1086. return ds;
  1087. }
  1088. [Sys.ComponentModel.DataObjectMethod(Sys.ComponentModel.DataObjectMethodType.Select, false)]
  1089. public static DataTable Select (int maximumRows, short startRowIndex) {
  1090. Assert.Fail ("Should not be called since not default Select DataObjectMethod");
  1091. return null;
  1092. }
  1093. [Sys.ComponentModel.DataObjectMethod(Sys.ComponentModel.DataObjectMethodType.Select, true)]
  1094. public static DataTable Select (int maximumRows, int startRowIndex)
  1095. {
  1096. DataSourceObject.maximumRows = maximumRows;
  1097. if (ds.Rows.Count > maximumRows) {
  1098. DataTable temp = ds.Clone ();
  1099. int i = 0;
  1100. while (i < maximumRows && startRowIndex <= ds.Rows.Count) {
  1101. object[] o = ds.Rows[startRowIndex].ItemArray;
  1102. temp.Rows.Add (o);
  1103. i++;
  1104. startRowIndex++;
  1105. }
  1106. return temp;
  1107. }
  1108. return ds;
  1109. }
  1110. public static DataTable Delete (string ID, string FName, string LName)
  1111. {
  1112. DataRow dr = ds.Rows.Find (ID);
  1113. if (dr != null) {
  1114. ds.Rows.Remove (dr);
  1115. }
  1116. return ds;
  1117. }
  1118. public static DataTable Insert (string ID, string FName, string LName)
  1119. {
  1120. DataRow dr = ds.NewRow ();
  1121. dr["ID"] = ID;
  1122. dr["FName"] = FName;
  1123. dr["LName"] = LName;
  1124. ds.Rows.Add (dr);
  1125. return ds;
  1126. }
  1127. public static DataTable Update (string ID, string FName, string LName)
  1128. {
  1129. foreach (DataRow row in ds.Rows) {
  1130. if (row["ID"].ToString () == ID) {
  1131. row["FName"] = FName;
  1132. row["LName"] = LName;
  1133. }
  1134. }
  1135. return ds;
  1136. }
  1137. public static int SelectCount ()
  1138. {
  1139. //Note: This is return 5 only for test goal
  1140. return 5;
  1141. }
  1142. public static DataTable CreateDataTable ()
  1143. {
  1144. DataTable aTable = new DataTable ("A");
  1145. DataColumn dtCol;
  1146. DataRow dtRow;
  1147. // Create ID column and add to the DataTable.
  1148. dtCol = new DataColumn ();
  1149. dtCol.DataType = Type.GetType ("System.Int32");
  1150. dtCol.ColumnName = "ID";
  1151. dtCol.AutoIncrement = true;
  1152. dtCol.Caption = "ID";
  1153. dtCol.ReadOnly = true;
  1154. dtCol.Unique = true;
  1155. aTable.Columns.Add (dtCol);
  1156. // Create Name column and add to the table
  1157. dtCol = new DataColumn ();
  1158. dtCol.DataType = Type.GetType ("System.String");
  1159. dtCol.ColumnName = "FName";
  1160. dtCol.AutoIncrement = false;
  1161. dtCol.Caption = "First Name";
  1162. dtCol.ReadOnly = false;
  1163. dtCol.Unique = false;
  1164. aTable.Columns.Add (dtCol);
  1165. // Create Last Name column and add to the table.
  1166. dtCol = new DataColumn ();
  1167. dtCol.DataType = Type.GetType ("System.String");
  1168. dtCol.ColumnName = "LName";
  1169. dtCol.AutoIncrement = false;
  1170. dtCol.Caption = "Last Name";
  1171. dtCol.ReadOnly = false;
  1172. dtCol.Unique = false;
  1173. aTable.Columns.Add (dtCol);
  1174. // Create three rows to the table
  1175. dtRow = aTable.NewRow ();
  1176. dtRow["ID"] = 1001;
  1177. dtRow["FName"] = "Mahesh";
  1178. dtRow["LName"] = "Chand";
  1179. aTable.Rows.Add (dtRow);
  1180. aTable.PrimaryKey = new DataColumn[] { aTable.Columns["ID"] };
  1181. return aTable;
  1182. }
  1183. }
  1184. }
  1185. #endif