public async Task <IEnumerable <CompanyModel> > Handle(CompanyListFetchQuery request, CancellationToken cancellationToken)
{
SqlConnection dbConnection = new SqlConnection
{
ConnectionString = Environment.GetEnvironmentVariable("DatabaseConnectionString")
};
await using (dbConnection)
{
await dbConnection.OpenAsync();
var results = await dbConnection.QueryAsync <CompanyModel>("SELECT * FROM Core.Company order by CompanyId ");
await dbConnection.CloseAsync();
return(request.PageNumber == 0 ? results : results.Skip((request.PageNumber - 1) * request.PageSize).Take(request.PageSize));
}
}
public async Task <IActionResult> CompanyListFetchQuery(
[HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = null)]
CompanyListFetchQuery companyListFetchQuery,
ILogger log,
ClaimsPrincipal principal
)
{
const string functionName = "CompanyListFetchQuery";
log.LogInformation($"Invoke:{functionName}");
log.LogTrace(companyListFetchQuery.Dump());
if (!CheckAuthenticated(principal, log))
{
return(new UnauthorizedResult());
}
var result = await _mediator.Send(companyListFetchQuery);
return(new OkObjectResult(result));
}
