I would just use a live image to boot the system and then use fdisk to see if you can read the drive. If so I am guessing that grub is broken. There are a number of methods out there to resolve that. If the drive isn't readable then I would first replace the cable and move it to a different port. If that doesn't work you could always try a drive and see if that is readable. Beyond that your hardware has failed

