public void TestGenerateFromDocx()
{
#region arrange
string nameFile = "Contractors.xlsx";
//cleanup - delete any files that may be left from the previous run
var dataFolder = new DirectoryInfo(".");
foreach (var file in dataFolder.GetFiles(nameFile))
{
file.Delete();
}
//start the filesystem to see where the files is
IFileSystem fileSystem = new LocalFileSystem("data");
#endregion
#region act
var extractor = new WordContractExtractor(fileSystem);
extractor.Start();
#endregion
#region assert
var files = dataFolder.GetFiles(nameFile);
Assert.AreEqual(1, files.Count(), " should genereate the excel file");
#endregion
}
public async Task <IActionResult> UploadFile(IFormFile file)
{
//exercise for the reader: add handling error
if (file == null || file.Length == 0)
{
return(Content("file not selected"));
}
string name = Path.GetFileNameWithoutExtension(file.FileName);
//exercise for the reader : for tenants ,where to store data to be returned ?
var fullPathFile = Path.Combine(
_environment.WebRootPath,
Path.GetFileName(file.FileName));
if (System.IO.File.Exists(fullPathFile))
{
System.IO.File.Delete(fullPathFile);
}
using (var stream = new FileStream(fullPathFile, FileMode.Create))
{
await file.CopyToAsync(stream);
}
var fileSystem = new ZipFileSystem(fullPathFile);
var extractor = new WordContractExtractor(fileSystem);
extractor.Start();
//exercise for the reader : for tenants ,where to store data to be returned ?
return(Content("upload success"));
}
private static void Main(string[] args)
{
var settings = Settings.From("app.json");
//var fileSystem = new LocalFileSystem(settings.DocumentsLocation);
//var fileSystem = new ZipFileSystem(@"data\Painting-Contract.zip");
var fileSystem = settings.FileSystemProvider.CurrentFileSystem();
var extractor = new WordContractExtractor(fileSystem);
extractor.Start();
}
static void Main(string[] args)
{
var settings = Settings.From("app.json");
string folderWithWordDocs = settings.DocumentsLocation;
string excelResultsFile = "Contractors.xlsx";
var wordExtractor = new WordContractExtractor(folderWithWordDocs);
wordExtractor.ExtractToFile(excelResultsFile);
Console.WriteLine("please see Contractors.xlsx");
}
static void Main(string[] args)
{
Console.WriteLine("please enter the folder with financial Word documents( press enter for current folder)");
string folderWithWordDocs = Console.ReadLine();
if (string.IsNullOrWhiteSpace(folderWithWordDocs))
{
folderWithWordDocs = ".";
}
string excelResultsFile = "Contractors.xlsx";
var wordExtractor = new WordContractExtractor(folderWithWordDocs);
wordExtractor.ExtractToFile(excelResultsFile);
Console.WriteLine("please see Contractors.xlsx");
}
private void StartButton_Click(object sender, EventArgs e)
{
try
{
string folderWithWordDocs = folderPath.Text;
if (string.IsNullOrWhiteSpace(folderWithWordDocs))
{
MessageBox.Show("please choose a folder");
return;
}
string excelResultsFile = "Contractors.xlsx";
var wordExtractor = new WordContractExtractor(folderWithWordDocs);
wordExtractor.ExtractToFile(excelResultsFile);
}
catch (Exception ex)
{
MessageBox.Show($"an error occured{ ex.Message}");
}
}
private void StartButton_Click(object sender, EventArgs e)
{
try
{
string folder = folderPath.Text;
if (string.IsNullOrWhiteSpace(folder))
{
MessageBox.Show("please choose a folder");
return;
}
var fileSystem = new LocalFileSystem(folder);
var extractor = new WordContractExtractor(fileSystem);
extractor.Start();
}
catch (Exception ex)
{
_logger.Error(ex, $"exception in {nameof(StartButton_Click)}");
MessageBox.Show("an error occured. See the log file for details");
}
}
