eDosWeb/safety/DocARoles.aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/Siten.master" AutoEventWireup="true" CodeBehind="DocARoles.aspx.cs" Inherits="safety.DocARoles" MaintainScrollPositionOnPostback="true" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
   
     <fieldset class="rfdRoundedCorners">
    
    <telerik:RadGrid ID="RadGrid1" runat="server" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="sqlDSDocARoles" ShowGroupPanel="True" CellSpacing="-1" GridLines="Both" GroupPanelPosition="Top">
    <ExportSettings>
        <Pdf PageWidth="">
        </Pdf>
    </ExportSettings>
    <ClientSettings AllowDragToGroup="True">
    </ClientSettings>
    <MasterTableView AllowAutomaticInserts="True" AllowAutomaticUpdates="True" CommandItemDisplay="Top" DataKeyNames="roleID" DataSourceID="sqlDSDocARoles">
        <Columns>
            <telerik:GridBoundColumn DataField="roleID" DataType="System.Int32" FilterControlAltText="Filter roleID column" HeaderText="roleID" ReadOnly="True" SortExpression="roleID" UniqueName="roleID">
                <ColumnValidationSettings>
                    <ModelErrorMessage Text="" />
                </ColumnValidationSettings>
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="cat" FilterControlAltText="Filter cat column" HeaderText="cat" SortExpression="cat" UniqueName="cat">
                <ColumnValidationSettings>
                    <ModelErrorMessage Text="" />
                </ColumnValidationSettings>
                <ItemStyle Width="40px" />
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="subcat" FilterControlAltText="Filter subcat column" HeaderText="subcat" SortExpression="subcat" UniqueName="subcat">
                <ColumnValidationSettings>
                    <ModelErrorMessage Text="" />
                </ColumnValidationSettings>
                <ItemStyle Width="70px" />
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="nr" DataType="System.Int32" FilterControlAltText="Filter nr column" HeaderText="nr" SortExpression="nr" UniqueName="nr">
                <ColumnValidationSettings>
                    <ModelErrorMessage Text="" />
                </ColumnValidationSettings>
                <ItemStyle Width="50px" />
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="name" FilterControlAltText="Filter name " HeaderText="Name" SortExpression="name" UniqueName="name">
                <ColumnValidationSettings>
                    <ModelErrorMessage Text="" />
                </ColumnValidationSettings>
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="shortname" FilterControlAltText="Filter column column" HeaderText="Short" UniqueName="column">
                <ColumnValidationSettings>
                    <ModelErrorMessage Text="" />
                </ColumnValidationSettings>
            </telerik:GridBoundColumn>
            <telerik:GridCheckBoxColumn DataField="isGZ" DataType="System.Boolean" FilterControlAltText="Filter column2 column" HeaderText="GZ" UniqueName="column2">
            </telerik:GridCheckBoxColumn>
            <telerik:GridCheckBoxColumn DataField="DesignOnly" DataType="System.Boolean" FilterControlAltText="Filter column1 column" HeaderText="Design" UniqueName="column1">
            </telerik:GridCheckBoxColumn>
            <telerik:GridBoundColumn DataField="NeedHPHApproval" DataType="System.Byte" FilterControlAltText="Filter NeedHPHApproval column" HeaderText="HPH Approve" SortExpression="nr" UniqueName="NeedHPHApproval"  />
            <telerik:GridButtonColumn CommandName="Edit" Text="Edit" ButtonCssClass="rgEdit" UniqueName="EditColumn"  HeaderStyle-Width="30px">
            </telerik:GridButtonColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>
         </fieldset>
<asp:SqlDataSource ID="sqlDSDocARoles" runat="server" ConnectionString="<%$ ConnectionStrings:idpbwConnectionString %>" SelectCommand="DocARolesSelect" DeleteCommand="DocARolesDelete" DeleteCommandType="StoredProcedure" InsertCommand="DocARolesInsert" InsertCommandType="StoredProcedure" SelectCommandType="StoredProcedure" UpdateCommand="DocARolesUpdate" UpdateCommandType="StoredProcedure">
    <DeleteParameters>
        <asp:Parameter Name="roleID" Type="Int32" />
    </DeleteParameters>
    <InsertParameters>
        <asp:Parameter Name="roleID" Type="Int32" />
        <asp:Parameter Name="cat" Type="String" />
        <asp:Parameter Name="subcat" Type="String" />
        <asp:Parameter Name="nr" Type="Int32" />
        <asp:Parameter Name="name" Type="String" />
        <asp:Parameter Name="shortname" Type="String" />
        <asp:Parameter Name="DesignOnly" Type="Boolean" />
        <asp:Parameter Name="isGZ" Type="Boolean" />
        <asp:Parameter Name="NeedHPHApproval" Type="Byte" />
    </InsertParameters>
    <UpdateParameters>
        <asp:Parameter Name="roleID" Type="Int32" />
        <asp:Parameter Name="cat" Type="String" />
        <asp:Parameter Name="subcat" Type="String" />
        <asp:Parameter Name="nr" Type="Int32" />
        <asp:Parameter Name="name" Type="String" />
        <asp:Parameter Name="shortname" Type="String" />
        <asp:Parameter Name="DesignOnly" Type="Boolean" />
        <asp:Parameter Name="isGZ" Type="Boolean" />
        <asp:Parameter Name="NeedHPHApproval" Type="Byte" />
    </UpdateParameters>
</asp:SqlDataSource>
</asp:Content>