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