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());
}
