public ActionResult Details(int id) { BlogEntities db = new BlogEntities(); ArticolViewModel model = db.Postares.Include(a => a.Pozas) .Include(p => p.Comentarius) .Select((p => new ArticolViewModel { Id = p.Id, Titlu = p.Titlu, DataCreare = p.DataCreare, Text = p.Text, ListaComentarii = p.Comentarius .Where(s => s.Aprobat) .Select(c => new ComentariuViewModel { Id = c.Id, DataCreare = c.DataCreare, Aprobat = c.Aprobat, Edited = c.Edited, Nume = c.Nume, Text = c.Text, Titlu = c.Titlu }).ToList(), ListaPoze = p.Pozas })) .FirstOrDefault(p => p.Id == id); return(View(model)); }
public ActionResult Details(int id) { BlogEntities db = new BlogEntities(); ArticolViewModel model = db.Postares.OrderByDescending(p => p.DataCreare).Include(a => a.Pozas) .Include(p => p.Comentarius) .Select((p => new ArticolViewModel { Id = p.Id, Titlu = p.Titlu, DataCreare = p.DataCreare, Text = p.Text, ListaComentarii = p.Comentarius.Where(a => a.Aprobat).OrderByDescending(s => s.DataCreare).ToList(), ListaPoze = p.Pozas })) .FirstOrDefault(p => p.Id == id); model.LoggedUser = User.Identity.Name; return(View(model)); }