Example #1
0
        /// <summary>
        /// Retourne le nombre d'absences d'un élève
        /// </summary>
        /// <param name="eleveId">Identifiant de l'élève</param>
        /// <returns></returns>
        public int GetNbAbsencesByEleveId(int eleveId)
        {
            AbsenceQuery   query  = new AbsenceQuery(monContexte);
            List <Absence> result = query.GetByEleveId(eleveId);

            return(result.Count());
        }
Example #2
0
        /// <summary>
        /// Retourne l'absence correspondant à l'identifiant
        /// </summary>
        /// <param name="id">Identifiant de l'absence</param>
        /// <returns>Entité <see cref="Absence"/></returns>
        public Absence GetAbsenceById(int id)
        {
            AbsenceQuery query  = new AbsenceQuery(monContexte);
            Absence      result = query.GetById(id);

            return(result);
        }
Example #3
0
        /// <summary>
        /// Retourne les absences correspondant à un élève
        /// </summary>
        /// <param name="eleveId">Identifiant de l'élève</param>
        /// <returns>Liste d'entités <see cref="Absence"/></returns>
        public List <Absence> GetAbsencesByEleveId(int eleveId)
        {
            AbsenceQuery   query  = new AbsenceQuery(monContexte);
            List <Absence> result = query.GetByEleveId(eleveId);

            return(result);
        }
Example #4
0
        /// <summary>
        /// Retourne toutes les absences
        /// </summary>
        /// <returns>Liste d'entités <see cref="Absence"/></returns>
        public List <Absence> GetAllAbsences()
        {
            AbsenceQuery   query  = new AbsenceQuery(monContexte);
            List <Absence> result = query.GetAll();

            return(result);
        }
Example #5
0
        /// <summary>
        /// Retourne les 5 dernières absences
        /// </summary>
        /// <returns>Liste d'entité <see cref="Absence"/></returns>
        public async Task <List <Absence> > GetLastAbsences()
        {
            AbsenceQuery   query  = new AbsenceQuery(monContexte);
            List <Absence> result = await query.GetLastAbsences();

            return(result);
        }
Example #6
0
        /// <summary>
        /// Récupérer le nombre d'absences d'un élève par son ID
        /// </summary>
        /// <param name="eleveID">Identifiant de l'élève</param>
        /// <returns>string</returns>
        public string GetNbAbsencesByEleveId(int eleveID)
        {
            AbsenceQuery aq         = new AbsenceQuery(contexte);
            int          nbAbsences = aq.GetByEleveID(eleveID).Count();

            if (nbAbsences == 0)
            {
                return("Aucunes absences.");
            }
            return(nbAbsences.ToString());
        }
Example #7
0
        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);
        }
Example #8
0
        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 List <Absence> GetAbsenceByEleveId(int EleveId)
        {
            AbsenceQuery query = new AbsenceQuery(_contexte);

            return(query.GetAbsenceByEleveId(EleveId));
        }
Example #10
0
        public int AddAbsence(Absence absence)
        {
            AbsenceQuery query = new AbsenceQuery(_contexte);

            return(query.AddAbsence(absence));
        }
Example #11
0
        /// <summary>
        /// Récupérer les absences en base par l'ID de l'élève
        /// </summary>
        /// <returns>List<Absence></Absence></returns>
        public List <Absence> GetAbsencesByEleveId(int eleveID)
        {
            AbsenceQuery aq = new AbsenceQuery(contexte);

            return(aq.GetByEleveID(eleveID).ToList());
        }
Example #12
0
        /// <summary>
        /// Récupérer une absence en base par son ID
        /// </summary>
        /// <returns>Absence</returns>
        public Absence GetAbsenceById(int absenceID)
        {
            AbsenceQuery aq = new AbsenceQuery(contexte);

            return(aq.GetByID(absenceID).SingleOrDefault());
        }
Example #13
0
        /// <summary>
        /// Récupérer une liste d'absence en base
        /// </summary>
        /// <returns>Liste de Absence</returns>
        public List <Absence> GetAllAbsence()
        {
            AbsenceQuery aq = new AbsenceQuery(contexte);

            return(aq.GetAll().ToList());
        }
Example #14
0
 public HomeController()
 {
     db           = new ProNetDbContext();
     eleveQuery   = new EleveQuery(db);
     absenceQuery = new AbsenceQuery(db);
 }
Example #15
0
        public Absence DeleteAbsence(int absenceId)
        {
            AbsenceQuery absenceQuery = new AbsenceQuery(_contexte);

            return(absenceQuery.DeleteAbsence(absenceId));
        }
Example #16
0
        public Absence UpdateAbsence(Absence absence)
        {
            AbsenceQuery absenceQuery = new AbsenceQuery(_contexte);

            return(absenceQuery.UpdateAbsence(absence));
        }
Example #17
0
        public List <Absence> GetAbsencesByEleve(int idEleve)
        {
            AbsenceQuery aq = new AbsenceQuery(contexte);

            return(aq.GetAbsencesByEleve(idEleve).ToList());
        }