/// <summary> /// Retourne la classe correspondant à l'identifiant /// </summary> /// <param name="id">Identifiant de la classe</param> /// <returns>Entité <see cref="Classe"/></returns> public Classe GetClasseById(int id) { ClasseQuery query = new ClasseQuery(monContexte); Classe result = query.GetById(id); return(result); }
/// <summary> /// Retourne toutes les classes /// </summary> /// <returns>Liste d'entités <see cref="Classe"/></returns> public List <Classe> GetAllClasses() { ClasseQuery query = new ClasseQuery(monContexte); List <Classe> result = query.GetAll(); return(result); }
public Classe GetOneClasse(int id) { ClasseQuery cq = new ClasseQuery(context); Classe c = cq.GetOne(id); c.Eleves = GetEleveByClasseId(id); return(c); }
public EleveAgController() { db = new ProNetDbContext(); eleveQuery = new EleveQuery(db); classeQuery = new ClasseQuery(db); eleveCommand = new EleveCommand(db); classeCommand = new ClasseCommand(db); }
public List <Classe> GetAllClasse() { ClasseQuery cq = new ClasseQuery(context); List <Classe> classes = new List <Classe>(); foreach (Classe c in cq.GetAll().ToList()) { c.Eleves = GetEleveByClasseId(c.Id); classes.Add(c); } return(classes); }
public Classe DeleteClasse(int ClassId) { ClasseQuery query = new ClasseQuery(_contexte); return(query.DeleteClasse(ClassId)); }
public Dictionary <int, Eleve> GetElevesByClasses() { ClasseQuery query = new ClasseQuery(_contexte); return(query.GetElevesByClasses()); }
public Classe GetClasse(int ClassId) { ClasseQuery query = new ClasseQuery(_contexte); return(query.GetClasse(ClassId)); }
public List <Classe> GetClasses() { ClasseQuery query = new ClasseQuery(_contexte); return(query.GetAll()); }
/// <summary> /// Récupérer une classe en base par son ID /// </summary> /// <returns>Classe</returns> public Classe GetClasseById(int classeID) { ClasseQuery cq = new ClasseQuery(contexte); return(cq.GetByID(classeID).SingleOrDefault()); }
/// <summary> /// Récupérer une liste de classe en base /// </summary> /// <returns>Liste de Classe</returns> public List <Classe> GetAllClasse() { ClasseQuery cq = new ClasseQuery(contexte); return(cq.GetAll().ToList()); }
public async Task <QueryResult <Section> > GetAll(ClasseQuery sectionQuery) { var result = new QueryResult <Section>(); var query = _dbSet .Include(s => s.NiveauSpecialite) .ThenInclude(ns => ns.Specialite) .ThenInclude(s => s.Filiere) .ThenInclude(f => f.DomaineFormation) .Include(s => s.Groupes) .ThenInclude(g => g.SousGroupes) .AsQueryable(); if (sectionQuery != null) { //Domaine De Formation Filter if (sectionQuery.DFId.HasValue) { query = query.Where(dp => dp.NiveauSpecialite.Specialite.Filiere.DomaineFormation.Id == sectionQuery.DFId); } //Filiaire Filter if (sectionQuery.FiliaireId.HasValue) { query = query.Where(dp => dp.NiveauSpecialite.Specialite.Filiere.Id == sectionQuery.FiliaireId); } //Specialite Filter if (sectionQuery.SpecialiteId.HasValue) { query = query.Where(dp => dp.NiveauSpecialite.Specialite.Id == sectionQuery.SpecialiteId); } //Niveau de Specialite Filter if (sectionQuery.NivSpecId.HasValue) { query = query.Where(dp => dp.NiveauSpecialite.Id == sectionQuery.NivSpecId); } var columnMap = new Dictionary <string, Expression <Func <Section, object> > >() { ["refSection"] = s => s.RefSection }; query = query.ApplyOrdering(sectionQuery, columnMap); result.TotalItems = await query.CountAsync(); query = query.ApplyPaging(sectionQuery); result.Items = await query.ToListAsync(); return(result); } else { result.TotalItems = await query.CountAsync(); result.Items = await query.ToListAsync(); return(result); } }
public ClasseTest() { _context = new ProNetDbContext(); comm = new ClasseCommand(_context); query = new ClasseQuery(_context); }
public ClasseTests() { _context = new Context(); com = new ClasseCommands(_context); query = new ClasseQuery(_context); }
public Classe UpdateClasse(Classe classe) { ClasseQuery query = new ClasseQuery(_contexte); return(query.UpdateClasse(classe)); }
public void AddClasse(Classe classe) { ClasseQuery query = new ClasseQuery(_contexte); query.AddClasse(classe); }
public ClasseController() { db = new ProNetDbContext(); classeQuery = new ClasseQuery(db); classeCommand = new ClasseCommand(db); }