What to do when a friend lures money you don't want to receive?
I have a foreigner friend from overseas who's been very nice to me since we met on FB. I enjoyed chatting with him about our respective cultures. He's coming here (India) next month; he planned this long ago and he wanted to meet me so that I could go with him to some places. Okay, I enjoyed having him as a friend and actually wanted to go and meet him, but kept it uncertain as I was unsure if I'd be available at that time. He kept poking me for months, if I was considering, as he needed guidance to visit specific tourist spots.
Yesterday, he proposed that if I was interested to play a "paid guide" for him so it would make his navigating easier and would earn me some bucks. I was instantly shocked as this was naturally disrespectful to me. Immediately I told him off that that offering money to me was a very bad move. He apologised to me countless times, but I can't get it out of my mind. The thought of him trying to buy my time by luring money is very humiliating. However, he knows financially I'm going through a tough time and all he did was to help me; he said that this was his genuine effort. But he thought offering money would suddenly make me all interested, like I was a whore.
I couldn't digest this fact, but it is evident that he's had success getting things done by money, and he assumed I'd take it, like his other Indian friends who I assumed did a good job representing themselves in front of a white man. I liked him, and was glad to have a foreigner white friend, but what he did is sort of irreparable and unexpected, but I'm not sure I should unfriend him, but I do want to say something to him which will make a lasting effect on him. So what should I do next? What should be the most affecting answer one can give?