Refuse directly, don't be tactful, tactful refusal will hurt him more, absolutely!
Because of euphemistic refusal to disappoint him, and seeing hope at the same time, he will think that there is still a chance, just because this opportunity will expand the harm.