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