public ActionResult DeleteEleve(Guid id)
        {
            EleveModels model;

            using (EleveRepository repository = new EleveRepository())
            {
                Pupils x = repository.GetPupilById(id);
                if (x == null)
                {
                    return(HttpNotFound());
                }
                model = new EleveModels
                {
                    id           = x.Id,
                    firstName    = x.FirstName,
                    lastName     = x.LastName,
                    sexe         = x.Sex,
                    birthdayDate = x.BirthdayDate,
                    tuteurId     = x.Tutor_Id,
                    classroomId  = x.Classroom_Id,
                    levelId      = x.Level_Id
                                   // tuteurs =
                                   // classroom =
                                   // level =
                                   // result =
                };
            }


            return(View("DeleteEleve", model));
        }
        public ActionResult EditEleve(Guid id)
        {
            EleveModels model;

            using (EleveRepository repository = new EleveRepository())
            {
                IQueryable <Tutors>     tuteurs = repository.GetTutors();
                IQueryable <Classrooms> classes = repository.GetClasses();
                IQueryable <Levels>     niveaux = repository.GetNiveaux();
                Pupils x = repository.GetPupilById(id);
                model = new EleveModels
                {
                    mode         = 0,
                    state        = short.MaxValue,
                    firstName    = x.FirstName,
                    lastName     = x.LastName,
                    sexe         = x.Sex,
                    birthdayDate = x.BirthdayDate,
                    tuteurId     = x.Tutor_Id,
                    classroomId  = x.Classroom_Id,
                    levelId      = x.Level_Id,
                    tuteurs      = getListTuteurs(tuteurs),
                    classes      = getListClasses(classes),
                    niveaux      = getListNiveaux(niveaux)
                };
            }
            return(View("CreateEleve", model));
        }
        public ActionResult ReadEleve(Guid id)
        {
            EleveModels model;

            using (EleveRepository repository = new EleveRepository())
            {
                Pupils x = repository.GetPupilById(id);
                IQueryable <Tutors>      t = repository.GetTutors();
                IQueryable <Results>     r = repository.GetResultatsByPupilId(id);
                IQueryable <Evaluations> e = repository.GetEvaluations();
                if (x == null)
                {
                    return(HttpNotFound());
                }
                model = new EleveModels
                {
                    id           = x.Id,
                    firstName    = x.FirstName,
                    lastName     = x.LastName,
                    sexe         = x.Sex,
                    birthdayDate = x.BirthdayDate,
                    tuteurId     = x.Tutor_Id,
                    classroomId  = x.Classroom_Id,
                    levelId      = x.Level_Id,
                    tuteurName   = x.Tutors.LastName,
                    classTitle   = x.Classrooms.Title,
                    niveauName   = x.Levels.Title,
                    resultats    = getListResultats(r),
                    evaluations  = getListEvaluations(e)
                };
            }
            return(View(model));
        }
        public ActionResult EditEleve(EleveModels model)
        {
            using (EleveRepository repository = new EleveRepository())
            {
                Pupils x = repository.GetPupilById(model.id);
                x.State        = short.MaxValue;
                x.FirstName    = model.firstName;
                x.LastName     = model.lastName;
                x.Sex          = model.sexe;
                x.BirthdayDate = model.birthdayDate;
                x.Tutor_Id     = model.tuteurId;
                x.Classroom_Id = model.classroomId;
                x.Level_Id     = model.levelId;
                // eleves =

                if (ModelState.IsValid)
                {
                    repository.Save();
                }
                return(RedirectToAction("ReadEleves"));
            }
        }