Hi Umar,
Did you open up your MacBook for fan cleaning or did you just use compressed air or dust cleaner?
Did you check your battery connection? Perhaps unplugging and replugging will do the deal already...
As Unibody Mac Books don't have a separate MagSafe Board anymore, you will run into a rather expensive problem if it isn't just the connector and you are out of warranty, namely a new Logic Board.
Kind regards,
deSteini