Helix SwarmHelix Swarm
Loading...

NewAccount.aspx

  • //
  • guest/
  • Necqui/
  • Documents/
  • Projects/
  • vsDotNet/
  • TKN/
  • BERP/
  • Admin/
  • NewAccount.aspx #2
  • View
  • Commits
  • Open Download .zip Download (21 KB) 
  1. <%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="NewAccount.aspx.cs" Inherits="NewAccount" %>
  2.  
  3. <asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="Server">
  4.    <style type="text/css">
  5. 	  .style1
  6. 	  {
  7. 		 width: 100%;
  8. 	  }
  9. 	  .style2
  10. 	  {
  11. 		 height: 17px;
  12. 	  }
  13. 	  .style3
  14. 	  {
  15. 		 width: 82px;
  16. 	  }
  17. 	  .style5
  18. 	  {
  19. 		 width: 82px;
  20. 		 height: 26px;
  21. 	  }
  22. 	  .style6
  23. 	  {
  24. 		 width: 8px;
  25. 		 height: 26px;
  26. 	  }
  27. 	  .style7
  28. 	  {
  29. 		 height: 26px;
  30. 	  }
  31. 	  .style8
  32. 	  {
  33. 		 width: 8px;
  34. 	  }
  35. 	  .style11
  36. 	  {
  37. 		 width: 31px;
  38. 	  }
  39. 	  .style13
  40. 	  {
  41. 		 width: 395px;
  42. 	  }
  43. 	  .style14
  44. 	  {
  45. 		 width: 93px;
  46. 	  }
  47. 	  .style15
  48. 	  {
  49. 		 width: 78px;
  50. 	  }
  51.    </style>
  52. </asp:Content>
  53.  
  54. <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="Server">
  55.    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
  56.    <ContentTemplate>
  57.  
  58.    <h2>New Account</h2>
  59.    <br />
  60.    <asp:MultiView ID="mvNewAccount" runat="server" ActiveViewIndex="0">
  61. 	  <asp:View ID="vJKAddressDetails" runat="server">
  62. 		 <asp:Panel ID="pnlAddress" runat="server" GroupingText="Jamatkhana &amp; Address Details:"
  63. 			Height="349px" Width="586px">
  64. 			<table class="style1">
  65. 			   <tr>
  66. 				  <td>
  67. 					 &nbsp;
  68. 				  </td>
  69. 				  <td>
  70. 					 &nbsp;
  71. 				  </td>
  72. 				  <td>
  73. 					 &nbsp;
  74. 				  </td>
  75. 			   </tr>
  76. 			   <tr>
  77. 				  <td>
  78. 					 <asp:Label ID="lblJamatkhana" runat="server" AssociatedControlID="ddlJamatkhana"
  79. 						CssClass="requiredField" Text="Jamatkhana:"> </asp:Label>
  80. 				  </td>
  81. 				  <td>
  82. 					 &nbsp;
  83. 				  </td>
  84. 				  <td>
  85. 					 <asp:DropDownList ID="ddlJamatkhana" runat="server" AppendDataBoundItems="True" DataSourceID="adsJK"
  86. 						DataTextField="JKName" DataValueField="JKID" Height="20px" TabIndex="1" Width="225px">
  87. 						<asp:ListItem Value="0">- Select Jamatkhana -</asp:ListItem>
  88. 					 </asp:DropDownList>
  89. 					 &nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidatorJK" runat="server" ControlToValidate="ddlJamatkhana"
  90. 						CssClass="failureNotification" Display="Dynamic" ErrorMessage="Jamatkhana selection is required."
  91. 						InitialValue="0" ValidationGroup="AddressDetailsJKValidationGroup">*</asp:RequiredFieldValidator>
  92. 				  </td>
  93. 			   </tr>
  94. 			   <tr>
  95. 				  <td>
  96. 					 &nbsp;
  97. 				  </td>
  98. 				  <td>
  99. 					 &nbsp;
  100. 				  </td>
  101. 				  <td>
  102. 					 &nbsp;
  103. 				  </td>
  104. 			   </tr>
  105. 			   <tr>
  106. 				  <td>
  107. 					 <asp:Label ID="lblStreetAddress" runat="server" Text="Address:" AssociatedControlID="txtboxStreetAddress"></asp:Label>
  108. 				  </td>
  109. 				  <td>
  110. 					 &nbsp;
  111. 				  </td>
  112. 				  <td>
  113. 					 <asp:TextBox ID="txtboxStreetAddress" runat="server" Width="415px" TabIndex="2" AutoCompleteType="Disabled"></asp:TextBox>
  114. 				  </td>
  115. 			   </tr>
  116. 			   <tr>
  117. 				  <td>
  118. 					 &nbsp;
  119. 				  </td>
  120. 				  <td>
  121. 					 &nbsp;
  122. 				  </td>
  123. 				  <td>
  124. 					 &nbsp;
  125. 				  </td>
  126. 			   </tr>
  127. 			   <tr>
  128. 				  <td>
  129. 					 <asp:Label ID="lblCity" runat="server" AssociatedControlID="ddlCity" Text="City:"></asp:Label>
  130. 				  </td>
  131. 				  <td>
  132. 					 &nbsp;
  133. 				  </td>
  134. 				  <td>
  135. 					 <asp:DropDownList ID="ddlCity" runat="server" AppendDataBoundItems="True" DataSourceID="adsCity"
  136. 						DataTextField="CityName" DataValueField="CityID" Width="225px" TabIndex="3">
  137. 						<asp:ListItem Value="0">- Select City -</asp:ListItem>
  138. 					 </asp:DropDownList>
  139. 				  </td>
  140. 			   </tr>
  141. 			   <tr>
  142. 				  <td>
  143. 					 &nbsp;
  144. 				  </td>
  145. 				  <td>
  146. 					 &nbsp;
  147. 				  </td>
  148. 				  <td>
  149. 					 &nbsp;
  150. 				  </td>
  151. 			   </tr>
  152. 			   <tr>
  153. 				  <td>
  154. 					 <asp:Label ID="lblProvince" runat="server" AssociatedControlID="ddlProvince" Text="Province:"></asp:Label>
  155. 				  </td>
  156. 				  <td>
  157. 					 &nbsp;
  158. 				  </td>
  159. 				  <td>
  160. 					 <asp:DropDownList ID="ddlProvince" runat="server" DataSourceID="adsProvince" DataTextField="ProvinceName"
  161. 						DataValueField="ProvinceID" Width="225px" Height="20px" TabIndex="4" AppendDataBoundItems="True">
  162. 						<asp:ListItem Value="0">- Select Province -</asp:ListItem>
  163. 					 </asp:DropDownList>
  164. 				  </td>
  165. 			   </tr>
  166. 			   <tr>
  167. 				  <td class="style2">
  168. 					 &nbsp;</td>
  169. 				  <td class="style2">
  170. 					 &nbsp;</td>
  171. 				  <td class="style2">
  172. 					 &nbsp;</td>
  173. 			   </tr>
  174. 			   <tr>
  175. 				  <td class="style2">
  176. 					 <asp:Label ID="lblPostalCode" runat="server" Text="Postal Code:"></asp:Label></td>
  177. 				  <td class="style2">
  178. 					 &nbsp;</td>
  179. 				  <td class="style2">
  180. 					 <asp:TextBox ID="txtboxPostalCode" runat="server" AutoCompleteType="Disabled" Width="146px" TabIndex="5"></asp:TextBox>
  181. 					 &nbsp;<asp:RegularExpressionValidator ID="RegexPostalCodeValidator" runat="server" ErrorMessage="Postal Code format is V6V6V6 (no spaces or hyphens)." Display="Dynamic" ControlToValidate="txtboxPostalCode" CssClass="failureNotification" ValidationGroup="AddressDetailsJKValidationGroup" ValidationExpression="(^([0-9]{5})$)|(^[abceghj-nprstvxyABCEGHJ-NPRSTVXY]{1}\d{1}[abceghj-nprstv-zABCEGHJ-NPRSTV-Z]{1}\d{1}[abceghj-nprstv-zABCEGHJ-NPRSTV-Z]{1}\d{1}$)" Text="*"></asp:RegularExpressionValidator>
  182. 				  </td>
  183. 			   </tr>
  184. 			   <tr>
  185. 				  <td class="style2">
  186. 				  </td>
  187. 				  <td class="style2">
  188. 				  </td>
  189. 				  <td class="style2">
  190. 				  </td>
  191. 			   </tr>
  192. 			   <tr>
  193. 				  <td>
  194. 					 <asp:Label ID="lblTelephone" runat="server" Text="Telephone:" AssociatedControlID="txtboxTelephone"
  195. 						CssClass="requiredField"></asp:Label>
  196. 				  </td>
  197. 				  <td>
  198. 					 &nbsp;
  199. 				  </td>
  200. 				  <td>
  201. 					 <asp:TextBox ID="txtboxTelephone" runat="server" AutoCompleteType="Disabled" Width="146px" TabIndex="6"></asp:TextBox>
  202. 					 &nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidatorTelephone" runat="server"
  203. 						ControlToValidate="txtboxTelephone" CssClass="failureNotification" Display="Dynamic"
  204. 						ErrorMessage="Telephone number is required." ValidationGroup="AddressDetailsJKValidationGroup">*</asp:RequiredFieldValidator>
  205. 					 <asp:RegularExpressionValidator ID="RegexPhoneNumberValidator" runat="server" ErrorMessage="Telephone number format is 10 numeric digits only (no spaces, parentheses or hyphens)." Display="Dynamic" ControlToValidate="txtboxTelephone" CssClass="failureNotification" ValidationExpression="^\d{10}$" Text="*" ValidationGroup="AddressDetailsJKValidationGroup"></asp:RegularExpressionValidator>
  206. 				  </td>
  207. 			   </tr>
  208. 			   <tr>
  209. 				  <td class="style2">
  210. 				  </td>
  211. 				  <td class="style2">
  212. 				  </td>
  213. 				  <td class="style2">
  214. 				  </td>
  215. 			   </tr>
  216. 			   <tr>
  217. 				  <td>
  218. 					 &nbsp;
  219. 				  </td>
  220. 				  <td>
  221. 					 &nbsp;
  222. 				  </td>
  223. 				  <td>
  224. 					 <asp:Button ID="btnView1Next" runat="server" CommandName="NextView" Text="Next" Width="71px"
  225. 						TabIndex="7" ValidationGroup="AddressDetailsJKValidationGroup" />
  226. 				  </td>
  227. 			   </tr>
  228. 			   <tr>
  229. 				  <td>
  230. 					 &nbsp;
  231. 				  </td>
  232. 				  <td>
  233. 					 &nbsp;
  234. 				  </td>
  235. 				  <td>
  236. 					 &nbsp;
  237. 				  </td>
  238. 			   </tr>
  239. 			   <tr>
  240. 				  <td>
  241. 					 &nbsp;
  242. 				  </td>
  243. 				  <td>
  244. 					 &nbsp;
  245. 				  </td>
  246. 				  <td>
  247. 					 <asp:ValidationSummary ID="ValidationSummaryJKAddressDetails" runat="server" CssClass="failureNotification"
  248. 						ValidationGroup="AddressDetailsJKValidationGroup" />
  249. 				  </td>
  250. 			   </tr>
  251. 			   <tr>
  252. 				  <td>
  253. 					 &nbsp;
  254. 				  </td>
  255. 				  <td>
  256. 					 &nbsp;
  257. 				  </td>
  258. 				  <td>
  259. 					 &nbsp;
  260. 				  </td>
  261. 			   </tr>
  262. 			</table>
  263. 		 </asp:Panel>
  264. 	  </asp:View>
  265. 	  <asp:View ID="vPrimaryMemberDetails" runat="server">
  266. 		 <asp:Panel ID="pnlPrimary" runat="server" GroupingText="Primary Member Details:"
  267. 			Height="342px" Width="585px">
  268. 			<table class="style1">
  269. 			   <tr>
  270. 				  <td class="style3">
  271. 					 &nbsp;
  272. 				  </td>
  273. 				  <td class="style8">
  274. 					 &nbsp;
  275. 				  </td>
  276. 				  <td>
  277. 					 &nbsp;
  278. 				  </td>
  279. 			   </tr>
  280. 			   <tr>
  281. 				  <td class="style3">
  282. 					 <asp:Label ID="lblLastName" runat="server" Text="Last Name:" CssClass="requiredField"></asp:Label>
  283. 				  </td>
  284. 				  <td class="style8">
  285. 					 &nbsp;
  286. 				  </td>
  287. 				  <td>
  288. 					 <asp:TextBox ID="txtboxLastName" runat="server" AutoCompleteType="Disabled" Width="283px"
  289. 						TabIndex="1"></asp:TextBox>
  290. 					 &nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidatorLastName" runat="server"
  291. 						ControlToValidate="txtboxLastName" CssClass="failureNotification" Display="Dynamic"
  292. 						ErrorMessage="Last name of the primary member is required." ValidationGroup="PrimaryMemberValidationGroup">*</asp:RequiredFieldValidator>
  293. 				  </td>
  294. 			   </tr>
  295. 			   <tr>
  296. 				  <td class="style3">
  297. 					 &nbsp;
  298. 				  </td>
  299. 				  <td class="style8">
  300. 					 &nbsp;
  301. 				  </td>
  302. 				  <td>
  303. 					 &nbsp;
  304. 				  </td>
  305. 			   </tr>
  306. 			   <tr>
  307. 				  <td class="style3">
  308. 					 <asp:Label ID="lblMiddleName" runat="server" Text="Middle Name:"></asp:Label>
  309. 				  </td>
  310. 				  <td class="style8">
  311. 					 &nbsp;
  312. 				  </td>
  313. 				  <td>
  314. 					 <asp:TextBox ID="txtboxMiddleName" runat="server" Width="283px" TabIndex="2" AutoCompleteType="Disabled"></asp:TextBox>
  315. 				  </td>
  316. 			   </tr>
  317. 			   <tr>
  318. 				  <td class="style3">
  319. 					 &nbsp;
  320. 				  </td>
  321. 				  <td class="style8">
  322. 					 &nbsp;
  323. 				  </td>
  324. 				  <td>
  325. 					 &nbsp;
  326. 				  </td>
  327. 			   </tr>
  328. 			   <tr>
  329. 				  <td class="style3">
  330. 					 <asp:Label ID="lblFirstName" runat="server" Text="First Name:" CssClass="requiredField"></asp:Label>
  331. 				  </td>
  332. 				  <td class="style8">
  333. 					 &nbsp;
  334. 				  </td>
  335. 				  <td>
  336. 					 <asp:TextBox ID="txtboxFirstName" runat="server" Width="283px" TabIndex="3" AutoCompleteType="Disabled"></asp:TextBox>
  337. 					 &nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidatorFirstName" runat="server"
  338. 						ControlToValidate="txtboxFirstName" CssClass="failureNotification" Display="Dynamic"
  339. 						ErrorMessage="First name of the primary member is required." ValidationGroup="PrimaryMemberValidationGroup">*</asp:RequiredFieldValidator>
  340. 				  </td>
  341. 			   </tr>
  342. 			   <tr>
  343. 				  <td class="style3">
  344. 					 &nbsp;
  345. 				  </td>
  346. 				  <td class="style8">
  347. 					 &nbsp;
  348. 				  </td>
  349. 				  <td>
  350. 					 &nbsp;
  351. 				  </td>
  352. 			   </tr>
  353. 			   <tr>
  354. 				  <td class="style3">
  355. 					 <asp:Label ID="lblJamatiTitle" runat="server" Text="Jamati Title:" CssClass="requiredField"></asp:Label>
  356. 				  </td>
  357. 				  <td class="style8">
  358. 					 &nbsp;
  359. 				  </td>
  360. 				  <td>
  361. 					<asp:DropDownList ID="ddlJamatiTitle" runat="server" AppendDataBoundItems="True" CssClass="eitField" DataSourceID="adsJamatiTitle"
  362. 						DataTextField="JMTitle" DataValueField="JMTitleID" Width="150px" >
  363. 						<asp:ListItem Value="0">- Select Title -</asp:ListItem>
  364.                         <asp:ListItem Value="15" Text="None" Selected="True"></asp:ListItem>
  365. 					</asp:DropDownList>
  366. 						&nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidatorJamatiTitle" runat="server"
  367. 						ControlToValidate="ddlJamatiTitle" CssClass="failureNotification" Display="Dynamic"
  368. 						ErrorMessage="Jamati Title of the primary member is required." ValidationGroup="PrimaryMemberValidationGroup"
  369. 						InitialValue="0">*</asp:RequiredFieldValidator>
  370. 				  </td>
  371. 			   </tr>
  372. 			   <tr>
  373. 				  <td class="style3">
  374. 					 &nbsp;
  375. 				  </td>
  376. 				  <td class="style8">
  377. 					 &nbsp;
  378. 				  </td>
  379. 				  <td>
  380. 					 &nbsp;
  381. 				  </td>
  382. 			   </tr>
  383. 			   <tr>
  384. 				  <td class="style5">
  385. 					 <asp:Label ID="lblBirthYear" runat="server" Text="Birth Year:" CssClass="requiredField"></asp:Label>
  386. 				  </td>
  387. 				  <td class="style6">
  388. 				  </td>
  389. 				  <td class="style7">
  390. 					 <asp:TextBox ID="txtboxBirthYear" runat="server" Width="120px" TabIndex="4" AutoCompleteType="Disabled"></asp:TextBox>
  391. 					 &nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidatorBirthYear" runat="server"
  392. 						ControlToValidate="txtboxBirthYear" CssClass="failureNotification" Display="Dynamic"
  393. 						ErrorMessage="Birth year of the primary member is required." ValidationGroup="PrimaryMemberValidationGroup">*</asp:RequiredFieldValidator>
  394. 					 <asp:RangeValidator ID="rangeValidatorBirthYear" runat="server" 
  395. 							  ErrorMessage="Birth Year ranges from 1900 to current year." CssClass="failureNotification" Display="Dynamic" 
  396. 							  MinimumValue='<%# DateTime.Now.Year - 120 %>' Type="Integer" Text="*" MaximumValue='<%# DateTime.Now.Year %>' ControlToValidate="txtboxBirthYear" ValidationGroup="PrimaryMemberValidationGroup"></asp:RangeValidator>
  397. 				  </td>
  398. 			   </tr>
  399. 			   <tr>
  400. 				  <td class="style3">
  401. 					 &nbsp;
  402. 				  </td>
  403. 				  <td class="style8">
  404. 					 &nbsp;
  405. 				  </td>
  406. 				  <td>
  407. 					 &nbsp;
  408. 				  </td>
  409. 			   </tr>
  410. 			   <tr>
  411. 				  <td class="style3">
  412. 					 <asp:Label ID="lblGender" runat="server" Text="Gender:" CssClass="requiredField"></asp:Label>
  413. 				  </td>
  414. 				  <td class="style8">
  415. 					 &nbsp;
  416. 				  </td>
  417. 				  <td>
  418. 					 <asp:DropDownList ID="ddlGender" runat="server" AppendDataBoundItems="True" DataSourceID="adsGender"
  419. 						DataTextField="GenderName" DataValueField="GenderID" Width="125px" TabIndex="5">
  420. 						<asp:ListItem Value="0">- Select Gender -</asp:ListItem>
  421. 					 </asp:DropDownList>
  422. 					 &nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidatorGender" runat="server"
  423. 						ControlToValidate="ddlGender" CssClass="failureNotification" Display="Dynamic"
  424. 						ErrorMessage="Gender of the primary member is required." ValidationGroup="PrimaryMemberValidationGroup"
  425. 						InitialValue="0">*</asp:RequiredFieldValidator>
  426. 				  </td>
  427. 			   </tr>
  428. 			   <tr>
  429. 				  <td class="style3">
  430. 					 &nbsp;
  431. 				  </td>
  432. 				  <td class="style8">
  433. 					 &nbsp;
  434. 				  </td>
  435. 				  <td>
  436. 					 &nbsp;
  437. 				  </td>
  438. 			   </tr>
  439. 			   <tr>
  440. 				  <td class="style3">
  441. 					 <asp:Button ID="btnView2Previous" runat="server" CommandName="PrevView" Text="Previous"
  442. 						TabIndex="6" />
  443. 				  </td>
  444. 				  <td class="style8">
  445. 					 &nbsp;
  446. 				  </td>
  447. 				  <td>
  448. 					 <asp:Button ID="btnView2Next" runat="server" Text="Next" Width="71px" TabIndex="7"
  449. 						ValidationGroup="PrimaryMemberValidationGroup" CommandName="NextView" />
  450. 				  </td>
  451. 			   </tr>
  452. 			   <tr>
  453. 				  <td class="style3">
  454. 					 &nbsp;
  455. 				  </td>
  456. 				  <td class="style8">
  457. 					 &nbsp;
  458. 				  </td>
  459. 				  <td>
  460. 					 &nbsp;
  461. 				  </td>
  462. 			   </tr>
  463. 			   <tr>
  464. 				  <td class="style3">
  465. 					 &nbsp;
  466. 				  </td>
  467. 				  <td class="style8">
  468. 					 &nbsp;
  469. 				  </td>
  470. 				  <td>
  471. 					 <asp:ValidationSummary ID="ValidationSummaryPrimaryMember" runat="server" CssClass="failureNotification"
  472. 						ValidationGroup="PrimaryMemberValidationGroup" />
  473. 				  </td>
  474. 			   </tr>
  475. 			</table>
  476. 		 </asp:Panel>
  477. 	  </asp:View>
  478. 	  <asp:View ID="vDuplicate" runat="server">
  479. 		 <table class="style1">
  480. 			<tr>
  481. 			   <td>
  482. 				  &nbsp;</td>
  483. 			   <td colspan="3">
  484. 				  <asp:GridView ID="gvDuplicateAccounts" runat="server" AllowPaging="True" AutoGenerateColumns="False"
  485. 					 CellPadding="4" DataSourceID="adsDuplicateAccounts" EmptyDataText="Congratulations! No duplicate accounts were found matching your criteria. You may continue with the creation of the account."
  486. 					 ForeColor="#333333" GridLines="None" Caption="Duplicate Accounts" 
  487. 					 CaptionAlign="Left">
  488. 					 <AlternatingRowStyle BackColor="White" />
  489. 					 <Columns>
  490. 						<asp:BoundField DataField="AccountID" HeaderText="Account ID" InsertVisible="False"
  491. 						   SortExpression="AccountID" />
  492. 						<asp:BoundField DataField="AccountStatus" HeaderText="Account Status" 
  493. 						   SortExpression="AccountStatus" />
  494. 						<asp:BoundField DataField="MemberLastName" HeaderText="Last Name" 
  495. 						   SortExpression="MemberLastName" />
  496. 						<asp:BoundField DataField="MemberMiddleName" HeaderText="Middle Name" 
  497. 						   SortExpression="MemberMiddleName" />
  498. 						<asp:BoundField DataField="MemberFirstName" HeaderText="First Name" 
  499. 						   SortExpression="MemberFirstName" />
  500. 						<asp:BoundField DataField="GenderAbbreviation" HeaderText="Gender" 
  501. 						   SortExpression="GenderAbbreviation" />
  502. 						<asp:BoundField DataField="MemberBirthYear" HeaderText="Birth Year" 
  503. 						   SortExpression="MemberBirthYear" />
  504. 						<asp:BoundField DataField="JKName" HeaderText="Jamatkhana" 
  505. 						   SortExpression="JKName" />
  506. 						<asp:CheckBoxField DataField="MemberPrimary" HeaderText="Primary" 
  507. 						   SortExpression="MemberPrimary" />
  508. 						<asp:BoundField DataField="AccountStreetAddress" HeaderText="Address" 
  509. 						   SortExpression="AccountStreetAddress" />
  510. 						<asp:BoundField DataField="CityName" HeaderText="City" 
  511. 						   SortExpression="CityName" />
  512. 						<asp:BoundField DataField="ProvinceAbbreviation" HeaderText="Province" 
  513. 						   SortExpression="ProvinceAbbreviation" />
  514. 						<asp:BoundField DataField="AccountPostalCode" HeaderText="Postal Code" 
  515. 						   SortExpression="AccountPostalCode" />
  516. 						<asp:BoundField DataField="AccountPhoneNumber" HeaderText="Phone Number" 
  517. 						   SortExpression="AccountPhoneNumber" />
  518. 						<asp:BoundField DataField="MemberStatus" HeaderText="Member Status" 
  519. 						   SortExpression="MemberStatus" />
  520. 					 </Columns>
  521. 					 <EditRowStyle BackColor="#2461BF" />
  522. 					 <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
  523. 					 <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
  524. 					 <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
  525. 					 <RowStyle BackColor="#EFF3FB" />
  526. 					 <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
  527. 					 <SortedAscendingCellStyle BackColor="#F5F7FB" />
  528. 					 <SortedAscendingHeaderStyle BackColor="#6D95E1" />
  529. 					 <SortedDescendingCellStyle BackColor="#E9EBEF" />
  530. 					 <SortedDescendingHeaderStyle BackColor="#4870BE" />
  531. 				  </asp:GridView>
  532. 			   </td>
  533. 			</tr>
  534. 			<tr>
  535. 			   <td>
  536. 				  &nbsp;
  537. 			   </td>
  538. 			   <td colspan="3">
  539. 				  &nbsp;
  540. 			   </td>
  541. 			</tr>
  542. 		 </table>
  543. 		 <table class="style13">
  544. 			<tr>
  545. 			   <td class="style15">
  546. 				  &nbsp;
  547. 			   </td>
  548. 			   <td class="style11">
  549. 				  &nbsp;
  550. 			   </td>
  551. 			   <td class="style14">
  552. 				  &nbsp;
  553. 			   </td>
  554. 			</tr>
  555. 			<tr>
  556. 			   <td class="style15">
  557. 				  <asp:Button ID="btnView3Next" runat="server" CommandName="NextView" 
  558. 					 onclick="btnView3Next_Click" Text="Create" Width="70px" />
  559. 			   </td>
  560. 			   <td class="style11">
  561. 				  <asp:Button ID="btnView3Previous" runat="server" Text="Previous" CommandName="PrevView" Width="70px"/>
  562. 			   </td>
  563. 			   <td class="style14">
  564. 				  <asp:Button ID="btnCancel" runat="server" onclick="btnCancel_Click" Text="Cancel" Width="70px"/>
  565. 			   </td>
  566. 			</tr>
  567. 			<tr>
  568. 			   <td class="style15">
  569. 				  &nbsp;
  570. 			   </td>
  571. 			   <td class="style11">
  572. 				  &nbsp;
  573. 			   </td>
  574. 			   <td class="style14">
  575. 				  &nbsp;
  576. 			   </td>
  577. 			</tr>
  578. 		 </table>
  579. 	  </asp:View>
  580.    </asp:MultiView>
  581.    <asp:AccessDataSource ID="adsJK" runat="server" DataFile="~/App_Data/Burial.mdb"
  582. 	  SelectCommand="SELECT [JKID], [JKName] FROM [Jamatkhana] ORDER BY [JKID]"></asp:AccessDataSource>
  583.    <asp:AccessDataSource ID="adsCity" runat="server" DataFile="~/App_Data/Burial.mdb"
  584. 	  SelectCommand="SELECT [CityID], [CityName] FROM [City] ORDER BY [CityID]"></asp:AccessDataSource>
  585.    <asp:AccessDataSource ID="adsProvince" runat="server" DataFile="~/App_Data/Burial.mdb"
  586. 	  SelectCommand="SELECT [ProvinceID], [ProvinceName] FROM [Province] ORDER BY [ProvinceID]">
  587.    </asp:AccessDataSource>
  588.    <asp:AccessDataSource ID="adsGender" runat="server" DataFile="~/App_Data/Burial.mdb"
  589. 	  SelectCommand="SELECT [GenderID], [GenderName] FROM [Gender] ORDER BY [GenderID]">
  590.    </asp:AccessDataSource>
  591.    <asp:AccessDataSource ID="adsJamatiTitle" runat="server" DataFile="~/App_Data/Burial.mdb"
  592. 	  SelectCommand="SELECT JMTitleID, JMTitle FROM JamatiTitle ORDER BY JMTitle">
  593.    </asp:AccessDataSource>
  594.    <asp:AccessDataSource ID="adsDuplicateAccounts" runat="server" DataFile="~/App_Data/Burial.mdb"
  595. 	  SelectCommand="SELECT Accounts.AccountID, Members.MemberLastName, Members.MemberMiddleName, Members.MemberFirstName, AccountStatus.AccountStatus, Members.MemberPrimary, Jamatkhana.JKName, Accounts.AccountStreetAddress, City.CityName, Province.ProvinceAbbreviation, Accounts.AccountPostalCode, Accounts.AccountPhoneNumber, Members.MemberBirthYear, MemberStatus.MemberStatus, Gender.GenderAbbreviation FROM (((((((Accounts INNER JOIN AccountStatus ON Accounts.AccountStatusID = AccountStatus.AccountStatusID) INNER JOIN Members ON Accounts.AccountID = Members.AccountID) INNER JOIN MemberStatus ON Members.MemberStatusID = MemberStatus.MemberStatusID) INNER JOIN Jamatkhana ON Accounts.AccountJamatkhanaID = Jamatkhana.JKID) INNER JOIN City ON Accounts.AccountCityID = City.CityID) INNER JOIN Province ON Accounts.AccountProvinceID = Province.ProvinceID) INNER JOIN Gender ON Members.MemberGenderID = Gender.GenderID) WHERE (Members.MemberLastName LIKE '%' + @LastName + '%') AND (Members.MemberFirstName LIKE '%' + @FirstName + '%') AND (Accounts.AccountPhoneNumber = @PhoneNumber) AND (Members.MemberBirthYear = @BirthYear) ORDER BY Accounts.AccountID">
  596. 	  <SelectParameters>
  597. 		 <asp:ControlParameter ControlID="txtboxLastName" Name="@LastName" PropertyName="Text" Type="String" />
  598. 		 <asp:ControlParameter ControlID="txtboxFirstName" Name="@FirstName" PropertyName="Text" Type="String" />
  599. 		 <asp:ControlParameter ControlID="txtboxTelephone" Name="@PhoneNumber" PropertyName="Text" Type="String" />
  600. 		 <asp:ControlParameter ControlID="txtboxBirthYear" Name="@BirthYear" PropertyName="Text" Type="String" />
  601. 	  </SelectParameters>
  602.    </asp:AccessDataSource>
  603.  
  604.    </ContentTemplate>
  605.    </asp:UpdatePanel>
  606.  
  607. </asp:Content>
# Change User Description Committed
#2 21431 Necqui Updates 8 years ago
#1 21430 Necqui TKN Initial 8 years ago