<telerik:RadGrid ID="gvCurrentSalaries" runat="server" AllowPaging="True" DataSourceID="sqlCurrentSalaries" PageSize="50" Visible="False" RenderMode="Lightweight" AllowSorting="True" AllowAutomaticInserts="True" AutoGenerateColumns="False" OnInsertCommand="gvCurrentSalaries_InsertCommand">
<GroupingSettings CollapseAllTooltip="Collapse all groups"></GroupingSettings>

            <ExportSettings ExportOnlyData="True" FileName="Workforce-Salary" IgnorePaging="True">
                <Excel FileExtension="xlsx" Format="Xlsx" />
            </ExportSettings>
            <ClientSettings AllowColumnsReorder="True" ReorderColumnsOnClient="True">
                <Selecting AllowRowSelect="True" />
            </ClientSettings>

<MasterTableView CommandItemDisplay="Top" DataSourceID="sqlCurrentSalaries" DataKeyNames="PersonID">
    <DetailTables>
        <telerik:GridTableView runat="server" DataKeyNames="PersonID" DataSourceID="sqlSalaryHistory">
            <ParentTableRelation>
                <telerik:GridRelationFields DetailKeyField="PersonID" MasterKeyField="PersonID" />
            </ParentTableRelation>
            <RowIndicatorColumn ShowNoSortIcon="False" Visible="False">
            </RowIndicatorColumn>
            <ExpandCollapseColumn Created="True" ShowNoSortIcon="False">
            </ExpandCollapseColumn>
            <EditFormSettings>
                <EditColumn ShowNoSortIcon="False">
                </EditColumn>
            </EditFormSettings>
            <Columns>
                <telerik:GridBoundColumn DataField="Salary" FilterControlAltText="Filter FullName column" HeaderText="Current Salary" ShowNoSortIcon="False" UniqueName="Salary" DataFormatString="{0:c}">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="StartDate" FilterControlAltText="Filter FullName column" HeaderText="Start Date" ShowNoSortIcon="False" UniqueName="StartDate" DataFormatString="{0:d}">
                </telerik:GridBoundColumn>
    </Columns>
        </telerik:GridTableView>
    </DetailTables>
    
    <CommandItemSettings ShowExportToExcelButton="True" ShowExportToPdfButton="True" ShowAddNewRecordButton="False" />
<RowIndicatorColumn ShowNoSortIcon="False" Visible="False"></RowIndicatorColumn>

<ExpandCollapseColumn ShowNoSortIcon="False" Created="True"></ExpandCollapseColumn>

    <Columns>
        <telerik:GridBoundColumn DataField="FullName" FilterControlAltText="Filter FullName column" HeaderText="Full Name" ShowNoSortIcon="False" UniqueName="FullName">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="PersonType" FilterControlAltText="Filter FullName column" HeaderText="Person Type" ShowNoSortIcon="False" UniqueName="PersonType">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Salary" FilterControlAltText="Filter FullName column" HeaderText="Current Salary" ShowNoSortIcon="False" UniqueName="Salary" DataFormatString="{0:c}">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="StartDate" FilterControlAltText="Filter FullName column" HeaderText="Start Date" ShowNoSortIcon="False" UniqueName="StartDate" DataFormatString="{0:d}">
        </telerik:GridBoundColumn>
    </Columns>

<EditFormSettings>
<EditColumn ShowNoSortIcon="False"></EditColumn>
</EditFormSettings>
</MasterTableView>
            <HeaderStyle Font-Bold="True" HorizontalAlign="Left" />

<FilterMenu RenderMode="Lightweight"></FilterMenu>

