public async Task <RProduct[]> SearchByCodeAndName(string keyword, EnumDefine.ProductStatus status, RefSqlPaging sqlPaging)
{
var datas = await WithConnection(async (connection) =>
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Keyword", keyword, DbType.String);
parameters.Add("@Status", status.AsEnumToInt(), DbType.Int32);
parameters.Add("@OFFSET", sqlPaging.OffSet, DbType.String);
parameters.Add("@FETCH", sqlPaging.PageSize, DbType.String);
return(await connection.QueryAsync <RProduct>(ProcName.Product_SearchByCodeOrName, parameters, commandType: CommandType.StoredProcedure));
});
return(datas.ToArray());
}
public async Task <RProduct[]> SearchByCodeAndName(string keyword, EnumDefine.ProductStatus status, RefSqlPaging sqlPaging)
{
return(await _productRepository.SearchByCodeAndName(keyword, status, sqlPaging));
}