public IEnumerable <LesNotes> notesMod(string idMod) { eleveDAO = new EleveDAO("eleves"); string req = "select e.nom,e.prenom,ma.codeMat,ma.codeModule,mo.code_Fil,n.note " + "from eleves e,matieres ma, modules mo ,notes n " + "where ma.codeModule = mo.codeModule " + "and n.codeElev = e.codeElev " + "and n.codeMat = ma.codeMat and mo.codeModule='" + idMod + "' "; List <Dictionary <string, string> > data = new List <Dictionary <string, string> >(); data = eleveDAO.Select(req); List <LesNotes> les_notes = new List <LesNotes>(); foreach (Dictionary <string, string> elt in data) { LesNotes m = new LesNotes(elt["nom"], elt["prenom"], elt["codeMat"], elt["codeModule"], elt["code_Fil"], elt["note"]); les_notes.Add(m); } int length = les_notes.Count; return(Enumerable.Range(0, length).Select(index => new LesNotes { Nom = les_notes[index].Nom, Prenom = les_notes[index].Prenom, CodeMat = les_notes[index].CodeMat, CodeModule = les_notes[index].CodeModule, CodeFiliere = les_notes[index].CodeFiliere, Note = les_notes[index].Note })); }
public IEnumerable <Absence> absences(string codeMat) { eleveDAO = new EleveDAO("eleves"); int length = codeMat.Length; char niveau = codeMat[length - 3]; string filiere = codeMat.Substring(0, length - 3); string req = "select e.codeElev,e.nom,e.prenom " + "from eleves e " + " where e.niveau=" + niveau + " and e.code_fil='" + filiere + "';"; List <Dictionary <string, string> > data = new List <Dictionary <string, string> >(); data = eleveDAO.Select(req); if (data != null) { List <Absence> absences_list = new List <Absence>(); foreach (Dictionary <string, string> elt in data) { Absence a = new Absence(elt["codeElev"], elt["nom"], elt["prenom"]); absences_list.Add(a); } length = absences_list.Count; return(Enumerable.Range(0, length).Select(index => new Absence { Nom = absences_list[index].Nom, Prenom = absences_list[index].Prenom, CodeEleve = absences_list[index].CodeEleve })); } else { return(Enumerable.Range(0, 1).Select(index => new Absence { Nom = "", Prenom = "", CodeEleve = "" })); } }