protected function add(AnnouncementPrice $announcementPrice) { $q = $this->dao->prepare('INSERT INTO ' . $this->table() . ' SET HALF_DAY = :halfDay, DAY = :day, WEEK_END = :weekEnd, WEEK = :week, FORTNIGHT = :fortnight, IS_ACTIVE = :isActive, ANNOUNCEMENT_ID = :announcementId, CONTACT_GROUP_ID = :contactGroupId'); $q->bindValue(':halfDay', $announcementPrice->getHalfDay()); $q->bindValue(':day', $announcementPrice->getDay()); $q->bindValue(':weekEnd', $announcementPrice->getWeekEnd()); $q->bindValue(':week', $announcementPrice->getWeek()); $q->bindValue(':fortnight', $announcementPrice->getFortnight()); $q->bindValue(':isActive', $announcementPrice->getIsActive()); $q->bindValue(':announcementId', $announcementPrice->getAnnouncementId(), PDO::PARAM_INT); $q->bindValue(':contactGroupId', $announcementPrice->getContactGroupId(), PDO::PARAM_INT); $q->execute(); $announcementPrice->setId($this->dao->lastInsertId()); }