public function updateAdvertisementPosition($advertisementPositionID, $changeKey, $advertisementID, $memberID, $positionNumber, $instrumentID, $durationID, $description, $experienceID, $ageRangeID, $genderID, $dbConnection = null)
 {
     $processed = false;
     $update = false;
     try {
         if ($changeKey != null) {
             $position = new AdvertisementPosition();
             $position->setVariable(AdvertisementPosition::ADVERTISEMENT_POSITION_ID, $advertisementPositionID);
             $position->setVariable(AdvertisementPosition::ADVERTISEMENT_ID, $advertisementID);
             ChangeUtilities::processChangeItem($position, $changeKey, AdvertisementPositionConstants::POSITION_NUMBER_CHANGE_KEY, AdvertisementPosition::POSITION_NUMBER, $positionNumber, $update);
             ChangeUtilities::processChangeItem($position, $changeKey, AdvertisementPositionConstants::POSITION_TYPE_CHANGE_KEY, AdvertisementPosition::INSTRUMENT_ID, $instrumentID, $update);
             ChangeUtilities::processChangeItem($position, $changeKey, AdvertisementPositionConstants::POSITION_DURATION_CHANGE_KEY, AdvertisementPosition::DURATION_ID, $durationID, $update);
             ChangeUtilities::processChangeItem($position, $changeKey, AdvertisementPositionConstants::POSITION_EXP_CHANGE_KEY, AdvertisementPosition::EXPERIENCE_ID, $experienceID, $update);
             ChangeUtilities::processChangeItem($position, $changeKey, AdvertisementPositionConstants::POSITION_AGE_CHANGE_KEY, AdvertisementPosition::AGE_RANGE_ID, $ageRangeID, $update);
             ChangeUtilities::processChangeItem($position, $changeKey, AdvertisementPositionConstants::POSITION_GENDER_CHANGE_KEY, AdvertisementPosition::GENDER_ID, $genderID, $update);
             ChangeUtilities::processChangeItem($position, $changeKey, AdvertisementPositionConstants::POSITION_OTHER_CHANGE_KEY, AdvertisementPosition::DESCRIPTION, $description, $update);
             if ($update) {
                 $processed = AdvertisementPositionDao::updateAdvertisementPosition($memberID, $position, $dbConnection);
             }
         }
     } catch (Exception $ex) {
         $processed = false;
         echo 'Caught exception: ' . $ex->getMessage();
     }
     return $processed;
 }
 public function updateAdvertisementPosition($memberID, $positionDetails, $dbConnection)
 {
     $preparedStatement = null;
     $processed = false;
     try {
         if ($memberID != null & $positionDetails->getVariable(AdvertisementPosition::ADVERTISEMENT_POSITION_ID) !== null) {
             $positionUpdateQuery = AdvertisementPositionDao::getAdvertisementPositionUpdateQuery($positionDetails);
             $preparedStatement = AdvertisementPositionDao::getAdvertisementPositionPreparedStatement($positionUpdateQuery, $memberID, $positionDetails, $dbConnection);
             if ($preparedStatement->execute()) {
             }
             $processed = true;
             $preparedStatement = null;
         }
     } catch (PDOException $ex) {
         echo 'Caught exception: ' . $ex->getMessage() . "\n";
     }
     return $processed;
 }