75 lines
5.7 KiB
Text
75 lines
5.7 KiB
Text
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeBehind="phoneRooms.aspx.cs" Inherits="safety.phoneRooms" %>
|
|
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
|
|
<telerik:RadGrid runat="server" ID="gridRooms" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True" DataSourceID="SqlDataSource1" AutoGenerateColumns="False">
|
|
|
|
<GroupingSettings CollapseAllTooltip="Collapse all groups" CaseSensitive="false"></GroupingSettings>
|
|
|
|
<ExportSettings OpenInNewWindow="true">
|
|
<Pdf PageWidth="">
|
|
</Pdf>
|
|
<Excel FileExtension="xlsx" Format="Xlsx" />
|
|
</ExportSettings>
|
|
<MasterTableView AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowSorting="True" CommandItemDisplay="Top" DataKeyNames="idRoom" DataSourceID="SqlDataSource1">
|
|
<CommandItemSettings ShowExportToExcelButton="True" />
|
|
<Columns>
|
|
<telerik:GridBoundColumn DataField="idRoom" DataType="System.Int32" FilterControlAltText="Filter idRoom column" HeaderText="idRoom" ReadOnly="True" SortExpression="idRoom" UniqueName="idRoom">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="name" FilterControlAltText="Filter name column" HeaderText="name" SortExpression="name" UniqueName="name">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="seatsMin" DataType="System.Int32" FilterControlAltText="Filter seatsMin column" HeaderText="seatsMin" SortExpression="seatsMin" UniqueName="seatsMin">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="seatsMax" DataType="System.Int32" FilterControlAltText="Filter seatsMax column" HeaderText="seatsMax" SortExpression="seatsMax" UniqueName="seatsMax">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="Building" FilterControlAltText="Filter Building column" HeaderText="Building" SortExpression="Building" UniqueName="Building">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="phone" FilterControlAltText="Filter phone column" HeaderText="phone" SortExpression="phone" UniqueName="phone">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="phone2" FilterControlAltText="Filter phone2 column" HeaderText="phone2" SortExpression="phone2" UniqueName="phone2">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="email" FilterControlAltText="Filter email column" HeaderText="email" SortExpression="email" UniqueName="email">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="nameResp" FilterControlAltText="Filter nameResp column" HeaderText="nameResp" SortExpression="nameResp" UniqueName="nameResp">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="phoneResp" FilterControlAltText="Filter phoneResp column" HeaderText="phoneResp" SortExpression="phoneResp" UniqueName="phoneResp">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="emailResp" FilterControlAltText="Filter emailResp column" HeaderText="emailResp" SortExpression="emailResp" UniqueName="emailResp">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="Responsible" DataType="System.Int32" FilterControlAltText="Filter Responsible column" HeaderText="Responsible" SortExpression="Responsible" UniqueName="Responsible">
|
|
</telerik:GridBoundColumn>
|
|
</Columns>
|
|
</MasterTableView>
|
|
|
|
</telerik:RadGrid>
|
|
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:HRConnectionString %>" InsertCommand="phoneRoomsInsert" InsertCommandType="StoredProcedure" SelectCommand="phoneRoomsSelect" SelectCommandType="StoredProcedure" UpdateCommand="phoneRoomsUpdate" UpdateCommandType="StoredProcedure" DeleteCommand="[dbo].[phoneRoomsDelete]" DeleteCommandType="StoredProcedure">
|
|
<DeleteParameters>
|
|
<asp:Parameter Name="idRoom" Type="Int32" />
|
|
</DeleteParameters>
|
|
<InsertParameters>
|
|
<asp:Parameter Name="name" Type="String" />
|
|
<asp:Parameter Name="seatsMin" Type="Int32" />
|
|
<asp:Parameter Name="seatsMax" Type="Int32" />
|
|
<asp:Parameter Name="Building" Type="String" />
|
|
<asp:Parameter Name="phone" Type="String" />
|
|
<asp:Parameter Name="phone2" Type="String" />
|
|
<asp:Parameter Name="email" Type="String" />
|
|
<asp:Parameter Name="nameResp" Type="String" />
|
|
<asp:Parameter Name="phoneResp" Type="String" />
|
|
<asp:Parameter Name="emailResp" Type="String" />
|
|
<asp:Parameter Name="Responsible" Type="Int32" />
|
|
</InsertParameters>
|
|
<UpdateParameters>
|
|
<asp:Parameter Name="idRoom" Type="Int32" />
|
|
<asp:Parameter Name="name" Type="String" />
|
|
<asp:Parameter Name="seatsMin" Type="Int32" />
|
|
<asp:Parameter Name="seatsMax" Type="Int32" />
|
|
<asp:Parameter Name="Building" Type="String" />
|
|
<asp:Parameter Name="phone" Type="String" />
|
|
<asp:Parameter Name="phone2" Type="String" />
|
|
<asp:Parameter Name="email" Type="String" />
|
|
<asp:Parameter Name="nameResp" Type="String" />
|
|
<asp:Parameter Name="phoneResp" Type="String" />
|
|
<asp:Parameter Name="emailResp" Type="String" />
|
|
<asp:Parameter Name="Responsible" Type="Int32" />
|
|
</UpdateParameters>
|
|
</asp:SqlDataSource>
|
|
</asp:Content>
|