public function deleteClassNameAction(Request $request, Application $app) { $id_students = $request->request->get('id_studentclass'); $students = $app['dao.student']->findAllStudentByClass($id_students); $newClass = new ClassName(); $newClass->setIdClassName($id_students); $app['dao.className']->deleteclassName($newClass->getIdClassName()); $app['session']->getFlashBag()->add('danger', 'La classe a été supprimée !'); // Redirecton vers le tableau des classes return $app->redirect($app['url_generator']->generate('classeslist')); }
/** * @param $row * @return ClassName * * construction de l'objet concernant les classes */ protected function buildDomainObject($row) { $class = new ClassName(); $class->setIdClassName($row['id_class']); $class->setClassName($row['class_name']); $class->setClassType($row['class_type']); $class->setClassOption($row['class_option']); $class->setClassYear($row['class_year']); $class->setDescription($row['description']); $class->setDtCreate($row['dt_create']); $class->setDtUpdate($row['dt_update']); return $class; }
public function CountStudentByClass(ClassName $className) { $_sql = "SELECT id_student FROM student WHERE id_class=?"; $_res = $this->getDb()->fetchAll($_sql, array($className->getIdClassName())); $CountStudentByClass = count($_res); return $CountStudentByClass; }