API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 1st, 2014
190
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 22.14 KB | None | 0 0
raw download clone embed print report
  1. <%@ Control Language="VB" AutoEventWireup="false" CodeFile="LingInfoUserControl.ascx.vb" Inherits="controls_LingInfoUserControl" %>
  2. <style type="text/css">
  3. .form-horizontal .control-label {
  4. width: 180px;
  5. }
  6. .form-horizontal .controls{
  7. margin-left: 200px;
  8. }
  9. </style>
  10. <!-- Purpose: Adding additional fields
  11. Author: Stacy Bridges
  12. Date: October 3, 2014
  13. Detailed Description: Had to do a complete rewrite to make sense of original code
  14. History: Unknown -->
  15. <asp:FormView ID="dv_lingInfo" runat="server" DataSourceID="sql_pinfo" AutoGenerateRows="false" GridLines="None">
  16. <ItemTemplate>
  17. <div class="form-horizontal">
  18. <table>
  19. <div class="row">
  20. <tr>
  21. <td>
  22. <div class="span6">
  23. <div class="control-group">
  24. <div class="control-label">
  25. Office Symbol
  26. </div>
  27. <div class="controls">
  28. <%#Eval("office_symbol")%>
  29. </div>
  30. </div>
  31. </div>
  32. </td>
  33. <td>
  34. <div class="span3">
  35. <div class="control-group">
  36. <div class="control-label">
  37. Language Position
  38. </div>
  39. <div class="controls">
  40. <asp:CheckBox ID="chkBx_lrdp" runat="server" Checked='<%#Eval("LRDP")%>' Enabled="false" />
  41. </div>
  42. </div>
  43. </div>
  44. </td>
  45. </tr>
  46. <tr>
  47. <td>
  48. <div class="span6">
  49. <div class="control-group">
  50. <div class="control-label">
  51. DLAB
  52. </div>
  53. <div class="controls">
  54. <%#Eval("dlab")%>
  55. </div>
  56. </div>
  57. </div>
  58. </td>
  59. <td>
  60. <div class="span3">
  61. <div class="control-group">
  62. <div class="control-label">
  63. Chandelier
  64. </div>
  65. <div class="controls">
  66. <asp:CheckBox ID="chkBx_chandelier" runat="server" Checked='<%#Eval("chandelier")%>' Enabled="false" />
  67. </div>
  68. </div>
  69. </div>
  70. </td>
  71. </tr>
  72. <tr>
  73. <td>
  74. <div class="span6">
  75. <div class="control-group">
  76. <div class="control-label">
  77. MCCEP
  78. </div>
  79. <div class="controls">
  80. <%#Eval("MCCEP")%>
  81. </div>
  82. </div>
  83. </div>
  84. </td>
  85. <td>
  86. <div class="span3">
  87. <div class="control-group">
  88. <div class="control-label">
  89. Deployed
  90. </div>
  91. <div class="controls">
  92. <asp:CheckBox ID="chkBx_dep" runat="server" Checked='<%#Eval("pinfo_deployed")%>' Enabled="false" />
  93. </div>
  94. </div>
  95. </div>
  96. </td>
  97. </tr>
  98. <tr>
  99. <td>
  100. <div class="span6">
  101. <div class="control-group">
  102. <div class="control-label">
  103. SID
  104. </div>
  105. <div class="controls">
  106. <%#Eval("sid")%>
  107. </div>
  108. </div>
  109. </div>
  110. </td>
  111. <td>
  112. <div class="span3">
  113. <div class="control-group">
  114. <div class="control-label">
  115. ECampus Logon ID
  116. </div>
  117. <div class="controls">
  118. <%#Eval("ecampus")%>
  119. </div>
  120. </div>
  121. </div>
  122. </td>
  123. </tr>
  124. <tr>
  125. <td>
  126. <div class="span3">
  127. <div class="control-group">
  128. <div class="control-label">
  129. MISC
  130. </div>
  131. <div class="controls">
  132. <%#Eval("misc")%>
  133. </div>
  134. </div>
  135. </div>
  136. </td>
  137. </tr>
  138. <tr>
  139. <td>
  140. <div class="span6">
  141. <div class="control-group">
  142. <div class="control-label">
  143. NIPR Email
  144. </div>
  145. <div class="controls">
  146. <%#Eval("email")%>
  147. </div>
  148. </div>
  149. </div>
  150. </td>
  151. <td>
  152. <div class="span3">
  153. <div class="control-group">
  154. <div class="control-label">
  155. Phone
  156. </div>
  157. <div class="controls">
  158. <%#Eval("phone")%>
  159. </div>
  160. </div>
  161. </div>
  162. </td>
  163. </tr>
  164. <tr>
  165. <td>
  166. <div class="span6">
  167. <div class="control-group">
  168. <div class="control-label">
  169. SIPR Email
  170. </div>
  171. <div class="controls">
  172. <%#Eval("sipremail")%>
  173. </div>
  174. </div>
  175. </div>
  176. </td>
  177. <td>
  178. <div class="span3">
  179. <div class="control-group">
  180. <div class="control-label">
  181. MISC
  182. </div>
  183. <div class="controls">
  184. <%#Eval("misc")%>
  185. </div>
  186. </div>
  187. </div>
  188. </td>
  189. </tr>
  190. <tr>
  191. <td>
  192. <div class="span6">
  193. <div class="control-group">
  194. <div class="control-label">
  195. JWICS Email
  196. </div>
  197. <div class="controls">
  198. <%#Eval("jwicsemail")%>
  199. </div>
  200. </div>
  201. </div>
  202. </td>
  203. <td>
  204. <div class="span3">
  205. <div class="controls">
  206. <asp:LinkButton ID="lb_edit" CommandName="Edit" runat="server" CssClass="btn btn-primary" Text="Edit"></asp:LinkButton>
  207. </div>
  208. </div>
  209. </td>
  210. </tr>
  211. <tr>
  212. <td>
  213. <div class="span6">
  214. <div class="control=group">
  215. <div class="control-label">
  216. Portal User
  217. </div>
  218. <div class="controls">
  219. <%#Eval("portal_user")%>
  220. </div>
  221. </div>
  222. </div>
  223. </td>
  224. </tr>
  225. </div>
  226. </table>
  227. </div>
  228. </ItemTemplate>
  229. <EditItemTemplate>
  230. <div class="form-horizontal">
  231. <table>
  232. <div class="row">
  233. <tr>
  234. <td>
  235. <div class="span6">
  236. <div class="control-group">
  237. <div class="control-label">
  238. Office Symbol
  239. </div>
  240. <div class="controls">
  241. <asp:TextBox ID="txtBx_offSym" runat="server" Text='<%# Bind("office_symbol")%>'></asp:TextBox>
  242. </div>
  243. </div>
  244. </div>
  245. </td>
  246. <td>
  247. <div class="span3">
  248. <div class="control-group">
  249. <div class="control-label">
  250. Language Position
  251. </div>
  252. <div class="controls">
  253. <asp:CheckBox ID="chkBx_Lrdp" runat="server" Checked='<%# Bind("LRDP")%>' />
  254. </div>
  255. </div>
  256. </div>
  257. </td>
  258. </tr>
  259. <tr>
  260. <td>
  261. <div class="span6">
  262. <div class="control-group">
  263. <div class="control-label">
  264. DLAB
  265. </div>
  266. <div class="controls">
  267. <asp:TextBox ID="txtBX_dlab" runat="server" Text='<%# Bind("dlab")%>'></asp:TextBox>
  268. </div>
  269. </div>
  270. </div>
  271. </td>
  272. <td>
  273. <div class="span3">
  274. <div class="control-group">
  275. <div class="control-label">
  276. Chandelier
  277. </div>
  278. <div class="controls">
  279. <asp:CheckBox ID="chkBx_chand" runat="server" Checked='<%# Bind("chandelier")%>' />
  280. </div>
  281. </div>
  282. </div>
  283. </td>
  284. </tr>
  285. <tr>
  286. <td>
  287. <div class="span6">
  288. <div class="control-group">
  289. <div class="control-label">
  290. MCCEP
  291. </div>
  292. <div class="controls">
  293. <asp:DropDownList ID="ddl_mccep" runat="server" DataSourceID="sql_mccep" SelectedValue='<%# Bind("MCCEP")%>' DataTextField="mccepVal" DataValueField="mccepVal">
  294. </asp:DropDownList>
  295. </div>
  296. </div>
  297. </div>
  298. </td>
  299. <td>
  300. <div class="span3">
  301. <div class="control-group">
  302. <div class="control-label">
  303. Deployed
  304. </div>
  305. <div class="controls">
  306. <asp:CheckBox ID="chkBx_deployed" runat="server" Checked='<%# Bind("pinfo_deployed")%>' />
  307. </div>
  308. </div>
  309. </div>
  310. </td>
  311. </tr>
  312. <tr>
  313. <td>
  314. <div class="span6">
  315. <div class="control-group">
  316. <div class="control-label">
  317. SID
  318. </div>
  319. <div class="controls">
  320. <asp:TextBox ID="txtBx_SID" runat="server" Text='<%# Bind("sid")%>' MaxLength ="10"></asp:TextBox>
  321. </div>
  322. </div>
  323. </div>
  324. </td>
  325. <td>
  326. <div class="span3">
  327. <div class="control-group">
  328. <div class="control-label">
  329. ECampus Logon ID
  330. </div>
  331. <div class="controls">
  332. <asp:TextBox ID="txtBx_ecampus" runat="server" Text='<%# Bind("ecampus")%>'></asp:TextBox>
  333. </div>
  334. </div>
  335. </div>
  336. </td>
  337. </tr>
  338. <tr>
  339. <td>
  340. <div class="span6">
  341. <div class="control-group">
  342. <div class="control-label">
  343. NIPR Email
  344. </div>
  345. <div class="controls">
  346. <asp:TextBox ID="txtBx_email" runat="server" Text='<%# Bind("email")%>'></asp:TextBox>
  347. </div>
  348. </div>
  349. </div>
  350. </td>
  351. <td>
  352. <div class="span3">
  353. <div class="control-group">
  354. <div class="control-label">
  355. Phone
  356. </div>
  357. <div class="controls">
  358. <asp:TextBox ID="txtBx_phone" runat="server" Text='<%# Bind("phone")%>'></asp:TextBox>
  359. </div>
  360. </div>
  361. </div>
  362. </td>
  363. </tr>
  364. <tr>
  365. <td>
  366. <div class="span6">
  367. <div class="control-group">
  368. <div class="control-label">
  369. SIPR Email
  370. </div>
  371. <div class="controls">
  372. <asp:TextBox ID="txtBx_sipremail" runat="server" Text='<%# Bind("sipremail")%>'></asp:TextBox>
  373. </div>
  374. </div>
  375. </div>
  376. </td>
  377. <td>
  378. <div class="span3">
  379. <div class="control-group">
  380. <div class="control-label">
  381. MISC
  382. </div>
  383. <div class="controls">
  384. <asp:TextBox ID="txtBx_misc" runat="server" Text='<%# Bind("Misc")%>' TextMode="MultiLine" Rows="4"></asp:TextBox>
  385. </div>
  386. </div>
  387. </div>
  388. </td>
  389. </tr>
  390. <tr>
  391. <td>
  392. <div class="span6">
  393. <div class="control-group">
  394. <div class="control-label">
  395. JWICS Email
  396. </div>
  397. <div class="controls">
  398. <asp:TextBox ID="txtBx_jwicsemail" runat="server" Text='<%# Bind("jwicsemail")%>'></asp:TextBox>
  399. </div>
  400. </div>
  401. </div>
  402. </td>
  403. </tr>
  404. <tr>
  405. <td>
  406. <div class="span6">
  407. <div class="control-group">
  408. <div class="control-label">
  409. Portal User
  410. </div>
  411. <div class="controls">
  412. <asp:DropDownList ID="ddl_users" runat="server" DataSourceID="sql_userName" SelectedValue='<%# Bind("portal_user")%>' DataTextField="userName" DataValueField="userName" AppendDataBoundItems="true">
  413. <asp:ListItem Text="Select" Value="" />
  414. </asp:DropDownList>
  415. </div>
  416. </div>
  417. </div>
  418. </td>
  419. </tr>
  420. <tr>
  421. <td>
  422. <div class="span3">
  423. <div class="control-group">
  424. <div class="control-label"></div>
  425. <div class="controls">
  426. <asp:LinkButton ID="lb_update" CommandName="Update" runat="server" CssClass="btn btn-primary" Text="Update"></asp:LinkButton>
  427. </div>
  428. </div>
  429. </div>
  430. </td>
  431. <td>
  432. <div class="span3">
  433. <div class="control-group">
  434. <div class="control-label"></div>
  435. <div class="controls">
  436. <asp:LinkButton ID="lb_cancel" CommandName="Cancel" runat="server" CssClass="btn" Text="Cancel"></asp:LinkButton>
  437. </div>
  438. </div>
  439. </div>
  440. </td>
  441. </tr>
  442. </div>
  443. </table>
  444. </div>
  445. </EditItemTemplate>
  446. </asp:FormView>
  447.  
  448.  
  449. <asp:SqlDataSource ID="sql_pinfo" runat="server" ConnectionString="<%$ ConnectionStrings:InstantASP_ConnectionString %>"
  450. SelectCommand="Select office_symbol, LRDP, email, sipremail, jwicsemail, mccep, chandelier, dlab, misc, phone, sid, portal_user, ecampus, pinfo_deployed, pinfo_cmd_id
  451. FROM CLPM_Pinfo WHERE Pinfo_IDNumber = @id"
  452. UpdateCommand="UPDATE CLPM_PINFO
  453. SET Office_Symbol = @Office_Symbol,
  454. pinfo_deployed = @pinfo_deployed,
  455. EMAIL = @email,
  456. sipremail = @sipremail
  457. jwicsemail = @jwisemail
  458. misc = @misc,
  459. phone = @phone,
  460. sid = @sid,
  461. portal_user = @portal_user,
  462. UpdateDate = @UpdateDate,
  463. MCCEP = @MCCEP,
  464. Chandelier = @Chandelier,
  465. DLAB = @DLAB,
  466. LRDP = @LRDP,
  467. ecampus = @ecampus
  468. WHERE (Pinfo_IDNumber = @id)">
  469. <SelectParameters>
  470. <asp:QueryStringParameter QueryStringField="linguist_id" Name="id" />
  471. </SelectParameters>
  472. <UpdateParameters>
  473. <asp:Parameter Name="Office_Symbol" />
  474. <asp:Parameter Name="pinfo_deployed" />
  475. <asp:Parameter Name="email" />
  476. <asp:Parameter Name="sipremail" />
  477. <asp:Parameter Name="jwicsemail" />
  478. <asp:Parameter Name="misc" />
  479. <asp:Parameter Name="phone" />
  480. <asp:Parameter Name="sid" />
  481. <asp:Parameter Name="portal_user" />
  482. <asp:Parameter Name="UpdateDate" />
  483. <asp:Parameter Name="MCCEP" />
  484. <asp:Parameter Name="Chandelier" />
  485. <asp:Parameter Name="DLAB" />
  486. <asp:Parameter Name="LRDP" />
  487. <asp:Parameter Name="Ecampus" />
  488. <%-- <asp:Parameter Name="pinfo_cmd_id" />--%>
  489. <asp:QueryStringParameter QueryStringField="linguist_id" Name="id" />
  490. </UpdateParameters>
  491. </asp:SqlDataSource>
  492. <asp:SqlDataSource ID="sql_mccep" runat="server" ConnectionString="<%$ ConnectionStrings:InstantASP_ConnectionString %>"
  493. SelectCommand="SELECT [mccep] As mccepVal FROM [DDL_mccep]"></asp:SqlDataSource>
  494. <asp:SqlDataSource ID="sql_userName" runat="server" ConnectionString="<%$ ConnectionStrings:InstantASP_ConnectionString %>"
  495. SelectCommand="SELECT userName FROM [dbo].[aspnet_Users] ORDER BY userName"></asp:SqlDataSource>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!