public async Task <ResponseResult <Response> > Handle(Command request, CancellationToken cancellationToken)
{
using (var scope = _databaseScopeFactory.CreateReadOnly())
{
// var filter = request.Filter.ToSql<ProductInfoDetails>();
// var filter = FieldLikeSearch.GetLikeSearchByField<ProductInfoDetails>("ProdName", request.Filter, 3);
var filter = FilterLikeSearch.Search <ProductInfoDetails>("1", "ProdName", request.Filter, 3, " ");
if (filter.errorMsg != string.Empty && filter.errorMsg != null)
{
return(ResponseResult <Response> .Error($"{filter.errorMsg}."));
}
var result = await _productInfoRepository.QueryAsync <ProductInfoDetails>(
() => filter.Item2,
request.PageIndex,
request.PageSize,
request.Sort.ToSql(),
true);
return(ResponseResult <Response> .Ok(
new Response(result.Data, result.Count, request.PageIndex, request.PageSize)));
}
}