protected function modify(ProfilePro $profilePro)
{
$q = $this->dao->prepare('UPDATE ' . $this->table() . ' SET COMPANY_NAME = :companyName, LASTNAME = :lastname, FIRSTNAME = :firstname, DESCRIPTION = :description, PHONE = :phone, MOBILE_PHONE = :mobilePhone, OFFICE_PHONE = :officePhone, WEBSITE = :website, AVATAR = :avatar, USER_ID = :userId, MAIN_ADDRESS_ID = :mainAddressId WHERE ID = :id');
$q->bindValue(':companyName', $profilePro->getCompanyName());
$q->bindValue(':lastname', $profilePro->getLastname());
$q->bindValue(':firstname', $profilePro->getFirstname());
$q->bindValue(':description', $profilePro->getDescription());
$q->bindValue(':phone', $profilePro->getPhone());
$q->bindValue(':mobilePhone', $profilePro->getMobilePhone());
$q->bindValue(':officePhone', $profilePro->getOfficePhone());
$q->bindValue(':website', $profilePro->getWebsite());
$q->bindValue(':avatar', $profilePro->getAvatar());
$q->bindValue(':userId', $profilePro->getUserId(), PDO::PARAM_INT);
$q->bindValue(':mainAddressId', $profilePro->getMainAddressId(), PDO::PARAM_INT);
$q->bindValue(':id', $profilePro->id(), PDO::PARAM_INT);
$q->execute();
}
