First, do this: http://support.apple.com/kb/HT1767
If not, then it's likely the PSU needs to be replaced. At this point, it MAY not even be worth replacing... but if you need a computer and/or the data isn't backed up, then you may have no choice. The Apple store may have deemed that model too old to repair anymore... so you might have to find one off ebay or something.