<%@ Page Language="vb" AutoEventWireup="false" MasterPageFile="~/FiniqAppMasterPage.Master" CodeBehind="Static_Data_View.aspx.vb" Inherits="FinIQWebApp.Static_Data_View" Title="Static Data View" %>

<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="Server">

    <link href="../App_Themes/Style1.css" rel="stylesheet" type="text/css" />
    	    <%--Start Added by shubham k on 22-Feb-21 for UBP UI Standard--%>
        <link href="../FinIQJS/FreezeGrid.css" type="text/css" rel="stylesheet">
 <script src="../FinIQJS/FreezeGrid.js" type="text/javascript"></script> 
    <%--End Added by shubham k on 22-Feb-21 for UBP UI Standard--%>
    <%--    <asp:ScriptManagerProxy ID="ScriptManagerProxy" runat="server">
    </asp:ScriptManagerProxy>--%>
    <style>
        /*Start Added by shubham k on 22-Feb-2021 for UBP*/
        .btn_padding {
            padding-right: 10px !important;
            padding-top: 5px !important;
        }
        /*End Added by shubham k on 22-Feb-2021 for UBP*/
    </style>
    <script type="text/javascript">

        //Changed by Akanksha P on 22-10-18 as suggested by Netra S
        function AllowAlphaNumericSpecialCharOnly() {
            try {


                var keycode;
                if (window.event)
                    keycode = window.event.keyCode;
                else if (event)
                    keycode = event.keyCode;
                else if (e)
                    keycode = e.which;
                else return true;
                if ((keycode > 47 && keycode <= 57) || (keycode > 63 && keycode < 91) || (keycode > 96 && keycode < 123)) {

                    return true;

                }
                else if ((keycode == 38) || (keycode == 39) || (keycode == 45) || (keycode == 46) || (keycode == 95) || (keycode == 124)) {
                    return true;

                }

                else {
                    return false;
                }
                return true;

            } catch (err) {
                console.log(err.message)
            }
        }
        //Change end
        //Start Added by shubham k on 22-Feb-2021 for UBP
        document.onkeyup = function (e) {
            if (e.ctrlKey && e.key == "r") {
                document.getElementById('<%= btnLoad.ClientID %>').click();
            } else if (e.ctrlKey && e.shiftKey && e.key == "E") {
                document.getElementById('<%= btnExport.ClientID %>').click();
            }
        }
        //End Added by shubham k on 22-Feb-2021 for UBP

    </script>
    <div>

        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
            <ContentTemplate>

                <table id="tblMain" runat="server">

                    <tr>
                        <td colspan="6">
                            <asp:Label ID="lblError" runat="server" Text="" CssClass="LBLERROR"></asp:Label>
                            <asp:Label ID="lblWarning" runat="server" Text="" CssClass="lblinfo"></asp:Label>
                            <asp:Label ID="lblInfo" runat="server" Text="" CssClass="lblinfo"></asp:Label>
                        </td>
                    </tr>

                    <tr>
                        <td class="lblBlotterPaddingRight btn_padding">


                            <asp:Label Text="Entity" ID="lblEntity" CssClass="lbl" runat="server"></asp:Label>
                        </td>
                        <td class="ctlBlotterPaddingRight btn_padding">
                            <asp:DropDownList ID="ddlentity" runat="server" CssClass="ddl" Width="185px">
                            </asp:DropDownList>

                        </td>


                        <td class="btn_padding">
                            <asp:TextBox ID="txtsearch" runat="server" CssClass="txt" Style="margin-left: 0px" OnKeyPress="return AllowAlphaNumericSpecialCharOnly();"></asp:TextBox>
                            <%--changed by Akanksha P on 22-10-18--%>
                            <asp:Button ID="btnSearch1" runat="server" Style="display: none"></asp:Button>


                        </td>
                        <td class="ctlBlotterPaddingRight btn_padding">
                            <asp:Button ID="btnSearch" runat="server" CssClass="btnSearch" />
                        </td>


                        <td class="ctlBlotterPaddingRight btn_padding">
                            <asp:Button ID="btnLoad" runat="server" ToolTip="Load (ctrl + r)" CssClass="btn" Text="Load" Width="111px" />

                        </td>

                        <td class="lblBlotterPaddingRight btn_padding">
                            <asp:Label ID="Label5" Text="Record(s) Per Page" CssClass="lbl" runat="server"></asp:Label>
                        </td>
                        <td class="lblBlotterPaddingRight btn_padding">

                            <asp:TextBox ID="txtrowsperpage" runat="server" Width="30px" Style="text-align: center;" MaxLength="2" OnKeyPress=" return AllowNumericOnly(this);"></asp:TextBox>
                            <asp:Button ID="btnSetPageSize" runat="server" Style="display: none"></asp:Button>

                        </td>
                    </tr>

                    <tr>

                        <td class="lblBlotterPaddingRight btn_padding">
                            <asp:Label Text="View" ID="lblView" CssClass="lbl" runat="server">

                            </asp:Label>
                        </td>

                        <td class="btn_padding">
                            <asp:DropDownList ID="ddlview" runat="server" AutoPostBack="True" CssClass="ddl" Width="185px">
                            </asp:DropDownList>

                        </td>
                        <td></td>
                        <td></td>
                        <td class="btn_padding"><%--Added by shubham k on 22-Feb-2021 for UBP , added export to excel class--%>
                            <asp:Button ID="btnExport" runat="server" style="margin-right:30px !important" CssClass="Export2Excel" Text="" ToolTip="Export Excel (ctrl + shift + e)" Width="111px" />

                        </td>

                        <td class="btn_padding">
                            <asp:Label ID="lblTotal" runat="server" CssClass="lbl" Text=" Total Record(s): "><%--Added by shubham k on 22-Feb-2021 for UBP--%>
                            </asp:Label>
                        </td>
                        <td class="btn_padding">

                            <asp:Label ID="txtcount1" CssClass="lbl" runat="server"></asp:Label>


                        </td>

                    </tr>

                </table>

                <table style="margin-top: 10px">
                    <tr>
                        <td>

                            <asp:UpdatePanel runat="server" ID="upd1">
                                <ContentTemplate>

                                    <%--Added by shubham k on 22-Feb-2021 for UBP, added frozen grid remove Width="500px"--%>
                                    <asp:GridView ID="dgBook" runat="server" AutoGenerateColumns="false" CssClass="Grid frozenGrid" AllowSorting="False"
                                        BorderStyle="None" AllowPaging="true" PageSize="10" ViewStateMode="Enabled" ShowHeaderWhenEmpty="true">
                                        <SelectedRowStyle CssClass="GridItemSelect" />
                                        <RowStyle CssClass="GridItem" />
                                        <HeaderStyle CssClass="GridHeader" />
                                        <FooterStyle CssClass="GridFooter" />
                                        <PagerStyle CssClass="GridPager" />

                                        <Columns>
                                            <asp:TemplateField HeaderText="ID" SortExpression="ID">
                                                <ItemStyle Wrap="False" HorizontalAlign="Center"></ItemStyle>
                                                <FooterStyle HorizontalAlign="Center" />
                                                <HeaderStyle HorizontalAlign="Center" />
                                                <ItemStyle HorizontalAlign="Center" />
                                                <ItemTemplate>
                                                    <asp:Label ID="lblID" runat="server" Text='<%# Eval("ID")%>' CssClass="lbl">
                                                    </asp:Label>

                                                </ItemTemplate>


                                            </asp:TemplateField>
                                            <asp:TemplateField HeaderText="Dept. Name" SortExpression="Dept_Name" ItemStyle-HorizontalAlign="Left">
                                                <ItemStyle Wrap="False" HorizontalAlign="Left"></ItemStyle>
                                                <FooterStyle HorizontalAlign="Left" />
                                                <HeaderStyle HorizontalAlign="Center" />
                                                <ItemTemplate>
                                                    <asp:Label ID="lblDeptName" runat="server" Text='<%# Eval("Dept_Name")%>' CssClass="lbl">
                                                    </asp:Label>

                                                </ItemTemplate>


                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Phone No." SortExpression="Phone_No">
                                                <ItemStyle Wrap="False" HorizontalAlign="Right"></ItemStyle>
                                                <FooterStyle HorizontalAlign="Right" />
                                                <HeaderStyle HorizontalAlign="Center" />
                                                <ItemStyle Wrap="False" HorizontalAlign="Right"></ItemStyle>
                                                <ItemTemplate>
                                                    <asp:Label ID="lblPhoneNo" runat="server" Text='<%# Eval("Phone_No")%>' CssClass="lbl">
                                                    </asp:Label>

                                                </ItemTemplate>


                                            </asp:TemplateField>


                                            <asp:TemplateField HeaderText="Active YN" SortExpression="Active_YN">
                                                <ItemStyle Wrap="False" HorizontalAlign="Center"></ItemStyle>
                                                <FooterStyle HorizontalAlign="Center" />
                                                <HeaderStyle HorizontalAlign="Center" />
                                                <ItemStyle Wrap="False" HorizontalAlign="Center"></ItemStyle>
                                                <ItemTemplate>
                                                    <asp:Label ID="lblActiveYN" runat="server" Text='<%# Eval("Active_YN")%>' CssClass="lbl">
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>




                                        </Columns>
                                    </asp:GridView>
                                    <%--Added by shubham k on 22-Feb-2021 for UBP, added frozen grid remove Width="500px"--%>
                                    <asp:GridView ID="dgCustomerGroup" runat="server" AutoGenerateColumns="false" CssClass="Grid frozenGrid" AllowSorting="False"
                                        BorderStyle="None" AllowPaging="true" PageSize="10"  ViewStateMode="Enabled" ShowHeaderWhenEmpty="true">
                                        <SelectedRowStyle CssClass="GridItemSelect" />
                                        <RowStyle CssClass="GridItem" />
                                        <HeaderStyle CssClass="GridHeader" />
                                        <FooterStyle CssClass="GridFooter" />
                                        <PagerStyle CssClass="GridPager" />
                                        <Columns>
                                            <asp:TemplateField HeaderText="ID" SortExpression="ID" ItemStyle-HorizontalAlign="Center">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label1" runat="server" Text='<%# Eval("ID")%>' CssClass="lbl">
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>
                                            <asp:TemplateField HeaderText="Name" SortExpression="Name" ItemStyle-HorizontalAlign="Left">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label2" runat="server" CssClass="lbl" Text='<%# Eval("Name")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Code" SortExpression="Code" ItemStyle-HorizontalAlign="Right">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label3" runat="server" CssClass="lbl" Text='<%# Eval("Code")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>


                                            <asp:TemplateField HeaderText="Valid From" SortExpression="Valid_From" ItemStyle-HorizontalAlign="Center">

                                                <ItemTemplate>
                                                    <asp:Label ID="lblValidFrom" runat="server" CssClass="lbl" Text='<%# Eval("Valid_From")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>
                                                <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="false" />
                                                <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="False" />

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Valid Till" SortExpression="Valid_Till" ItemStyle-HorizontalAlign="Center">

                                                <ItemTemplate>
                                                    <asp:Label ID="lblValidTill" runat="server" CssClass="lbl" Text='<%# Eval("Valid_Till")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>
                                                <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="false" />
                                                <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="False" />


                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Location" SortExpression="Location" ItemStyle-HorizontalAlign="Left" Visible="false">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label6" runat="server" CssClass="lbl" Text='<%# Eval("Location")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>


                                            <asp:TemplateField HeaderText="Phone No" SortExpression="Phone_No" ItemStyle-HorizontalAlign="Right" Visible="false">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label7" runat="server" CssClass="lbl" Text='<%# Eval("Phone_No")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Fax No" SortExpression="Fax_No" ItemStyle-HorizontalAlign="Right" Visible="false">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label8" runat="server" CssClass="lbl" Text='<%# Eval("Fax_No")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>



                                        </Columns>
                                    </asp:GridView>
                                    <%--Added by shubham k on 22-Feb-2021 for UBP, added frozen grid remove Width="318px"--%>
                                    <asp:GridView ID="dgCounterPartyDetail" runat="server" AutoGenerateColumns="false" CssClass="Grid frozenGrid" AllowSorting="False"
                                        ShowFooter="true" BorderStyle="None" AllowPaging="true" PageSize="10"  ViewStateMode="Enabled" ShowHeaderWhenEmpty="true">

                                        <SelectedRowStyle CssClass="GridItemSelect" />
                                        <RowStyle CssClass="GridItem" />
                                        <HeaderStyle CssClass="GridHeader" />
                                        <FooterStyle CssClass="GridFooter" />
                                        <PagerStyle CssClass="GridPager" />



                                        <Columns>
                                            <asp:TemplateField HeaderText="SSI Id" SortExpression="SSI_Id">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label9" runat="server" CssClass="lbl" Text='<%# Eval("SSI_Id")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>
                                            <asp:TemplateField HeaderText="Customer Name" SortExpression="Customer_Name">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label10" runat="server" CssClass="lbl" Text='<%# Eval("Customer_Name")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Currency" SortExpression="Currency">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label11" runat="server" CssClass="lbl" Text='<%# Eval("Currency")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>


                                            <asp:TemplateField HeaderText="Product" SortExpression="Product">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label12" runat="server" CssClass="lbl" Text='<%# Eval("Product")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Direction" SortExpression="Direction">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label13" runat="server" CssClass="lbl" Text='<%# Eval("Direction")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Account No" SortExpression="Account_No">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label14" runat="server" CssClass="lbl" Text='<%# Eval("Account_No")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>


                                            <asp:TemplateField HeaderText="Start Date" SortExpression="Start_Date" ItemStyle-HorizontalAlign="Center">

                                                <ItemTemplate>
                                                    <asp:Label ID="lblStartDate" runat="server" CssClass="lbl" Text='<%# Eval("Start_Date")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>
                                                <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="False" />
                                                <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="False" />


                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="End Date" SortExpression="EndDate" ItemStyle-HorizontalAlign="Center">

                                                <ItemTemplate>
                                                    <asp:Label ID="lblEndDate" runat="server" CssClass="lbl" Text='<%# Eval("EndDate")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>
                                                <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="False" />
                                                <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="False" />


                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Rule" SortExpression="Rule">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label17" runat="server" CssClass="lbl" Text='<%# Eval("Rule")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>
                                            <asp:TemplateField HeaderText="Account Type" SortExpression="Account_Type">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label18" runat="server" CssClass="lbl" Text='<%# Eval("Account_Type")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Active YN" SortExpression="Active_YN">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label19" runat="server" CssClass="lbl" Text='<%# Eval("Active_YN")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>


                                            <asp:TemplateField HeaderText="Intermediary Bank Name" SortExpression="Intermediary_Bank_Name">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label20" runat="server" CssClass="lbl" Text='<%# Eval("Intermediary_Bank_Name")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Intermediary Bank Code" SortExpression="Intermediary_Bank_Code">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label21" runat="server" CssClass="lbl" Text='<%# Eval("Intermediary_Bank_Code")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Intermediary Bank Cpty Ac No" SortExpression="Intermediary_Bank_Cpty_Ac_No">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label22" runat="server" CssClass="lbl" Text='<%# Eval("Intermediary_Bank_Cpty_Ac_No")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="CHIP Code" SortExpression="CHIP_Code">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label23" runat="server" CssClass="lbl" Text='<%# Eval("CHIP_Code")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="SORT Code" SortExpression="SORT_Code">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label24" runat="server" CssClass="lbl" Text='<%# Eval("SORT_Code")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Intermediary CHIP Code" SortExpression="Intermediary_CHIP_Code">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label25" runat="server" CssClass="lbl" Text='<%# Eval("Intermediary_CHIP_Code")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Intermediary SORT Code" SortExpression="Intermediary_SORT_Code">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label26" runat="server" CssClass="lbl" Text='<%# Eval("Intermediary_SORT_Code")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                        </Columns>
                                    </asp:GridView>
                                     <%--Added by shubham k on 22-Feb-2021 for UBP, added frozen grid remove Width="318px"--%>
                                    <asp:GridView ID="dgCustomerSSIDetail" runat="server" AutoGenerateColumns="false" CssClass="Grid frozenGrid" AllowSorting="False"
                                        BorderStyle="None" AllowPaging="true" Width="318px" ViewStateMode="Enabled" ShowHeaderWhenEmpty="true">
                                        <SelectedRowStyle CssClass="GridItemSelect" />
                                        <RowStyle CssClass="GridItem" />
                                        <HeaderStyle CssClass="GridHeader" />
                                        <FooterStyle CssClass="GridFooter" />
                                        <PagerStyle CssClass="GridPager" />



                                        <Columns>
                                            <asp:TemplateField HeaderText="SSI ID" SortExpression="SSI_ID" ItemStyle-HorizontalAlign="Center">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label27" runat="server" CssClass="lbl" Text='<%# Eval("SSI_ID")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>
                                            <asp:TemplateField HeaderText="Customer Name" SortExpression="Customer_Name">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label28" runat="server" CssClass="lbl" Text='<%# Eval("Customer_Name")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Currency" SortExpression="Currency" ItemStyle-HorizontalAlign="Center">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label29" runat="server" CssClass="lbl" Text='<%# Eval("Currency")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>


                                            <asp:TemplateField HeaderText="Product" SortExpression="Product" ItemStyle-HorizontalAlign="Center">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label30" runat="server" CssClass="lbl" Text='<%# Eval("Product")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Direction" SortExpression="Direction" ItemStyle-HorizontalAlign="Center">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label47" runat="server" Text='<%# Eval("Direction")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Default" SortExpression="Default" ItemStyle-HorizontalAlign="Center">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label4" runat="server" CssClass="lbl" Text='<%# Eval("Default")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>


                                            <asp:TemplateField HeaderText="Account No." SortExpression="Account_No" ItemStyle-HorizontalAlign="Right">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label32" runat="server" CssClass="lbl" Text='<%# Eval("Account_No")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>


                                            <asp:TemplateField HeaderText="Bank Name" SortExpression="Bank_Name">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label33" runat="server" CssClass="lbl" Text='<%# Eval("Bank_Name")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="City" SortExpression="City">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label34" runat="server" CssClass="lbl" Text='<%# Eval("City")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Start Date" SortExpression="Start_Date" ItemStyle-HorizontalAlign="Center">

                                                <ItemTemplate>
                                                    <asp:Label ID="lblStartDate" runat="server" CssClass="lbl" Text='<%# Eval("Start_Date")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>
                                                <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="False" />
                                                <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="False" />


                                            </asp:TemplateField>
                                            <asp:TemplateField HeaderText="End Date" SortExpression="EndDate" ItemStyle-HorizontalAlign="Center">

                                                <ItemTemplate>
                                                    <asp:Label ID="lblEndDate" runat="server" CssClass="lbl" Text='<%# Eval("EndDate")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>
                                                <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="False" />
                                                <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="False" />


                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Rule" SortExpression="Rule">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label37" runat="server" CssClass="lbl" Text='<%# Eval("Rule")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>


                                            <asp:TemplateField HeaderText="Account Type" SortExpression="Account_Type">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label38" runat="server" CssClass="lbl" Text='<%# Eval("Account_Type")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Active YN" SortExpression="Active_YN" ItemStyle-HorizontalAlign="Center">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label39" runat="server" CssClass="lbl" Text='<%# Eval("Active_YN")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Intermediary Bank Name" SortExpression="Intermediary_Bank_Name">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label40" runat="server" CssClass="lbl" Text='<%# Eval("Intermediary_Bank_Name")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Intermediary Bank Code" SortExpression="Intermediary_Bank_Code">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label41" runat="server" CssClass="lbl" Text='<%# Eval("Intermediary_Bank_Code")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Intermediary Bank cpy Ac No" SortExpression="Intermediary_Bank_cpty_Ac_No">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label42" runat="server" CssClass="lbl" Text='<%# Eval("Intermediary_Bank_cpty_Ac_No")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="CHIP Code" SortExpression="CHIP_Code">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label43" runat="server" CssClass="lbl" Text='<%# Eval("CHIP_Code")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Sort Code" SortExpression="SORT_Code">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label44" runat="server" CssClass="lbl" Text='<%# Eval("SORT_Code")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Intermediary Chip Code" SortExpression="Intermediary_CHIP_Code">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label45" runat="server" CssClass="lbl" Text='<%# Eval("Intermediary_CHIP_Code")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Intermediary Sort Code" SortExpression="Intermediary_SORT_Code">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label46" runat="server" CssClass="lbl" Text='<%# Eval("Intermediary_SORT_Code")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>


                                        </Columns>
                                    </asp:GridView>
                                     <%--Added by shubham k on 22-Feb-2021 for UBP, added frozen grid remove Width: 1900px;--%>
                                    <div style="overflow: scroll;" id="divCustomer" visible="false" runat="server">
                                        <asp:GridView ID="dgCustomer" runat="server" AutoGenerateColumns="false" CssClass="Grid frozenGrid" AllowSorting="true"
                                            BorderStyle="None" AllowPaging="true" PageSize="10" ViewStateMode="Enabled" ShowHeaderWhenEmpty="true" >
                                            <SelectedRowStyle CssClass="GridItemSelect" />
                                            <RowStyle CssClass="GridItem" />
                                            <HeaderStyle CssClass="GridHeader" />
                                            <FooterStyle CssClass="GridFooter" />
                                            <PagerStyle CssClass="GridPager" />


                                            <Columns>
                                                <asp:TemplateField HeaderText="PAN" SortExpression="PAN" ItemStyle-HorizontalAlign="Center">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label31" CssClass="lbl" runat="server" Text='<%# Eval("PAN")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Customer Name" SortExpression="CustomerName" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label48" runat="server" CssClass="lbl" Text='<%# Eval("CustomerName")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Short Name" SortExpression="Short_Name" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblShortName" runat="server" CssClass="lbl" Text='<%# Eval("Short_Name")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Print Name Line1" SortExpression="Print_Name_Line1" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label50" runat="server" CssClass="lbl" Text='<%# Eval("Print_Name_Line1")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Print Name Line2" SortExpression="Print_Name_Line2" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label51" runat="server" CssClass="lbl" Text='<%# Eval("Print_Name_Line2")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Name (ENG)" SortExpression="LONGNAME" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label53" runat="server" CssClass="lbl" Text='<%# Eval("LONGNAME")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="ID Doc Type Main" SortExpression="ID_Doc_Type_Main" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label54" runat="server" CssClass="lbl" Text='<%# Eval("ID_Doc_Type_Main")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="ID Doc No Main" SortExpression="ID_Doc_No_Main" ItemStyle-HorizontalAlign="Left"><%--Added by shubham k on 22-Feb-21 , changed alignment--%>

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label55" runat="server" CssClass="lbl" Text='<%# Eval("ID_Doc_No_Main")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Joint1 AC holder" SortExpression="Joint1_AC_holder">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label56" runat="server" CssClass="lbl" Text='<%# Eval("Joint1_AC_holder")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="ID Doc Type Joint1" SortExpression="ID_Doc_Type_Joint1">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label57" runat="server" CssClass="lbl" Text='<%# Eval("ID_Doc_Type_Joint1")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="ID Doc No Joint1" SortExpression="ID_Doc_No_Joint1">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label58" runat="server" CssClass="lbl" Text='<%# Eval("ID_Doc_No_Joint1")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Joint2 AC holder" SortExpression="Joint2_AC_holder">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label59" runat="server" CssClass="lbl" Text='<%# Eval("Joint2_AC_holder")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="ID Doc Type Joint2" SortExpression="ID_Doc_Type_Joint2">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label60" runat="server" CssClass="lbl" Text='<%# Eval("ID_Doc_Type_Joint2")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="ID Doc No Joint2" SortExpression="ID_Doc_No_Joint2">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label61" runat="server" Text='<%# Eval("ID_Doc_No_Joint2")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Joint3 AC holder" SortExpression="Joint3_AC_holder">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label62" runat="server" CssClass="lbl" Text='<%# Eval("Joint3_AC_holder")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="ID Doc Type Joint3" SortExpression="ID_Doc_Type_Joint3">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label63" runat="server" CssClass="lbl" Text='<%# Eval("ID_Doc_Type_Joint3")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="ID Doc No Joint3" SortExpression="ID_Doc_No_Joint3">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label64" runat="server" CssClass="lbl" Text='<%# Eval("ID_Doc_No_Joint3")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Joint4 AC holder" SortExpression="Joint4_AC_holder">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label65" runat="server" CssClass="lbl" Text='<%# Eval("Joint4_AC_holder")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="ID Doc Type Joint4" SortExpression="ID_Doc_Type_Joint4">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label66" runat="server" CssClass="lbl" Text='<%# Eval("ID_Doc_Type_Joint4")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="ID Doc No Joint4" SortExpression="ID_Doc_No_Joint4">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label67" runat="server" CssClass="lbl" Text='<%# Eval("ID_Doc_No_Joint4")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Joint5 AC holder" SortExpression="Joint5_AC_holder">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label68" runat="server" CssClass="lbl" Text='<%# Eval("Joint5_AC_holder")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="ID Doc Type Joint5" SortExpression="ID_Doc_Type_Joint5">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label69" runat="server" CssClass="lbl" Text='<%# Eval("ID_Doc_Type_Joint5")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="ID Doc No Joint5" SortExpression="ID_Doc_No_Joint5">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label70" runat="server" CssClass="lbl" Text='<%# Eval("ID_Doc_No_Joint5")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Joint6 AC holder" SortExpression="Joint6_AC_holder">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label71" runat="server" CssClass="lbl" Text='<%# Eval("Joint6_AC_holder")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="ID Doc Type Joint6" SortExpression="ID_Doc_Type_Joint6">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label72" runat="server" CssClass="lbl" Text='<%# Eval("ID_Doc_Type_Joint6")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="ID Doc No Joint6" SortExpression="ID_Doc_No_Joint6">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label73" runat="server" CssClass="lbl" Text='<%# Eval("ID_Doc_No_Joint6")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Joint7 AC holder" SortExpression="Joint7_AC_holder">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label74" runat="server" CssClass="lbl" Text='<%# Eval("Joint7_AC_holder")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="ID Doc Type Joint7" SortExpression="ID_Doc_Type_Joint7">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label75" runat="server" CssClass="lbl" Text='<%# Eval("ID_Doc_Type_Joint7")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="ID Doc No Joint7" SortExpression="ID_Doc_No_Joint7">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label76" runat="server" CssClass="lbl" Text='<%# Eval("ID_Doc_No_Joint7")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Address line1" SortExpression="Address_line1" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label77" runat="server" CssClass="lbl" Text='<%# Eval("Address_line1")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Address line2" SortExpression="Address_line2" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label78" runat="server" CssClass="lbl" Text='<%# Eval("Address_line2")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Address line3" SortExpression="Address_line3" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label79" runat="server" CssClass="lbl" Text='<%# Eval("Address_line3")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="City" SortExpression="City" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label80" runat="server" CssClass="lbl" Text='<%# Eval("City")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="State" SortExpression="State" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label81" runat="server" CssClass="lbl" Text='<%# Eval("State")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Zip Code" SortExpression="Zip_Code" ItemStyle-HorizontalAlign="Right">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label82" runat="server" CssClass="lbl" Text='<%# Eval("Zip_Code")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Country" SortExpression="Country" ItemStyle-HorizontalAlign="Left">
                                                    <ItemStyle HorizontalAlign="Center" />
                                                    <ItemTemplate>
                                                        <asp:Label ID="Label83" runat="server" CssClass="lbl" Text='<%# Eval("Country")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Customer Type" SortExpression="CustomerType" ItemStyle-HorizontalAlign="Left">
                                                    <ItemStyle HorizontalAlign="Center" />
                                                    <ItemTemplate>
                                                        <asp:Label ID="Label84" runat="server" CssClass="lbl" Text='<%# Eval("CustomerType")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Customer Status" SortExpression="CustomerStatus" ItemStyle-HorizontalAlign="Left">
                                                    <ItemStyle HorizontalAlign="Center" />
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblCustomerStatus" runat="server" CssClass="lbl" Text='<%# Eval("CustomerStatus")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Mail Code" SortExpression="Mail_Code" ItemStyle-HorizontalAlign="Right">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblMailCode" runat="server" CssClass="lbl" Text='<%# Eval("Mail_Code")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Relationship Manager" SortExpression="Relationship_Manager" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblRelationshipManager" runat="server" CssClass="lbl" Text='<%# Eval("Relationship_Manager")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Cust Group ARM" SortExpression="Cust_Group_ARM" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label88" runat="server" CssClass="lbl" Text='<%# Eval("Cust_Group_ARM")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Branch Name" SortExpression="Book_Name" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label89" runat="server" CssClass="lbl" Text='<%# Eval("Book_Name")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Language" SortExpression="Language" ItemStyle-HorizontalAlign="left"><%--Added by shubham k on 22-Feb-2021 for UBP,changed alignment--%> 

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblLanguage" runat="server" CssClass="lbl" Text='<%# Eval("Language")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Created At" SortExpression="Created_At" ItemStyle-HorizontalAlign="Center">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblCreatedAt" runat="server" CssClass="lbl" Text='<%# Eval("Created_At")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>
                                                    <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="false" />
                                                    <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="False" />

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Created By" SortExpression="Created_By" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label92" runat="server" CssClass="lbl" Text='<%# Eval("Created_By")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Agreement Date" SortExpression="Agreement_Date" ItemStyle-HorizontalAlign="Center">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblAgreementDate" runat="server" CssClass="lbl" Text='<%# Eval("Agreement_Date")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Suitability Date" SortExpression="Suitability_Date" ItemStyle-HorizontalAlign="Center">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblSuitabilityDate" runat="server" CssClass="lbl" Text='<%# Eval("Suitability_Date")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Sub Status" SortExpression="Sub_Status" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblSubStatus" runat="server" CssClass="lbl" Text='<%# Eval("Sub_Status")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Verified" SortExpression="Verified" ItemStyle-HorizontalAlign="Center">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblVerified" runat="server" CssClass="lbl" Text='<%# Eval("Verified")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Verified At" SortExpression="Verified_At " ItemStyle-HorizontalAlign="Center">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblVarifiedAt" runat="server" CssClass="lbl" Text='<%# Eval("Verified_At")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Verified By" SortExpression="Verified_By">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblVerifiedBy" runat="server" CssClass="lbl" Text='<%# Eval("Verified_By")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Active" SortExpression="Active" ItemStyle-HorizontalAlign="Center">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label99" runat="server" CssClass="lbl" Text='<%# Eval("Active")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Deactivated At" SortExpression="Deactivated_At" ItemStyle-HorizontalAlign="Center">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblDeactivatedAt" runat="server" CssClass="lbl" Text='<%# Eval("Deactivated_At")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Deactivated By" SortExpression="Deactivated_By">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label101" runat="server" CssClass="lbl" Text='<%# Eval("Deactivated_By")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Edited At" SortExpression="Edited_At" ItemStyle-HorizontalAlign="Center">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblEditedAt" runat="server" CssClass="lbl" Text='<%# Eval("Edited_At")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Edited By" SortExpression="Edited_By">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label103" runat="server" CssClass="lbl" Text='<%# Eval("Edited_By")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Option Cut location" SortExpression="Option_Cut_location">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblOptionCutlocation" runat="server" CssClass="lbl" Text='<%# Eval("Option_Cut_location")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>




                                                <asp:TemplateField HeaderText="Option Cut time" SortExpression="Option_Cut_time" ItemStyle-HorizontalAlign="Left">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblOptionCuttime" runat="server" CssClass="lbl" Text='<%# Eval("Option_Cut_time")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>




                                                <asp:TemplateField HeaderText="Tax Rate" SortExpression="Tax_Rate">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblTaxRate" runat="server" CssClass="lbl" Text='<%# Eval("Tax_Rate")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Address Sync Flag" SortExpression="Address_Sync_Flag">
                                                    <ItemStyle HorizontalAlign="Center" />
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblAddressSyncFlag" runat="server" CssClass="lbl" Text='<%# Eval("Address_Sync_Flag")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Remarks" SortExpression="Remarks">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblRemarks" runat="server" CssClass="lbl" Text='<%# Eval("Remarks")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="MM Sub Flag" SortExpression="MM_Sub_Flag">
                                                    <ItemStyle HorizontalAlign="Center" />
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblMMSubFlag" runat="server" CssClass="lbl" Text='<%# Eval("MM_Sub_Flag")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Customer service channel" SortExpression="Customer_service_channel">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblCustomerservicechannel" runat="server" CssClass="lbl" Text='<%# Eval("Customer_service_channel")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Resident YN" SortExpression="Resident_YN">
                                                    <ItemStyle HorizontalAlign="Center" />
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblResidentYN" runat="server" CssClass="lbl" Text='<%# Eval("Resident_YN")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Sales Info" SortExpression="Sales_Info">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblSalesInfo" runat="server" CssClass="lbl" Text='<%# Eval("Sales_Info")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Address2" SortExpression="Address2">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblAddress2" runat="server" CssClass="lbl" Text='<%# Eval("Address2")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Address3" SortExpression="Address3">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblAddress3" runat="server" CssClass="lbl" Text='<%# Eval("Address3")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Contact Person" SortExpression="Contact_Person">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblContactPerson" runat="server" CssClass="lbl" Text='<%# Eval("Contact_Person")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Accredited Investor Flag" SortExpression="Accredited_Investor_Flag" ItemStyle-HorizontalAlign="Center">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblAccreditedInvestorFlag" runat="server" CssClass="lbl" Text='<%# Eval("Accredited_Investor_Flag")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Contact2" SortExpression="Contact2">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblContact2" runat="server" CssClass="lbl" Text='<%# Eval("Contact2")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Phone Number" SortExpression="PhoneNumber">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblPhoneNumber" runat="server" CssClass="lbl" Text='<%# Eval("PhoneNumber")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>





                                                <asp:TemplateField HeaderText="Phone1" SortExpression="Phone1">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label119" runat="server" CssClass="lbl" Text='<%# Eval("Phone1")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Phone2" SortExpression="Phone2">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label120" runat="server" CssClass="lbl" Text='<%# Eval("Phone2")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Fax No" SortExpression="Fax_No">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label121" runat="server" CssClass="lbl" Text='<%# Eval("Fax_No")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Fax1" SortExpression="Fax1">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label122" runat="server" CssClass="lbl" Text='<%# Eval("Fax1")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Fax2" SortExpression="Fax2">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblFax2" runat="server" CssClass="lbl" Text='<%# Eval("Fax2")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Email Id" SortExpression="EmailId">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label124" runat="server" CssClass="lbl" Text='<%# Eval("EmailId")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Email1" SortExpression="Email1">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label125" runat="server" CssClass="lbl" Text='<%# Eval("Email1")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Email2" SortExpression="Email2">

                                                    <ItemTemplate>
                                                        <asp:Label ID="Label126" runat="server" CssClass="lbl" Text='<%# Eval("Email2")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                             <%--     <Change done by Mayuri C on 13-Oct-2020  as per Discussed with Nitin N for Branch Name set to visiable false>--%>
                                             
                                                 

                                                <asp:TemplateField HeaderText="Branch Name" SortExpression="BranchName"   visible="false">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblBranchName" runat="server" CssClass="lbl" Text='<%# Eval("BranchName")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                  <asp:TemplateField HeaderText="Unit" SortExpression="Unit"  >

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblUnit" runat="server" CssClass="lbl" Text='<%# Eval("Unit")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                              <%--<Change done by Mayuri C on 13-Oct-2020 as per Discussed with Nitin N for Branch Name to visiable false>--%>

                                                <asp:TemplateField HeaderText="Balance Amount" SortExpression="BalanceAmount" ItemStyle-HorizontalAlign="Right">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblBalanceAmount" runat="server" CssClass="lbl" Text='<%# Eval("BalanceAmount")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>





                                                <asp:TemplateField HeaderText="Balance Currency" SortExpression="BalanceCurrency">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblBalanceCurrency" runat="server" CssClass="lbl" Text='<%# Eval("BalanceCurrency")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>




                                                <asp:TemplateField HeaderText="Account Ccy" SortExpression="AccountCcy">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblAccountCcy" runat="server" CssClass="lbl" Text='<%# Eval("AccountCcy")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Balance Later" SortExpression="BalanceLater" ItemStyle-HorizontalAlign="Right">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblBalanceLater" runat="server" CssClass="lbl" Text='<%# Eval("BalanceLater")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Notes AC No" SortExpression="Notes_AC_No" ItemStyle-HorizontalAlign="Right">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblNotesACNo" runat="server" CssClass="lbl" Text='<%# Eval("Notes_AC_No")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Ccy Ac No" SortExpression="Ccy_Ac_No" ItemStyle-HorizontalAlign="Right">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblCcyAcNo" runat="server" CssClass="lbl" Text='<%# Eval("Ccy_Ac_No")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="BIC Code" SortExpression="BICCode">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblBICCode" runat="server" CssClass="lbl" Text='<%# Eval("BICCode")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="CDP No" SortExpression="CDP_No">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblCDPNo" runat="server" CssClass="lbl" Text='<%# Eval("CDP_No")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Signatory Name1" SortExpression="Signatory_Name1">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblSignatoryName1" CssClass="lbl" runat="server" Text='<%# Eval("Signatory_Name1")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Signatory CIN1" SortExpression="Signatory_CIN1">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblSignatoryCIN1" CssClass="lbl" runat="server" Text='<%# Eval("Signatory_CIN1")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Signatory Name2" SortExpression="Signatory_Name2">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblSignatoryName2" CssClass="lbl" runat="server" Text='<%# Eval("Signatory_Name2")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Signatory CIN2" SortExpression="Signatory_CIN2">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblSignatoryCIN2" CssClass="lbl" runat="server" Text='<%# Eval("Signatory_CIN2")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Signatory Name3" SortExpression="Signatory_Name3">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblSignatoryName3" CssClass="lbl" runat="server" Text='<%# Eval("Signatory_Name3")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Signatory CIN3" SortExpression="Signatory_CIN3">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblSignatoryCIN3" CssClass="lbl" runat="server" Text='<%# Eval("Signatory_CIN3")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Signatory Name4" SortExpression="Signatory_Name4">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblSignatoryName4" CssClass="lbl" runat="server" Text='<%# Eval("Signatory_Name4")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Signatory CIN4" SortExpression="Signatory_CIN4">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblSignatoryCIN4" CssClass="lbl" runat="server" Text='<%# Eval("Signatory_CIN4")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="Signatory CIN5" SortExpression="Signatory_CIN5">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblSignatoryCIN5" CssClass="lbl" runat="server" Text='<%# Eval("Signatory_CIN5")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Signatory Name5" SortExpression="Signatory_Name5">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblSignatoryName5" CssClass="lbl" runat="server" Text='<%# Eval("Signatory_Name5")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="Entity" SortExpression="Entity" ItemStyle-HorizontalAlign="Right">
                                                    <ItemStyle HorizontalAlign="Center" />
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblEntity" CssClass="lbl" runat="server" Text='<%# Eval("Entity")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Use Default tax rates" SortExpression="Use_Default_tax_rates">
                                                    <ItemStyle HorizontalAlign="Center" />
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblUseDefaulttaxrates" CssClass="lbl" runat="server" Text='<%# Eval("Use_Default_tax_rates")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>

                                                </asp:TemplateField>



                                                <asp:TemplateField HeaderText="AH Officer Name3" SortExpression="AH_Officer_Name3" ItemStyle-HorizontalAlign="Center" Visible="False">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblAHOfficerName3" runat="server" CssClass="lbl" Text='<%# Eval("AH_Officer_Name3")%>' Visible="False">
                                                        </asp:Label>

                                                    </ItemTemplate>
                                                </asp:TemplateField>

                                                <asp:TemplateField HeaderText="RM No" SortExpression="CDM_External_Id_1" ItemStyle-HorizontalAlign="Center" Visible="False">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblCDMExternalId1" runat="server" CssClass="lbl" Text='<%# Eval("CDM_External_Id_1")%>'>
                                                        </asp:Label>

                                                    </ItemTemplate>
                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="TLT Cust ID" SortExpression="CDM_TLT_Id" ItemStyle-HorizontalAlign="Center" Visible="False">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblCDMTLTId" runat="server" CssClass="lbl" Text='<%# Eval("CDM_TLT_Id")%>' Visible="False">
                                                        </asp:Label>

                                                    </ItemTemplate>
                                                </asp:TemplateField>


                                                <asp:TemplateField HeaderText="Customer Segment" SortExpression="AH_Customer_Segment" ItemStyle-HorizontalAlign="Center" Visible="False">

                                                    <ItemTemplate>
                                                        <asp:Label ID="lblAHCustomerSegment" runat="server" CssClass="lbl" Text='<%# Eval("AH_Customer_Segment")%>' Visible="False">
                                                        </asp:Label>

                                                    </ItemTemplate>
                                                </asp:TemplateField>





                                            </Columns>
                                        </asp:GridView>
                                    </div>
                                    <%--Added by shubham k on 22-Feb-2021 for UBP, added frozen grid remove Width="318px"--%>
                                    <asp:GridView ID="dgDealer" runat="server" AutoGenerateColumns="false" CssClass="Grid frozenGrid" AllowSorting="true"
                                        BorderStyle="None" AllowPaging="true" PageSize="10"  ViewStateMode="Enabled" ShowHeaderWhenEmpty="true">
                                        <SelectedRowStyle CssClass="GridItemSelect" />
                                        <RowStyle CssClass="GridItem" />
                                        <HeaderStyle CssClass="GridHeader" />
                                        <FooterStyle CssClass="GridFooter" />
                                        <PagerStyle CssClass="GridPager" />



                                        <Columns>
                                            <asp:TemplateField HeaderText="ID" SortExpression="ID" ItemStyle-HorizontalAlign="Center">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label52" runat="server" CssClass="lbl" Text='<%# Eval("ID")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>
                                            <asp:TemplateField HeaderText="Dealer Name" SortExpression="Dealer_Name" ItemStyle-HorizontalAlign="Left">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label149" runat="server" CssClass="lbl" Text='<%# Eval("Dealer_Name")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>

                                            <asp:TemplateField HeaderText="Phone No." SortExpression="Phone_No" ItemStyle-HorizontalAlign="Right">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label150" runat="server" CssClass="lbl" Text='<%# Eval("Phone_No")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>


                                            <asp:TemplateField HeaderText="Active YN" SortExpression="Active_YN" ItemStyle-HorizontalAlign="Center">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label151" runat="server" CssClass="lbl" Text='<%# Eval("Active_YN")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>



                                            <asp:TemplateField HeaderText="Department" SortExpression="Department" ItemStyle-HorizontalAlign="Center">

                                                <ItemTemplate>
                                                    <asp:Label ID="Label152" runat="server" CssClass="lbl" Text='<%# Eval("Department")%>'>
                                                    </asp:Label>

                                                </ItemTemplate>

                                            </asp:TemplateField>





                                        </Columns>
                                    </asp:GridView>


                                </ContentTemplate>
                            </asp:UpdatePanel>

                        </td>
                    </tr>
                </table>
                <%--     </fieldset> --%>

                <script type="text/javascript">


                    var prm1;

                    $(document).ready(function () {

                        prm1 = Sys.WebForms.PageRequestManager.getInstance();
                        prm1.add_initializeRequest(InitializeRequest1);
                        prm1.add_endRequest(EndRequest1);


                        function InitializeRequest1(sender, args) {
                        }

                        function EndRequest1(sender, args) {
                            $("#<%=txtrowsperpage.ClientID%>").keydown(function (e) {
                                var code = e.keyCode || e.which;

                                if (code == 13 || code == 9) {
                                    document.getElementById('<%=btnSetPageSize.ClientID%>').click();
                                }
                            });
                        }

                        $("#<%=txtrowsperpage.ClientID%>").keydown(function (e) {
                            var code = e.keyCode || e.which;

                            if (code == 13 || code == 9) {
                                document.getElementById('<%=btnSetPageSize.ClientID%>').click();
                            }
                        });



                        var prm2 = Sys.WebForms.PageRequestManager.getInstance();

                        prm2.add_initializeRequest(InitializeRequest2);


                        prm2.add_endRequest(EndRequest2);


                        function InitializeRequest2(sender, args) {

                        }

                        function EndRequest2(sender, args) {
                            $("#<%=txtsearch.ClientID%>").keydown(function (e) {
                                var code = e.keyCode || e.which;

                                if (code == 13 || code == 9) {
                                    document.getElementById('<%=btnSearch1.ClientID%>').click();


                            }
                            });
                    }

                        $("#<%=txtsearch.ClientID%>").keydown(function (e) {

                            var code = e.keyCode || e.which;

                            if (code == 13 || code == 9) {

                                document.getElementById('<%=btnSearch1.ClientID%>').click();


                            }
                        });

                        function AllowNumericOnly(e) {
                            var keycode;
                            if (window.event)
                                keycode = window.event.keyCode;
                            else if (event)
                                keycode = event.keyCode;
                            else if (e)
                                keycode = e.which;
                            else return true;
                            if ((keycode > 47 && keycode <= 57)) { return true; }
                            else { return false; } return true;
                        }


                    });
                </script>

            </ContentTemplate>
            <Triggers>
                <asp:PostBackTrigger ControlID="btnExport" />
            </Triggers>
        </asp:UpdatePanel>

    </div>
</asp:Content>
