public async Task <TvPanelSetupPaging> GetAllBoxes(int skip, int limit, string filter) { string sqlfilter, sql, sqlp, sqlc; CreateFilter(filter, out sqlfilter, out sql, out sqlp, out sqlc); var result = await GetAllTvBoxesWithPanels(sql, sqlp, skip, limit); var count = _db.Connection.ExecuteScalar <int>(sqlc); var output = new TvPanelSetupPaging { Data = result, Total = count }; return(output); }
public async Task <TvPanelSetupPaging> GetAllBoxes(int skip, int limit) { const string sql = @"SELECT b.* FROM[TvBoxes] AS b ORDER BY b.Id DESC OFFSET @skip ROWS FETCH NEXT @limit ROWS ONLY"; const string sqlp = @"SELECT p.* FROM[TvPanels] AS p WHERE p.TVBoxId = @Id ORDER by p.UpdateDate"; const string sqlc = @"SELECT count(*) FROM [TvBoxes] as b"; var result = await GetAllTvBoxesWithPanels(sql, sqlp, skip, limit); var count = _db.Connection.ExecuteScalar <int>(sqlc); var output = new TvPanelSetupPaging { Data = result, Total = count }; return(output); }