eDosWeb/safety/OverzichtLRM.aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeBehind="OverzichtLRM.aspx.cs" Inherits="safety.OverzichtLRM" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <h1>LRM</h1>
    <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 urineColor column" UniqueName="urineColor" GroupByExpression="urineColor" HeaderText="S" SortExpression="urineColor">
                    <ItemTemplate>
                        <asp:Image ID="column" runat="server" ImageUrl='<%# bunkerStatus2(DataBinder.Eval(Container, "DataItem.urineColor")) %>' />
                    </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="Pu" DataType="System.Byte" FilterControlAltText="Filter Pu column" HeaderText="Pu" SortExpression="Pu" UniqueName="Pu">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn ColumnGroupName="Freq" DataField="Am" DataType="System.Byte" FilterControlAltText="Filter Am column" HeaderText="Am" SortExpression="Am" UniqueName="Am">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn ColumnGroupName="Freq" DataField="U" DataType="System.Byte" FilterControlAltText="Filter U column" HeaderText="U" SortExpression="U" UniqueName="U">
                    <columnvalidationsettings>
                        <modelerrormessage text=""></modelerrormessage>
                    </columnvalidationsettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn ColumnGroupName="Freq" DataField="Tr" DataType="System.Byte" FilterControlAltText="Filter Tr column" HeaderText="Tr" SortExpression="Tr" UniqueName="Tr" ItemStyle-BackColor="LightGray" HeaderTooltip="Not in routine">
                    <columnvalidationsettings>
                        <modelerrormessage text=""></modelerrormessage>
                    </columnvalidationsettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn ColumnGroupName="Freq" DataField="Po" DataType="System.Byte" FilterControlAltText="Filter Po column" HeaderText="Po" SortExpression="Po" UniqueName="Po"/>
                <telerik:GridBoundColumn ColumnGroupName="Freq" DataField="Andere" DataType="System.Byte" FilterControlAltText="Filter Andere column" HeaderText="Andere" SortExpression="Andere" UniqueName="Andere" />
                <telerik:GridBoundColumn ColumnGroupName="Freq" DataField="inVitroRemark" DataType="System.String" HeaderText="Remark" SortExpression="inVitroRemark" UniqueName="inVitroRemark" />

                <telerik:GridBoundColumn ColumnGroupName="Dates" DataField="urinedate" DataType="System.DateTime" FilterControlAltText="Filter urinedate column" HeaderText="Measure" SortExpression="urinedate" UniqueName="urinedate" DataFormatString="{0:yyyy-MM-dd}">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                    <HeaderStyle Width="80px" />
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn ColumnGroupName="Dates" DataField="urineTill" DataType="System.DateTime" FilterControlAltText="Filter urineTill column" HeaderText="Expires" SortExpression="urineTill" UniqueName="urineTill" 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>
            </Columns>
        </MasterTableView>
    </telerik:RadGrid>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:idpbwConnectionString %>" SelectCommand="personUrineSelect" SelectCommandType="StoredProcedure">
        </asp:SqlDataSource>
</asp:Content>