public async Task <List <Eleve> > GetBestEleves() { EleveQuery query = new EleveQuery(monContexte); List <Eleve> result = await query.GetBestEleves(); return(result); }
public List <Eleve> SearchEleve(String searchString) { EleveQuery query = new EleveQuery(_contexte); List <Eleve> Eleves = query.SearchEleve(searchString); return(Eleves); }
public List <Eleve> GetEleves() { EleveQuery query = new EleveQuery(_contexte); var result = query.GetAll(); return(result); }
/// <summary> /// Retourne l'élève correspondant à l'identifiant /// </summary> /// <param name="id">Identifiant de l'élève</param> /// <returns>Entité <see cref="Eleve"/></returns> public Eleve GetEleveById(int id) { EleveQuery query = new EleveQuery(monContexte); Eleve result = query.GetById(id); return(result); }
/// <summary> /// Retourne tous les élèves /// </summary> /// <param name="criterias">critères de recherche</param> /// <returns>Liste d'entités <see cref="Eleve"/></returns> public List <Eleve> GetAllEleves(String criterias) { EleveQuery query = new EleveQuery(monContexte); List <Eleve> result = query.GetAll(criterias); return(result); }
public EleveAgController() { db = new ProNetDbContext(); eleveQuery = new EleveQuery(db); classeQuery = new ClasseQuery(db); eleveCommand = new EleveCommand(db); classeCommand = new ClasseCommand(db); }
public Eleve UpdateEleve(Eleve eleve) { EleveQuery query = new EleveQuery(_contexte); if (query.GetEleveById(eleve.EleveId) != null) { return(query.UpdateEleve(eleve)); } return(null); }
public ListEleveVM() { _eleves = new ObservableCollection <DetailEleveVM>(); query = new EleveQuery(_context); query.GetAll().ToList().ForEach(e => _eleves.Add(new DetailEleveVM(e))); if (_eleves != null && _eleves.Count > 0) { _selectedEleve = _eleves.ElementAt(0); } }
public Eleve getOneEleveById(int id) { EleveQuery eq = new EleveQuery(contexte); NoteQuerry nq = new NoteQuerry(contexte); AbsenceQuerry aq = new AbsenceQuerry(contexte); Eleve e = eq.GetOne(id); e.Notes = nq.GetAllByEleveId(e.Id).ToList() != null?nq.GetAllByEleveId(e.Id).ToList() : new List <Note>(); e.GetMoyenne(); e.Absences = aq.GetAllByEleveId(e.Id).ToList() != null?aq.GetAllByEleveId(e.Id).ToList() : new List <Absence>(); return(e); }
public List <Eleve> getEleveByClasseId(int id) { EleveQuery eq = new EleveQuery(contexte); NoteQuerry nq = new NoteQuerry(contexte); AbsenceQuerry aq = new AbsenceQuerry(contexte); List <Eleve> eleves = eq.getByClassId(id); foreach (Eleve e in eleves) { e.Notes = nq.GetAllByEleveId(e.Id).ToList() != null?nq.GetAllByEleveId(e.Id).ToList() : new List <Note>(); e.Absences = aq.GetAllByEleveId(e.Id).ToList() != null?aq.GetAllByEleveId(e.Id).ToList() : new List <Absence>(); } return(eleves); }
public Eleve GetOneEleve(int id) { EleveQuery eq = new EleveQuery(context); Eleve e = eq.GetOne(id); NoteQuery nq = new NoteQuery(context); e.Notes = nq.GetByEleveId(id).ToList(); AbsenceQuery aq = new AbsenceQuery(context); e.Absences = aq.GetByEleveId(id).ToList(); return(e); }
public List <Eleve> GetAllEleve() { EleveQuery eq = new EleveQuery(context); List <Eleve> eleves = new List <Eleve>(); foreach (Eleve e in eq.GetAll().ToList()) { NoteQuery nq = new NoteQuery(context); e.Notes = nq.GetByEleveId(e.Id).ToList(); AbsenceQuery aq = new AbsenceQuery(context); e.Absences = aq.GetByEleveId(e.Id).ToList(); eleves.Add(e); } return(eleves); }
public ListEleveViewModel() { Context c = new Context(); EleveQuery eq = new EleveQuery(c); List <Eleve> le = eq.GetAll().ToList(); _eleves = new ObservableCollection <DetailEleveViewModel>(); foreach (Eleve e in le) { _eleves.Add(new DetailEleveViewModel(e)); } if (_eleves != null && _eleves.Count > 0) { _selectedEleve = _eleves.ElementAt(0); } }
public Classe getOneClasseById(int id) { ClasseQuerry cq = new ClasseQuerry(contexte); EleveQuery eq = new EleveQuery(contexte); Classe classe = cq.GetOne(id); foreach (Eleve e in eq.getByClassId(id)) { Eleve eleve = getOneEleveById(e.Id); if (!classe.Eleves.Contains(eleve)) { classe.Eleves.Add(eleve); } } return(classe); }
public List <Eleve> GetAllEleve() { EleveQuery eq = new EleveQuery(contexte); List <Eleve> eleves = new List <Eleve>(); NoteQuerry nq = new NoteQuerry(contexte); AbsenceQuerry aq = new AbsenceQuerry(contexte); foreach (Eleve e in eq.GetAll().ToList()) { List <Note> notes = new List <Note>(); notes = nq.GetAllByEleveId(e.Id).ToList(); e.Notes = notes != null ? notes : new List <Note>(); e.GetMoyenne(); List <Absence> absences = new List <Absence>(); absences = aq.GetAllByEleveId(e.Id).ToList(); e.Absences = absences != null ? absences : new List <Absence>(); eleves.Add(e); } return(eleves); }
public Eleve DeleteEleve(int EleveID) { EleveQuery query = new EleveQuery(_contexte); return(query.DeleteEleve(EleveID)); }
public int AddEleve(Eleve e) { EleveQuery query = new EleveQuery(_contexte); return(query.AddEleve(e)); }
public Eleve GetEleve(int eleveId) { EleveQuery query = new EleveQuery(_contexte); return(query.GetEleveById(eleveId)); }
/*public List<Eleve> Get5Best() * { * EleveQuery eq = new EleveQuery(contexte); * return eq.Get5Best().ToList(); * }*/ public List <Eleve> GetEleveByClasse(int idClasse) { EleveQuery eq = new EleveQuery(contexte); return(eq.GetByClasse(idClasse).ToList()); }
public HomeController() { db = new ProNetDbContext(); eleveQuery = new EleveQuery(db); absenceQuery = new AbsenceQuery(db); }
/// <summary> /// Récupérer les élèves d'une classe en base par l'ID de la classe /// </summary> /// <returns>List<Eleve></returns> public List <Eleve> GetElevesByClasseId(int classeID) { EleveQuery eq = new EleveQuery(contexte); return(eq.GetByClasseID(classeID).ToList()); }
/// <summary> /// Récupérer un élève en base par son ID /// </summary> /// <returns>Eleve</returns> public Eleve GetEleveById(int eleveID) { EleveQuery eq = new EleveQuery(contexte); return(eq.GetByID(eleveID).SingleOrDefault()); }
/// <summary> /// Récupérer une liste d'élève en base /// </summary> /// <returns>Liste de Eleve</returns> public List <Eleve> GetAllEleve() { EleveQuery eq = new EleveQuery(contexte); return(eq.GetAll().ToList()); }
public List <Eleve> GetEleveByClasseId(int id) { EleveQuery eq = new EleveQuery(context); return(eq.GetAllByClasseId(id)); }
public Eleve GetEleveById(int idEleve) { EleveQuery eq = new EleveQuery(contexte); return(eq.GetById(idEleve)); }
public List <Eleve> GetElevesForClasse(int ClassId) { EleveQuery query = new EleveQuery(_contexte); return(query.GetEleveForClasse(ClassId)); }
public List <Eleve> GetEleveByName(string name) { EleveQuery eq = new EleveQuery(contexte); return(eq.GetByName(name).ToList()); }