ASP.NET Page /Admin/QuestionsAnswers.aspx (C#)
Uses Code Behind Page Page /Admin/QuestionsAnswers.aspx.cs (C#)
1: <%@ Page Language="C#" AutoEventWireup="True" Inherits="QuiznetOnline.Web.UI.Admin.AdminQuestionsAnswers" validateRequest="false" Codebehind="QuestionsAnswers.aspx.cs" %>  
2:   
3:   
4:   
5: <html xmlns="http://www.w3.org/1999/xhtml" >  
6: <head runat="server">  
7:     <title>Admin - Questions and answers maintenance</title>  
8: </head>  
9: <body>  
10:     <form id="form1" runat="server">  
11:     <asp:HyperLink ID="lblHome" runat="server" NavigateUrl="~/Admin/Default.aspx">Home</asp:HyperLink>   
12:         <table>  
13:         <tr>  
14:             <td><asp:TextBox ID="txtFind" runat="server"></asp:TextBox></td>  
15:             <td><asp:Button ID="cmdGetID" runat="server" Text="Get ID" OnClick="cmdGetID_Click" /></td>  
16:             <td><asp:Button ID="cmdGetQuestion" runat="server" Text="Get Question" OnClick="cmdGetQuestion_Click" /></td>  
17:             <td><asp:Button ID="cmdGetAnswer" runat="server" Text="Get Answer" OnClick="cmdGetAnswer_Click" /></td>  
18:             <td><table border="1">  
19:                     <tr>  
20:                         <td><asp:Button ID="cmdGetAll" runat="server" Text="Get All" OnClick="cmdGetAll_Click" /></td>  
21:                         <td><asp:Button ID="cmdAuthorRating" runat="server" Text="Get Author ranked" OnClick="cmdAuthorRating_Click" /></td>  
22:                     </tr>  
23:                     <tr>  
24:                         <td><asp:Button ID="cmdGetEasy" runat="server" Text="Get Easy" OnClick="cmdGetEasy_Click" /></td>  
25:                         <td><asp:Button ID="cmdGetHard" runat="server" Text="Get Hard" OnClick="cmdGetHard_Click" /></td>  
26:                     </tr>  
27:                 </table></td>  
28:             <td><asp:Button ID="cmdFree" runat="server" Text="Free Questions" OnClick="cmdFree_Click" />  
29:             <td><asp:Button ID="cmdClear" runat="server" Text="Clear" OnClick="cmdClear_Click" />  
30:             <asp:Button runat="server" ID="cmdAddImage" Text="Assign Image to Question" OnClick="cmdAddImage_Click"/></td>  
31:         </tr>  
32:         <tr>  
33:             <td></td>  
34:             <td></td>  
35:             <td></td>  
36:             <td></td>  
37:             <td><asp:ListBox runat="server" ID="cmbTopics"/></td>  
38:         </tr>  
39:         </table>  
40:            
41: <%--        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"  
42:             DeleteCommand="DELETE FROM [Answers] WHERE [QuestionID] = @original_QuestionID;  
43:                 DELETE FROM [Questions] WHERE [QuestionID] = @original_QuestionID;  
44:                 DELETE FROM QuestionRating WHERE [QuestionID] = @original_QuestionID;  
45:                 DELETE FROM QuestionLog WHERE [QuestionID] = @original_QuestionID;  
46:                 DELETE FROM UserFavourites WHERE [QuestionID] = @original_QuestionID;  
47:                 DELETE FROM UserQuestionRating WHERE [QuestionID] = @original_QuestionID;  
48:                 DELETE FROM UserQuestionSaveResult WHERE [QuestionID] = @original_QuestionID;  
49:                 DELETE FROM UserQuestionSave WHERE [QuestionID] = @original_QuestionID;  
50:                 DELETE FROM Images WHERE [QuestionID] = @original_QuestionID;  
51:                 DELETE FROM TagQuestion WHERE [QuestionID] = @original_QuestionID;  
52:                 DELETE FROM UserTestQuestion WHERE [QuestionID] = @original_QuestionID;"  
53:             OldValuesParameterFormatString="original_{0}" SelectCommand="exec GetQuestion null,null,null"  
54:             UpdateCommand="UPDATE [Questions] SET [TopicCode] = @TopicCode, [Question] = @Question, [Answer] = @Answer, [Explaination] = @Explaination, [Approved] = @Approved, [CreationDate] = @CreationDate,[Link] = @Link ,[Correct] = @Correct ,[Incorrect] = @Incorrect,[IsFree] = @IsFree,[Position] = @Position WHERE [QuestionID] = @original_QuestionID">  
55:             <DeleteParameters>  
56:                 <asp:Parameter Name="original_QuestionID" Type="Int32" />  
57:             </DeleteParameters>  
58:             <UpdateParameters>  
59:                 <asp:Parameter Name="original_QuestionID" Type="Int32" />  
60:                 <asp:Parameter Name="TopicCode" Type="String" />  
61:                 <asp:Parameter Name="Question" Type="String" />  
62:                 <asp:Parameter Name="Answer" Type="String" />  
63:                 <asp:Parameter Name="Explaination" Type="String" />  
64:                 <asp:Parameter Name="Approved" Type="Boolean" />  
65:                 <asp:Parameter Name="CreationDate" Type="DateTime" />  
66:                 <asp:Parameter Name="Link" Type="String" />                  
67:                 <asp:Parameter Name="Correct" Type="Int32" />  
68:                 <asp:Parameter Name="Incorrect" Type="Int32" />  
69:                 <asp:Parameter Name="QuestionCreatedBy" Type="String" />  
70:                 <asp:Parameter Name="IsFree" Type="Boolean" />  
71:                 <asp:Parameter Name="Position" Type="Int32" />  
72:             </UpdateParameters>  
73:         </asp:SqlDataSource>--%>  
74:           
75:             
76:           
77:         <asp:FormView ID="FormView1" Width="100%" runat="server" DataKeyNames="QuestionID" AllowPaging="True" OnPageIndexChanging="FormView1_PageIndexChanging" OnDataBound="FormView1_OnDataBound">  
78:             <ItemTemplate>  
79:             <table border="1" width="100%" style="background-color:LightBlue">  
80:             <tr>  
81:                 <td align="center">  
82:                     <i>You are viewing page  
83:                         <%=FormView1.PageIndex + 1%>  
84:                         of  
85:                         <%=FormView1.PageCount%>  
86:                     </i>  
87:                 </td>  
88:             </tr>  
89:             </table>  
90:             <table border="1" width="100%">  
91:             <tr>  
92:                     <td>QuestionID:</td>  
93:                     <td><asp:Label ID="QuestionIDLabel" runat="server" Text='<%# Eval("QuestionID") %>'></asp:Label></td>  
94:             </tr>  
95:             <tr>  
96:                     <td>TopicCode:</td>  
97:                     <td><asp:TextBox ID="TopicCodeLabel" runat="server" Text='<%# Bind("Topic.TopicCode") %>'></asp:TextBox></td>  
98:             </tr>  
99:             <tr>  
100:                     <td>Question:</td>  
101:                     <td><asp:TextBox TextMode="MultiLine" Rows="4" Width="100%" ID="QuestionLabel" runat="server" Text='<%# Bind("QuestionDesc") %>'></asp:TextBox></td>  
102:             </tr>  
103:             <tr>  
104:                     <td>Answer:</td>  
105:                     <td><asp:TextBox ID="AnswerLabel" runat="server" Text='<%# Bind("Answer") %>'/></td>  
106:             </tr>  
107:             <tr>  
108:                     <td>Explaination:</td>  
109:                     <td><asp:TextBox TextMode="MultiLine" Rows="4" Width="100%" ID="ExplainationLabel" runat="server" Text='<%# Bind("Explaination") %>'></asp:TextBox></td>  
110:             </tr>  
111:             <tr>  
112:                     <td>Approved:</td>  
113:                     <td><asp:CheckBox ID="ApprovedCheckBox" runat="server" Checked='<%# Bind("Approved") %>' /></td>  
114:             </tr>  
115:             <tr>  
116:                     <td>CreationDate:</td>  
117:                     <td><asp:Label ID="CreationDateLabel" runat="server" Text='<%# Bind("CreationDate") %>'></asp:Label></td>  
118:             </tr>  
119:             <tr>  
120:                     <td>Link:</td>  
121:                     <td><asp:TextBox ID="LinkLabel" runat="server" Text='<%# Bind("Link") %>'/></td>  
122:             </tr>  
123:             <tr>  
124:                     <td>Correct:</td>  
125:                     <td><asp:Label ID="LinkCorrect" runat="server" Text='<%# Bind("Correct") %>'></asp:Label></td>  
126:             </tr>  
127:             <tr>  
128:                     <td>Incorrect:</td>  
129:                     <td><asp:Label ID="LinkIncorrect" runat="server" Text='<%# Bind("Incorrect") %>'></asp:Label></td>  
130:             </tr>  
131:             <tr>  
132:                     <td>QuestionCreatedBy:</td>  
133:                     <td><asp:Label ID="Label2" runat="server" Text='<%# Bind("QuestionCreatedBy") %>'></asp:Label></td>  
134:             </tr>                                                  
135:             <tr>  
136:                 <td  colspan="2">  
137:                     <table>  
138:                     <tr>  
139:                         <td>IsFree:</td>  
140:                         <td><asp:CheckBox ID="chkIsFree" runat="server" Checked='<%# Bind("IsFree") %>'></asp:CheckBox></td>  
141:                         <td>Position:</td>  
142:                         <td><asp:TextBox ID="txtPosition" runat="server" Text='<%# Bind("Position") %>' /></td>  
143:                         <td>Author Rating:</td>  
144:                         <td><asp:TextBox ID="txtAuthorRating" runat="server" Text='' /></td>  
145:                     </tr>  
146:                     </table>  
147:                 </td>  
148:             </tr>                                      
149:             <tr>                      
150:                 <td><asp:LinkButton ID="SaveButton" OnClick="SaveButton_Click" runat="server" CausesValidation="False" CommandName="Save" Text="Save"></asp:LinkButton>  
151: There is a limit of 150 source code lines in the evaluation version
152: There is a limit of 150 source code lines in the evaluation version
153: There is a limit of 150 source code lines in the evaluation version
154: There is a limit of 150 source code lines in the evaluation version
155: There is a limit of 150 source code lines in the evaluation version
156: There is a limit of 150 source code lines in the evaluation version
157: There is a limit of 150 source code lines in the evaluation version
158: There is a limit of 150 source code lines in the evaluation version
159: There is a limit of 150 source code lines in the evaluation version
160: There is a limit of 150 source code lines in the evaluation version
161: There is a limit of 150 source code lines in the evaluation version
162: There is a limit of 150 source code lines in the evaluation version
163: There is a limit of 150 source code lines in the evaluation version
164: There is a limit of 150 source code lines in the evaluation version
165: There is a limit of 150 source code lines in the evaluation version
166: There is a limit of 150 source code lines in the evaluation version
167: There is a limit of 150 source code lines in the evaluation version
168: There is a limit of 150 source code lines in the evaluation version
169: There is a limit of 150 source code lines in the evaluation version
170: There is a limit of 150 source code lines in the evaluation version
171: There is a limit of 150 source code lines in the evaluation version
172: There is a limit of 150 source code lines in the evaluation version
173: There is a limit of 150 source code lines in the evaluation version
174: There is a limit of 150 source code lines in the evaluation version
175: There is a limit of 150 source code lines in the evaluation version
176: There is a limit of 150 source code lines in the evaluation version
177: There is a limit of 150 source code lines in the evaluation version
178: There is a limit of 150 source code lines in the evaluation version
179: There is a limit of 150 source code lines in the evaluation version
180: There is a limit of 150 source code lines in the evaluation version
181: There is a limit of 150 source code lines in the evaluation version
182: There is a limit of 150 source code lines in the evaluation version
183: There is a limit of 150 source code lines in the evaluation version
184: There is a limit of 150 source code lines in the evaluation version
185: There is a limit of 150 source code lines in the evaluation version
186: There is a limit of 150 source code lines in the evaluation version
187: There is a limit of 150 source code lines in the evaluation version
188: There is a limit of 150 source code lines in the evaluation version
189: There is a limit of 150 source code lines in the evaluation version
190: There is a limit of 150 source code lines in the evaluation version
191: There is a limit of 150 source code lines in the evaluation version
192: There is a limit of 150 source code lines in the evaluation version
193: There is a limit of 150 source code lines in the evaluation version
194: There is a limit of 150 source code lines in the evaluation version
195: There is a limit of 150 source code lines in the evaluation version
196: There is a limit of 150 source code lines in the evaluation version
197: There is a limit of 150 source code lines in the evaluation version
198: There is a limit of 150 source code lines in the evaluation version
199: There is a limit of 150 source code lines in the evaluation version
200: There is a limit of 150 source code lines in the evaluation version
201: There is a limit of 150 source code lines in the evaluation version
202: There is a limit of 150 source code lines in the evaluation version
203: There is a limit of 150 source code lines in the evaluation version
204: There is a limit of 150 source code lines in the evaluation version
205: There is a limit of 150 source code lines in the evaluation version
206: There is a limit of 150 source code lines in the evaluation version
207: There is a limit of 150 source code lines in the evaluation version
208: There is a limit of 150 source code lines in the evaluation version
209: There is a limit of 150 source code lines in the evaluation version
210: There is a limit of 150 source code lines in the evaluation version
211: There is a limit of 150 source code lines in the evaluation version
212: There is a limit of 150 source code lines in the evaluation version
213: There is a limit of 150 source code lines in the evaluation version
214: There is a limit of 150 source code lines in the evaluation version
215: There is a limit of 150 source code lines in the evaluation version
216: There is a limit of 150 source code lines in the evaluation version
217: There is a limit of 150 source code lines in the evaluation version
218: There is a limit of 150 source code lines in the evaluation version
219: There is a limit of 150 source code lines in the evaluation version
220: There is a limit of 150 source code lines in the evaluation version
221: There is a limit of 150 source code lines in the evaluation version
222: There is a limit of 150 source code lines in the evaluation version
223: There is a limit of 150 source code lines in the evaluation version
224: There is a limit of 150 source code lines in the evaluation version
225: There is a limit of 150 source code lines in the evaluation version
226: There is a limit of 150 source code lines in the evaluation version
227: There is a limit of 150 source code lines in the evaluation version
228: There is a limit of 150 source code lines in the evaluation version
229: There is a limit of 150 source code lines in the evaluation version
230: There is a limit of 150 source code lines in the evaluation version
231: There is a limit of 150 source code lines in the evaluation version
232: There is a limit of 150 source code lines in the evaluation version
233: There is a limit of 150 source code lines in the evaluation version
234: There is a limit of 150 source code lines in the evaluation version
235: There is a limit of 150 source code lines in the evaluation version
236: There is a limit of 150 source code lines in the evaluation version
237: There is a limit of 150 source code lines in the evaluation version
238: There is a limit of 150 source code lines in the evaluation version
239: There is a limit of 150 source code lines in the evaluation version
240: There is a limit of 150 source code lines in the evaluation version
241: There is a limit of 150 source code lines in the evaluation version
242: There is a limit of 150 source code lines in the evaluation version
243: There is a limit of 150 source code lines in the evaluation version
244: There is a limit of 150 source code lines in the evaluation version
245: There is a limit of 150 source code lines in the evaluation version
246: There is a limit of 150 source code lines in the evaluation version
247: There is a limit of 150 source code lines in the evaluation version
248: There is a limit of 150 source code lines in the evaluation version
249: There is a limit of 150 source code lines in the evaluation version
250: There is a limit of 150 source code lines in the evaluation version
251: There is a limit of 150 source code lines in the evaluation version
252: There is a limit of 150 source code lines in the evaluation version
253: There is a limit of 150 source code lines in the evaluation version
254: There is a limit of 150 source code lines in the evaluation version
255: There is a limit of 150 source code lines in the evaluation version
256: There is a limit of 150 source code lines in the evaluation version
257: There is a limit of 150 source code lines in the evaluation version
258: There is a limit of 150 source code lines in the evaluation version
259: There is a limit of 150 source code lines in the evaluation version
260: There is a limit of 150 source code lines in the evaluation version

.NET Documentation Tool is © 2002 - 2009 Winnersh Triangle Web Solutions Limited.