SSC/CMS_SC/WebUserControls/mod_listValues.ascx

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="mod_listValues.ascx.cs"
  Inherits="CMS_SC.WebUserControls.mod_listValues" %>


<div class="row mt-2 fontSmall align-bottom">
  <div class="col-sm-2">
    <div class="input-group input-group-sm">
      <div class="input-group-btn">
        <asp:DropDownList ID="ddlTable" runat="server" AutoPostBack="True" CssClass="form-control form-control-sm" Font-Size="X-Small" DataSourceID="odsTableName" DataTextField="TableName" DataValueField="TableName" AppendDataBoundItems="true" OnSelectedIndexChanged="ddlTable_SelectedIndexChanged">
          <asp:ListItem Value="" Selected="True">--- Select ---</asp:ListItem>
        </asp:DropDownList>
      </div>
    </div>
  </div>
  <div class="col-sm-2">
    <asp:LinkButton ID="lbShowNew" runat="server" OnClick="btnShowInsert" CssClass="btn btn-dark text-light btn-sm btn-block">
      <i class="glyphicon glyphicon-plus"></i>
      <asp:Label ID="lblBtnShowNew" runat="server" Text="..." />
    </asp:LinkButton>
  </div>
  <div class="col-sm-8" style="height: 5em;">
    <div runat="server" id="divInsert" class="row">
      <div class="col-sm-3">
        <%: traduci("TableName") %>:<br />
                <asp:TextBox runat="server" ID="txtTableName" />
      </div>
      <div class="col-sm-3">
        <%: traduci("FieldName") %>:<br />
                <asp:TextBox runat="server" ID="txtFieldName" />
      </div>
      <div class="col-sm-3">
        <%: traduci("value") %>:<br />
                <asp:TextBox runat="server" ID="txtvalue" />
      </div>
      <div class="col-sm-3">
        <asp:LinkButton ID="btnDoInsert" runat="server" CssClass="btn btn-success btn-sm btn-block" OnClick="btnDoInsert_Click">
            <i class="glyphicon glyphicon-plus"></i>
            <%: traduci("insertNew") %>
        </asp:LinkButton>
      </div>
    </div>
  </div>
  <div class="col-sm-12">
    <asp:GridView ID="grView" runat="server" DataSourceID="ods" AllowPaging="True" AllowSorting="True"
      DataKeyNames="TableName,FieldName,value" AutoGenerateColumns="False" CssClass="table table-striped table-bordered"
      OnDataBound="grView_DataBound">
      <EmptyDataTemplate>
        <h3>
          <asp:Label runat="server" ID="lblNoRes" Text='<%# traduci("NoResultsFound") %>' />
        </h3>
        <asp:Label runat="server" ID="Label4" Text='<%# traduci("PleaseSelectFromList") %>' />
      </EmptyDataTemplate>
      <Columns>
        <asp:TemplateField ShowHeader="False" ItemStyle-HorizontalAlign="Center">
          <EditItemTemplate>
            <asp:LinkButton runat="server" ID="lbUpdate" CausesValidation="true" CommandName="Update"><i class="fa fa-check fa-2x"></i></asp:LinkButton><asp:LinkButton runat="server" ID="lbCancel" CausesValidation="false" CommandName="Cancel"><i class="fa fa-undo fa-2x"></i></asp:LinkButton>
          </EditItemTemplate>
          <HeaderTemplate>
          </HeaderTemplate>
          <ItemTemplate>
            <asp:LinkButton runat="server" ID="lbEdit" CausesValidation="false" CommandName="Edit"><i class="fa fa-edit text-info fa-2x"></i></asp:LinkButton>
          </ItemTemplate>
        </asp:TemplateField>
        <asp:BoundField DataField="TableName" HeaderText="TableName" ReadOnly="True" SortExpression="TableName" />
        <asp:BoundField DataField="FieldName" HeaderText="FieldName" ReadOnly="True" SortExpression="FieldName" />
        <asp:BoundField DataField="value" HeaderText="value" ReadOnly="True" SortExpression="value" />
        <asp:TemplateField HeaderText="label" SortExpression="label">
          <EditItemTemplate>
            <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("label") %>' />
          </EditItemTemplate>
          <ItemTemplate>
            <asp:Label ID="Label2" runat="server" Text='<%# Bind("label") %>' />
          </ItemTemplate>
          <FooterTemplate>
            <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("label") %>' Width="20em" />
          </FooterTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="ordinal" SortExpression="ordinal">
          <EditItemTemplate>
            <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("ordinal") %>' Width="3em" />
          </EditItemTemplate>
          <ItemTemplate>
            <asp:Label ID="Label3" runat="server" Text='<%# Bind("ordinal") %>' />
          </ItemTemplate>
          <FooterTemplate>
            <asp:TextBox ID="txtordinal" runat="server" Text='<%# Bind("ordinal") %>' Width="3em" />
          </FooterTemplate>
        </asp:TemplateField>
        <asp:TemplateField ShowHeader="False" ItemStyle-HorizontalAlign="Center">
          <HeaderTemplate>
            <%--<asp:LinkButton ID="lbtReset" runat="server" OnClick="btnShowFooter" CssClass="btn" Visible="true"><i class="glyphicon glyphicon-plus"></i> <%: traduci("btnNewListVal") %></asp:LinkButton>--%>
          </HeaderTemplate>
          <EditItemTemplate>
          </EditItemTemplate>
          <ItemTemplate>
            <asp:LinkButton runat="server" ID="lbDelete" CausesValidation="false" CommandName="Delete" OnClientClick='<%# SteamWare.jsUtils.getCBE("confermaDel") %>'><i class="fa fa-trash text-danger fa-2x"></i></asp:LinkButton>
          </ItemTemplate>
        </asp:TemplateField>
      </Columns>
    </asp:GridView>
    <asp:Label ID="lblNumRec" runat="server" CssClass="txtMini" />&nbsp;&nbsp;
        <asp:Label ID="lblWarning" runat="server" Visible="false" CssClass="erroreMid" />
    <asp:ObjectDataSource ID="ods" runat="server" InsertMethod="insertQuery"
      OldValuesParameterFormatString="Original_{0}" SelectMethod="getByTable" FilterExpression=" (value like '%{0}%' OR label like '%{0}%' OR (CONVERT(ordinal, 'System.String') LIKE '%{0}%')) "
      TypeName="CMS_SC_Data.DS_UtilityTableAdapters.ListValuesTableAdapter" DeleteMethod="deleteQuery" UpdateMethod="updateQuery">
      <SelectParameters>
        <asp:ControlParameter ControlID="ddlTable" PropertyName="SelectedValue" Name="TableName"
          DefaultValue="" Type="String" />
      </SelectParameters>
      <DeleteParameters>
        <asp:Parameter Name="Original_TableName" Type="String" />
        <asp:Parameter Name="Original_FieldName" Type="String" />
        <asp:Parameter Name="Original_value" Type="String" />
      </DeleteParameters>
      <FilterParameters>
        <asp:SessionParameter Type="String" Name="valore" SessionField="searchVal" />
      </FilterParameters>
      <InsertParameters>
        <asp:Parameter Name="TableName" Type="String" />
        <asp:Parameter Name="FieldName" Type="String" />
        <asp:Parameter Name="value" Type="String" />
        <asp:Parameter Name="label" Type="String" />
        <asp:Parameter Name="ordinal" Type="Int32" />
      </InsertParameters>
      <UpdateParameters>
        <asp:Parameter Name="label" Type="String" />
        <asp:Parameter Name="ordinal" Type="Int32" />
        <asp:Parameter Name="Original_TableName" Type="String" />
        <asp:Parameter Name="Original_FieldName" Type="String" />
        <asp:Parameter Name="Original_value" Type="String" />
      </UpdateParameters>
    </asp:ObjectDataSource>
    <asp:ObjectDataSource ID="odsTableName" runat="server" OldValuesParameterFormatString="original_{0}"
      SelectMethod="getDistTableName" TypeName="CMS_SC_Data.DS_UtilityTableAdapters.ListValuesTableAdapter"></asp:ObjectDataSource>
  </div>
</div>