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