public async Task <IActionResult> SearchEmployeesByHiringDate([FromQuery] SearchEmployeesByHiringDateQueryRequest queryRequest)
{
var queryResponse = await mediator.Send(queryRequest);
switch (queryResponse.Status)
{
case true: return(Ok(queryResponse));
case false: return(BadRequest(queryResponse));
}
}
public async Task <HandlerResultEntity <IEnumerable <SearchEmployeesByHiringDateQueryResponse> > > Handle(SearchEmployeesByHiringDateQueryRequest queryRequest, CancellationToken cancellationToken)
{
var validationResult = await validator.ValidateAsync(queryRequest, cancellationToken);
if (validationResult.IsValid)
{
var queryResponse = await employeeRepository.SearchEmployeesByHiringDateAsync(queryRequest);
return(new HandlerResultEntity <IEnumerable <SearchEmployeesByHiringDateQueryResponse> >(true, string.Empty, queryResponse));
}
else
{
return(new HandlerResultEntity <IEnumerable <SearchEmployeesByHiringDateQueryResponse> >(false, ValidationResultErrorMessage.Format(validationResult), null));
}
}
public async Task <IEnumerable <SearchEmployeesByHiringDateQueryResponse> > SearchEmployeesByHiringDateAsync(SearchEmployeesByHiringDateQueryRequest queryRequest)
{
return(await paymentsControlDataContext
.connection
.QueryAsync <SearchEmployeesByHiringDateQueryResponse>("spSearchEmployeesByHiringDate",
new
{
queryRequest.StartDate,
queryRequest.EndDate
}, commandType : CommandType.StoredProcedure));
}
