I did try windows repair as well, however, like I said, it doesn't detect the HDD at all.
I tried connecting the HDD with all the 4 SATA ports one after the other and with different SATA cables but still no luck.
Yes, I did reset the BIOS after the re-assembly since none of the methods I tried...