<%@ Page Language="vb" AutoEventWireup="false" MasterPageFile="~/FiniqAppMasterPage.Master" CodeBehind="DocGenShowAllTags.aspx.vb" Inherits="FinIQWebApp.DocGenShowAllTags" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

<asp:Content  ID="Content1" runat="server" ContentPlaceHolderID="MainContent">
    <asp:ScriptManagerProxy ID="ScriptManagerProxy1" runat="server"></asp:ScriptManagerProxy>
    <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
        <ContentTemplate>
            <script>
                function allowOnlyNumber(evt) {
                    var charCode = (evt.which) ? evt.which : event.keyCode
                    if (charCode > 31 && (charCode < 48 || charCode > 57))
                        return false;
                    return true;
                }
            </script>
            <script src="../FinIQJS/SortFilter_Grid.js"></script>

           <table border="0">
               <tr>
                   <td>
                       <asp:Label ID="lblMsg" runat="server" CssClass="lblerror" />
                   </td>
               </tr>    
                     <tr>
                         <td>                       
                        <asp:Panel ID="PnlShowAllTags" runat="server" BorderColor="LightGray" BorderWidth="1px" BorderStyle="None">
                            <table style="margin-top: 2px; margin-bottom: 2px;">
                                 <tr style="height:40px;">
                                    <td>
                                        <asp:Label ID="lblDataBaseShowAllTag" runat="server" CssClass="lbl" Text="DataBase"></asp:Label>
                                    </td>
                                    <td style="padding-right: 30px;padding-left:10px">
                                        <asp:DropDownList ID="ddlDataBaseShowAllTag" runat="server" CssClass="ddl ddlDataBaseShowAllTag" AutoPostBack="true" Width="200px" AppendDataBoundItems="true">
                                            <asp:ListItem Text="All" Value="All" />
                                        </asp:DropDownList>
                                    </td>
                                    <td>
                                        <asp:Label ID="lblSchemaShowAllTag" runat="server" CssClass="lbl" Text="Schema"></asp:Label>
                                    </td>
                                    <td style="padding-right: 30px;padding-left:10px">
                                        <asp:DropDownList ID="ddlSchemaShowAllTag" runat="server" CssClass="ddl ddlSchemaShowAllTag" AutoPostBack="true" Width="200px" AppendDataBoundItems="true">
                                        </asp:DropDownList>
                                    </td>
                                    <td>
                                        <asp:Label ID="lblTableShowAllTag" runat="server" CssClass="lbl" Text="Table"></asp:Label>
                                    </td>
                                    <td  style="padding-right: 30px;padding-left:10px">
                                        <asp:DropDownList ID="ddlTableShowAllTag" runat="server" CssClass="ddl ddlTableShowAllTag" AutoPostBack="true" Width="200px" AppendDataBoundItems="true">
                                            <asp:ListItem Text="All" Value="All" />
                                        </asp:DropDownList>
                                    </td>

                                    <td>
                                        <asp:Button ID="btnLoadShowAllTag" runat="server" CssClass="btn" Text="Load" Width="100px" />
                                    </td>
                                      <td  style="padding-right: 10px;padding-left:10px">
                                        <asp:Label ID="lblNoOfRows" runat="server" CssClass="lbl" Text="Page Size"></asp:Label>
                                    </td>
                                    <td>
                                        <asp:textbox id="txtNoOfRows" runat="server" CssClass="txt" TextMode="Number" AutoPostBack ="true" Text="99"  Width="40px" style="text-align:right"/>                                       
                                    </td>
                                </tr>
                                <tr style="height:40px;">
                                    <td>
                                        <asp:Label ID="lblAliasShowAllTag" runat="server" CssClass="lbl" Text="Alias"></asp:Label>
                                    </td>
                                    <td  style="padding-right: 30px;padding-left:10px">
                                        <asp:DropDownList ID="ddlAliasShowAllTag" runat="server" CssClass="ddl ddlAliasShowAllTag" Width="200px" AppendDataBoundItems="true">
                                            <asp:ListItem Text="All" Value="All" />
                                        </asp:DropDownList>
                                    </td>
                                    <td>
                                        <asp:Label ID="lblTextToSearchShowAllTag" runat="server" CssClass="lbl" Text="Text to Search"></asp:Label>
                                    </td>
                                    <td  style="padding-right: 30px;padding-left:10px">
                                        <asp:TextBox ID="txtTextToSearchShowAllTag" runat="server" CssClass="txt txtTextToSearchShowAllTag" Width="200px" ></asp:TextBox>    
                                        <%--Set Width by Saurabh Kulkarni for alignment on 02-Nov-2018--%>
                                    </td>

                                </tr>
                                <tr>
                                    <td colspan="8" style="text-align: right;"></td>
                                </tr>
                            </table>
                            </asp:Panel>
                            </td>
                     </tr>
               <tr style="height:10px;">
                                    <td colspan="2"></td>
                                </tr>
               <tr>
                   <td>
                         <asp:Panel ID="pnlDetails" runat="server" BorderColor="LightGray" BorderWidth="1px" BorderStyle="None" >
                            <table style="margin-top: 2px; margin-bottom: 2px;">
                                <tr>
                                    <td colspan="6">
                                        <asp:GridView ID="gvShowAllTag" runat="server" CssClass="Grid" AutoGenerateColumns="false"  AllowPaging="true"  ShowHeaderWhenEmpty="true" EmptyDataText="No Records Found"  >
                                            <SelectedRowStyle CssClass="GridItemSelect" />
                                            <RowStyle CssClass="GridItem" />
                                            <HeaderStyle CssClass="GridHeader" />
                                            <FooterStyle CssClass="GridFooter" />
                                            <PagerStyle CssClass="GridPager" />
                                            <Columns>
                                                <asp:TemplateField HeaderText="Tag Id"  ItemStyle-HorizontalAlign ="center">
                                                    <HeaderStyle  Width="50"/>
                                                    <ItemStyle HorizontalAlign="Left"   Width="50"/>
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblTag_Id"  Width="50" runat="server" Text='<%# Eval("Tag_Id")%>'></asp:Label>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Database Name">
                                                    <HeaderStyle  Width="80"/>
                                                    <ItemStyle  Width="80"/>
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblDataBase_Name"  Width="80" runat="server" Text='<%# Eval("DataBase_Name")%>'></asp:Label>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Schema Name">
                                                    <HeaderStyle  Width="80" />
                                                    <ItemStyle  Width="80" />
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblSchema_Name" Width="80"  runat="server" Text='<%# Eval("Schema_Name")%>'></asp:Label>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Table Name">
                                                    <HeaderStyle Width="100"  />
                                                    <ItemStyle  Width="100" Wrap="true" />
                                                    <ItemTemplate>
                                                        <div style="word-break:break-word">
                                                              <asp:Label ID="lblTable_Name"  Width="100" runat="server" Text='<%# Eval("Table_Name")%>'></asp:Label>
                                                        </div>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Alias Name">
                                                    <HeaderStyle  Width="30" />
                                                    <ItemStyle  Width="30" />
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblAlias_Name"  Width="30" runat="server" Text='<%# Eval("Alias_Name")%>'></asp:Label>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="DTI Tag Value">
                                                    <HeaderStyle  Width="100" />
                                                    <ItemStyle  Width="100" />
                                                    <ItemTemplate>
                                                        <div style="word-break:break-word">
                                                        <asp:Label ID="lblDTI_TAG_VALUE"  Width="100" runat="server" Text='<%# Eval("DTI_TAG_VALUE")%>'></asp:Label>
                                                        </div>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Tag">
                                                    <HeaderStyle  Width="100" />
                                                    <ItemStyle  Width="100" />
                                                    <ItemTemplate>
                                                        <div style="word-break:break-word">
                                                        <asp:Label ID="lblTag"  Width="100" runat="server" Text='<%# Eval("Tag")%>'></asp:Label>
                                                        </div>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Data Type">
                                                    <HeaderStyle  Width="60" />
                                                    <ItemStyle  Width="60" />
                                                    <ItemTemplate>
                                                        <div style="word-break:break-word">
                                                        <asp:Label ID="lblDataType"  Width="60" runat="server" Text='<%# Eval("DTI_DATA_TYPE")%>'></asp:Label>
                                                            </div>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Format">
                                                    <HeaderStyle  Width="80" />
                                                    <ItemStyle  Width="80" />
                                                    <ItemTemplate>
                                                        <div style="word-break:break-word">
                                                        <asp:Label ID="lblFormat"  Width="80" runat="server" Text='<%# Eval("Format")%>'></asp:Label>
                                                            </div>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="DTI Description">
                                                    <HeaderStyle  Width="100" />
                                                    <ItemStyle  Width="100" />
                                                    <ItemTemplate>
                                                        <div style="word-break:break-word">
                                                        <asp:Label ID="lblDTI_Description"  Width="100" runat="server" Text='<%# Eval("DTI_Description")%>'></asp:Label>
                                                            </div>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Free Format Tag">
                                                    <HeaderStyle  Width="100" />
                                                    <ItemStyle  Width="100" />
                                                    <ItemTemplate>
                                                        <div style="word-break:break-word">
                                                        <asp:Label ID="lblTemplateColumn"  Width="100" runat="server" Text='<%# Eval("TemplateColumn")%>'></asp:Label>
                                                            </div>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Used In DocGen">
                                                    <HeaderStyle  Width="40" />
                                                    <ItemStyle HorizontalAlign="Center"   Width="40" />
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblUsedInDocGen"  Width="40" runat="server" Text='<%# Eval("DTI_USEDINDOCGENYN")%>'></asp:Label>
                                                    </ItemTemplate>
                                                    <EditItemTemplate>
                                                        <asp:TextBox ID="txtUsedInDocGen" runat="server" Text='<%# Eval("DTI_USEDINDOCGENYN")%>'></asp:TextBox>
                                                    </EditItemTemplate>
                                                </asp:TemplateField>
                                            </Columns>
                                        </asp:GridView>
                                    </td>
                                </tr>
                            </table>
                        </asp:Panel>
                    </td>
               </tr>
           </table>
        </ContentTemplate>
    </asp:UpdatePanel>
</asp:Content>
