public async Task<FileContentModel> Handle(ExportWorkerInfos request, CancellationToken cancellationToken)
{
IQueryable<WorkerInfo> query = _workerInfoRepository.GetEntities();
query = query.Filter(request.Filter);
query = query.OrderBy(request.OrderBy, request.OrderDirection);
var workerInfos = await query.ToListAsync();
var models = _mapper.Map<List<WorkerInfo>, List<WorkerInfoModel>>(workerInfos);
return await _excelFormatter.GetExcelFileAsync(models, "WorkerInfos");
}
public async Task <FileContentModel> Handle(ExportRoles request, CancellationToken cancellationToken)
{
IQueryable <Role> query = _roleManager.Roles;
query = query.Filter(request.Filter);
query = query.OrderBy(request.OrderBy, request.OrderDirection);
var roles = await query.ToListAsync();
var models = _mapper.Map <List <Role>, List <RoleModel> >(roles);
return(await _excelFormatter.GetExcelFileAsync(models, "Roles"));
}
public async Task <FileContentModel> Handle(ExportLanguages request, CancellationToken cancellationToken)
{
IQueryable <Language> query = _languageRepository.GetEntities();
query = query.Filter(request.Filter);
query = query.OrderBy(request.OrderBy, request.OrderDirection);
var languages = await query.ToListAsync();
var models = _mapper.Map <List <Language>, List <LanguageModel> >(languages);
return(await _excelFormatter.GetExcelFileAsync(models, "Languages"));
}
public async Task <FileContentModel> Handle(ExportUsers request, CancellationToken cancellationToken)
{
IQueryable <User> query = _userManager.Users;
query = query.Filter(request.Filter);
query = query.OrderBy(request.OrderBy, request.OrderDirection);
var users = await query.ToListAsync();
var models = _mapper.Map <List <User>, List <UserModel> >(users);
return(await _excelFormatter.GetExcelFileAsync(models, "Users"));
}
public async Task <FileContentModel> Handle(ExportFileGroups request, CancellationToken cancellationToken)
{
IQueryable <FileGroup> query = _fileGroupRepository.GetEntities();
query = query.Filter(request.Filter);
query = query.OrderBy(request.OrderBy, request.OrderDirection);
var fileGroups = await query.ToListAsync();
var models = _mapper.Map <List <FileGroup>, List <FileGroupModel> >(fileGroups);
return(await _excelFormatter.GetExcelFileAsync(models, "FileGroups"));
}
public async Task <FileContentModel> Handle(ExportArticles request, CancellationToken cancellationToken)
{
// TODO: Limit export size
IQueryable <Article> query = _articleRepository.GetEntities()
.Include(e => e.FromLanguage)
.Include(e => e.ToLanguage)
.Include(e => e.Category)
.DefaultFilter();
query = query.Filter(request.Filter);
query = query.OrderBy(request.OrderBy, request.OrderDirection);
var articles = await query.ToListAsync();
var models = _mapper.Map <List <Article>, List <ArticleModel> >(articles);
return(await _excelFormatter.GetExcelFileAsync(models, "Articles"));
}
