/**
* creates sports venue
*
* @param Entity\SportsVenueImpl $sportsVenue
* @throws RDException
*/
public function save($sportsVenue)
{
if ($sportsVenue->isPersistent()) {
//update
$q = "UPDATE sports_venue\n set sports_venue.name = ?,\n address = ?,\n is_indoor = ?\n WHERE sports_venue_id = ?;";
//create prepared statement from query
$stmt = $this->dbConnection->prepare($q);
//bind parameters to prepared statement
$sportsVenueName = $sportsVenue->getName();
$address = $sportsVenue->getAddress();
$isIndoor = $sportsVenue->getIsIndoor() ? 1 : 0;
$sportsVenueId = $sportsVenue->getId();
$stmt->bindParam(1, $sportsVenueName, \PDO::PARAM_STR);
$stmt->bindParam(2, $address, \PDO::PARAM_STR);
$stmt->bindParam(3, $isIndoor, \PDO::PARAM_INT);
$stmt->bindParam(4, $sportsVenueId, \PDO::PARAM_INT);
if ($stmt->execute()) {
echo 'venue created successfully';
} else {
throw new RDException('Error creating venue');
}
} else {
//insert
//create Query
$q = "INSERT INTO sports_venue (sports_venue.name, address, is_indoor) VALUES(?, ?, ?);";
//create prepared statement from query
$stmt = $this->dbConnection->prepare($q);
//bind parameters to prepared statement
$sportsVenueName = $sportsVenue->getName();
$address = $sportsVenue->getAddress();
$isIndoor = $sportsVenue->getIsIndoor() ? 1 : 0;
$stmt->bindParam(1, $sportsVenueName, \PDO::PARAM_STR);
$stmt->bindParam(2, $address, \PDO::PARAM_STR);
$stmt->bindParam(3, $isIndoor, \PDO::PARAM_INT);
if ($stmt->execute()) {
$sportsVenue->setId($this->dbConnection->lastInsertId());
echo 'venue created successfully';
} else {
throw new RDException('venue creating match');
}
}
}
