affichage de données mvc

public class commande { public int id { get; set; } public int perssonneid { get; set; } public int bookid { get; set; } [DataType(DataType.Date)] [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}", ApplyFormatInEditMode = true)] [Display(Name = "Start Date")] public DateTime StartDate { get; set; } public virtual book bookgetr { get; set; } public virtual personne personngeter { get; set; } }

public ActionResult all() { var rslt = from c in db.commands join b in db.boks on c.bookid equals b.id join p in db.presons on c.perssonneid equals p.id select new { b_name = b.name, p_name = p.name, StartDate = c.StartDate }; rslt .ToList(); return View( rslt ); }

Salut,

Il faut "typer" le model que la vue va avoir besoin en utilisant ce que l'on appelle un ViewModel.

En MVC il n'y a pas de "ListView" tu utilises un composant externe ?

ViewModel :

Code:

1
2
3
4
5
6
    public class CommandViewModel
    {
        public string BookName { get; set; }
        public string PersonName { get; set; }
        public DateTime StartDate { get; set; }
    }

Controller :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
        public ActionResult All()
        {
            var commandViewModels = from c in db.commands
                join b in db.boks on c.bookid equals b.id
                join p in db.presons on c.perssonneid equals p.id
                select new CommandViewModel
                {
                    BookName = b.name,
                    PersonName = p.name,
                    StartDate = c.StartDate
 
                };
            return View(commandViewModels.ToList());
        }

View :

Code:

1
2
3
4
5
6
7
8
9
@model IEnumerable<CommandViewModel>
@{
    ViewBag.Title = "All";
}
 
@foreach (var commandViewModel in Model)
{
    <div>@commandViewModel.PersonName | @commandViewModel.BookName | @commandViewModel.StartDate.ToShortDateString()</div>
}