/**
* 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');
}
}
}
/**
* Create a new SportsVenue object, given the set of initial attribute values.
* @param name the name of the sports venue
* @param address the address of the sports venue
* @param isIndoor is the sports venue an indoor venue?
* @return a new SportsVenue object instance with the given attribute values
* @throws RDException in case name is null
*/
public function createSportsVenue($name = null, $address = null, $isIndoor = null)
{
$aSportsVenue = new Entity\SportsVenueImpl();
// if ($name != null && $address != null && $isIndoor != null) {
$aSportsVenue->setName($name);
$aSportsVenue->setAddress($address);
$aSportsVenue->setIsIndoor($isIndoor);
//}
return $aSportsVenue;
}
public function updateSportsVenue($venueID, $newName = null, $isIndoor = null, $address = null)
{
$sportsVenueModel = new Entity\SportsVenueImpl();
$sportsVenueModel->setID($venueID);
$sportsVenueIter = $this->objectLayer->findSportsVenue($sportsVenueModel);
if ($sportsVenueIter->size() <= 0) {
throw new RDException("Sports Venue not found");
} else {
$sportsVenue = $sportsVenueIter->current();
if ($newName != null) {
$sportsVenue->setName($newName);
}
if ($isIndoor != null) {
$sportsVenue->setIsIndoor($isIndoor);
}
if ($address != null) {
$sportsVenue->setAddress($address);
}
$this->objectLayer->storeSportsVenue($sportsVenue);
}
}
spl_autoload_register(function ($class_name) {
include '/Users/montanawong/Sites/RecDawgs/src/' . str_replace('\\', '/', $class_name) . '.php';
});
use edu\uga\cs\recdawgs\presentation as Presentation;
use edu\uga\cs\recdawgs\entity\impl as Entity;
if (!isset($_POST) || !isset($_POST['sportsVenueId'])) {
$errorMsg = urlencode("Sports Venue not found.");
header("Location: sportsVenues.php?status={$errorMsg}");
}
?>
<body>
<div class="container">
<?php
$sportsVenueId = $_POST['sportsVenueId'];
$sportsVenueModel = new Entity\SportsVenueImpl();
$sportsVenueModel->setId($sportsVenueId);
$sportsVenueUI = new Presentation\SportsVenueUI();
echo $sportsVenueUI->listSportsVenueInfo($sportsVenueModel);
echo "<h2>Leagues used in</h2>";
echo $sportsVenueUI->listLeaguesUsedIn(null, $sportsVenueId);
?>
<br/><br/>
<?php
//if admin allow update and deletion of sports venues and assignment to league
if ($_SESSION['userType'] == 1) {
echo $sportsVenueUI->listAddToLeagueButton($sportsVenueId);
echo "<h3>Update Sports Venue</h3><br/><form action = 'updateSportsVenue.php' method = 'post' >\n <input type = 'hidden' name = 'sportsVenueId' value = '{$sportsVenueId}'>\n <input type ='submit' value ='Update the Sports Venue'>\n</form >";
}
if ($_SESSION['userType'] == 1) {
