public void EditReferral(Referral referral, Referral newReferral)
 {
     _dbConnection.Open();
     using (var transaction = _dbConnection.BeginTransaction())
     {
         _referralRepository.EditReferral(_dbConnection, referral, newReferral);
         transaction.Commit();
     }
     _dbConnection.Close();
 }