public void DeleteAllReferrals()
{
_dbConnection.Open();
using (var transaction = _dbConnection.BeginTransaction())
{
_referralRepository.DeleteAllReferrals(_dbConnection);
transaction.Commit();
}
_dbConnection.Close();
}