public void Map(ExcelFileDto dto, HttpPostedFileBase file) { if (string.IsNullOrEmpty(dto.Title)) { dto.Title = Path.GetFileNameWithoutExtension(file.FileName); } dto.File = file.InputStream; }
public ActionResult ParseExcelFile(ExcelFileDto dto) { if (Request.Files != null && Request.Files[0].InputStream.Length == 0) { return(View("ParseExcelFile")); } fileMapper.Map(dto, Request.Files[0]); parseExcelFileCommand.Execute(dto); return(RedirectToAction("Index")); }
public SingleObjectModel GetExcelTrialBalance([FromBody] TrialBalanceCommand command) { base.RequireBody(command); using (var usecases = TrialBalanceUseCases.UseCaseInteractor()) { TrialBalanceDto trialBalance = usecases.BuildTrialBalance(command); var excelExporter = new ExcelExporter(); ExcelFileDto excelFileDto = excelExporter.Export(trialBalance, command); return(new SingleObjectModel(this.Request, excelFileDto)); } }
public SingleObjectModel GetAccountsInExcelFile([FromUri] string accountsChartUID, [FromBody] AccountsSearchCommand searchCommand) { base.RequireBody(searchCommand); using (var usecases = AccountsChartUseCases.UseCaseInteractor()) { AccountsChartDto accountsChart = usecases.SearchAccounts(accountsChartUID, searchCommand); var excelExporter = new ExcelExporter(); ExcelFileDto excelFileDto = excelExporter.Export(accountsChart, searchCommand); return(new SingleObjectModel(base.Request, excelFileDto)); } }
public void Execute(ExcelFileDto dto) { DataSet data = null; using (var reader = ExcelReaderFactory.CreateReader(dto.File)) { data = reader.AsDataSet(); } var csvData = data.Tables[0].ToCsv(); var csvFile = new CsvFile { Title = dto.Title, Description = dto.Description, Contents = csvData }; csvFileRepository.Save(csvFile); }