eDosWeb/safety/BuildingResponsableOld.aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/Site2n.master" AutoEventWireup="true" CodeBehind="BuildingResponsableOld.aspx.cs" Inherits="safety.BuildingResponsableOld" MaintainScrollPositionOnPostback="true" %>


<asp:Content ID="Contenth" ContentPlaceHolderID="head" runat="server" />
    
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">



    <%--    <telerik:RadAjaxManager runat="server">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="ddIDPBW">
                    <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="ddFuncties" UpdatePanelCssClass="" />
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" UpdatePanelCssClass="" />
                </UpdatedControls>
            </telerik:AjaxSetting>
            
            <telerik:AjaxSetting AjaxControlID="ddFuncties">
                    <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" UpdatePanelCssClass="" />
                </UpdatedControls>
            </telerik:AjaxSetting>
            
            <telerik:AjaxSetting AjaxControlID="ddBuildings">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" UpdatePanelCssClass="" />
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
       
    </telerik:RadAjaxManager>--%>


    <div style="width: 100%;">
        <telerik:RadDropDownList ID="ddIDPBW" runat="server" AppendDataBoundItems="True" SelectedText="Beheerd IDPBW" SelectedValue="True" AutoPostBack="True">
            <Items>
                <telerik:DropDownListItem runat="server" Text="Beheerd IDPBW" Value="True" Selected="True" />
                <telerik:DropDownListItem runat="server" Text="Andere" Value="False" />
            </Items>
        </telerik:RadDropDownList>

        <telerik:RadDropDownList ID="ddFuncties" runat="server" DataSourceID="SqlDSGebouwFuncties" DataTextField="naam" DataValueField="functie" AutoPostBack="true">
        </telerik:RadDropDownList>
        <telerik:RadDropDownList ID="ddBuildings" runat="server" AppendDataBoundItems="True" DataSourceID="SqlDSBuildings" DataTextField="name" DataValueField="building" AutoPostBack="true">
            <Items>
                <telerik:DropDownListItem runat="server" Text="Alle" Value="*" />
            </Items>
        </telerik:RadDropDownList>
    </div>


    <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" DataSourceID="dsBResponsables" AllowSorting="True" AutoPostBack="true" CellSpacing="-1" GridLines="Both" GroupPanelPosition="Top" OnPreRender="RadGrid1_PreRender">
        <GroupingSettings CollapseAllTooltip="Collapse all groups" CaseSensitive="False"></GroupingSettings>

        <ExportSettings ExportOnlyData="True" FileName="GebouwVerantwoordelijken" OpenInNewWindow="True">
            <Pdf PageWidth="">
            </Pdf>
            <Excel Format="Xlsx" />
        </ExportSettings>
        <MasterTableView DataKeyNames="building,functie" DataSourceID="dsBResponsables" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" CommandItemDisplay="Top">
            <CommandItemSettings ShowExportToExcelButton="True" ShowAddNewRecordButton="False" />
            <Columns>
                <telerik:GridDropDownColumn DataField="functie" FilterControlAltText="Filter functie" HeaderText="functie" ListValueField="functie" UniqueName="functie" DataSourceID="SqlDSGebouwFuncties" ListTextField="naam" ListTextFormatString="{0}" ReadOnly="true">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridDropDownColumn>
                <telerik:GridDropDownColumn DataField="building" FilterControlAltText="Filter building" HeaderText="Gebouw" ListValueField="building" UniqueName="building" DataSourceID="SqlDSBuildings" ListTextField="name" ListTextFormatString="{0}" ReadOnly="true">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridDropDownColumn>

                <telerik:GridTemplateColumn DataField="persid" FilterControlAltText="Filter column column" HeaderText="Coordinator1" UniqueName="persid">
                    <EditItemTemplate>
                        <telerik:RadComboBox ID="persidRadComboBoxp1" runat="server" DataSourceID="SqlDSNamen" DataTextField="naam" DataValueField="persid" SelectedValue='<%# Bind("persid") %>'>
                        </telerik:RadComboBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:HyperLink runat="server" NavigateUrl='<%# string.Format("http://intern.sckcen.be/phonebook/fiche.asp?id={0}",Eval("persid")) %>' Text='<%# Eval("name1") %>' />
                    </ItemTemplate>
                </telerik:GridTemplateColumn>

                <telerik:GridTemplateColumn DataField="persid2" FilterControlAltText="Filter column column" HeaderText="Coordinator 2" UniqueName="persid2">
                    <EditItemTemplate>
                        <telerik:RadComboBox ID="persidRadComboBoxp2" runat="server" DataSourceID="SqlDSNamen" DataTextField="naam" DataValueField="persid" SelectedValue='<%# Bind("persid2") %>'>
                        </telerik:RadComboBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:HyperLink runat="server" NavigateUrl='<%# string.Format("http://intern.sckcen.be/phonebook/fiche.asp?id={0}",Eval("persid2")) %>' Text='<%# Eval("name2") %>' />
                    </ItemTemplate>
                </telerik:GridTemplateColumn>


                <%--                <telerik:GridDropDownColumn DataField="persid2" FilterControlAltText="Filter column column" HeaderText="Coordinator2" ListValueField="persid" UniqueName="persid2" DataSourceID="SqlDSNamen" ListTextField="naam" ListTextFormatString="{0}">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridDropDownColumn>--%>

                <telerik:GridTemplateColumn DataField="persidsec" FilterControlAltText="Filter column column" HeaderText="Delegate 1" UniqueName="persidsec">
                    <EditItemTemplate>
                        <telerik:RadComboBox ID="persidRadComboBoxs1" runat="server" DataSourceID="SqlDSNamen" DataTextField="naam" DataValueField="persid" SelectedValue='<%# Bind("persidsec") %>'>
                        </telerik:RadComboBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:HyperLink runat="server" NavigateUrl='<%# string.Format("http://intern.sckcen.be/phonebook/fiche.asp?id={0}",Eval("persidsec")) %>' Text='<%# Eval("name3") %>' />
                    </ItemTemplate>
                </telerik:GridTemplateColumn>

                <telerik:GridTemplateColumn DataField="persidsec2" FilterControlAltText="Filter column column" HeaderText="Delegate 2" UniqueName="persidsec2">
                    <EditItemTemplate>
                        <telerik:RadComboBox ID="persidRadComboBoxs2" runat="server" DataSourceID="SqlDSNamen" DataTextField="naam" DataValueField="persid" SelectedValue='<%# Bind("persidsec2") %>'>
                        </telerik:RadComboBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:HyperLink runat="server" NavigateUrl='<%# string.Format("http://intern.sckcen.be/phonebook/fiche.asp?id={0}",Eval("persidsec2")) %>' Text='<%# Eval("name4") %>' />
                    </ItemTemplate>
                </telerik:GridTemplateColumn>



                <telerik:GridButtonColumn CommandName="Edit" Text="Edit" ButtonCssClass="rgEdit" UniqueName="EditColumn" HeaderStyle-Width="30px">
                    <HeaderStyle Width="30px"></HeaderStyle>
                </telerik:GridButtonColumn>

            </Columns>
        </MasterTableView>
    </telerik:RadGrid>
    <asp:SqlDataSource ID="dsBResponsables" runat="server" ConnectionString="<%$ ConnectionStrings:idpbwConnectionString %>" DeleteCommand="GebouwVerantwoo rdelijkenDelete" DeleteCommandType="StoredProcedure" InsertCommand="GebouwVerantwoordelijkenInsert" InsertCommandType="StoredProcedure" SelectCommand="GebouwVerantwoordelijkenSelect" SelectCommandType="StoredProcedure" UpdateCommand="GebouwVerantwoordelijkenUpdate" UpdateCommandType="StoredProcedure" CancelSelectOnNullParameter="false">
        <DeleteParameters>
            <asp:Parameter Name="building" Type="String" />
            <asp:Parameter Name="functie" Type="String" />
        </DeleteParameters>
        <InsertParameters>
            <asp:ControlParameter ControlID="ddBuildings" Name="building" PropertyName="SelectedValue" Type="String" />
            <asp:ControlParameter ControlID="ddFuncties" Name="functie" PropertyName="SelectedValue" Type="String" />
            <asp:Parameter Name="persid" Type="Int32" />
            <asp:Parameter Name="persid2" Type="Int32" />
            <asp:Parameter Name="persidSec" Type="Int32" />
            <asp:Parameter Name="persidSec2" Type="Int32" />
        </InsertParameters>
        <SelectParameters>
            <asp:ControlParameter ControlID="ddIDPBW" DefaultValue="" Name="vis" PropertyName="SelectedValue" Type="Boolean" />
            <asp:ControlParameter ControlID="ddBuildings" DefaultValue="" Name="building" PropertyName="SelectedValue" Type="String" />
            <asp:ControlParameter ControlID="ddFuncties" Name="functie" PropertyName="SelectedValue" Type="String" />
        </SelectParameters>
        <UpdateParameters>
            <asp:Parameter Name="building" Type="String" />
            <asp:Parameter Name="functie" Type="String" />
            <asp:Parameter Name="persid" Type="Int32" />
            <asp:Parameter Name="persid2" Type="Int32" />
            <asp:Parameter Name="persidSec" Type="Int32" />
            <asp:Parameter Name="persidSec2" Type="Int32" />
        </UpdateParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDSBuildings" runat="server" ConnectionString="<%$ ConnectionStrings:idpbwConnectionString %>"
        SelectCommand="SELECT [building], [name] FROM [gebouwen] where deleted=0 ORDER BY [name] "></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDSGebouwFuncties" runat="server" ConnectionString="<%$ ConnectionStrings:idpbwConnectionString %>"
        SelectCommand="select [functie]='*', [naam] =' Alles'
union
SELECT [functie], [naam] FROM [gebouwFuncties] where visible= @vis ORDER BY [naam]">
        <SelectParameters>
            <asp:ControlParameter ControlID="ddIDPBW" DefaultValue="" Name="vis" PropertyName="SelectedValue" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDSNamen" runat="server" ConnectionString="<%$ ConnectionStrings:idpbwConnectionString %>"
        SelectCommand="getLijstNamen" SelectCommandType="StoredProcedure"></asp:SqlDataSource>
</asp:Content>