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);
}