// GET: Matchs
public ActionResult Index()
{
using (championnatEntities db = new championnatEntities())
{
List <Match> matchs = db.Matchs.ToList();
List <Equipe> equipes = db.Equipes.ToList();
List <Stade> stades = db.Stades.ToList();
var match = from m in matchs
join e in equipes on m.NomEqDom equals e.NomEq into table1
from e in table1.ToList()
join eq in equipes on m.NomEqVis equals eq.NomEq into table2
from eq in table2.ToList()
join s in stades on m.nomStd equals s.NomStd into table3
from s in table3.ToList()
select new ViewModel
{
match = m,
equipe = e,
equipe1 = eq,
stade = s
};
return(View(match));
}
}
// GET: Entrainer
public ActionResult Index()
{
using (championnatEntities db = new championnatEntities())
{
List <Entrainer> entrainers = db.Entrainers.ToList();
List <Entraineur> entraineurs = db.Entraineurs.ToList();
List <Equipe> equipes = db.Equipes.ToList();
List <Saison> saisons = db.Saisons.ToList();
var entrainer = from en in entrainers
join e in entraineurs on en.codeent equals e.codeent into table1
from e in table1.ToList()
join eq in equipes on en.nomeq equals eq.NomEq into table2
from eq in table2.ToList()
join s in saisons on en.codesai equals s.CodeSai into table3
from s in table3.ToList()
select new ViewModel
{
entrainer = en,
entraineur = e,
equipe = eq,
saison = s
};
return(View(entrainer));
}
}
public ActionResult loadData()
{
using (championnatEntities db = new championnatEntities())
{
var data = db.Matchs.ToList();
return(Json(new { data = data }, JsonRequestBehavior.AllowGet));
}
}
