eDosWeb/eDos/CommentToInstalltion.aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeBehind="CommentToInstalltion.aspx.cs" Inherits="Rems2018.CommentToInstallation" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowSorting="True" CellSpacing="-1" GridLines="Both" AllowAutomaticDeletes="True" AllowCustomPaging="True" AllowFilteringByColumn="True" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="sqlDSV_CommentToInstallation" AutoGenerateEditColumn="True">
        <GroupingSettings CollapseAllTooltip="Collapse all groups"></GroupingSettings>
        <ExportSettings>
            <Pdf PageWidth="">
            </Pdf>
            <Excel FileExtension="xlsx" Format="Xlsx" />
        </ExportSettings>
        <ClientSettings AllowColumnsReorder="True">
        </ClientSettings>
        <MasterTableView DataKeyNames="ID_CommentToInstallation" CommandItemDisplay="Top" AllowAutomaticDeletes="False" DataSourceID="sqlDSV_CommentToPerson">
            <CommandItemSettings ShowExportToExcelButton="True" />
            <Columns>

                <telerik:GridBoundColumn DataField="ID_CommentToInstallation" DataType="System.Int32" HeaderText="ID" UniqueName="ID_CommentToInstallation" FilterControlAltText="Filter ID_CommentToInstallation column" ReadOnly="True" SortExpression="ID_CommentToInstallation" AllowFiltering="False" MaxLength="3">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="InstallationName" HeaderText="Installation" UniqueName="InstallationName" FilterControlAltText="Filter InstallationName column" SortExpression="InstallationName">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="Comment" FilterControlAltText="Filter Comment column" HeaderText="Comment" SortExpression="Comment" UniqueName="Comment">
                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn DataField="CommentDateStart" HeaderText="DateStart" UniqueName="CommentDateStart" FilterControlAltText="Filter CommentDateStart column" SortExpression="CommentDateStart" DataType="System.DateTime">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="CommentDateSTOP" HeaderText="DateSTOP" UniqueName="CommentDateSTOP" SortExpression="CommentDateSTOP" DataType="System.DateTime" FilterControlAltText="Filter CommentDateSTOP column">
                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn DataField="FNameAgent" HeaderText="Agent" UniqueName="FNameAgent" FilterControlAltText="Filter FNameAgent column" SortExpression="FNameAgent">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="LNameAgent" HeaderText=" " UniqueName="LNameAgent" FilterControlAltText="Filter LNameAgent column" SortExpression="LNameAgent">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="FNameHPH" HeaderText="HPH" UniqueName="FNameHPH" FilterControlAltText="Filter FNameHPH column" SortExpression="FNameHPH">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="LNameHPH" HeaderText=" " UniqueName="LNameHPH" FilterControlAltText="Filter LNameHPH column" SortExpression="LNameHPH">
                </telerik:GridBoundColumn>
                
                <telerik:GridBoundColumn DataField="CommentDate" FilterControlAltText="Filter CommentDate column" HeaderText="Date registration" SortExpression="CommentDate" UniqueName="CommentDate" DataType="System.DateTime">
                </telerik:GridBoundColumn>
          


            </Columns>
        </MasterTableView>
    </telerik:RadGrid>


    <asp:SqlDataSource ID="sqlDSV_CommentToInstallation" runat="server"
        ConnectionString="<%$ ConnectionStrings:HPH_REMS_newConnectionString %>"
        SelectCommand="SELECT [ID_CommentToInstallation], [FNameAgent], [LNameAgent], [FNameHPH], [LNameHPH], [InstallationName], [Comment], [CommentDate], [CommentDateStart], [CommentDateSTOP] FROM [V_CommentToInstallation]"></asp:SqlDataSource>



    <table >

    <tr>
       <td style="font-weight: bold">
           <asp:Label ID="Label3" runat="server" CssClass="rdfLabel rdfBlock" Text="Installation: "></asp:Label>
       </td>
       <td>
          <telerik:RadComboBox ID="RadComboBoxSelectInst" runat="server" DataSourceID="SqlDSSelectInst" DataTextField="[InstallationName]" DataValueField="Inst_CODE" Width="95%">
                </telerik:RadComboBox>
                <asp:SqlDataSource ID="SqlDSSelectInst" runat="server" ConnectionString="<%$ ConnectionStrings:HPH_REMS_newConnectionString %>" SelectCommand="SELECT [Inst_CODE], [InstallationName] FROM [Installation]"></asp:SqlDataSource>
       </td>
   </tr>
        
   <tr>
       <td style="font-weight: bold">
           <asp:Label ID="Label10" runat="server" CssClass="rdfLabel rdfBlock" Text="Comment:"></asp:Label>
       </td>
       <td>
           <asp:Label ID="Label11" runat="server" CssClass="rdfFieldValue" Text='<%# Bind("Comment") %>' />
            </td>
       </tr>

   <tr>
        <td style ="font-weight: bold">
            <asp:Label ID="Label12" runat="server" CssClass="rdfLabel rdfBlock" Text="Date Start:"></asp:Label>
        </td>
        <td>
            <telerik:RadDatePicker ID="RadDatePicker1" runat="server" SelectedDate='<%# Bind("CommentDateSTART") %>' />
          </td>
   </tr>
                 
   <tr>
        <td style ="font-weight: bold">
            <asp:Label ID="Label13" runat="server" CssClass="rdfLabel rdfBlock" Text="Date Stop:"></asp:Label>
        </td>
 
        <td>
              <telerik:RadDatePicker ID="RadDatePicker2" runat="server" SelectedDate='<%# Bind("CommentDateSTOP") %>' />
        </td>
   </tr>

   <tr>
       <td style="font-weight: bold">
           <asp:Label ID="Label7" runat="server" CssClass="rdfLabel rdfBlock" Text="Register by (Agent SC): "></asp:Label>
       </td>
       <td>
           <telerik:RadComboBox ID="RadComboBoxSelectAgentSC" runat="server" DataSourceID="SqlDSSelectAgentSC" DataTextField="[LastName] + [FirstName]" DataValueField="PersID" Width="95%">
           </telerik:RadComboBox>
           <asp:SqlDataSource ID="SqlDSSelectAgentSC" runat="server" ConnectionString="<%$ ConnectionStrings:HPH_REMS_newConnectionString %>" SelectCommand="SELECT [PersID], [LastName], [FirstName] FROM [V_SelectAgent SC]"></asp:SqlDataSource>
       </td>
   </tr>

   <tr>
       <td style="font-weight: bold">
          <asp:Label ID="Label8" runat="server" CssClass="rdfLabel rdfBlock" Text="Register by (HPHResp): "></asp:Label>
       </td>
       <td>
          <telerik:RadComboBox ID="RadComboBoxSelectHPH" runat="server" DataSourceID="SqlDSSelectHPHResp" DataTextField="[LastName] + [FirstName]" DataValueField="PersID" Width="95%">
          </telerik:RadComboBox>
          <asp:SqlDataSource ID="SqlDSSelectHPHResp" runat="server" ConnectionString="<%$ ConnectionStrings:HPH_REMS_newConnectionString %>" SelectCommand="SELECT [PersID], [FirstName], [LastName] FROM [V_SelectHPHResp]"></asp:SqlDataSource>
            </td>
        </tr>
       
       <td style ="font-weight: bold">
           <asp:Label ID="Label6" runat="server" CssClass="rdfLabel rdfBlock" Text="Date of the registration:"></asp:Label>
       </td>
       <td>
           <telerik:RadDatePicker ID="CommentDate" runat="server" SelectedDate='<%# Bind("CommentDate") %>' />
       </td>
  </tr>

    </table>

    <<--! Na Edit moet een controle dat alles ingevuld is behalve Agent SC of verantwoordelijk. us 1 van de 2 is voldoen -->

</asp:Content>