public async Task AddTranscriptRequestSubmittedAsync(int transcriptRequestId, string receivingInstitutionEmail = null, DateTime?dateSentByMailUtc = null)
 {
     await _sql.ExecuteAsync(
         sql : "[ApplicationPlanner].[TranscriptRequestSubmittedInsert]",
         param : new
     {
         transcriptRequestId,
         receivingInstitutionEmail,
         dateSentByMail = dateSentByMailUtc
     },
         commandType : CommandType.StoredProcedure);
 }
 public async Task DeleteTranscriptRequestAsync(int portfolioId)
 {
     await _sql.ExecuteAsync(
         sql : "[Utility].[TranscriptRequestDelete]",
         param : new
     {
         portfolioId
     },
         commandType : CommandType.StoredProcedure);
 }