226 lines
18 KiB
Text
226 lines
18 KiB
Text
<%@ Page Title="" Language="C#" MasterPageFile="~/Site2n.master" AutoEventWireup="true" CodeBehind="QuizAnswers.aspx.cs" Inherits="safety.Quiz.QuizAnswers" %>
|
|
|
|
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
|
|
<telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="sqldsmodules" AutoGenerateColumns="False" OnItemDataBound="RadGrid1_ItemDataBound">
|
|
<GroupingSettings CaseSensitive="false" CollapseAllTooltip="Collapse all groups"></GroupingSettings>
|
|
<ExportSettings FileName="QuizExport" OpenInNewWindow="True" IgnorePaging="True">
|
|
<Pdf PageWidth="" PaperSize="A4">
|
|
</Pdf>
|
|
<Excel Format="Xlsx" FileExtension="xlsx" />
|
|
</ExportSettings>
|
|
<MasterTableView DataKeyNames="moduleId" DataSourceID="sqldsmodules" CommandItemDisplay="Top">
|
|
<DetailTables>
|
|
<telerik:GridTableView runat="server" DataKeyNames="vraagId" DataSourceID="SqlDataSource1" AutoGenerateColumns="False" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" CommandItemDisplay="Top" Name="vragen" AllowAutomaticDeletes="True">
|
|
<DetailTables>
|
|
<telerik:GridTableView runat="server" DataKeyNames="vraagId,antwId" DataSourceID="SqlDataSource2" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" CommandItemDisplay="Top" Name="answers">
|
|
<ParentTableRelation>
|
|
<telerik:GridRelationFields DetailKeyField="vraagId" MasterKeyField="vraagId" />
|
|
</ParentTableRelation>
|
|
<CommandItemSettings ShowExportToExcelButton="True" AddNewRecordText="Nieuw antwoord" />
|
|
<Columns>
|
|
<telerik:GridBoundColumn DataField="vraagId" FilterControlAltText="Filter vraagId column" HeaderText="vraagId" UniqueName="vraagId" Visible="false" />
|
|
<telerik:GridBoundColumn DataField="antwId" FilterControlAltText="Filter antwId column" HeaderText="antwId" UniqueName="antwId" InsertVisiblityMode="AlwaysHidden" ReadOnly="true" />
|
|
<telerik:GridTemplateColumn DataField="NL" FilterControlAltText="Filter column column" HeaderText="NL" UniqueName="NL">
|
|
<EditItemTemplate>
|
|
<asp:TextBox ID="NLTextBox" runat="server" Text='<%# Bind("NL") %>' Width="600px"></asp:TextBox>
|
|
</EditItemTemplate>
|
|
<ItemTemplate>
|
|
<asp:Label ID="NLLabel" runat="server" Text='<%# Eval("NL") %>'></asp:Label>
|
|
</ItemTemplate>
|
|
</telerik:GridTemplateColumn>
|
|
<telerik:GridTemplateColumn DataField="FR" FilterControlAltText="Filter column column" HeaderText="FR" UniqueName="FR">
|
|
<EditItemTemplate>
|
|
<asp:TextBox ID="FRTextBox" runat="server" Text='<%# Bind("FR") %>' Width="600px"></asp:TextBox>
|
|
</EditItemTemplate>
|
|
<ItemTemplate>
|
|
<asp:Label ID="FRLabel" runat="server" Text='<%# Eval("FR") %>'></asp:Label>
|
|
</ItemTemplate>
|
|
</telerik:GridTemplateColumn>
|
|
<telerik:GridTemplateColumn DataField="EN" FilterControlAltText="Filter column column" HeaderText="EN" UniqueName="EN">
|
|
<EditItemTemplate>
|
|
<asp:TextBox ID="ENTextBox" runat="server" Text='<%# Bind("EN") %>' Width="600px"></asp:TextBox>
|
|
</EditItemTemplate>
|
|
<ItemTemplate>
|
|
<asp:Label ID="ENLabel" runat="server" Text='<%# Eval("EN") %>'></asp:Label>
|
|
</ItemTemplate>
|
|
</telerik:GridTemplateColumn>
|
|
<telerik:GridCheckBoxColumn DataField="correct" DataType="System.Boolean" FilterControlAltText="Filter correct column" HeaderText="correct" SortExpression="correct" UniqueName="correct" />
|
|
<telerik:GridBoundColumn DataField="fig" FilterControlAltText="Filter fig column" HeaderText="fig" UniqueName="fig" />
|
|
<telerik:GridTemplateColumn DataField="QuizImageId" FilterControlAltText="Filter QuizImageId column" HeaderText="Image Id" UniqueName="QuizImageId">
|
|
<EditItemTemplate>
|
|
<asp:TextBox ID="QuizImageIdTextBox" runat="server" Text='<%# Bind("QuizImageId") %>'></asp:TextBox>
|
|
</EditItemTemplate>
|
|
<ItemTemplate>
|
|
<telerik:RadBinaryImage runat="server" DataValue='<%# Eval("Image") == DBNull.Value ? new System.Byte[0] : Eval("Image") %>' Visible='<%# Eval("Image") == DBNull.Value ? false : true %>' />
|
|
</ItemTemplate>
|
|
</telerik:GridTemplateColumn>
|
|
<telerik:GridButtonColumn CommandName="Delete" Text="Edit" ButtonCssClass="rgDel" UniqueName="DeleteColumn" HeaderStyle-Width="30px" ConfirmText="Wil je dit antwoord verwijderen ? ">
|
|
<HeaderStyle Width="30px"></HeaderStyle>
|
|
</telerik:GridButtonColumn>
|
|
<telerik:GridButtonColumn CommandName="Edit" Text="Edit" ButtonCssClass="rgEdit" UniqueName="EditColumn" HeaderStyle-Width="30px">
|
|
<HeaderStyle Width="30px"></HeaderStyle>
|
|
</telerik:GridButtonColumn>
|
|
|
|
</Columns>
|
|
</telerik:GridTableView>
|
|
</DetailTables>
|
|
<ParentTableRelation>
|
|
<telerik:GridRelationFields DetailKeyField="moduleId" MasterKeyField="moduleId" />
|
|
</ParentTableRelation>
|
|
<CommandItemSettings ShowExportToExcelButton="True" AddNewRecordText="Nieuwe vraag" />
|
|
<Columns>
|
|
<%--<telerik:GridBinaryImageColumn DataField="Image" HeaderText="Image" ImageHeight="" ImageWidth="100px" UniqueName="Image" AllowFiltering="False" AutoAdjustImageControlSize="False" ShowFilterIcon="False" ReadOnly="true" InsertVisiblityMode="AlwaysHidden" />--%>
|
|
<telerik:GridBoundColumn DataField="moduleId" FilterControlAltText="Filter vraagId column" HeaderText="moduleId" UniqueName="moduleId" />
|
|
<telerik:GridBoundColumn DataField="vraagId" FilterControlAltText="Filter vraagId column" HeaderText="vraagId" UniqueName="vraagId" ReadOnly="true" />
|
|
|
|
<telerik:GridTemplateColumn DataField="NL" HeaderText="NL" UniqueName="NL">
|
|
<EditItemTemplate>
|
|
<asp:TextBox ID="NLTextBox" runat="server" Text='<%# Bind("NL") %>' Width="600px"></asp:TextBox>
|
|
</EditItemTemplate>
|
|
<ItemTemplate>
|
|
<asp:Label ID="NLLabel" runat="server" Text='<%# Eval("NL") %>'></asp:Label>
|
|
</ItemTemplate>
|
|
</telerik:GridTemplateColumn>
|
|
<telerik:GridTemplateColumn DataField="FR" FilterControlAltText="Filter column column" HeaderText="FR" UniqueName="FR">
|
|
<EditItemTemplate>
|
|
<asp:TextBox ID="FRTextBox" runat="server" Text='<%# Bind("FR") %>' Width="600px"></asp:TextBox>
|
|
</EditItemTemplate>
|
|
<ItemTemplate>
|
|
<asp:Label ID="FRLabel" runat="server" Text='<%# Eval("FR") %>'></asp:Label>
|
|
</ItemTemplate>
|
|
</telerik:GridTemplateColumn>
|
|
<telerik:GridTemplateColumn DataField="EN" FilterControlAltText="Filter column column" HeaderText="EN" UniqueName="EN">
|
|
<EditItemTemplate>
|
|
<asp:TextBox ID="ENTextBox" runat="server" Text='<%# Bind("EN") %>' Width="600px"></asp:TextBox>
|
|
</EditItemTemplate>
|
|
<ItemTemplate>
|
|
<asp:Label ID="ENLabel" runat="server" Text='<%# Eval("EN") %>'></asp:Label>
|
|
</ItemTemplate>
|
|
</telerik:GridTemplateColumn>
|
|
<telerik:GridBoundColumn DataField="difficulty" FilterControlAltText="Filter column column" HeaderText="difficulty" UniqueName="difficulty" />
|
|
<telerik:GridCheckBoxColumn DataField="final" DataType="System.Boolean" HeaderText="final" SortExpression="final" UniqueName="final" />
|
|
<telerik:GridCheckBoxColumn DataField="active" DataType="System.Boolean" FilterControlAltText="Filter verplicht column" HeaderText="active" SortExpression="active" UniqueName="active" />
|
|
<%--<telerik:GridBoundColumn DataField="QuizImageId" FilterControlAltText="Filter Image ID column" HeaderText="Image ID" UniqueName="QuizImageId" />--%>
|
|
<telerik:GridTemplateColumn DataField="QuizImageId" FilterControlAltText="Filter QuizImageId column" HeaderText="Image Id" UniqueName="QuizImageId">
|
|
<EditItemTemplate>
|
|
<asp:TextBox ID="QuizImageIdTextBox" runat="server" Text='<%# Bind("QuizImageId") %>'></asp:TextBox>
|
|
</EditItemTemplate>
|
|
<ItemTemplate>
|
|
<telerik:RadBinaryImage runat="server" DataValue='<%# Eval("Image") == DBNull.Value ? new System.Byte[0] : Eval("Image") %>' Visible='<%# Eval("Image") == DBNull.Value ? false : true %>' AutoAdjustImageControlSize="true" Height="30px" Width="200px" ResizeMode="Fit" />
|
|
</ItemTemplate>
|
|
</telerik:GridTemplateColumn>
|
|
<telerik:GridButtonColumn CommandName="Delete" Text="Edit" ButtonCssClass="rgDel" UniqueName="DeleteColumn" HeaderStyle-Width="30px" ConfirmText="Wil je deze vraag verwijderen ? ">
|
|
<HeaderStyle Width="30px"></HeaderStyle>
|
|
</telerik:GridButtonColumn>
|
|
<telerik:GridButtonColumn CommandName="Edit" Text="Edit" ButtonCssClass="rgEdit" UniqueName="EditColumn" HeaderStyle-Width="30px">
|
|
<HeaderStyle Width="30px"></HeaderStyle>
|
|
</telerik:GridButtonColumn>
|
|
</Columns>
|
|
</telerik:GridTableView>
|
|
</DetailTables>
|
|
<CommandItemSettings ShowAddNewRecordButton="False" ShowExportToExcelButton="True" />
|
|
<Columns>
|
|
<telerik:GridBoundColumn DataField="moduleId" DataType="System.Int16" FilterControlAltText="Filter moduleId column" HeaderText="moduleId" ReadOnly="True" SortExpression="moduleId" UniqueName="moduleId">
|
|
<ColumnValidationSettings>
|
|
<ModelErrorMessage Text="" />
|
|
</ColumnValidationSettings>
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="naamNL" FilterControlAltText="Filter naamNL column" HeaderText="naamNL" SortExpression="naamNL" UniqueName="naamNL">
|
|
<ColumnValidationSettings>
|
|
<ModelErrorMessage Text="" />
|
|
</ColumnValidationSettings>
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="naamFR" FilterControlAltText="Filter naamFR column" HeaderText="naamFR" SortExpression="naamFR" UniqueName="naamFR">
|
|
<ColumnValidationSettings>
|
|
<ModelErrorMessage Text="" />
|
|
</ColumnValidationSettings>
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="naamEN" FilterControlAltText="Filter naamEN column" HeaderText="naamEN" SortExpression="naamEN" UniqueName="naamEN">
|
|
<ColumnValidationSettings>
|
|
<ModelErrorMessage Text="" />
|
|
</ColumnValidationSettings>
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="aantalvragen" DataType="System.Int16" FilterControlAltText="Filter aantalvragen column" HeaderText="aantalvragen" SortExpression="aantalvragen" UniqueName="aantalvragen">
|
|
<ColumnValidationSettings>
|
|
<ModelErrorMessage Text="" />
|
|
</ColumnValidationSettings>
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="IkoonFile" FilterControlAltText="Filter IkoonFile column" HeaderText="IkoonFile" SortExpression="IkoonFile" UniqueName="IkoonFile">
|
|
<ColumnValidationSettings>
|
|
<ModelErrorMessage Text="" />
|
|
</ColumnValidationSettings>
|
|
</telerik:GridBoundColumn>
|
|
</Columns>
|
|
</MasterTableView>
|
|
</telerik:RadGrid>
|
|
<asp:SqlDataSource ID="sqldsmodules" runat="server" ConnectionString="<%$ ConnectionStrings:idpbwConnectionString %>" SelectCommand="quizModulesSelect" SelectCommandType="StoredProcedure"></asp:SqlDataSource>
|
|
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:idpbwConnectionString %>" SelectCommand="quizVragenSelect" SelectCommandType="StoredProcedure" InsertCommand="quizVragenInsert" InsertCommandType="StoredProcedure" UpdateCommand="quizVragenUpdate" UpdateCommandType="StoredProcedure" DeleteCommand="QuizVragenDelete" DeleteCommandType="StoredProcedure">
|
|
<DeleteParameters>
|
|
<asp:Parameter Name="vraagId" Type="Int16" />
|
|
</DeleteParameters>
|
|
<InsertParameters>
|
|
<asp:Parameter Name="moduleId" Type="Int16" />
|
|
<asp:Parameter Name="NL" Type="String" />
|
|
<asp:Parameter Name="FR" Type="String" />
|
|
<asp:Parameter Name="EN" Type="String" />
|
|
<asp:Parameter Name="fig" Type="String" />
|
|
<asp:Parameter Name="final" Type="Boolean" />
|
|
<asp:Parameter Name="active" Type="Boolean" />
|
|
<asp:Parameter Name="difficulty" Type="Byte" />
|
|
<asp:Parameter Name="QuizImageId" Type="Int32" />
|
|
</InsertParameters>
|
|
<SelectParameters>
|
|
<asp:Parameter Name="moduleId" Type="Int32" />
|
|
</SelectParameters>
|
|
<UpdateParameters>
|
|
<asp:Parameter Name="vraagId" Type="Int16" />
|
|
<asp:Parameter Name="moduleId" Type="Int16" />
|
|
<asp:Parameter Name="NL" Type="String" />
|
|
<asp:Parameter Name="FR" Type="String" />
|
|
<asp:Parameter Name="EN" Type="String" />
|
|
<asp:Parameter Name="fig" Type="String" />
|
|
<asp:Parameter Name="final" Type="Boolean" />
|
|
<asp:Parameter Name="active" Type="Boolean" />
|
|
<asp:Parameter Name="difficulty" Type="Byte" />
|
|
<asp:Parameter Name="QuizImageId" Type="Int32" />
|
|
</UpdateParameters>
|
|
</asp:SqlDataSource>
|
|
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:idpbwConnectionString %>"
|
|
SelectCommand="quizAntwoordenSelect" SelectCommandType="StoredProcedure"
|
|
InsertCommand="quizAntwoordenInsert" InsertCommandType="StoredProcedure"
|
|
UpdateCommand="quizAntwoordenUpdate" UpdateCommandType="StoredProcedure"
|
|
DeleteCommand="quizAntwoordenUpdate" DeleteCommandType="StoredProcedure">
|
|
<DeleteParameters>
|
|
<asp:Parameter Name="vraagId" Type="Int32" />
|
|
<asp:Parameter Name="antwId" Type="Int32" />
|
|
<asp:Parameter Name="NL" Type="String" />
|
|
<asp:Parameter Name="FR" Type="String" />
|
|
<asp:Parameter Name="EN" Type="String" />
|
|
<asp:Parameter Name="fig" Type="String" />
|
|
<asp:Parameter Name="correct" Type="Boolean" />
|
|
<asp:Parameter Name="QuizImageId" Type="Int32" />
|
|
</DeleteParameters>
|
|
<InsertParameters>
|
|
<asp:Parameter Name="vraagId" Type="Int32" />
|
|
<asp:Parameter Name="NL" Type="String" />
|
|
<asp:Parameter Name="FR" Type="String" />
|
|
<asp:Parameter Name="EN" Type="String" />
|
|
<asp:Parameter Name="fig" Type="String" />
|
|
<asp:Parameter Name="correct" Type="Boolean" />
|
|
<asp:Parameter Name="QuizImageId" Type="Int32" />
|
|
</InsertParameters>
|
|
<SelectParameters>
|
|
<asp:Parameter Name="vraagId" Type="Int32" />
|
|
</SelectParameters>
|
|
<UpdateParameters>
|
|
<asp:Parameter Name="vraagId" Type="Int32" />
|
|
<asp:Parameter Name="antwId" Type="Int32" />
|
|
<asp:Parameter Name="NL" Type="String" />
|
|
<asp:Parameter Name="FR" Type="String" />
|
|
<asp:Parameter Name="EN" Type="String" />
|
|
<asp:Parameter Name="fig" Type="String" />
|
|
<asp:Parameter Name="correct" Type="Boolean" />
|
|
<asp:Parameter Name="QuizImageId" Type="Int32" />
|
|
</UpdateParameters>
|
|
</asp:SqlDataSource>
|
|
</asp:Content>
|