Failing Superdrive(?) and Problems with Bootcamp
Apple has a service provider lookup at https://locate.apple.com and I would start with an authorized service provider. Those era Macs aren't that hard to open and work on and the cost you might pay might make a DIY repair more likely than the more modern Macs that are designed more for factory trained technicians and have adhesive and very fragile connectors that you typically replace rather than reseat.

As to your failures, one bad drive can bring down the entire storage controller and/or bus, so you might open and just disconnect the superdrive to see if that helps the other storage devices work.

http://ifixit.com might be the best place for a take apart and quick quote on the parts you might need for that repair.