Show users who do not have a department

Question

Show users who do not have a department

Navigation

#1 by (1 votes)

2

I want to show the names of people who do not have a departamento

The data is:

+----+---------+----------------+    +----+--------------------+
| id | Nombre  | idDepartamento |    | id | NombreDepartamento |
+----+---------+----------------+    +----+--------------------+
| 44 | Daniel  |        1       |    | 1  |    Desarrollo      |
+----+---------+----------------+    +----+--------------------+
| 45 | Manuel  |        0       |    | 2  |   Contabilidad     |
+----+---------+----------------+    +----+--------------------+
| 47 |  Juan   |        0       |
+----+---------+----------------+
| 49 | Alfonso |        0       |
+----+---------+----------------+

I want to show them in a select of

c# asp.net-mvc-5 razor

asked by JuankGlezz 14.01.2017 в 00:05

source

1 answer

Problem with DialogFragment on Android? Uncaught TypeError: Can not read property '3' of undefined

score 1 · Accepted Answer

Try the following using Linq in your in your razor:

<select class="form-control" name="UsuarioSelect" multiple>
  <optgroup label="Sin Departamento"></optgroup>
  @foreach (var empleado in Model.Empleados.Where(i=>i.IdDepartamento == 0))
  {    
    <option value="@empleado.id">@empleado.Nombre</option>
  }

  @{foreach (var departamento in Model.Departamentos)
  {
    <optgroup label="@departamento.Departamento"></optgroup>
    foreach (var empleado in Model.Empleados.Where(i=>i.IdDepartamento == departamento.id))
    {
       <option value="@empleado.id">@empleado.Nombre</option>         
    }
  }
</select>