public async Task <IEnumerable <Segment> > GetPaginatedWithFilterAsync(string description, int page, int pageSize)
{
using (SqlConnection connection = new SqlConnection(DabaseConnectionConfiguration.ConnectionString)) {
int offset = page * pageSize;
return(await connection.QueryAsync <Segment> (SegmentQueries.GetAllPaginatedWithFilter(description),
new {
Offset = offset,
PageSize = pageSize,
Description = description,
}
));
}
}
public async Task <int> Count(string description)
{
using (SqlConnection connection = new SqlConnection(DabaseConnectionConfiguration.ConnectionString)) {
return(await connection.ExecuteScalarAsync <int> (SegmentQueries.CountWithFilter(description), new { Description = description }));
}
}
