/**
* @param Book $address
* @return \Zend\Db\Adapter\Driver\StatementInterface|\Zend\Db\ResultSet\ResultSet
*/
public function saveAddress(Book $address)
{
$data = array('name' => $address->getName() ?: null, 'mobile' => $address->getMobile() ?: null, 'email' => $address->getEmail() ?: null, 'cityId' => $address->getCityId() ?: null, 'districtId' => (int) $address->getDistrictId() ?: null, 'address' => $address->getAddress() ?: null, 'createdById' => (int) $address->getCreatedById() ?: null);
/* @var $dbAdapter \Zend\Db\Adapter\Adapter */
$dbAdapter = $this->getServiceLocator()->get('dbAdapter');
/* @var $dbSql \Zend\Db\Sql\Sql */
$dbSql = $this->getServiceLocator()->get('dbSql');
if (null === ($id = $address->getId())) {
$insert = $dbSql->insert(self::TABLE_NAME);
$insert->values($data);
$query = $dbSql->buildSqlString($insert);
$results = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
} else {
$update = $dbSql->update(self::TABLE_NAME);
$update->set($data);
$update->where("id = " . $address->getId());
$query = $dbSql->buildSqlString($update);
$results = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
}
return $results;
}
