Can I get a refund for the fee I paid in case of a visa refusal?

No, fees paid for visa applications (consular fees) are considered processing fees. In the event of a visa refusal, the fee is non-refundable.