Answers

• colin Posts: 15,240Questions: 1Answers: 2,599

  September 2019

  Hi @LearningStuff ,

  I don't follow your thread but this might help - it's showing how to count checkboxes in a column - I suspect you can use this as a template for your requirements.

  Cheers,

  Colin
• LearningStuff Posts: 11Questions: 3Answers: 0

  September 2019

  Hi @colin

  Sorry for any confusion, let me clarify.
  Essentially I would like certain checkboxes showing checked if a value in the database for each object is 1. I tried to achieve this via Razor in my cshtml by doing

  <td><input type="checkbox" class="checkBox" val=@item.Value @(item.Value ? "checked=\"checked\"" : "") /></td>
  

  However, this keeps the checkbox click event only returning true even when unchecking.

  I handle the checkbox event in my js file as suggested in the other thread

  $('.checkBox').on("change", function () {
          var row = $(this).closest('tr');
          var data = table.row(row).data();
          console.log('Using TR:', data)
          console.log('Checked ID from TR:', data[0]);
          var ID = data[0];
          //Now need to set it to the values in the criteria I created
          UpdateCriteria.IDToUpdate = data[0];
          var status = $('.checkBox').is(":checked");
          UpdateCriteria.StatusChange = status ? 1:0;
  
          var request = $.ajax({
              url: "StatusUpdate",
              dataType: "html",
              //traditional: "true",
              type: "POST",
              data: "{UpdateCriteria:" + JSON.stringify(UpdateCriteria) + "}",
              contentType: "application/json; charset=utf-8"
          });
  

  With the code above, checkbox returns true/false accurately on click/unclick, but when I add in the Razor code into my cshtml, it only returns true despite unclick.
• LearningStuff Posts: 11Questions: 3Answers: 0

  September 2019

  @colin Thanks for showing me the every method. I'm about to select all checkboxes using that however, I come across the same issue as it's constantly running it but I only want it to run once. Even on unclick, it shows true for the checkboxes because the function is constantly running? I'm not entirely sure.

  Here is my js

  var populateCheckBoxes = function () {
      var table = $('#statsTable').DataTable();
          table.rows().every( function ( rowIdx, tableLoop, rowLoop ) {
              var data = this.data();
              //This checks if the value is true
              if (data[4] === "True") {
                  console.log("true");
                  $('.checkBox').prop('checked',true);
              }
          });
  };
  

  $(document).ready(function () {
      populateCheckBoxes();
      var table = $('#statsTable').DataTable({... });
  });
  
• LearningStuff Posts: 11Questions: 3Answers: 0

  September 2019

  Here is how I solved the issue, I had to use js to get the checkbox value instead of jQuery. See the status variable in the js file.

  cshtml

      <tbody>
          @foreach (var item in Model.SearchResult)
          {
              <tr>
                  <td "col-md-1" class="ID" val="@item.ID">@item.ID</td>
                  <td "col-md-1" val="@item.Name">@item.Name</td>
                  <td><input type="checkbox" class="checkBox" val=@item.Value @(item.Value ? "checked=true" : "") /></td>
                  <td></td>
              </tr>
          }
      </tbody>
  

  js

   $('.checkBox').on("change", function () {
          var row = $(this).closest('tr');
          var data = table.row(row).data();
          var ID = data[0];
          var status = (this).checked;