refactor get_reservation method to use scopes