public ActionResult Index()
{
CarteleraDBEntities db = new CarteleraDBEntities();
var data = db.Pasas
.Include(p => p.Pelicula)
.Include(p => p.Pelicula.Genero)
.Include(p => p.Pelicula.Actores)
.Include(p => p.Tanda)
.Include(p => p.Cine)
.Include(p => p.Cine.Direccion)
.Include(p => p.Cine.Tarifas);
var query = (from c in data
//group c by new { c.CineId, c.PeliculaId } into Cartelera
group c by c.CineId into Cartelera
orderby Cartelera.Key
select new
{
CineId = Cartelera.Key,
Tandas = Cartelera.Select(x => x.Tanda.Hora),
Peliculas = Cartelera.Select(x => x.Pelicula),
Cartelera.FirstOrDefault().Cine,
})
.ToList()
.Select(c => new ViewModel.CarteleraViewModel
{
Cine = c.Cine,
Peliculas = c.Peliculas,
Tandas = c.Tandas,
CineId = c.CineId
}).ToList();
ViewBag.Cartelera = query;
return(View());
}
