/secure/admin/displayEvent.asp

https://github.com/barrynovak5/SWOGC · ASP · 148 lines · 110 code · 33 blank · 5 comment · 1 complexity · ebfb93f5e56a873d8f89053a0adad725 MD5 · raw file

  1. <!--#INCLUDE FILE="adminheader.asp"-->
  2. <!--#include file=adovbs.inc -->
  3. <script src="eventsavevalidators.js" type="text/javascript"></script>
  4. <%
  5. Set objConn = Server.CreateObject("ADODB.Connection")
  6. Set objCmd = Server.CreateObject("ADODB.Command")
  7. Set objRS = Server.CreateObject("ADODB.Recordset")
  8. objConn.Open "FourC"
  9. objRS.CursorType = adOpenForwardOnly
  10. objRS.LockType = adLockOptimistic
  11. Set objCmd.ActiveConnection = objConn
  12. 'If a SQL statement with question marks is specified, then the
  13. 'CommandType is adCmdText. If a query name is specified, then
  14. 'the CommandType is adCmdStoredProc.
  15. objCmd.CommandText = "SELECT * FROM EVENTS INNER JOIN EVENTTYPE ON EVENTS.EventTypeID = EVENTTYPE.EventTypeID WHERE EVENTID = ?"
  16. objCmd.CommandType = adCmdText
  17. 'Create the parameter and populate it.
  18. Set objParam = objCmd.CreateParameter("@EVENTID" , adInteger, adParamInput, 0, 0)
  19. objCmd.Parameters.Append objParam
  20. donationEventId = Request.Form("DonationEventId")
  21. objCmd.Parameters("@EVENTID") = donationEventId
  22. 'Open and display the Recordset.
  23. objRS.Open objCmd
  24. Do While Not objRS.EOF
  25. sendEmailReceiptCheckedTrue = ""
  26. sendEmailReceiptCheckedFalse = ""
  27. if(objRS.Fields("SendEmailReceipt") = "True") then
  28. sendEmailReceiptCheckedTrue = "checked"
  29. else
  30. sendEmailReceiptCheckedFalse = "checked"
  31. end if
  32. %>
  33. <p>Event Type: <%= objRS.Fields("EventTypeDescription")%></p>
  34. <p>Event Id: <%= objRS.Fields("EventID")%></p>
  35. <form method="POST" action="updateevent.asp" onsubmit="return Validator(this)">
  36. Do not include quotes (") in fields. The field will not be saved as quotes are rejected by Authorize.Net
  37. <div>
  38. <input type="hidden" name="EventId" value="<%= objRS.Fields("EVENTID")%>"/>
  39. <label for="EventName">Event Name:</label>
  40. <input type="text" name="EventName" value="<%= objRS.Fields("EventName")%>"/>
  41. </div>
  42. <div>
  43. <label for="EventDescription">Event Description:</label>
  44. <input type="text" name="EventDescription" value="<%= objRS.Fields("EventDescription")%>"/>
  45. </div>
  46. <div>
  47. <label for="ReceiptLink">Receipt Link:</label>
  48. <input type="text" name="ReceiptLink" value="<%= objRS.Fields("ReceiptLink")%>"/>
  49. </div>
  50. <div>
  51. <label for="ReceiptMethod">Receipt Method:</label>
  52. <input type="text" name="ReceiptMethod" value="<%= objRS.Fields("ReceiptMethod")%>"/>
  53. </div>
  54. <div>
  55. <label for="SendEmailReceipt">Send Email Receipt:</label>
  56. <input type="radio" name="SendEmailReceipt" value="True" <%=sendEmailReceiptCheckedTrue%>/>Yes
  57. <input type="radio" name="SendEmailReceipt" value="False" <%=sendEmailReceiptCheckedFalse%>/> No
  58. </div>
  59. <div>
  60. <label for="ReceiptEmailSender">Receipt Email Sender:</label>
  61. <input type="text" name="ReceiptEmailSender" value="<%= objRS.Fields("ReceiptEmailSender")%>"/>
  62. </div>
  63. <div>
  64. <label for="ReceiptEmailFooter">Receipt Email Footer:</label>
  65. <input type="text" name="ReceiptEmailFooter" value="<%= objRS.Fields("ReceiptEmailFooter")%>"/>
  66. </div>
  67. <div>
  68. <label for="PaymentFormHeader">Payment Form Header:</label>
  69. <input type="text" name="PaymentFormHeader" value="<%= objRS.Fields("PaymentFormHeader")%>"/>
  70. </div>
  71. <div>
  72. <label for="PaymentFormFooter">Payment Form Footer:</label>
  73. <input type="text" name="PaymentFormFooter" value="<%= objRS.Fields("PaymentFormFooter")%>"/>
  74. </div>
  75. <div>
  76. <label for="ReceiptFormHeader">Receipt Form Header:</label>
  77. <input type="text" name="ReceiptFormHeader" value="<%= objRS.Fields("ReceiptFormHeader")%>"/>
  78. </div>
  79. <div>
  80. <label for="ReceiptFormFooter">Receipt Form Footer:</label>
  81. <input type="text" name="ReceiptFormFooter" value="<%= objRS.Fields("ReceiptFormFooter")%>"/>
  82. </div>
  83. <div>
  84. <label for="CancelURL">Cancel URL:</label>
  85. <input type="text" name="CancelURL" value="<%= objRS.Fields("CancelURL")%>"/>
  86. </div>
  87. <div>
  88. <label for="ReceiptPageURL">Receipt Page URL:</label>
  89. <input type="text" name="ReceiptPageURL" value="<%= objRS.Fields("ReceiptPageURL")%>"/>
  90. </div>
  91. <div>
  92. <label for="ReceiptPageTitle">Receipt Page Title:</label>
  93. <input type="text" name="ReceiptPageTitle" value="<%= objRS.Fields("ReceiptPageTitle")%>"/>
  94. </div>
  95. <div>
  96. <label for="EventConfirmation">Event Confirmation:</label>
  97. <input type="text" name="EventConfirmation" value="<%= objRS.Fields("EventConfirmation")%>"/>
  98. </div>
  99. <div>
  100. <label for="EventEmailConfirmation">Event Email Confirmation:</label>
  101. <input type="text" name="EventEmailConfirmation" value="<%= objRS.Fields("EventEmailConfirmation")%>"/>
  102. </div>
  103. <input type="submit" value="Save"/>
  104. <div>
  105. </div>
  106. </form>
  107. <%
  108. objRS.MoveNext
  109. Loop
  110. objRS.Close
  111. objConn.Close
  112. Set objRS = Nothing
  113. Set objCmd = Nothing
  114. Set objConn = Nothing
  115. %>