public function addSportInvolveAction()
{
$studentSP = new Entity\SportInvolve();
$studentSP->setSportId($_GET["sportId"]);
$studentSP->setStudentId($_GET["student_id"]);
$studentSP->setIsActive($_GET["status"]);
$studentSP->setRole($_GET["role"]);
$status = StudentDBaccess::addSportInvolveDetails($studentSP);
return new JsonResponse(['status' => $status]);
}
public static function addStudent(Student $student, array $contact)
{
try {
$conn = connection::getConnectionObject();
$con = $conn->getConnection();
$con->autocommit(false);
$sql = $con->prepare("INSERT INTO Student VALUES (?,?,?,?,?,? )");
$studentId = $student->getStudentId();
$name = $student->getName();
$faculty = $student->getFaculty();
$batch = $student->getBatch();
$address = $student->getAddress();
$nic = $student->getNic();
$sql->bind_param("ssssss", $studentId, $name, $batch, $faculty, $address, $nic);
if ($sql->execute() == TRUE) {
foreach ($contact as $value) {
$isAdded = StudentDBaccess::addStudentContact($con, $studentId, $value);
if ($isAdded == false) {
$con->rollback();
return false;
}
}
$con->commit();
return true;
} else {
$con->rollback();
return false;
// echo "Error: " . $sql . "<br>";
}
} catch (Exception $e) {
$con->rollback();
return false;
} finally {
$con->close();
}
}
public function indexAction()
{
$s_id = StudentDBaccess::getLastStudentID();
return $this->render('applicationStudentBundle:Default:AddStudent.html.twig', array('s_id' => $s_id));
}
public function getStudentDetailsAction()
{
$student_id = $_GET["student_id"];
$student = cont\StudentDBaccess::getStudentDetails($student_id);
return new JsonResponse(['name' => $student->getName(), 'faculty' => $student->getFaculty(), 'batch' => $student->getBatch()]);
}
