Search code examples
c#jqueryasp.netrepeater

Keep a running total in Repeater control, trying to modify existing code


I have a script that keeps running totals as values are being entered into a GridView form control.

This works great. Below is the code:

  <script type="text/javascript">
        $(function () {
            $('[id*=txttaxpayerret]').keyup(function () {
                totalcalculate();
            });
            window.onload = totalcalculate();
            function totalcalculate() {
                var total = 0;
                for (var i = 0; i < $('.txttaxpayerret').length; i++) {
                    var temp = $('.txttaxpayerret')[i].value;
                    temp != "" ? temp : temp = 0;
                    total = parseFloat(temp) + parseFloat(total);
                    $('[id*=lblTotal]').html(total);
                }
            }
        });
 </script>
<asp:Label ID="lblTotal" runat="server"></asp:Label>

we recently switched from GridView control to Repeater and since then, the code stopped worked working.

I have been trying to modify to work with Repeater control but to no avail.

Any ideas how to get this code to continue to keep a running to total user's entry as they are being entered?

llblTotal is outside the Repeater control.

However, txttaxpayerret is inside the Repeater control

<asp:TextBox ID="txttaxpayerret" runat="server" Width="280px"></asp:TextBox>

UPDATED:

         <asp:Repeater ID="rptAircraft" runat="server">
                <ItemTemplate>
                  <tr>
                    <td>
                         <asp:TextBox ID="TextBox2" runat="server" Width="280px" Text='<%#Eval("taxpayerret") %>'></asp:TextBox>
                    </td>
                </tr>
             </ItemTemplate>
           </asp:Repeater>
          <tr>
            <td>
                 <asp:TextBox ID="txttaxpayerret"  CssClass="clsTxtToCalculate" runat="server" Width="280px"></asp:TextBox>
            </td>
          </tr>
         </table>
         asp:Button ID="btnAdd" runat="server" Width="70px" Text="Add More" onclick="btnAdd_Click" />
         <asp:Label ID="lblTotal" runat="server"></asp:Label>

UPDATED:

<script type="text/javascript">
   $(function () {
        $('body').on('keyup', '.taxInput', function (e) {
            totalcalculate();
        });
        window.onload = totalcalculate();
        function totalcalculate() {
            var total = 0;
            for (var i = 0; i < $('.taxInput').length; i++) {
                var temp = $('.taxInput')[i].value;
                temp != "" ? temp : temp = 0;
                total = parseFloat(temp) + parseFloat(total);
                $('[id*=lblTotal]').html(total);
            }
        }
});

  <table border="1" style="width:50%;text-align:center">
<tr>
<td style="width:100%;vertical-align: text-top;">
<asp:ScriptManager ID="scriptManager" runat="server"></asp:ScriptManager>
 <asp:UpdatePanel ID="upPanael" runat="server">
  <ContentTemplate>
    <div><div>
        <table border="1">
            <tr>
                <th>
                    AIRCRAFT REGISTRATION #:
                </th>
                <th>
                    RETURNED VALUE<br /> 
                </th>
                <th>
                    FOR TAX OFFICE USE ONLY<br />
                </th>
                <th>&nbsp;</th>
            </tr>
             <asp:Repeater ID="rptAircraft" runat="server">
                    <ItemTemplate>
                      <tr>
                        <td>
                            <asp:TextBox ID="TextBox1" runat="server" Width="530px" Text='<%#Eval("boatregNum") %>'></asp:TextBox>
                        </td>
                        <td>
                             <asp:TextBox ID="TextBox2" runat="server" Width="280px" Text='<%#Eval("taxpayerret") %>'></asp:TextBox>
                        </td>
                        <td>
                            <asp:TextBox ID="TextBox3" runat="server" Width="256px" Text='<%#Eval("fortaxofficeonly") %>'></asp:TextBox>
                        </td>
                        <td>&nbsp;</td>
                    </tr>
                 </ItemTemplate>
               </asp:Repeater>
              <tr>
                <td>
                    <asp:TextBox ID="txtboatregNum" runat="server" Width="530px"></asp:TextBox>
                </td>
                <td>
                     <asp:TextBox ID="txttaxpayerret"  CssClass="taxInput" runat="server" Width="280px"></asp:TextBox>
                </td>
                <td>
                    <asp:TextBox ID="txtfortaxofficeonly" runat="server" Width="256px"></asp:TextBox>
                </td>
                <td style="white-space:nowrap;">
                   <asp:Button ID="btnAdd" runat="server" Width="70px" Text="Add New" onclick="btnAdd_Click" />
                   <asp:Button ID="btnDelete" runat="server" Width="70px" Text="Remove" OnClick="btnDelete_Click" />
                </td>
            </tr>
        </table>
    </div>
    </div>
   </ContentTemplate>
  </asp:UpdatePanel>
   </td>
    </tr>
  </table>
  <table border="1" style="width: 87%; text-align: center">
    <tr>
        <td style="width: 43.6%;">
            TOTAL&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;>
        </td>
        <td style="width: 23.2%;">
            <asp:Label ID="lblTotal" runat="server"></asp:Label>
        </td>
        <td class="auto-style4">
        </td>
    </tr>
