public ExportLanguagesHandler(IEntityRepository <Language> languageRepository,
IExcelFormatter excelFormatter,
IMapper mapper)
{
_languageRepository = languageRepository;
_excelFormatter = excelFormatter;
_mapper = mapper;
}
public ExportFilesHandler(IEntityRepository <File> fileRepository,
IExcelFormatter excelFormatter,
IMapper mapper)
{
_fileRepository = fileRepository;
_excelFormatter = excelFormatter;
_mapper = mapper;
}
public ExportWorkerRunsHandler(IEntityRepository <WorkerRun> workerRunRepository,
IExcelFormatter excelFormatter,
IMapper mapper)
{
_workerRunRepository = workerRunRepository;
_excelFormatter = excelFormatter;
_mapper = mapper;
}
public ExportCategoriesHandler(IEntityRepository <Category> categoryRepository,
IExcelFormatter excelFormatter,
IMapper mapper)
{
_categoryRepository = categoryRepository;
_excelFormatter = excelFormatter;
_mapper = mapper;
}
public ExportArticlesHandler(IEntityRepository <Article> articleRepository,
IExcelFormatter excelFormatter,
IMapper mapper)
{
_articleRepository = articleRepository;
_excelFormatter = excelFormatter;
_mapper = mapper;
}
public static async Task <FileContentModel> GetExcelFileAsync <T>(this IExcelFormatter excelFormatter, IEnumerable <T> data, string filename)
{
using var ms = new MemoryStream();
await excelFormatter.SaveToAsync(ms, data, true);
return(new FileContentModel()
{
Name = $"{filename}.xlsx",
Content = ms.ToArray(),
ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
});
}
public AgreementOrchestrator(
IMediator mediator,
IHashingService hashingService,
IProviderCommitmentsLogger logger,
IAgreementMapper agreementMapper,
ICsvFormatter csvFormatter,
IExcelFormatter excelFormatter)
: base(mediator, hashingService, logger)
{
_agreementMapper = agreementMapper;
_csvFormatter = csvFormatter;
_excelFormatter = excelFormatter;
}
private static void FormatExcelFile()
{
// try and format the excel sheet
try
{
IExcelFormatter excelReader = _serviceProvider.GetService <IExcelFormatter>();
excelReader.FormatExcelHealthFile();
// print changes
foreach (var cell in excelReader.Changes)
{
string message = "ROW:" + cell.Row + " COL:" + cell.Column;
if (cell.Value.HasValue)
{
message += " VALUE: " + cell.Value;
}
Console.WriteLine(message);
}
}
catch (FileNotFoundException ex)
{
Debug.WriteLine("The file or worksheet could not be found!!");
Console.WriteLine(ex.Message);
}
catch (ArgumentNullException ex)
{
Debug.WriteLine("The file path or workbook name are invalid, possibly null or blank");
Console.WriteLine(ex.Message);
}
catch (InvalidOperationException ex)
{
Debug.WriteLine("Unable to save the workbook. Is it open in another program?");
Console.WriteLine(ex.Message);
Console.WriteLine("Unable to save the workbook. If open in other program, close it down");
}
}
public ExportRolesHandler(RoleManager <Role> roleManager, IExcelFormatter excelFormatter, IMapper mapper)
{
_roleManager = roleManager;
_excelFormatter = excelFormatter;
_mapper = mapper;
}
public ExportUsersHandler(UserManager <User> userManager, IExcelFormatter excelFormatter, IMapper mapper)
{
_userManager = userManager;
_excelFormatter = excelFormatter;
_mapper = mapper;
}
