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