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