public DataSet Bulletins()
        {
            List <GridViewModel> list = new List <GridViewModel>();

            foreach (Etudiant e in context.Etudiants)
            {
                float       somme     = 0;
                int         sommecoef = 0;
                var         query     = from n in context.Notes where n.Idetudiant == e.Id select n;
                List <Note> notes     = query.ToList <Note>();

                foreach (Note n in notes)
                {
                    Matiere matiere = (from m in context.Matieres where m.Id == n.Idmatiere select m).First <Matiere>();
                    somme     += n.NoteObtenue * matiere.Coef;
                    sommecoef += matiere.Coef;
                }
                float noteFinal = somme / sommecoef;
                list.Add(new GridViewModel()
                {
                    ID = e.Id, nom = e.Nom, prenom = e.Prenom, note = noteFinal
                });
            }

            return(Helper.ToDataSet(list));
        }
        public void AjouterMatiere(int Id, int Coef, string Libelle)
        {
            Matiere Matiere = new Matiere()
            {
                Id = Id, Coef = Coef, Libelle = Libelle
            };

            context.Matieres.Add(Matiere);
            context.SaveChanges();
        }