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