public function completeRegistration(User $user, $addressId)
 {
     $user->setAddressId($addressId);
     $sql = '
         UPDATE users_tb SET
             id=:id,
             first_name = :first_name,
             last_name = :last_name,
             address_id = :address_id
         WHERE
             id = :id';
     $params = array(':id' => $user->getId(), ':first_name' => $user->getFirstName(), ':last_name' => $user->getLastName(), 'address_id' => $user->getAddressId());
     return $this->execute($sql, $user, $params);
 }
 public static function map(User $user, array $properties)
 {
     if (array_key_exists('id', $properties)) {
         $user->setId($properties['id']);
     }
     if (array_key_exists('first_name', $properties)) {
         $user->setFirstName($properties['first_name']);
     }
     if (array_key_exists('last_name', $properties)) {
         $user->setLastName($properties['last_name']);
     }
     if (array_key_exists('user_password', $properties)) {
         $user->setPassword($properties['user_password']);
     }
     if (array_key_exists('email', $properties)) {
         $user->setEmail($properties['email']);
     }
     if (array_key_exists('address_id', $properties)) {
         $user->setAddressId($properties['address_id']);
     }
 }