eDosWeb/safety/OverzichtWBC.aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeBehind="OverzichtWBC.aspx.cs" Inherits="safety.OverzichtWBC" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <h1>WBC</h1>
    <telerik:RadComboBox ID="RadComboBox1" Runat="server" Label="Groep" AutoPostBack="True">
        <Items>
            <telerik:RadComboBoxItem runat="server" Text="Extern" Value="E" />
            <telerik:RadComboBoxItem runat="server" Text="Werknemer" Value="W" />
            <telerik:RadComboBoxItem runat="server" Text="Stage" Value="[SATJ]" />
            <telerik:RadComboBoxItem runat="server" Text="Alles" Value="%" />
        </Items>
    </telerik:RadComboBox>
    <telerik:RadGrid ID="RadGrid1" runat="server" CellSpacing="0" DataSourceID="SqlDataSource1" GridLines="None" AutoGenerateColumns="False" AllowSorting="True" ShowGroupPanel="True">
        <ExportSettings ExportOnlyData="True" HideStructureColumns="True" OpenInNewWindow="True">
            <Pdf PageWidth="">
            </Pdf>
            <Excel Format="ExcelML" />
        </ExportSettings>
        <ClientSettings AllowDragToGroup="True">
        </ClientSettings>
        <MasterTableView DataSourceID="SqlDataSource1" CommandItemDisplay="Top">
            <CommandItemSettings ShowExportToExcelButton="True" ShowAddNewRecordButton="False" />
            <ColumnGroups>
                <telerik:GridColumnGroup Name="Freq" HeaderText="Frequentie"></telerik:GridColumnGroup>
                <telerik:GridColumnGroup Name="Dates" HeaderText="Datums"></telerik:GridColumnGroup>
                <telerik:GridColumnGroup Name="Mentor" HeaderText="Mentor/Chef"></telerik:GridColumnGroup>
            </ColumnGroups>
            <Columns>
                <telerik:GridTemplateColumn FilterControlAltText="Filter column column" UniqueName="wbcColor" GroupByExpression="wbcColor" HeaderText="W" SortExpression="wbcColor">
                    <ItemTemplate>
                        <asp:Image ID="column" runat="server" ImageUrl='<%# bunkerStatus2(DataBinder.Eval(Container, "DataItem.wbcColor")) %>' />
                    </ItemTemplate>
                </telerik:GridTemplateColumn>
                <telerik:GridTemplateColumn FilterControlAltText="Filter lungColor column" UniqueName="lungColor" GroupByExpression="lungColor" HeaderText="L" SortExpression="lungColor">
                    <ItemTemplate>
                        <asp:Image ID="column" runat="server" ImageUrl='<%# bunkerStatus2(DataBinder.Eval(Container, "DataItem.lungColor")) %>' />
                    </ItemTemplate>
                </telerik:GridTemplateColumn>
                <telerik:GridBoundColumn DataField="building" FilterControlAltText="Filter building column" HeaderText="building" SortExpression="building" UniqueName="building">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
                <telerik:GridHyperLinkColumn AllowSorting="False" DataNavigateUrlFields="persid" DataNavigateUrlFormatString="https://toegang.intern.sckcen.be/pub/fiche/{0}" DataTextField="persid" DataTextFormatString="{0}" FilterControlAltText="Filter column column" HeaderText="persID" Text="persid" UniqueName="column">
                </telerik:GridHyperLinkColumn>
                <telerik:GridBoundColumn DataField="name" FilterControlAltText="Filter name column" HeaderText="name" ReadOnly="True" SortExpression="name" UniqueName="name">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="lang" FilterControlAltText="Filter lang column" HeaderText="Taal" SortExpression="lang" UniqueName="lang">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="email" FilterControlAltText="Filter email column" HeaderText="email" SortExpression="email" UniqueName="email">
                    <columnvalidationsettings>
                        <modelerrormessage text=""></modelerrormessage>
                    </columnvalidationsettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="companyName" FilterControlAltText="Filter companyName column" HeaderText="Company" SortExpression="companyName" UniqueName="companyName" ReadOnly="True">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="start" DataType="System.DateTime" FilterControlAltText="Filter start column" HeaderText="start" SortExpression="start" UniqueName="start" DataFormatString="{0:yyyy-MM-dd}" >
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                    <HeaderStyle Width="80px" />
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="einde" DataType="System.DateTime" FilterControlAltText="Filter einde column" HeaderText="einde" SortExpression="einde" UniqueName="einde" DataFormatString="{0:yyyy-MM-dd}">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                    <HeaderStyle Width="80px" />
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn ColumnGroupName="Freq" DataField="bunkerFreq" DataType="System.Byte" FilterControlAltText="Filter bunkerFreq column" HeaderText="WBC" SortExpression="bunkerFreq" UniqueName="bunkerFreq">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn ColumnGroupName="Freq" DataField="lungFreq" DataType="System.Byte" FilterControlAltText="Filter lungFreq column" HeaderText="Lung" SortExpression="lungFreq" UniqueName="lungFreq">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn ColumnGroupName="Freq" DataField="thyroidFreq" DataType="System.Byte" FilterControlAltText="Filter thyroidFreq column" HeaderText="thyroid" SortExpression="thyroidFreq" UniqueName="thyroidFreq">
                    <columnvalidationsettings>
                        <modelerrormessage text=""></modelerrormessage>
                    </columnvalidationsettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn ColumnGroupName="Dates" DataField="wbcDate" DataType="System.DateTime" FilterControlAltText="Filter wbcDate column" HeaderText="WBC" SortExpression="wbcDate" UniqueName="wbcDate" DataFormatString="{0:yyyy-MM-dd}">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                    <HeaderStyle Width="80px" />
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn ColumnGroupName="Dates" DataField="wbcTill" DataType="System.DateTime" FilterControlAltText="Filter wbcTill column" HeaderText="WBC Expires" SortExpression="wbcTill" UniqueName="wbcTill" ReadOnly="True" DataFormatString="{0:yyyy-MM-dd}">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                    <HeaderStyle Width="80px" />
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn ColumnGroupName="Dates" DataField="lungdate" DataType="System.DateTime" FilterControlAltText="Filter lungdate column" HeaderText="Lung" SortExpression="lungdate" UniqueName="lungdate" DataFormatString="{0:yyyy-MM-dd}">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                    <HeaderStyle Width="80px" />
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn ColumnGroupName="Dates" DataField="lungTill" DataType="System.DateTime" FilterControlAltText="Filter lungTill column" HeaderText="Lung Expires" SortExpression="lungTill" UniqueName="lungTill" ReadOnly="True" DataFormatString="{0:yyyy-MM-dd}">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                    <HeaderStyle Width="80px" />
                </telerik:GridBoundColumn>
                
                <telerik:GridBoundColumn ColumnGroupName="Mentor" DataField="mentor" FilterControlAltText="Filter mentor column" HeaderText="Mentor" ReadOnly="True" SortExpression="mentor" UniqueName="mentor">
                    <columnvalidationsettings>
                        <modelerrormessage text=""></modelerrormessage>
                    </columnvalidationsettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn ColumnGroupName="Mentor"  DataField="mentoremail" FilterControlAltText="Filter mentoremail column" HeaderText="Email" SortExpression="mentoremail" UniqueName="mentoremail">
                    <columnvalidationsettings>
                        <modelerrormessage text=""></modelerrormessage>
                    </columnvalidationsettings>
                </telerik:GridBoundColumn>
                <telerik:GridCheckBoxColumn DataField="final" DataType="System.Boolean" FilterControlAltText="Filter final column" HeaderText="Final" UniqueName="final">
                </telerik:GridCheckBoxColumn>
            </Columns>
        </MasterTableView>
    </telerik:RadGrid>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:idpbwConnectionString %>" SelectCommand="personBunkerSelect" SelectCommandType="StoredProcedure">
        <SelectParameters>
            <asp:ControlParameter ControlID="RadComboBox1" DefaultValue="%" Name="group" PropertyName="SelectedValue" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
</asp:Content>