<HeaderContextMenu RenderMode="Lightweight"></HeaderContextMenu>
        </telerik:RadGrid>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentMain" runat="Server">
    <section class="section-admin-main">
        <h1 class="page-title">
            <asp:Label ID="lblTitle" runat="server" Text="Informes"></asp:Label>
        </h1>
        <telerik:RadAjaxManagerProxy ID="RadAjaxManager1" runat="server">
            <AjaxSettings>
                <telerik:AjaxSetting AjaxControlID="rcb_Views">
                    <UpdatedControls>
                        <telerik:AjaxUpdatedControl ControlID="rcb_Views"></telerik:AjaxUpdatedControl>
                        <telerik:AjaxUpdatedControl ControlID="RG_DistributorsWithoutParts"></telerik:AjaxUpdatedControl>
                        <telerik:AjaxUpdatedControl ControlID="eds_Generic"></telerik:AjaxUpdatedControl>
                    </UpdatedControls>
                </telerik:AjaxSetting>
                <telerik:AjaxSetting AjaxControlID="RG_DistributorsWithoutParts">
                    <UpdatedControls>
                        <telerik:AjaxUpdatedControl ControlID="rcb_Views"></telerik:AjaxUpdatedControl>
                        <telerik:AjaxUpdatedControl ControlID="RG_DistributorsWithoutParts"></telerik:AjaxUpdatedControl>
                        <telerik:AjaxUpdatedControl ControlID="eds_Generic"></telerik:AjaxUpdatedControl>
                    </UpdatedControls>
                </telerik:AjaxSetting>
            </AjaxSettings>
        </telerik:RadAjaxManagerProxy>
        <div id="div_combo">
            <telerik:RadComboBox ID="rcb_Views" runat="server" MaxHeight="200" Width="315" OnSelectedIndexChanged="rcb_Views_SelectedIndexChanged" DataSourceID="eds_ViewNames"
                DataTextField="description" DataValueField="ViewName" AutoPostBack="true" Label="Seleccione los datos a mostrar: ">
            </telerik:RadComboBox>
        </div>
        <telerik:RadGrid ID="RG_DistributorsWithoutParts" runat="server" Height="500px" AllowPaging="True" ShowFooter="True"
            AllowSorting="True" AutoGenerateColumns="True" ShowStatusBar="True" AllowFilteringByColumn="True" DataSourceID="eds_Generic" 
            OnItemCommand="RG_DistributorsWithoutParts_ItemCommand" CellSpacing="-1" Culture="es-ES" GridLines="Both">
            <GroupingSettings CaseSensitive="false" />
            <MasterTableView Width="100%" CommandItemDisplay="Top" CommandItemSettings-ShowAddNewRecordButton="false" CommandItemSettings-ShowRefreshButton="true" CommandItemSettings-ShowExportToExcelButton="true" PageSize="50">
                <CommandItemSettings ShowAddNewRecordButton="False" ShowExportToExcelButton="True"></CommandItemSettings>
                <Columns>
                </Columns>
            </MasterTableView>
            <ClientSettings>
                <Scrolling AllowScroll="true" UseStaticHeaders="false" SaveScrollPosition="false" />
                <Resizing AllowColumnResize="true" AllowResizeToFit="true" />
            </ClientSettings>
        </telerik:RadGrid>
        <asp:SqlDataSource ID="eds_Generic" runat="server" ConnectionString="<%$ ConnectionStrings:LMSViewsConnString %>" SelectCommand="SELECT * FROM [man_participantes]"></asp:SqlDataSource>
        <asp:SqlDataSource ID="eds_ViewNames" runat="server" ConnectionString="<%$ ConnectionStrings:LMSViewsConnString %>" SelectCommand="SELECT * FROM [v_ViewNames]"></asp:SqlDataSource>
    </section>
</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="FooterScripts" runat="Server">
    <style type="text/css">
        input[type="checkbox"] {
            -webkit-appearance: checkbox;
        }

        input[type="radio"] {
            -webkit-appearance: radio;
        }
    </style>

    <script type="text/javascript">
        function pageLoad() {
            var grid = $find('<%=RG_DistributorsWithoutParts.ClientID %>');
            var columns = grid.get_masterTableView().get_columns();
                for (var i = 0; i < columns.length; i++) {
                    columns[i].resizeToFit();
                }
        }
    </script>
</asp:Content>

protected void Page_Load(object sender, EventArgs e)
{
    (this.Master as BaseMaster).setVisibilityMenu(false);
    this.meth_TranslateGrids(RG_DistributorsWithoutParts);
    if (rcb_Views.SelectedValue != "")
    {
        eds_Generic.SelectCommand = "SELECT * FROM [" + rcb_Views.SelectedValue + "]";
    }

    if (!IsPostBack)
    {
        rcb_Views.DataBind();
        eds_Generic.SelectCommand = "SELECT * FROM [" + rcb_Views.SelectedValue + "]";
        RG_DistributorsWithoutParts.DataBind();
    }
}
protected void rcb_Views_SelectedIndexChanged(object sender, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
    eds_Generic.SelectCommand = "SELECT * FROM [" + rcb_Views.SelectedValue + "]";
    RG_DistributorsWithoutParts.DataBind();
}