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