public function deactivateBand($memberID, $bandID, $dbConnection)
{
$success = false;
try {
$bandDetails = new Band();
$bandDetails->setVariable(Band::BAND_ID, $bandID);
$bandDetails->setVariable(Band::ACTIVE, 2);
$success = BandDao::updateBand($memberID, $bandDetails, $dbConnection);
} catch (Exception $ex) {
echo 'Caught exception: ', $ex->getMessage(), "\n";
$success = false;
}
return $success;
}
public function updateBand($memberID, $bandDetails, $dbConnection)
{
$preparedStatement = null;
$processed = false;
try {
if ($memberID != null & $bandDetails->getVariable(Band::BAND_ID) !== null) {
if ($dbConnection == null) {
$dbConnection = DatabaseUtilities::getDatabaseConnection();
}
$bandUpdateQuery = BandDao::getBandUpdateQuery($bandDetails);
$preparedStatement = BandDao::getBandUpdatePreparedStatement($bandUpdateQuery, $memberID, $bandDetails, $dbConnection);
if ($preparedStatement->execute()) {
}
$processed = true;
$preparedStatement = null;
}
} catch (Exception $ex) {
echo 'Caught exception: ' . $ex->getMessage() . "\n";
}
return $processed;
}
