public async Task <bool> AddAsync(ConfirmationCode code)
 {
     using (var transaction = _context.Database.BeginTransaction())
     {
         try
         {
             var record = code.ToModel();
             _context.ConfirmationCodes.Add(record);
             await _context.SaveChangesAsync().ConfigureAwait(false);;
             transaction.Commit();
             return(true);
         }
         catch (Exception ex)
         {
             transaction.Rollback();
             _managerEventSource.Failure(ex);
             return(false);
         }
     }
 }