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 })); } }