Are you able to detect the drive in the BIOS?
I had an issue where I could see in bios and not in windows. As previously suggested by somewhere, re-seat the cables to your HDD and autodetect the drives via the bios.
If the drive shows up, then chances are it still lives in some shape or form!