An appeal made by a prisoner for the right to vote in elections and referendums has been dismissed by the Supreme Court.