public static function addRequestResource($con, RequestResource $requestResource)
{
try {
$sql = $con->prepare("INSERT INTO RequestResource VALUES(?,?,?,?,?,?,?)");
$requestId = $requestResource->getRequestId();
$resourceId = $requestResource->getResourceId();
$qty = $requestResource->getQty();
$borrowingDate = $requestResource->getItemBorrowingDate();
$issueDate = date('Y-m-d');
$returnDate = $requestResource->getReturnDate();
$status = 1;
$sql->bind_param("ssisssi", $requestId, $resourceId, $qty, $borrowingDate, $issueDate, $returnDate, $status);
if ($sql->execute() == TRUE) {
return true;
} else {
return false;
}
} catch (Exception $w) {
return false;
}
}
