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