Loading time is too long

3 posts, 0 answers
  1. lakmal
    lakmal avatar
    76 posts
    Member since:
    Jun 2009

    Posted 10 Sep 2009 Link to this post

    Hi

    I have grid with tabstrip. It take more time to load. Can you say how can i speed up this?

    Actual web link is this

    http://seeds-lanka.com/minute/document.aspx





    <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Document.aspx.cs" Inherits="Document" %>

    <%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>

    <%@ Register assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" namespace="System.Web.UI" tagprefix="asp" %>

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    <html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
      <style type="text/css">
        .viewWrap
        {
            padding:15px;
            background:#2291b5 0 0 url(Img/bluegradient.gif) repeat-x;
        }
        
        .contactWrap
        {
            padding:10px 15px 15px 15px;
            background:#fff;
            color:#333;
        }
        
        .contactWrap td
        {
            padding:0 20px 0 0;
        }
        
        .contactWrap td td
        {
            padding:3px 20px 3px 0;
        }
        
        .contactWrap img
        {
            border:1px solid #05679d;
        }
        
        </style>
        <title></title>
    </head>
    <body>
        <form id="form1" runat="server">
        <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
        </telerik:RadScriptManager>
        

        
            <br />
            <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"
                DefaultLoadingPanelID="RadAjaxLoadingPanel1" EnableAJAX="False"
                EnablePageHeadUpdate="False">
                <AjaxSettings>
                    <telerik:AjaxSetting AjaxControlID="RadGrid4">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="RadGrid4" />
                        </UpdatedControls>
                    </telerik:AjaxSetting>
                </AjaxSettings>
            </telerik:RadAjaxManager>
          
        
    <telerik:RadGrid ID="RadGrid4" runat="server" AutoGenerateColumns="False"
                GridLines="None" onitemcommand="RadGrid1_ItemCommand" DataSourceID="sqlNewDocument"
                 Skin="Web20"
                onprerender="RadGrid4_PreRender" AllowFilteringByColumn="True"
                AllowPaging="True" AllowSorting="True">
        <MasterTableView DataKeyNames="DocNo" EditMode="InPlace" >
        <RowIndicatorColumn>
        <HeaderStyle Width="20px"></HeaderStyle>
        </RowIndicatorColumn>

        <ExpandCollapseColumn>
        <HeaderStyle Width="20px"></HeaderStyle>
        </ExpandCollapseColumn>
            <NestedViewTemplate>
                        <asp:Panel runat="server" ID="InnerContainer" CssClass="viewWrap" Visible="false">
          
                     
            
                          <telerik:radtabstrip ID="RadTabStrip1" runat="server" SelectedIndex="0"
                            MultiPageID="RadMultiPage1" Skin="Web20">
                            <Tabs>
                                <telerik:radtab runat="server" Selected="True" Text="Document Info"
                                    PageViewID="PageInfor">
                                </telerik:RadTab>
                                <telerik:radtab runat="server" Text="CAM CPY Info" PageViewID="PageCAM">
                                </telerik:RadTab>
                                <telerik:radtab runat="server" Text="IDC" PageViewID="PageIDC">
                                </telerik:RadTab>
                                <telerik:radtab runat="server" Text="Transmittal" PageViewID="PageTransmital">
                                </telerik:RadTab>
                                <telerik:radtab runat="server" Text="Planning Dates" PageViewID="PagePlaning">
                                </telerik:RadTab>
                                <telerik:radtab runat="server" Text="Remarks" PageViewID="PageRemark">
                                </telerik:RadTab>
                            </Tabs>
                        </telerik:RadTabStrip>
                        
                        <telerik:radmultipage ID="RadMultiPage1" Runat="server" SelectedIndex="0">
                            <telerik:radpageview ID="PageInfor" runat="server">
                                    
                                    <table>
                                    <tr>
                                        <td>
                                         <b>Document Number</b>
                                        </td>
                                        <td>
                                            <asp:TextBox ID="txtDocNo" Text='<%# Eval("DocNo") %>' runat="server"></asp:TextBox>
                                        
                                        </td>                               
                                    
                                    </tr>
                                    
                                     <tr>
                                        <td>
                                         <b>Document Title</b>
                                        </td>
                                        <td>
                                            <asp:TextBox ID="txtDocTitle" Text='<%# Eval("[Document Title]") %>' runat="server"></asp:TextBox>
                                        
                                        </td>                               
                                    
                                    </tr>
                                    
                                      <tr>
                                        <td>
                                         <b>Client Doc No</b>
                                        </td>
                                        <td>
                                            <asp:TextBox ID="txtClientDocNo" Text='<%# Eval("[Client Doc No]") %>' runat="server"></asp:TextBox>
                                        
                                        </td>                               
                                    
                                    </tr>
                                
                                 <tr>
                                        <td>
                                         <b>System</b>
                                        </td>
                                        <td>
                                                <telerik:RadComboBox runat="server"
                                                 ID="ddlSystem"
                                                 DataTextField="System"
                                                 DataValueField="SystemID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="220px"
                                                 DropDownWidth="420px"
                                                 DataSourceID="sqlSystem"
                                                 SelectedValue='<%#Bind("SystemID") %>'  ></telerik:RadComboBox>
                                                                                
                                        </td>                               
                                    
                                    </tr>
                                    
                                     <tr>
                                        <td>
                                         <b>Package</b>
                                        </td>
                                        <td>
                                                <telerik:RadComboBox runat="server"
                                                 ID="ddlPackage"
                                                 DataTextField="Package"
                                                 DataValueField="PackageID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="220px"
                                                 DropDownWidth="420px"
                                                    DataSourceID="sqlPackage"
                                                  SelectedValue='<%#Bind("PackageID") %>'  ></telerik:RadComboBox>
                                                                                
                                        </td>                               
                                    
                                    </tr>
                                    
                                     <tr>
                                        <td>
                                         <b>Phase</b>
                                        </td>
                                        <td>
                                                <telerik:RadComboBox runat="server"
                                                 ID="ddlPhase"
                                                 DataTextField="Phase"
                                                 DataValueField="PhaseID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="220px"
                                                 DropDownWidth="420px"
                                                    DataSourceID="sqlPhase"
                                                  SelectedValue='<%#Bind("PhaseID") %>'  ></telerik:RadComboBox>
                                                                                
                                        </td>                               
                                    
                                    </tr>
                                    
                                    <tr>
                                        <td>
                                         <b>CTR </b>
                                        </td>
                                        <td>
                                                <telerik:RadComboBox runat="server"
                                                 ID="ddlCTR"
                                                 DataTextField="Title"
                                                 DataValueField="CTRID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="220px"
                                                 DropDownWidth="420px"
                                                    DataSourceID="sqlCTR"
                                                  SelectedValue='<%#Bind("CTRID") %>'  ></telerik:RadComboBox>
                                                                                
                                        </td>                               
                                    
                                    </tr>
                                    
                                    <tr>
                                        <td>
                                         <b>Reporting CTR </b>
                                        </td>
                                        <td>
                                               <%-- <telerik:RadComboBox runat="server"
                                                 ID="ddlReportCTR"
                                                 DataTextField="CTRTitle"
                                                 DataValueField="RepCTRID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="220px"
                                                 DropDownWidth="420px"
                                                 DataSourceID="sqlReportCTR"
                                                  SelectedValue='<%#Eval("RepCTRID") %>'  ></telerik:RadComboBox>         --%>  
                                           
                                                                                
                                        </td>                               
                                    
                                    </tr>
                                    
                                    <tr>
                                        <td>
                                            <asp:Button ID="cmdUpdateInfo" runat="server" Text="Update" CommandName="UpdateInfo" CommandArgument='<%Bind("DocNo") %>' />                            
                                        </td>
                                        <td>
                                            <asp:Literal ID="ltrInfo"   runat="server"></asp:Literal>
                                        </td>
                                    
                                    
                                    </tr>
                                    
                                
                                </table>                 
                                
                            </telerik:RadPageView>
                            <telerik:radpageview ID="PageCAM" runat="server">
                            
                              <table>
                                    <tr>
                                        <td>
                                         <b>CAM Category</b>
                                        </td>
                                        <td>
                                             <telerik:RadComboBox runat="server"
                                                 ID="ddlCamCAtegory"
                                                 DataTextField="CategoryClass"
                                                 DataValueField="CatClassID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="220px"
                                                 DropDownWidth="420px"
                                                 DataSourceID="sqlCAMCat"
                                                 SelectedValue='<%#Bind("CatClassID") %>'  >
                                              </telerik:RadComboBox>
                                        
                                        </td>                               
                                    
                                    </tr>
                                    
                                     <tr>
                                        <td>
                                         <b>Client Doc Type</b>
                                        </td>
                                        <td>
                                           <telerik:RadComboBox runat="server"
                                                 ID="ddlClientDoc"
                                                 DataTextField="Submitable"
                                                 DataValueField="SubmitID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="220px"
                                                 DropDownWidth="420px"
                                                    DataSourceID="sqlSunmit"
                                                    SelectedValue='<%#Bind("SubmitID") %>'></telerik:RadComboBox>
                                                                            
                                        </td>                               
                                    
                                    </tr>
                                    
                                    
                                      <tr>
                                        <td>
                                         <b>Client Sys/SubSys</b>
                                        </td>
                                        <td>
                                           <telerik:RadComboBox runat="server"
                                                 ID="ddlClientSys"
                                                 DataTextField="ClientSys_SubSysCode"
                                                 DataValueField="ClientSys_SubSysCodeID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="220px"
                                                 DropDownWidth="420px"
                                                    DataSourceID="sqlClientSys"
                                                    SelectedValue='<%#Bind("ClientSys_SubSysCodeID") %>'></telerik:RadComboBox>
                                                                            
                                        </td>                               
                                    
                                    </tr>
                                    
                                    
                                     <tr>
                                        <td>
                                         <b>Document Owner</b>
                                        </td>
                                        <td>
                                       <telerik:RadComboBox runat="server"
                                                 ID="ddlOwner"
                                                 DataTextField="DocOwnAppComment"
                                                 DataValueField="DocOACID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="220px"
                                                 DropDownWidth="420px"
                                                    DataSourceID="sqlOWner"
                                                  SelectedValue='<%#Bind("DocOwnerID") %>'  ></telerik:RadComboBox>
                                        
                                        </td>                               
                                    
                                    </tr>
                                    
                                     <tr>
                                        <td>
                                         <b>IDC Approver</b>
                                        </td>
                                        <td>
                                           <telerik:RadComboBox runat="server"
                                                 ID="ddlApprover"
                                                 DataTextField="DocOwnAppComment"
                                                 DataValueField="DocOACID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="220px"
                                                 DropDownWidth="420px"
                                                    DataSourceID="sqlOWner"
                                                    SelectedValue='<%#Bind("IDCAppID") %>'></telerik:RadComboBox>
                                                                            
                                        </td>                               
                                    
                                    </tr>
                                    
                                    
                                      <tr>
                                        <td>
                                         <b>Submitable</b>
                                        </td>
                                        <td>
                                           <telerik:RadComboBox runat="server"
                                                 ID="ddlSumitable"
                                                 DataTextField="Submitable"
                                                 DataValueField="SubmitID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="220px"
                                                 DropDownWidth="420px"
                                                    DataSourceID="sqlSunmit"
                                                    SelectedValue='<%#Bind("SubmitID") %>'></telerik:RadComboBox>
                                                                            
                                        </td>                               
                                    
                                    </tr>
                                    
                                    
                                    
                                    
                                    
                                   
                                    
                                    <tr>
                                        <td>
                                         <b>Live Data </b>
                                        </td>
                                        <td>
                                           <telerik:RadComboBox runat="server"
                                                 ID="ddlLiveData"
                                                 DataTextField="Live Data"
                                                 DataValueField="LiveDataID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="220px"
                                                 DropDownWidth="420px"
                                                    DataSourceID="sqlLiveData"
                                                    SelectedValue='<%#Bind("LiveDataID") %>'></telerik:RadComboBox>
                                                                            
                                        </td>                               
                                    
                                    </tr>
                                    
                                     <tr>
                                        <td>
                                         <b>New Document  </b>
                                        </td>
                                        <td>
                                                
                                            <asp:TextBox ID="txtNewDocument" Text='<%# Eval("New Document") %>' runat="server"></asp:TextBox>   
                                                                            
                                        </td>                               
                                    
                                    </tr>
                                    
                                     <tr>
                                        <td>
                                            <asp:Button ID="cmdCamCat" runat="server" Text="Update" CommandName="UpdateCam" CommandArgument='<%Bind("DocNo") %>' />                            
                                        </td>
                                        <td>
                                            <asp:Literal ID="litCam"   runat="server"></asp:Literal>
                                        </td>
                                    
                                    
                                    </tr>
                                    
                                    
                                
                                
                                </table>       
                                                 
                                    
                                        
                                        
                            
                            </telerik:RadPageView>
                            
                            <telerik:radpageview ID="PageIDC" runat="server">
                                <asp:Label ID="Label1" runat="server" Font-Bold="true" Font-Italic="true" Text='<%# Eval("DocNo") %>'></asp:Label>
                                 
                
                                    <telerik:RadGrid ID="RadGrid5" runat="server" AutoGenerateColumns="False"  AllowAutomaticInserts="True"
                                    AllowAutomaticUpdates="True" AllowAutomaticDeletes="True"
                                            GridLines="None" DataSourceID="SqlDataSource2" Width="400px"
                                    AllowSorting="True" Skin="Web20" >
                                    <MasterTableView AutoGenerateColumns="False" DataKeyNames="IDCID" DataMember="DefaultView" CommandItemDisplay="TopAndBottom"
                                     AllowAutomaticDeletes="true" ClientDataKeyNames="IDCID" EditMode="InPlace" AllowAutomaticInserts="true" >
                                    
                                        <Columns>
                                         <telerik:GridEditCommandColumn ButtonType="ImageButton">
                                            </telerik:GridEditCommandColumn>
                                            
                                        
                                         <telerik:GridBoundColumn DataField="IDCID" HeaderText="IDCID" ReadOnly="true" Visible="false"
                                                UniqueName="IDCID">
                                            </telerik:GridBoundColumn>  
                                                                                 
                                            <telerik:GridBoundColumn DataField="DocNo" HeaderText="Doc No" ReadOnly="true"  Visible="false"
                                                UniqueName="DocNo">
                                            </telerik:GridBoundColumn>
                                            
                                         <telerik:GridTemplateColumn UniqueName="IDCcomID" HeaderText="Document Owner">                                        
                                            <ItemTemplate>                                        
                                             <telerik:RadComboBox runat="server"
                                                 ID="RadComp"
                                                 DataTextField="DocOwnAppComment"
                                                 DataValueField="DocOACID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="220px"
                                                 DropDownWidth="420px" Enabled="false"
                                                    DataSourceID="ContactsDataSource"
                                                    SelectedValue='<%#Bind("IDCcomID") %>'></telerik:RadComboBox>                                        
                                            </ItemTemplate>
                                            <EditItemTemplate>                                        
                                            <telerik:RadComboBox runat="server"
                                                 ID="RadCompEdit"
                                                 DataTextField="DocOwnAppComment"
                                                 DataValueField="DocOACID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="220px"
                                                 DropDownWidth="420px"
                                                    DataSourceID="ContactsDataSource"
                                                    SelectedValue='<%#Bind("IDCcomID") %>'></telerik:RadComboBox>                                                
                                            
                                            </EditItemTemplate>                                        
                                            </telerik:GridTemplateColumn>                        
                                            
                                            <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" ConfirmText="Are you sure delete this record?"
                                                Text="Delete" UniqueName="column">
                                            </telerik:GridButtonColumn>
                                           </Columns>
                                        
                                    </MasterTableView>
                                  </telerik:RadGrid>
                               
                               <asp:SqlDataSource ID="ContactsDataSource"                                                 
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT * FROM [tbl_LU_DocOwnAppComment]"
                                        runat="server">
                                </asp:SqlDataSource>
                                       
                                    <asp:SqlDataSource ID="SqlDataSource2" runat="server"
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>"
                                        SelectCommand="SELECT [IDCID], [DocNo] , [IDCcomID] FROM [tbl_DATA_IDCcomment] WHERE (DocNo = @DocNo)"
                                        InsertCommand="INSERT INTO [tbl_DATA_IDCcomment] ([DocNo], [IDCcomID]) VALUES (@DocNo, @IDCcomID)"
                                        DeleteCommand ="Delete from [tbl_DATA_IDCcomment] where IDCID= @IDCID "
                                        UpdateCommand="Update [tbl_DATA_IDCcomment] set [IDCcomID]=@IDCcomID where IDCID= @IDCID "  >
                                       
                                        <SelectParameters>                                                                           
                                            <asp:ControlParameter ControlID="Label1" PropertyName="Text" Type="String" Name="DocNo" />                                      
                                             
                                        </SelectParameters>
                                        
                                       <DeleteParameters>
                                         <asp:Parameter Name="IDCID" Type="Int32"  />                                   
                                       </DeleteParameters>
                                       <UpdateParameters>
                                            <asp:Parameter Name="IDCID" Type="Int32"  />
                                           <asp:Parameter Name="IDCcomID" Type="Int64"  />
                                       
                                       </UpdateParameters>
                                        
                                         <InsertParameters>
                                            <asp:ControlParameter ControlID="Label1" PropertyName="Text" Type="String" Name="DocNo" />
                                            <asp:Parameter Name="IDCcomID" Type="Int64"  />
                                        </InsertParameters>
                                        
                                        
                                    </asp:SqlDataSource>
                                    
                                    
                            
                            </telerik:RadPageView>
                            <telerik:radpageview ID="PageTransmital" runat="server">                        
                                    <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" Width="750px" AllowAutomaticDeletes="true" AllowAutomaticInserts="true" AllowAutomaticUpdates="true"
                                            GridLines="None" DataSourceID="SqlTransmital"
                                    AllowSorting="True" Skin="Web20" ClientDataKeyNames="TransID" EditMode="InPlace" DataMember="DefaultView" >
                                    <MasterTableView AutoGenerateColumns="False" DataKeyNames="TransID" CommandItemDisplay="TopAndBottom" AllowAutomaticDeletes="true" AllowAutomaticInserts="true" AllowAutomaticUpdates="true">                                
                                      <Columns>
                                          <telerik:GridEditCommandColumn ButtonType="ImageButton">
                                          </telerik:GridEditCommandColumn>
                                          
                                           <telerik:GridBoundColumn DataField="TransID" HeaderText="TransID" Visible="false" ReadOnly="True"
                                                UniqueName="TransID">
                                            </telerik:GridBoundColumn>
                                            
                                            
                                     <telerik:GridTemplateColumn UniqueName="ReasonforIssueID" HeaderText="Reason for Issue">
                                     <ItemTemplate>
                                     
                                             <telerik:RadComboBox runat="server"
                                                 ID="ddlReason"
                                                 DataTextField="Reason for Issue"
                                                 DataValueField="ReasonforIssueID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="60px"
                                                 DropDownWidth="420px" Enabled="false"
                                                    DataSourceID="sqlReason"
                                                    SelectedValue='<%#Bind("ReasonforIssueID") %>'></telerik:RadComboBox>
                                                    
                                     </ItemTemplate>
                                     <EditItemTemplate>
                                     
                                     <telerik:RadComboBox runat="server"
                                                 ID="ddlReasonEdit"
                                                 DataTextField="Reason for Issue"
                                                 DataValueField="ReasonforIssueID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="60px"
                                                 DropDownWidth="420px"
                                                    DataSourceID="sqlReason"
                                                    SelectedValue='<%#Bind("ReasonforIssueID") %>'></telerik:RadComboBox>
                                     
                                     </EditItemTemplate>
                                            </telerik:GridTemplateColumn>
                                      
                                            <telerik:GridBoundColumn DataField="OurDocRev" HeaderText="Our DocRev"
                                                UniqueName="OurDocRev">
                                            </telerik:GridBoundColumn>
                                             <telerik:GridTemplateColumn UniqueName="OurTransDate" HeaderText="Our Trans Date">
                                             <ItemTemplate>
                                             
                                             <asp:Literal ID="TDate" runat="server"     Text ='<%#Bind("OurTransDateF") %>' ></asp:Literal>
                                             
                                                
                                             
                                             </ItemTemplate>
                                             
                                             <EditItemTemplate>
                                                 <telerik:RadDatePicker ID="RadOurTransDateEdit" runat="server" DbSelectedDate='<%#Bind("OurTransDate") %>' Width="100px"  DateInput-DateFormat="dd/MM/yyyy"  >
                                                 </telerik:RadDatePicker>
                                             
                                             </EditItemTemplate>
                                             </telerik:GridTemplateColumn>                                
                                            
                                                                                    
                                            
                                              <telerik:GridBoundColumn DataField="ClientDocRev" HeaderText="Client Doc Rev"
                                                UniqueName="ClientDocRev">
                                            </telerik:GridBoundColumn>
                                            
                                            <telerik:GridTemplateColumn UniqueName="ClientTransRetDate" HeaderText="Client Rtrn Trans Date">
                                             <ItemTemplate>
                                                 <asp:Literal ID="TCDate" runat="server"     Text ='<%#Bind("ClientTransRetDateF") %>' ></asp:Literal>

                                                
                                             
                                             </ItemTemplate>
                                             
                                             <EditItemTemplate>
                                                 <telerik:RadDatePicker ID="RadCRtrnDateEdit" runat="server" DbSelectedDate='<%#Bind("ClientTransRetDate") %>' Width="100px"  DateInput-DateFormat="dd/MM/yyyy">
                                                 </telerik:RadDatePicker>
                                             
                                             </EditItemTemplate>
                                             </telerik:GridTemplateColumn>
                                           
                                            
                                             <telerik:GridBoundColumn DataField="ClientRtrnTransNo" HeaderText="Client Rtrn Trans No"
                                                UniqueName="ClientRtrnTransNo">
                                            </telerik:GridBoundColumn>
                                          
                                            <telerik:GridTemplateColumn UniqueName="ClientRtrnCodeID" HeaderText="Client Rtrn Code">
                                             <ItemTemplate>
                                     
                                             <telerik:RadComboBox runat="server"
                                                 ID="ddlClientReturn"
                                                 DataTextField="ReturnDescription"
                                                 DataValueField="ClientRtrnCodeID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="180px"
                                                 DropDownWidth="420px" Enabled="false"
                                                    DataSourceID="sqlClientReturn"
                                                    SelectedValue='<%#Bind("ClientRtrnCodeID") %>'></telerik:RadComboBox>
                                                    
                                     </ItemTemplate>
                                     <EditItemTemplate>
                                     
                                     <telerik:RadComboBox runat="server"
                                                 ID="ddlClientReturnEdit"
                                                 DataTextField="ReturnDescription"
                                                 DataValueField="ClientRtrnCodeID"
                                                 HighlightTemplatedItems="true"
                                                 Height="190px"
                                                 Width="180px"
                                                 DropDownWidth="420px"
                                                    DataSourceID="sqlClientReturn"
                                                    SelectedValue='<%#Bind("ClientRtrnCodeID") %>'></telerik:RadComboBox>
                         
                                     
                                     </EditItemTemplate>
                                     
                                     </telerik:GridTemplateColumn>
                                       <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" ConfirmText="Are you sure delete this record?"
                                            Text="Delete" UniqueName="column">
                                        </telerik:GridButtonColumn>
                                        </Columns>
                                    <EditFormSettings>
                                    <EditColumn UniqueName="EditCommandColumn1"></EditColumn>
                                    </EditFormSettings>
                                    </MasterTableView>
                                    </telerik:RadGrid>
                               
                                    <asp:SqlDataSource ID="SqlTransmital"
                                        
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>"
                                        SelectCommand="SELECT convert(varchar(10),OurTransDate,103) as OurTransDateF,convert(varchar(10),ClientTransRetDate,103) as ClientTransRetDateF, * FROM [tbl_DATA_Transmittals] WHERE (DocNo = @DocNo)"
                                        DeleteCommand ="Delete from [tbl_DATA_Transmittals] where TransID=@TransID"
                                        
                                        InsertCommand="insert into tbl_DATA_Transmittals ([OurDocRev],[OurTransDate],ReasonforIssueID,
                                        [ClientTransRetDate],[ClientRtrnTransNo],ClientRtrnCodeID,DocNo,ClientDocRev) values(@OurDocRev,@OurTransDate,
                                        @ReasonforIssueID,@ClientTransRetDate ,@ClientRtrnTransNo,@ClientRtrnCodeID,@DocNo,@ClientDocRev) "
                                        
                                        UpdateCommand="update tbl_DATA_Transmittals set [OurDocRev]=@OurDocRev, [OurTransDate]=@OurTransDate,
                                        ReasonforIssueID=@ReasonforIssueID, [ClientTransRetDate]=@ClientTransRetDate,
                                        [ClientRtrnTransNo]=@ClientRtrnTransNo,ClientRtrnCodeID=@ClientRtrnCodeID, ClientDocRev=@ClientDocRev where TransID=@TransID" runat="server">
                                                                                    
                                        
                                      <SelectParameters>                                                                           
                                            <asp:ControlParameter ControlID="Label1" PropertyName="Text" Type="String" Name="DocNo" />
                                        </SelectParameters>
                                        <DeleteParameters>
                                            <asp:Parameter Name="TransID" Type="Int32" />
                                        
                                        </DeleteParameters>
                                        
                                        <UpdateParameters>
                                        <asp:Parameter Name="TransID" Type="Int32" />                                    
                                        <asp:Parameter Name="OurDocRev" Type="String" />
                                        <asp:Parameter Name="OurTransDate" Type="DateTime" />
                                        <asp:Parameter Name="ReasonforIssueID" Type="Int32" />
                                        <asp:Parameter Name="ClientTransRetDate" Type="DateTime" />
                                        <asp:Parameter Name="ClientRtrnTransNo" Type="Int32" />
                                        <asp:Parameter Name="ClientRtrnCodeID" Type="Int32" />
                                        <asp:Parameter Name="ClientDocRev" Type="Int32" />
                                        
                                        
                                        </UpdateParameters>
                                        
                                        <InsertParameters>    
                                        <asp:Parameter Name="OurDocRev" Type="String" />
                                        <asp:Parameter Name="OurTransDate" Type="DateTime" />                                   
                                        <asp:Parameter Name="ReasonforIssueID" Type="Int32" />
                                        <asp:Parameter Name="ClientTransRetDate" Type="DateTime" />
                                        <asp:Parameter Name="ClientRtrnTransNo" Type="Int32" />
                                        <asp:Parameter Name="ClientRtrnCodeID" Type="Int32" />
                                        <asp:ControlParameter ControlID="Label1" PropertyName="Text" Type="String" Name="DocNo" />
                                        <asp:Parameter Name="ClientDocRev" Type="Int32" />
                                           
                               


                                        </InsertParameters>

                                        
                                    </asp:SqlDataSource>
                            </telerik:RadPageView>
                            <telerik:radpageview ID="PagePlaning" runat="server">
                            
                            <table>
                                <tr>
                                    <td>
                                    <table>
                                    <tbody>
                                            <tr>
                                                <td>
                                                    <telerik:RadCalendar ID="sharedCalendar" runat="server"  EnableMultiSelect="false" MinDate="2000/1/1"
                 />
                                                </td>
                                            
                                                <td>
                                                    <b>Plan </b>
                                                </td>
                                                <td>
                                                    <b>Forecast </b>
                                                </td>
                                                <td>
                                                    <b>Actual </b>
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                            <tr>
                                                <td>
                                                    <b>Doc Start </b>
                                                </td>
                                            
                                                <td>
                                                    <telerik:RadDatePicker ID="dtpDocStart"      DbSelectedDate='<%# Bind("DocuStartP") %>' SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput44" runat="server"    DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="RadDocuStartF"     DbSelectedDate='<%# Bind("DocuStartF") %>' SharedCalendarID="sharedCalendar" Width="100px"    runat="server">
                                                    <DateInput ID="DateInput43" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                     <telerik:RadDatePicker ID="RadDocuStartA"     DbSelectedDate='<%# Bind("DocuStartA")  %>' SharedCalendarID="sharedCalendar" Width="100px"    runat="server">
                                                    <DateInput ID="DateInput42" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                                                        
                                            </tr>
                                            
                                             <tr>
                                                <td>
                                                    <b>Doc End </b>
                                                </td>
                                            
                                                <td>
                                                    <telerik:RadDatePicker ID="RadDocuEndP"     DbSelectedDate='<%# Bind("DocuEndP") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput41" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="RadDocuEndF"     DbSelectedDate='<%# Bind("DocuEndF") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                   <DateInput ID="DateInput40" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                   </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                   <telerik:RadDatePicker ID="RadDocuEndA"     DbSelectedDate='<%# Bind("DocuEndA")  %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput39" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                           <tr>
                                                <td>
                                                    <b>IDC Start </b>
                                                </td>
                                            
                                                <td>
                                                    <telerik:RadDatePicker ID="RadSubmitForIDCP"     DbSelectedDate='<%# Bind("SubmitForIDCP") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput38" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="RadSubmitForIDCF"     DbSelectedDate='<%# Bind("SubmitForIDCF") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput37" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="RadSubmitForIDCA"     DbSelectedDate='<%# Bind("SubmitForIDCA")  %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput36" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                                                        
                                            </tr>
                                                        
                                                       
                                             <tr>
                                                <td>
                                                    <b>IDC End </b>
                                                </td>
                                            
                                                <td>
                                                    <telerik:RadDatePicker ID="RadReturnFromIDCP"     DbSelectedDate='<%# Bind("ReturnFromIDCP") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                   <DateInput ID="DateInput35" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="RadReturnFromIDCF"     DbSelectedDate='<%# Bind("ReturnFromIDCF") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput34" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                     <telerik:RadDatePicker ID="RadReturnFromIDCA"     DbSelectedDate='<%# Bind("ReturnFromIDCA")  %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                   <DateInput ID="DateInput33" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                             <tr>
                                                <td>
                                                    <b>IFC Sent </b>
                                                </td>
                                            
                                                <td>
                                                    <telerik:RadDatePicker ID="RadIssueForCommentsP"     DbSelectedDate='<%# Bind("IssueForCommentsP") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                   <DateInput ID="DateInput32" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="RadIssueForCommentsF"     DbSelectedDate='<%# Bind("IssueForCommentsF") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                   <DateInput ID="DateInput31" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                <telerik:RadDatePicker ID="RadIssueForCommentsA"     DbSelectedDate='<%# Bind("IssueForCommentsA") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                 <DateInput ID="DateInput30" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                    
                                                    
                                                   
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                             <tr>
                                                <td>
                                                    <b>IFC Return </b>
                                                </td>
                                            
                                                <td>
                                                    <telerik:RadDatePicker ID="RadClientReturnedCommentsP"     DbSelectedDate='<%# Bind("ClientReturnedCommentsP") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput29" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="RadClientReturnedCommentsF"     DbSelectedDate='<%# Bind("ClientReturnedCommentsF") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                   <DateInput ID="DateInput28" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                 <telerik:RadDatePicker ID="RadClientReturnedCommentsA"     DbSelectedDate='<%# Bind("ClientReturnedCommentsA") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                  <DateInput ID="DateInput27" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                
                                                    
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                             <tr>
                                                <td>
                                                    <b>Owner Notified IFC </b>
                                                </td>
                                            
                                                <td>
                                                    <telerik:RadDatePicker ID="RadReceiveForCommentsP"     DbSelectedDate='<%# Bind("ReceiveForCommentsP") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput26" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="RadReceiveForCommentsF"     DbSelectedDate='<%# Bind("ReceiveForCommentsF") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                   <DateInput ID="DateInput25" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                <telerik:RadDatePicker ID="RadReceiveForCommentsA"     DbSelectedDate='<%# Bind("ReceiveForCommentsA") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                <DateInput ID="DateInput24" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                 </telerik:RadDatePicker>
                                                    
                                                 
                                                 
                                                  
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                              <tr>
                                                <td>
                                                    <b>Incorp Comment IFC </b>
                                                </td>
                                            
                                                <td>
                                                    <telerik:RadDatePicker ID="RadIncorporateCommentsP"     DbSelectedDate='<%# Bind("IncorporateCommentsP") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput23" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="RadIncorporateCommentsF"     DbSelectedDate='<%# Bind("IncorporateCommentsF") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                   <DateInput ID="DateInput22" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                 <telerik:RadDatePicker ID="RadIncorporateCommentsA"     DbSelectedDate='<%# Bind("IncorporateCommentsA") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                 <DateInput ID="DateInput21" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                 </telerik:RadDatePicker>
                                                    

                                                   
                                                </td>
                                                                                        
                                            </tr>
                                            
                                
                                    </table>     
                                
                                    
                                    </td>
                                    
                                    <td>
                                    
                                        <table>
                                           <tr>
                                                <td>
                                                    <b>Our Action </b>
                                                </td>
                                            
                                                <td>
                                                    <telerik:RadDatePicker ID="RadOURACTION"     DbSelectedDate='<%# Bind("OURACTION") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput20" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                    
                                                   
                                                </td>
                                                <td>
                                                    <b>Client Action </b>
                                                </td>
                                                <td>
                                                 <telerik:RadDatePicker ID="RadCLIENTACTION"     DbSelectedDate='<%# Bind("CLIENTACTION") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                   <DateInput ID="DateInput19" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                    
                                                    

                                                </td>
                                                                                        
                                            </tr>
                                            
                                             <tr>
                                                <td>
                                                    
                                                </td>
                                            
                                                <td>
                                                    <b>Plan </b>
                                                </td>
                                                <td>
                                                    <b>Forecast </b>
                                                </td>
                                                <td>
                                                    <b>Actual </b>
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                             <tr>
                                                <td>
                                                    <b>IFA Sent </b>
                                                </td>
                                            
                                                <td>
                                                    <telerik:RadDatePicker ID="RadIssueForApprovalP"     DbSelectedDate='<%# Bind("IssueForApprovalP") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput18" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="RadIssueForApprovalF"     DbSelectedDate='<%# Bind("IssueForApprovalF") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                   <DateInput ID="DateInput17" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                
                                                 <telerik:RadDatePicker ID="RadIssueForApprovalA"     DbSelectedDate='<%# Bind("IssueForApprovalA") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                  <DateInput ID="DateInput16" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                    
                                                    

                                                </td>
                                                                                        
                                            </tr>
                                            
                                        
                                          <tr>
                                                <td>
                                                    <b>IFA Return </b>
                                                </td>
                                            
                                                <td>
                                                    <telerik:RadDatePicker ID="RadClientReturnFromIFAP"     DbSelectedDate='<%# Bind("ClientReturnFromIFAP") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput15" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy"   />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="RadClientReturnFromIFAF"     DbSelectedDate='<%# Bind("ClientReturnFromIFAF") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                   <DateInput ID="DateInput14" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                 <telerik:RadDatePicker ID="RadClientReturnFromIFAA"     DbSelectedDate='<%# Bind("ClientReturnFromIFAA") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                  <DateInput ID="DateInput13" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                    

                                                </td>
                                                                                        
                                            </tr>
                                            
                                        
                                        
                                            <tr>
                                                <td>
                                                    <b>Owner Notified IFA</b>
                                                </td>
                                            
                                                <td>
                                                    <telerik:RadDatePicker ID="RadReceiveForComments2P"     DbSelectedDate='<%# Bind("ReceiveForComments2P") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput12" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="RadReceiveForComments2F"     DbSelectedDate='<%# Bind("ReceiveForComments2F") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                   <DateInput ID="DateInput11" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                
                                                 <telerik:RadDatePicker ID="RadReceiveForComments2A"     DbSelectedDate='<%# Bind("ReceiveForComments2A") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                   <DateInput ID="DateInput10" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                    
                                                 
                                                
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                             <tr>
                                                <td>
                                                    <b>Incorp Comment IFA</b>
                                                </td>
                                            
                                                <td>
                                                    <telerik:RadDatePicker ID="RadIncorporateComments2P"     DbSelectedDate='<%# Bind("IncorporateComments2P") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput9" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="RadIncorporateComments2F"     DbSelectedDate='<%# Bind("IncorporateComments2F") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput8" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                
                                                  <telerik:RadDatePicker ID="RadIncorporateComments2A"     DbSelectedDate='<%# Bind("IncorporateComments2A") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput7" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                   
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                            
                                             <tr>
                                                <td>
                                                    <b>AFC Sent</b>
                                                </td>
                                            
                                                <td>
                                                    <telerik:RadDatePicker ID="RadIssueForAFCP"     DbSelectedDate='<%# Bind("IssueForAFCP") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput6" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="RadIssueForAFCF"     DbSelectedDate='<%# Bind("IssueForAFCF") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput5" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                
                                                 <telerik:RadDatePicker ID="RadIssueForAFCA"     DbSelectedDate='<%# Bind("IssueForAFCA") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput4" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                   
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                             <tr>
                                                <td>
                                                    <b>AFC Return</b>
                                                </td>
                                            
                                                <td>
                                                    <telerik:RadDatePicker ID="RadReceiveAFCP"     DbSelectedDate='<%# Bind("ReceiveAFCP") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput3" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="RadReceiveAFCF"     DbSelectedDate='<%# Bind("ReceiveAFCF") %>'   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                    <DateInput ID="DateInput2" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                     <telerik:RadDatePicker ID="RadReceiveAFCA"     DbSelectedDate='<%# Bind("ReceiveAFCA")  %>' DateInput-DateFormat="dd/mmm/yyyy"   SharedCalendarID="sharedCalendar"  Width="100px"    runat="server">
                                                     <DateInput ID="DateInput1" runat="server" DateFormat ="dd/MM/yyyy"  DisplayDateFormat="dd/MM/yyyy" />
                                                    </telerik:RadDatePicker>
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                            
                                             <tr>
                                                <td>
                                                    <b>Progress %</b>
                                                </td>
                                                
                                                <td>
                                                    <asp:TextBox ID="txtProgress" Text='<%# Bind("Progress")  %>' Width="80px" runat="server"></asp:TextBox>
                                                </td>
                                                <td>
                                                   
                                                </td>
                                                <td>
                                                    
                                                </td>
                                                                                        
                                            </tr>
                                             <tr>
                                                <td>
                                                    <asp:Button ID="cmdUPlan" runat="server" Text="Update" CommandName="UpdatePlan" CommandArgument='<%Bind("DocNo") %>' />                            
                                                </td>
                                                <td>
                                                    <asp:Literal ID="ltrPlan"   runat="server"></asp:Literal>
                                                </td>
                                                <td>
                                                </td>
                                                <td>
                                                </td>
                                    
                                    
                                    </tr>
                                    
                                            
                                        </table>
                                    
                                    
                                    </td>
                                
                                
                                </tr>
                            
                            
                            </table>
                            
                            </telerik:RadPageView>
                            <telerik:radpageview ID="PageRemark" runat="server">
                               <table>
                                    <tbody>
                                    <tr>
                                        <td valign="top">
                                         <b>Remark</b>
                                        </td>
                                        <td>
                                            <asp:TextBox ID="txtREmark" Text='<%# Eval("Comments") %>' runat="server" Width="400px" Height="300px"></asp:TextBox>
                                            
                                        </td>
                                        </tr>
                                         <tr>
                                        <td>
                                            <asp:Button ID="cmdUpRemark" runat="server" Text="Update" CommandName="UpdateRemark" CommandArgument='<%Bind("DocNo") %>' />                            
                                        </td>
                                        <td>
                                            <asp:Literal ID="litRemark"   runat="server"></asp:Literal>
                                        </td>
                                    
                                    
                                    </tr>
                                    
                                    
                                        </tbody>
                                
                                </table>     
                            
                            </telerik:RadPageView>
                        </telerik:RadMultiPage>
         
            
              </asp:Panel>
        </NestedViewTemplate>
        
        <Columns>
            <telerik:gridboundcolumn DataField="DocNo" HeaderText="Doc No"
                UniqueName="DocNo">
            </telerik:GridBoundColumn>
            <telerik:gridboundcolumn DataField="[Document Title]"
                HeaderText="Document Title" UniqueName="DocumentTitle">
            </telerik:GridBoundColumn>
            <telerik:gridboundcolumn DataField="[Client Doc No]" HeaderText="Client Doc No"
                UniqueName="ClientDocNo">
            </telerik:GridBoundColumn>
       </Columns>   
    </MasterTableView>
            </telerik:RadGrid>
          
                  
           
                                        <asp:SqlDataSource ID="sqlCAMCat"                                                 
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT * FROM [tbl_LU_CategoryClass]"
                                        runat="server">
                                        </asp:SqlDataSource>
                                        
                                          <asp:SqlDataSource ID="sqlOWner"                                                 
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT * FROM [tbl_LU_DocOwnAppComment]"
                                        runat="server">
                                        </asp:SqlDataSource>
                                        
                                        <asp:SqlDataSource ID="sqlSunmit"                                                 
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT * FROM [tbl_LU_Submitables]"
                                        runat="server">
                                        </asp:SqlDataSource>
                                        
                                        
                                          <asp:SqlDataSource ID="sqlSystem"                                                 
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT * FROM [tbl_LU_Systems]"
                                        runat="server">
                                        </asp:SqlDataSource>
                                        
                                            <asp:SqlDataSource ID="sqlPackage"                                                 
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT * FROM [tbl_LU_Packages]"
                                        runat="server">
                                        </asp:SqlDataSource>
                                        
                                        <asp:SqlDataSource ID="sqlPhase"                                                 
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT * FROM [tbl_LU_Phases]"
                                        runat="server">
                                        </asp:SqlDataSource>
                                        
                                        <asp:SqlDataSource ID="sqlCTR"                                                 
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT ([CTR Number] +' '+[CTR Title]) as Title,[CTR Number], CTRID  FROM [tbl_LU_CTR]"
                                        runat="server">
                                        </asp:SqlDataSource>
                                        
                                        <asp:SqlDataSource ID="sqlReportCTR"                                                 
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT  ([Rep CTR Number] + ' '+[Rep CTR Title]) as CTRTitle ,[Rep CTR Number], RepCTRID   FROM [tbl_LU_ReportingCTR]"
                                        runat="server">
                                        </asp:SqlDataSource>
                                        
                                        
                                        
                                        <!--******************Cam CPY -->
                                        
                                        <asp:SqlDataSource ID="sqlClientDocType"                                                 
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT *   FROM [tbl_LU_ClientDocType]"
                                        runat="server">
                                        </asp:SqlDataSource>
                                        
                                        <asp:SqlDataSource ID="sqlClientSys"                                                 
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT *   FROM [tbl_LU_ClientSys_SubSysCode]"
                                        runat="server">
                                        </asp:SqlDataSource>
                                        
                                         <asp:SqlDataSource ID="sqlLiveData"                                                 
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT *   FROM [tbl_LU_LiveData]"
                                        runat="server">
                                        </asp:SqlDataSource>
                                        
                                         <asp:SqlDataSource ID="sqlNewDocument"                                                 
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT *   FROM [tbl_DATA_Docs]"
                                        runat="server">
                                        </asp:SqlDataSource>
                                        
                                        <!-- Transmital  -->
                                        
                                        
                                        <asp:SqlDataSource ID="sqlReason"                                                 
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT  *   FROM [tbl_LU_ReasonForIssue]"
                                        runat="server">
                                        </asp:SqlDataSource>
                                        
                                        
                                        <asp:SqlDataSource ID="sqlClientReturn"                                                 
                                        ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT [Client Rtrn Code]+' '+[Client Rtrn Description] as ReturnDescription,[Client Rtrn Code],ClientRtrnCodeID    FROM [tbl_LU_ClientRtrnCode]"
                                        runat="server">
                                        </asp:SqlDataSource>
                                        
                                                                            
                                
                                        
                                
                                    
            <br />              
                                    
            <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" Runat="server"
                Skin="Default">
            </telerik:RadAjaxLoadingPanel>
                                    
     
        
        
     
                                
                                    
                                    
                                  
                                  
        
     
        </form>
    </body>
    </html>
  2. Schlurk
    Schlurk avatar
    812 posts
    Member since:
    May 2009

    Posted 10 Sep 2009 Link to this post

    There are a couple of suggestions I could think of.
    First check out the RadGrid with LINQ demo which should be able to help out with some potential database interaction. You could also take a look at the RadGrid performance documentation to see if anything in there can help you.
    For the TabStrip I believe it would be best if you had some sort of Load-on-Demand feature since it seems that, coupled with the database queries, this entire TabStrip gets loaded. I would suggest looking into this demo and see if it helps you out.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. lakmal
    lakmal avatar
    76 posts
    Member since:
    Jun 2009

    Posted 14 Sep 2009 Link to this post

    HI,

    I have solve my issue. I have follow following tips

    1. Remove Update functionality in main page and put it to Popup window

    2. Use lingtosql datasource

    3. Remove all possible controls from tabs and use html databinding like MVC

    You can check speed now using link

    http://seeds-lanka.com/minute/document.aspx

    This is new code. If there is anything i can improve optimization ,pls let me know

    <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Document.aspx.cs" Inherits="Document" %>

    <%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>

    <%@ Register assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" namespace="System.Web.UI" tagprefix="asp" %>

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    <html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
      <style type="text/css">
        .viewWrap
        {
            padding:15px;
            background:#2291b5 0 0 url(Img/bluegradient.gif) repeat-x;
        }
        
        .contactWrap
        {
            padding:10px 15px 15px 15px;
            background:#fff;
            color:#333;
        }
        
        .contactWrap td
        {
            padding:0 20px 0 0;
        }
        
        .contactWrap td td
        {
            padding:3px 20px 3px 0;
        }
        
        .contactWrap img
        {
            border:1px solid #05679d;
        }
        
        </style>
        <title></title>
    </head>
    <body>
        <form id="form1" runat="server">
        <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
        </telerik:RadScriptManager>
        

        
            <br />
            <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"
                DefaultLoadingPanelID="RadAjaxLoadingPanel1">
                <AjaxSettings>
                    <telerik:AjaxSetting AjaxControlID="RadGrid4">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="RadGrid4" />
                        </UpdatedControls>
                    </telerik:AjaxSetting>
                </AjaxSettings>
            </telerik:RadAjaxManager>
          
        
    <telerik:RadGrid ID="RadGrid4" runat="server" AutoGenerateColumns="False"
                GridLines="None" onitemcommand="RadGrid1_ItemCommand" DataSourceID="ldsDocument"
                 Skin="Web20"
                 AllowFilteringByColumn="True"
                AllowPaging="True" AllowSorting="True"
            ondeletecommand="RadGrid4_DeleteCommand" AllowAutomaticInserts="True">
        <MasterTableView DataKeyNames="DocNo" CommandItemDisplay="TopAndBottom"
            InsertItemPageIndexAction="ShowItemOnFirstPage"
            DataSourceID="ldsDocument" >
        <RowIndicatorColumn>
        <HeaderStyle Width="20px"></HeaderStyle>
        </RowIndicatorColumn>

        <ExpandCollapseColumn>
        <HeaderStyle Width="20px"></HeaderStyle>
        </ExpandCollapseColumn>
            <NestedViewTemplate>
                        <asp:Panel runat="server" ID="InnerContainer" CssClass="viewWrap" Visible="false">
          
                     
            
                          <telerik:radtabstrip ID="RadTabStrip1" runat="server" SelectedIndex="0" AutoPostBack="true"
                            MultiPageID="RadMultiPage1" Skin="Web20">
                            <Tabs>
                                <telerik:radtab runat="server" Selected="True" Text="Document Info"  
                                    PageViewID="PageInfor">
                                </telerik:RadTab>
                                <telerik:radtab runat="server" Text="CAM CPY Info" PageViewID="PageCAM">
                                </telerik:RadTab>
                                <telerik:radtab runat="server" Text="IDC" PageViewID="PageIDC">
                                </telerik:RadTab>
                                <telerik:radtab runat="server" Text="Transmittal" PageViewID="PageTransmital">
                                </telerik:RadTab>
                                <telerik:radtab runat="server" Text="Planning Dates" PageViewID="PagePlaning">
                                </telerik:RadTab>
                                <telerik:radtab runat="server" Text="Remarks" PageViewID="PageRemark">
                                </telerik:RadTab>
                            </Tabs>
                        </telerik:RadTabStrip>
                        
                        <telerik:radmultipage ID="RadMultiPage1" Runat="server" SelectedIndex="0" RenderSelectedPageOnly ="true" >
                            <telerik:radpageview ID="PageInfor" runat="server" >
                                    
                                    <table>
                                    <tr>
                                        <td>
                                         <b>Document Number</b>
                                        </td>
                                        <td>
                                       
                                        <%# Eval("DocNo")%>
                                        
                                        
                                            
                                        
                                        </td>                               
                                    
                                    </tr>
                                    
                                     <tr>
                                        <td>
                                         <b>Document Title</b>
                                        </td>
                                        <td>
                                       
                                        <%# Eval("Document_Title") %>
                                       
                                            
                                        
                                        </td>                               
                                    
                                    </tr>
                                    
                                      <tr>
                                        <td>
                                         <b>Client Doc No</b>
                                        </td>
                                        <td>
                                       
                                        <%# Eval("Client_Doc_No") %>
                                        
                                       
                                            
                                        
                                        </td>                               
                                    
                                    </tr>
                                
                                 <tr>
                                        <td>
                                         <b>System</b>
                                        </td>
                                        <td>
                                        
                                        <%#Eval("System") %>  
                                        
                                                                                                       
                                        </td>                               
                                    
                                    </tr>
                                    
                                     <tr>
                                        <td>
                                         <b>Package</b>
                                        </td>
                                        <td>
                                        <%#Eval("Package") %>
                                        
                                                                                                   
                                        </td>                               
                                    
                                    </tr>
                                    
                                     <tr>
                                        <td>
                                         <b>Phase</b>
                                        </td>
                                        <td>
                                         <%#Eval("Phase") %>
                                                                                                       
                                        </td>                               
                                    
                                    </tr>
                                    
                                    <tr>
                                        <td>
                                         <b>CTR </b>
                                        </td>
                                        <td>
                                         <%#Eval("CTR_Title") %>
                                                                                                     
                                        </td>                               
                                    
                                    </tr>
                                    
                                    <tr>
                                        <td>
                                         <b>Reporting CTR </b>
                                        </td>
                                        <td>
                                                 <%# Eval("Rep_CTR_Title") %>   
                                                                                
                                        </td>                               
                                    
                                    </tr>
                                    
                                    <tr>
                                        <td>
                                            <asp:Button ID="cmdUpdateInfo" runat="server" Text="Update" CommandName="UpdateInfo" CommandArgument='<%Bind("DocNo") %>' />                            
                                        </td>
                                        <td>
                                          
                                        </td>
                                    
                                    
                                    </tr>
                                    
                                
                                </table>  
                                        
                                                       
                                
                            </telerik:RadPageView>
                            <telerik:radpageview ID="PageCAM" runat="server">
                            
                              <table>
                                    <tr>
                                        <td>
                                         <b>CAM Category</b>
                                        </td>
                                        <td>
                                        <%#Eval("CategoryClass") %>
                                        
                                            
                                        
                                        </td>                               
                                    
                                    </tr>
                                    
                                     <tr>
                                        <td>
                                         <b>Client Doc Type</b>
                                        </td>
                                        <td>
                                        <%#Eval("Submitable") %>
                                        
                                          
                                                                            
                                        </td>                               
                                    
                                    </tr>
                                    
                                    
                                      <tr>
                                        <td>
                                         <b>Client Sys/SubSys</b>
                                        </td>
                                        <td>
                                        <%#Eval("ClientSys_SubSysCode") %>
                                        
                                                                                          
                                        </td>                               
                                    
                                    </tr>
                                    
                                    
                                     <tr>
                                        <td>
                                         <b>Document Owner</b>
                                        </td>
                                        <td>
                                        
                                        <%#Eval("DocOwner") %>
                                        
                                                                          
                                        </td>                               
                                    
                                    </tr>
                                    
                                     <tr>
                                        <td>
                                         <b>IDC Approver</b>
                                        </td>
                                        <td>
                                        <%#Eval("IDCAppID") %>
                                        
                                                                                              
                                        </td>                               
                                    
                                    </tr>
                                    
                                    
                                      <tr>
                                        <td>
                                         <b>Submitable</b>
                                        </td>
                                        <td>
                                        
                                        <%#Eval("Submitable") %>
                                        
                                                                                             
                                        </td>                               
                                    
                                    </tr>
                                    
                                    
                                    
                                    
                                    
                                   
                                    
                                    <tr>
                                        <td>
                                         <b>Live Data </b>
                                        </td>
                                        <td>
                                        <%#Eval("Live_Data") %>
                                        
                                                                                                   
                                        </td>                               
                                    
                                    </tr>
                                    
                                     <tr>
                                        <td>
                                         <b>New Document  </b>
                                        </td>
                                        <td>
                                             '<%# Eval("New_Document") %>'   
                                            
                                                                            
                                        </td>                               
                                    
                                    </tr>
                                    
                                     <tr>
                                        <td>
                                            <asp:Button ID="cmdCamCat" runat="server" Text="Update" CommandName="UpdateCam" CommandArgument='<%Bind("DocNo") %>' />                            
                                        </td>
                                        <td>
                                            <asp:Literal ID="litCam"   runat="server"></asp:Literal>
                                        </td>
                                    
                                    
                                    </tr>
                                    
                                    
                                
                                
                                </table>   
                            
                            </telerik:RadPageView>
                            
                            <telerik:radpageview ID="PageIDC" runat="server">
                                <asp:Label ID="Label1" runat="server" Font-Bold="true" Font-Italic="true" Text='<%# Eval("DocNo") %>'></asp:Label>
                                 
                
                                 <telerik:RadGrid ID="RadGrid5" runat="server" AutoGenerateColumns="False"   
                                     GridLines="None" DataSourceID="SqlDataSource2" Width="400px"
                                    AllowSorting="True" Skin="Web20" >
                                    <MasterTableView AutoGenerateColumns="False"  
                                        >
                                    
                                        <Columns>
                                            
                                         <telerik:GridBoundColumn DataField="DocOwnAppComment" HeaderText="Document Owner" ReadOnly="true"
                                                UniqueName="DocNo">
                                            </telerik:GridBoundColumn>
                                         
                                          </Columns>
                                        
                                    </MasterTableView>
                                  </telerik:RadGrid>
                               
                                 <asp:LinqDataSource ID="SqlDataSource2" runat="server" ContextTypeName="DataClassesDataContext"
                                            TableName="qry_Data_IDCcomments"
                                    AutoPage="False" Where="DocNo == @DocNo">
                                                  <WhereParameters>
                                                      <asp:ControlParameter ControlID="Label1" DefaultValue="0" Name="DocNo"
                                                          PropertyName="Text" Type="String" />
                                                  </WhereParameters>
                                    </asp:LinqDataSource>          
                   
                                      
                                    
                                 <asp:Button ID="cmdUpdateIDC" runat="server" Text="Update"  CommandName="UpdateIDC" CommandArgument='<%Bind("DocNo") %>' />                            
                                     
                            
                            </telerik:RadPageView>
                            
                            <telerik:radpageview ID="PageTransmital" runat="server">                        
                                    <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" Width="750px"  
                                     GridLines="None" DataSourceID="SqlTransmital"
                                    AllowSorting="True" Skin="Web20"   >
                                    <MasterTableView AutoGenerateColumns="False"  >                                
                                      <Columns>
                                      
                                            <telerik:GridBoundColumn DataField="Reason_for_Issue" HeaderText="Reason for Issue"
                                                UniqueName="ReasonforIssue">
                                            </telerik:GridBoundColumn>
                                            
                                            
                                             <telerik:GridBoundColumn DataField="OurDocRev" HeaderText="OurDocRev"
                                                UniqueName="OurDocRev">
                                            </telerik:GridBoundColumn>
                                            
                                            
                                            <telerik:GridBoundColumn DataField="OurTransDate" HeaderText="OurTransDate"   DataFormatString="{0:dd-MM-yyyy}"
                                                UniqueName="OurTransDate">
                                            </telerik:GridBoundColumn>                                                                                
                                            
                                              <telerik:GridBoundColumn DataField="ClientDocRev" HeaderText="Client Doc Rev"
                                                UniqueName="ClientDocRev">
                                            </telerik:GridBoundColumn>
                                            
                                            
                                              <telerik:GridBoundColumn DataField="ClientTransRetDate" HeaderText="Client Trans Ret Date"  DataFormatString="{0:dd-MM-yyyy}"
                                                UniqueName="ClientTransRetDate">
                                            </telerik:GridBoundColumn>
                                           
                                            
                                             <telerik:GridBoundColumn DataField="ClientRtrnTransNo" HeaderText="Client Rtrn Trans No"
                                                UniqueName="ClientRtrnTransNo">
                                            </telerik:GridBoundColumn>
                                            
                                             <telerik:GridBoundColumn DataField="Client_Rtrn_Code" HeaderText="Client Rtrn Code"
                                                UniqueName="ClientRtrnCode">
                                            </telerik:GridBoundColumn>
                                            
                                      
                                        </Columns>
                                   
                                    </MasterTableView>
                                    </telerik:RadGrid>
                                    
                                    
                                    
                                     <asp:LinqDataSource ID="SqlTransmital" runat="server" ContextTypeName="DataClassesDataContext"
                                            TableName="qry_Data_Transmittals"
                                    AutoPage="False" Where="DocNo == @DocNo">
                                                  <WhereParameters>
                                                      <asp:ControlParameter ControlID="Label1" DefaultValue="0" Name="DocNo"
                                                          PropertyName="Text" Type="String" />
                                                  </WhereParameters>
                                    </asp:LinqDataSource>
                                        
                                        
                                     <asp:Button ID="cmdUpTran" runat="server" Text="Update"  CommandName="UpdateTrn" CommandArgument='<%Bind("DocNo") %>' />                            
                                        
                                        
                            </telerik:RadPageView>
                            <telerik:radpageview ID="PagePlaning" runat="server">
                            
                            <table>
                                <tr>
                                    <td >
                                    <table width="500px">
                                    <tbody>
                                            <tr>
                                                <td>
                                                   
                                                </td>
                                            
                                                <td>
                                                    <b>Plan </b>
                                                </td>
                                                <td>
                                                    <b>Forecast </b>
                                                </td>
                                                <td>
                                                    <b>Actual </b>
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                            <tr>
                                                <td>
                                                    <b>Doc Start </b>
                                                </td>
                                            
                                                <td>
                                                    <%# Eval("DocuStartP","{0:dd-MM-yyyy}") %>
                                                   
                                                </td>
                                                <td>
                                                    <%# Eval("DocuStartF","{0:dd-MM-yyyy}") %>
                                                
                                                   
                                                </td>
                                                <td>
                                                <%# Eval("DocuStartA","{0:dd-MM-yyyy}") %>
                                                     
                                                </td>
                                                                                        
                                            </tr>
                                            
                                             <tr>
                                                <td>
                                                    <b>Doc End </b>
                                                </td>
                                            
                                                <td>
                                                <%# Eval("DocuEndP","{0:dd-MM-yyyy}") %>
                                                    
                                                </td>
                                                <td>
                                                <%# Eval("DocuEndF","{0:dd-MM-yyyy}") %>
                                                   
                                                </td>
                                                <td>
                                                <%# Eval("DocuEndA","{0:dd-MM-yyyy}") %>
                                                  
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                           <tr>
                                                <td>
                                                    <b>IDC Start </b>
                                                </td>
                                            
                                                <td>
                                                <%# Eval("SubmitForIDCP","{0:dd-MM-yyyy}") %>
                                                   
                                                </td>
                                                <td>
                                                <%# Eval("SubmitForIDCF","{0:dd-MM-yyyy}") %>
                                                   
                                                </td>
                                                <td>
                                                <%# Eval("SubmitForIDCA","{0:dd-MM-yyyy}") %>
                                                   
                                                </td>
                                                                                        
                                            </tr>
                                                        
                                                       
                                             <tr>
                                                <td>
                                                    <b>IDC End </b>
                                                </td>
                                            
                                                <td>
                                                <%# Eval("ReturnFromIDCP","{0:dd-MM-yyyy}") %>
                                                   
                                                </td>
                                                <td>
                                                <%# Eval("ReturnFromIDCF","{0:dd-MM-yyyy}") %>
                                                   
                                                </td>
                                                <td>
                                                <%# Eval("ReturnFromIDCA","{0:dd-MM-yyyy}") %>
                                                   
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                             <tr>
                                                <td>
                                                    <b>IFC Sent </b>
                                                </td>
                                            
                                                <td>
                                                <%# Eval("IssueForCommentsP","{0:dd-MM-yyyy}") %>
                                                   
                                                </td>
                                                <td>
                                                <%# Eval("IssueForCommentsF","{0:dd-MM-yyyy}") %>
                                                   
                                                </td>
                                                <td>
                                                <%# Eval("IssueForCommentsA","{0:dd-MM-yyyy}") %>
                                                    
                                                   
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                             <tr>
                                                <td>
                                                    <b>IFC Return </b>
                                                </td>
                                            
                                                <td>
                                                <%# Eval("ClientReturnedCommentsP","{0:dd-MM-yyyy}") %>
                                                   
                                                </td>
                                                <td>
                                                <%# Eval("ClientReturnedCommentsF","{0:dd-MM-yyyy}") %>
                                                  
                                                </td>
                                                <td>
                                                <%# Eval("ClientReturnedCommentsA","{0:dd-MM-yyyy}") %>
                                                                                           
                                                    
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                             <tr>
                                                <td>
                                                    <b>Owner Notified IFC </b>
                                                </td>
                                            
                                                <td>
                                                <%# Eval("ReceiveForCommentsP","{0:dd-MM-yyyy}") %>
                                                  
                                                </td>
                                                <td>
                                                <%# Eval("ReceiveForCommentsF","{0:dd-MM-yyyy}") %>
                                                 
                                                </td>
                                                <td>
                                                <%# Eval("ReceiveForCommentsA","{0:dd-MM-yyyy}") %>
                                                                                            
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                              <tr>
                                                <td>
                                                    <b>Incorp Comment IFC </b>
                                                </td>
                                            
                                                <td>
                                                <%# Eval("IncorporateCommentsP","{0:dd-MM-yyyy}") %>
                                                   
                                                </td>
                                                <td>
                                                <%# Eval("IncorporateCommentsF","{0:dd-MM-yyyy}") %>
                                                  
                                                </td>
                                                <td>
                                                <%# Eval("IncorporateCommentsA","{0:dd-MM-yyyy}") %>
                                                 
                                                </td>
                                                                                        
                                            </tr>
                                            
                                
                                    </table>     
                                
                                    
                                    </td>
                                    
                                    <td>
                                    
                                        <table width="500px">
                                           <tr>
                                                <td>
                                                    <b>Our Action </b>
                                                </td>
                                            
                                                <td>
                                                <%# Eval("OURACTION","{0:dd-MM-yyyy}") %>
                                                 
                                                </td>
                                                <td>
                                                    <b>Client Action </b>
                                                </td>
                                                <td>
                                                <%# Eval("CLIENTACTION","{0:dd-MM-yyyy}") %>
                                               
                                                </td>
                                                                                        
                                            </tr>
                                            
                                             <tr>
                                                <td>
                                                    
                                                </td>
                                            
                                                <td>
                                                    <b>Plan </b>
                                                </td>
                                                <td>
                                                    <b>Forecast </b>
                                                </td>
                                                <td>
                                                    <b>Actual </b>
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                             <tr>
                                                <td>
                                                    <b>IFA Sent </b>
                                                </td>
                                            
                                                <td>
                                                <%# Eval("IssueForApprovalP","{0:dd-MM-yyyy}") %>
                                                 
                                                </td>
                                                <td>
                                                <%# Eval("IssueForApprovalF","{0:dd-MM-yyyy}") %>
                                                
                                                </td>
                                                <td>
                                                <%# Eval("IssueForApprovalA","{0:dd-MM-yyyy}") %>
                                               

                                                </td>
                                                                                        
                                            </tr>
                                            
                                        
                                          <tr>
                                                <td>
                                                    <b>IFA Return </b>
                                                </td>
                                            
                                                <td>
                                                <%# Eval("ClientReturnFromIFAP","{0:dd-MM-yyyy}") %>
                                                
                                                </td>
                                                <td>
                                                <%# Eval("ClientReturnFromIFAF","{0:dd-MM-yyyy}") %>
                                                
                                                </td>
                                                <td>
                                                <%# Eval("ClientReturnFromIFAA","{0:dd-MM-yyyy}") %>
                                              

                                                </td>
                                                                                        
                                            </tr>
                                            
                                        
                                        
                                            <tr>
                                                <td>
                                                    <b>Owner Notified IFA</b>
                                                </td>
                                            
                                                <td>
                                                <%# Eval("ReceiveForComments2P","{0:dd-MM-yyyy}") %>
                                                
                                                </td>
                                                <td>
                                                <%# Eval("ReceiveForComments2F","{0:dd-MM-yyyy}") %>
                                               
                                                </td>
                                                <td>
                                                <%# Eval("ReceiveForComments2A","{0:dd-MM-yyyy}") %>
                                                
                                                
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                             <tr>
                                                <td>
                                                    <b>Incorp Comment IFA</b>
                                                </td>
                                            
                                                <td>
                                                <%# Eval("IncorporateComments2P","{0:dd-MM-yyyy}") %>
                                                  
                                                </td>
                                                <td>
                                                <%# Eval("IncorporateComments2F","{0:dd-MM-yyyy}") %>
                                                  
                                                </td>
                                                <td>
                                                <%# Eval("IncorporateComments2A","{0:dd-MM-yyyy}") %>
                                                 
                                                   
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                            
                                             <tr>
                                                <td>
                                                    <b>AFC Sent</b>
                                                </td>
                                            
                                                <td>
                                                <%# Eval("IssueForAFCP","{0:dd-MM-yyyy}") %>
                                                  
                                                </td>
                                                <td>
                                                <%# Eval("IssueForAFCF","{0:dd-MM-yyyy}") %>
                                                
                                                </td>
                                                <td>
                                                <%# Eval("IssueForAFCA","{0:dd-MM-yyyy}") %>
                                             
                                                   
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                             <tr>
                                                <td>
                                                    <b>AFC Return</b>
                                                </td>
                                            
                                                <td>
                                                <%# Eval("ReceiveAFCP","{0:dd-MM-yyyy}") %>
                                               
                                                </td>
                                                <td>
                                                <%# Eval("ReceiveAFCF","{0:dd-MM-yyyy}") %>
                                                
                                                </td>
                                                <td>
                                                <%# Eval("ReceiveAFCA","{0:dd-MM-yyyy}") %>
                                                 
                                                </td>
                                                                                        
                                            </tr>
                                            
                                            
                                            
                                             <tr>
                                                <td>
                                                    <b>Progress %</b>
                                                </td>
                                                
                                                <td>
                                                <%# Eval("Progress") %>
                                                </td>
                                                <td>
                                                   
                                                </td>
                                                <td>
                                                    
                                                </td>
                                                                                        
                                            </tr>
                                             <tr>
                                                <td>
                                                    <asp:Button ID="cmdUPlan" runat="server" Text="Update" CommandName="UpdatePlan" CommandArgument='<%Bind("DocNo") %>' />                            
                                                </td>
                                                <td>
                                                    <asp:Literal ID="ltrPlan"   runat="server"></asp:Literal>
                                                </td>
                                                <td>
                                                </td>
                                                <td>
                                                </td>
                                    
                                    
                                    </tr>                                
                                            
                                        </table>
                                    
                                    
                                    </td>
                                
                                
                                </tr>
                            
                            
                            </table>
                            
                            </telerik:RadPageView>
                            <telerik:radpageview ID="PageRemark" runat="server">
                               <table>
                                    <tbody>
                                    <tr>
                                        <td valign="top">
                                         <b>Remark</b>
                                        </td>
                                        <td>
                                        <%# Eval("Comments") %>
                                            
                                        </td>
                                        </tr>
                                         <tr>
                                        <td>
                                            <asp:Button ID="cmdUpRemark" runat="server" Text="Update" CommandName="UpdateRemark" CommandArgument='<%Bind("DocNo") %>' />                            
                                        </td>
                                        <td>
                                            <asp:Literal ID="litRemark"   runat="server"></asp:Literal>
                                        </td>
                                    
                                    
                                    </tr>
                                    
                                    
                                        </tbody>
                                
                                </table>     
                            
                            </telerik:RadPageView>
                        </telerik:RadMultiPage>
                        <asp:Literal ID="ltrInfo"   runat="server"></asp:Literal>
           
            
              </asp:Panel>
        </NestedViewTemplate>
        
        <Columns>
            <telerik:gridboundcolumn DataField="DocNo" HeaderText="Doc No"
                UniqueName="DocNo">
            </telerik:GridBoundColumn>
            <telerik:gridboundcolumn DataField="Document_Title"
                HeaderText="Document Title" UniqueName="DocumentTitle">
            </telerik:GridBoundColumn>
            <telerik:gridboundcolumn DataField="Client_Doc_No" HeaderText="Client Doc No"
                UniqueName="ClientDocNo">
            </telerik:GridBoundColumn>
            <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" ConfirmDialogType="RadWindow" ConfirmText="Are you sure delete this record?"
                Text="Delete" UniqueName="column">
            </telerik:GridButtonColumn>
       </Columns>   
    </MasterTableView>
            </telerik:RadGrid>          
                                
                                    
            <br />  
            <asp:Literal ID="ltrInfo"   runat="server"></asp:Literal>
                        
                                    
            <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" Runat="server"
                Skin="Default">
            </telerik:RadAjaxLoadingPanel>
            
               <asp:LinqDataSource ID="ldsDocument" runat="server" ContextTypeName="DataClassesDataContext"
                                            TableName="qry_Data_Docs" AutoPage="False">
                                                  </asp:LinqDataSource>
                                                  
                                                  
     
                               
     
        </form>
    </body>
    </html>

Back to Top