public async Task <IActionResult> OnGetAsync()
{
Filieres = await db.Filieres.ToListAsync();
nbrFiliere = Filieres.Count();
return(Page());
}
private static void SeedFilieres(DataContext dataContext)
{
if (dataContext.Filieres.Where(s => s.NomFiliere.Equals("informatique")).FirstOrDefault() == null)
{
Filieres filieres = new Filieres();
filieres.NomFiliere = "informatique";
dataContext.Filieres.Add(filieres);
dataContext.SaveChanges();
}
if (dataContext.Filieres.Where(s => s.NomFiliere.Equals("Génie télécommunication et reseaux")).FirstOrDefault() == null)
{
Filieres filieres = new Filieres();
filieres.NomFiliere = "Génie télécommunication et reseaux";
dataContext.Filieres.Add(filieres);
dataContext.SaveChanges();
}
}
public async Task <IViewComponentResult> InvokeAsync()
{
Filieres filGtr = _dataContext.Filieres.Where(s => s.NomFiliere.Equals("Génie télécommunication et reseaux")).FirstOrDefault();
List <GroupsModel> grpsModel = new List <GroupsModel>();
if (filGtr != null)
{
List <Groupes> grps = _dataContext.Groupes.Where(g => g.Students.FirstOrDefault().IdFil == filGtr.IdFiliere).ToList();
GroupsModel testModel;
foreach (Groupes grp in grps)
{
List <AspNetUsers> student = (from s in _dataContext.Students
join u in _dataContext.AspNetUsers
on s.IdUser equals u.Id
where (s.GroupId == grp.Id && s.IdFil == filGtr.IdFiliere)
select u).ToList();
testModel = new GroupsModel();
testModel.id = grp.Id;
testModel.sujet = grp.Sujet;
testModel.students = student;
Societes societe = _dataContext.Societes.Where(s => grp.IdSociete == s.Id).FirstOrDefault();
if (societe != null)
{
testModel.ville = societe.Ville;
}
Professors professor = _dataContext.Professors.Where(s => grp.Idprof == s.Id).FirstOrDefault();
if (professor != null)
{
testModel.encadrant = _dataContext.AspNetUsers.Where(s => s.Id == professor.IdUser).FirstOrDefault();
}
grpsModel.Add(testModel);
}
}
return(View(grpsModel));
}
