/**
* Gets newsletter.
*
* @param integer $id
* @return NewsletterModel|null
*/
public function getNewsletterById($id)
{
$newsletterRow = $this->db()->select('*')->from('newsletter')->where(array('id' => $id))->execute()->fetchAssoc();
if (empty($newsletterRow)) {
return null;
}
$newsletterModel = new NewsletterModel();
$newsletterModel->setId($newsletterRow['id']);
$newsletterModel->setUserId($newsletterRow['user_id']);
$newsletterModel->setDateCreated($newsletterRow['date_created']);
$newsletterModel->setSubject($newsletterRow['subject']);
$newsletterModel->setText($newsletterRow['text']);
return $newsletterModel;
}
