protected function add(AnnouncementReservation $announcementReservation)
{
$q = $this->dao->prepare('INSERT INTO ' . $this->table() . ' SET DATE = :date, DATE_END = :dateEnd, DATE_OPTION = :option, ANNOUNCEMENT_ID = :announcementId, USER_OWNER_ID = :userOwnerId, USER_SUBSCRIBER_ID = :userSubscriberId, CONTACT_GROUP_ID = :contactGroupId, PRICE = :price, STATE_ID = :stateId, KEY_CHECK = :keyCheck, TRANSACTION_REF = :transactionRef');
$q->bindValue(':date', $announcementReservation->getDate());
$q->bindValue(':dateEnd', $announcementReservation->getDateEnd());
$q->bindValue(':option', $announcementReservation->getDateOption());
$q->bindValue(':announcementId', $announcementReservation->getAnnouncementId(), PDO::PARAM_INT);
$q->bindValue(':userOwnerId', $announcementReservation->getUserOwnerId(), PDO::PARAM_INT);
$q->bindValue(':userSubscriberId', $announcementReservation->getUserSubscriberId(), PDO::PARAM_INT);
$q->bindValue(':contactGroupId', $announcementReservation->getContactGroupId(), PDO::PARAM_INT);
$q->bindValue(':price', $announcementReservation->getPrice());
$q->bindValue(':stateId', $announcementReservation->getStateId(), PDO::PARAM_INT);
$q->bindValue(':keyCheck', $announcementReservation->getKeyCheck());
$q->bindValue(':transactionRef', $announcementReservation->getTransactionRef());
$q->execute();
$announcementReservation->setId($this->dao->lastInsertId());
}
