public DetailFormation ObtenirDetailsFormation(string nomSeo) { DetailFormation detailFormationEntity = null; using (var context = new AvisEntities()) { Formation detailEntity = context.Formation.SingleOrDefault(f => f.NomSeo == nomSeo); if (detailEntity != null) { detailFormationEntity = new DetailFormation(detailEntity) { MoyenneDesVotes = 0, NombreVotant = 0 }; if (detailEntity.Avis.Any()) { detailFormationEntity.MoyenneDesVotes = Math.Round(detailEntity.Avis.Average(a => a.Note), 1); detailFormationEntity.NombreVotant = detailEntity.Avis.Count(); detailFormationEntity.Avis = detailEntity.Avis.ToList(); } } } return(detailFormationEntity); }
/// <summary> /// Affichage de 4 formations au hazard sur la page d'accueil /// </summary> public List <DetailFormation> ObtenirDetailFormations() { var detailFormationListe = new List <DetailFormation>(); using (var context = new AvisEntities()) { List <Formation> formation = context.Formation.OrderBy(x => Guid.NewGuid()).Take(4).ToList(); foreach (Formation formationdetail in formation) { DetailFormation detailsFormations = ObtenirDetailsFormation(formationdetail.NomSeo); if (detailsFormations != null) { detailFormationListe.Add(detailsFormations); } } } return(detailFormationListe); }