ObjectDataSourceViewTest.cs 52 KB

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