</table>

protected void btnAdd_Click(object sender, EventArgs e)
{
    DataTable dtAircraft = new DataTable();
    dtAircraft = GetAircraftInfo();

    if (ViewState["AircraftTable"] != null)
    {
        dtAircraft = (DataTable)ViewState["AircraftTable"];


        rptAircraft.DataSource = dtAircraft;
        rptAircraft.DataBind();
        rptAircraft.Visible = true;
    }
    else
    {
        rptAircraft.DataSource = null;
        rptAircraft.DataBind();
        rptAircraft.Visible = false;
    }
    txtboatregNum.Text = string.Empty;
    txttaxpayerret.Text = string.Empty;
    txtfortaxofficeonly.Text = string.Empty;
}

private DataTable GetAircraftInfo()
{

    DataTable dtAircraft = null;
    if (ViewState["RowNumber"] != null)
    {
        int RowNumber = Convert.ToInt32((ViewState["RowNumber"]));
        RowNumber++;
        ViewState["RowNumber"] = RowNumber;
    }
    else
    {
        ViewState["RowNumber"] = 1;
    }

    if (ViewState["AircraftTable"] == null)
    {
        dtAircraft = new DataTable("AircraftTable");
        dtAircraft.Columns.Add(new DataColumn("RowNumber", typeof(int)));
        dtAircraft.Columns.Add(new DataColumn("boatregNum", typeof(string)));
        dtAircraft.Columns.Add(new DataColumn("taxpayerret", typeof(string)));
        dtAircraft.Columns.Add(new DataColumn("fortaxofficeonly", typeof(string)));

        ViewState["AircraftTable"] = dtAircraft;
    }
    else
    {
        dtAircraft = (DataTable)ViewState["AircraftTable"];
    }
    DataRow dtRow = dtAircraft.NewRow();

    dtRow["RowNumber"] = Convert.ToInt32(ViewState["RowNumber"]);
    dtRow["boatregNum"] = txtboatregNum.Text.Trim();
    dtRow["taxpayerret"] = txttaxpayerret.Text.Trim();
    dtRow["fortaxofficeonly"] = txtfortaxofficeonly.Text.Trim();
    dtAircraft.Rows.Add(dtRow);
    ViewState["AircraftTable"] = dtAircraft;
    return dtAircraft;
}

Solution

  • When you do this $('.txttaxpayerret') you're trying to get an input with a class named txttaxpayerret (Reference: https://developer.mozilla.org/en-US/docs/Web/CSS/Class_selectors)

    You can fix this by adding a class to your input.

    <asp:TextBox ID="txttaxpayerret" CssClass="taxInput" runat="server" Width="280px"></asp:TextBox>
    

    And then you can use that class as a selector:

       $(function () {
            $('body').on('keyup', '.taxInput', function (e) {
                totalcalculate();
            });
            window.onload = totalcalculate();
            function totalcalculate() {
                var total = 0;
                for (var i = 0; i < $('.taxInput').length; i++) {
                    var temp = $('.taxInput')[i].value;
                    temp != "" ? temp : temp = 0;
                    total = parseFloat(temp) + parseFloat(total);
                    $('[id*=lblTotal]').html(total);
                }
            }
        });