How to edit a Boolean field in a list in Asp.Net MVC

Question

Guys, I’m developing an application that manages Courses, and I have the following problem. On my screen Administrator I need the fields Course Name, Student Name and the countryside Approved which is a field booleano. That screen is where the Administrator tells which pupil is approved in the course you signed up for. Only in my View only fields appear Course Name and the countryside Approved and nay appears the Student Name, as shown below.

The other problem is that this field of mine Approved when I mark the checkbox he’s not saving like true in the Database, is always getting false.

Action Aprovacao of controller Course

public ActionResult Aprovacao()
    {
        return View(db.Cursos.ToList());
    }

My View Aprovacao

@model IEnumerable<MeuProjeto.Models.Curso>

@{
    Layout = "/Views/Shared/_Layout.cshtml";
}

<h2>Aprovação</h2>

<table class="table table-hover">
    <tr>
        <th>
            Curso
        </th>
        <th>
            Aluno
        </th>
        <th>
            Aprovado?
        </th>

        <th></th>
    </tr>

    @foreach (var item in Model)
    {
        <tr>
            <td>
                @Html.DisplayFor(modelItem => item.Nome_Curso)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.AlunoCursos)
            </td>
            <td>
                @*@Html.DisplayFor(modelItem => item.Aprovado)*@
                <input type="checkbox" id="Aprovado" name="Aprovado" value="Aprovado"/>
            </td>
        </tr>
    }

</table>
@section Scripts {
    @Scripts.Render("~/bundles/jqueryval")

}

Answer 1

As far as I can tell, there’s nothing that fires a Action to the Controller, then your View needs some modifications:

1. Identify the CheckBox correctly

@foreach (var item in Model)
{
    <tr>
        <td>
            @Html.DisplayFor(modelItem => item.Nome_Curso)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.AlunoCursos)
        </td>
        <td>
            @Html.CheckBox("Aprovado_" + item.Nome_Curso, new { @class = "Aprovado", id = item.Id })
        </td>
    </tr>
}

2. Add Script that shoots Action

This can be done by Ajax:

$(".Aprovado").click(function() {
    $.ajax({
        url: '@Url.Action("Aprovacao", "Curso")',
        type: "POST",
        data: { id = $(this).attr('id') },
        success: function (data) {
            alert("Aprovação feita com sucesso!");
        }
   });
});

3. Create a Action Aprovar in AlunoCursosController

[HttpPost]
public ActionResult Aprovar(int id)
{
    var alunoCurso = db.AlunoCursos.FirstOrDefault(ac => ac.AlunoCursoId == id);
    alunoCurso.Aprovado = !alunoCurso.Aprovado;
    db.Entry(alunoCurso).State = EntityState.Modified;
    db.SaveChanges();
}

About the column Aluno

When it comes to selecting AlunoCursos, try the following:

public ActionResult Aprovacao()
{
    return View(db.AlunoCursos.Include(ac => ac.Aluno).ToList());
}

To display:

@Html.DisplayFor(modelItem => item.AlunoCursos.Aluno.Nome)