"Today, the world has lost one of the greats of magic, but I have lost my best friend," the entertainer's partner, Siegfried Fischbacher, said in a statement