public async IAsyncEnumerable <string[]> AllSelected( string function, AllSelectedDto dto, int skip) { // Create new collection to store // selected without change List <string> resultColumns = this.Columns(dto.PreSelectedColumns, dto.SelectedColumns); var query = this.sqlManager .ExecuteQueryAsync(function, dto.Date, dto.Id, resultColumns) .Skip(skip); await foreach (var item in query) { yield return(item); } }
public static async Task <T> SetGet <T>(IEntityService service, string functionActive, IEnumerable <string> userColumns) { bool isInLayoutMode = userColumns.Count() > 0 ? true : false; var today = DateTime.Today; var primeHeaders = await service.All(functionActive, null, today).FirstOrDefaultAsync(); var headers = await service.All(functionActive, null, today).FirstOrDefaultAsync(); var values = await service.All(functionActive, null, today, 1).ToListAsync(); if (isInLayoutMode) { var dtoSelected = new AllSelectedDto { Date = today, PreSelectedColumns = headers.Take(GlobalConstants.PreSelectedColumnsCount).ToList(), SelectedColumns = userColumns, }; headers = await service.AllSelected(functionActive, dtoSelected).FirstOrDefaultAsync(); values = await service.AllSelected(functionActive, dtoSelected, 1).ToListAsync(); } var dto = new EntitiesOverviewGetDto() { IsActive = true, Date = DateTimeExtensions.ToWebFormat(today), HeadersSelection = primeHeaders, Headers = headers, Values = values, SelectedColumns = userColumns, }; return(AutoMapperConfig.MapperInstance.Map <T>(dto)); }