public Referral GetReferral(string referralTitle)
        {
            Referral referral;

            _dbConnection.Open();
            using (var transaction = _dbConnection.BeginTransaction())
            {
                referral = _referralRepository.GetReferral(
                    _dbConnection,
                    referralTitle.ToLower());
                transaction.Commit();
            }
            _dbConnection.Close();
            return(referral);
        }