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