public static function addStudentRequest(Request $request, array $requestResource)
{
try {
$conn = connection::getConnectionObject();
$con = $conn->getConnection();
$con->autocommit(false);
$sql = $con->prepare("INSERT INTO Request VALUES (?,?,?,?)");
$requestId = $request->getRequestId();
$studentId = $request->getStudentId();
$date = $request->getRequestDate();
$status = "pending";
$sql->bind_param("ssss", $requestId, $studentId, $date, $status);
if ($sql->execute() == TRUE) {
foreach ($requestResource as $value) {
$isAdded = StudentRequestDBaccess::addRequestResource($con, $value);
if ($isAdded == false) {
$con->rollback();
return false;
}
}
} else {
$con->rollback();
return false;
}
$con->commit();
return true;
} catch (Exception $e) {
$con->rollback();
return false;
} finally {
$con->autocommit(true);
$con->close();
}
}
