You asked that guy out. You went after what you want. You did it. So awesome He said "no" because he is not interested. Not because you are not interesting. So keep going , there will be someone who is as it looks as if you are ready to give love.
Not all doors will be shut. Its only if you focus on how "humiliating" it was to put yourself out there, that you may get stuck in the quagmire of it all.
The important thing is that you tried and made your intentions known in a dignified way. Nothing to be ashamed of. The rebuffs will only clear away the confusion of "do they feel the same?". So don't beat yourself up. Please.
This approach is impressive as most people who say they need someone in their life, are always waiting to have the other person initiate. The other person be the one "giving" whilst they remain passive.
It is not unusual to reunite with old friends(even lovers) during this time. As you are evaluating what you actually want(Venus) from a sober point of view(Saturn)-focusing only on that.
So opportunities may arise that have been previously overlooked. Or a bond that didn't get the chance to mature etc.
Keep going. It will come right.