public async Task <IEnumerable <VerificationsResult> > GetVerifications(VerificationsParameter data) { // Procedure name: GetVerifications // use dapper string connectionString = configuration.GetConnectionString("Default"); var commandText = "GetVerifications"; var command = new CommandDefinition(commandText, data, commandType: CommandType.StoredProcedure); IEnumerable <VerificationsResult> result; try { using SqlConnection connection = new SqlConnection(connectionString); result = await connection.QueryAsync <VerificationsResult>(command); } catch (Exception ex) { logger.LogError(ex.GetExceptionMessage()); return(null); } return(result); }
public async Task <IActionResult> GetVerifications(VerificationsParameter data) { return(Ok(await repo.GetVerifications(data))); }