Send a list of data in a viewbag and receive in a foreach in the view

Question

The query data is correct, but I cannot return the data to the view.

Controller:

var disponib = (from d in db.Disponibilidade
                join c in db.Catequista on d.CatequistaID equals c.CatequistaID
                where c.CatequistaID == d.CatequistaID && d.CatequistaID == id
                select new
                {
                    AnoPastoral = d.AnoPastoral,
                    DiaDisponivel = d.DiaDisponivel,
                    HoraDisponivel = d.HoraDisponivel,
                    HoraFim = d.HoraFim,
                    Observacoes = d.Observacoes,
                }).ToList();

ViewBag.Disponibilidade = disponib;

View:

@model WebAppCatechesis2.Models.Catequista

@foreach (var item in ViewBag.Disponibilidade)
{    
    //  ???
}

Answer 1

var lista = linq.toList<suaClasse>();
ViewBag.MinhaView = lista;


@foreach (var item in ViewBag.MinhaView as IList<suaClasse>) {
   //-- Codigo
}

Line = (your query expression)

It is feasible to put before the foreach a check of the type:

@if(ViewBag.MinhaView != null) {
   //-- foreach aqui
}

I don’t know about your application, but there’s how you pass an object to the view maybe it’s even better:

return PartialView("NomeDaView", ObjetoDeClasse);

in View accesses with

@model ObjetoDeClasse

@foreach(var item in Model){ 
   //-- Codigo
}

I hope to help.

Answer 2

Problem solved with the query

var disponib = (from d in db.Disponibilidade
                            join c in db.Catequista on d.CatequistaID equals c.CatequistaID
                            where c.CatequistaID == d.CatequistaID && d.CatequistaID == id
                            select d);

            ViewBag.Disponibilidade = disponib;