public void GetFileDateShouldThrowOnWrongFilePath()
{
var filePath = @"..\someFolder\fsdf";
var excelFileLoader = new ExcelFileLoader();
var extractedDate = excelFileLoader.GetFileDate(filePath);
}
public void GetFileDateShouldThrowOnWrongFileNameFormat()
{
var filePath = @"..\filename-55-Jun-2015-wrong-wrong.xls";
var excelFileLoader = new ExcelFileLoader();
var extractedDate = excelFileLoader.GetFileDate(filePath);
}
public void GetFileDateShouldReturnCorrectDateOnCorrectFilePath()
{
var filePath = @"..\filename-10-Jun-2015.xls";
var excelFileLoader = new ExcelFileLoader();
var extractedDate = excelFileLoader.GetFileDate(filePath);
var expectedDate = new DateTime(2015, 6, 10);
Assert.AreEqual(expectedDate, extractedDate);
}
private static ExcelModel GetExcelModel(string fileName)
{
ExcelFileLoader excelFileLoader = new ExcelFileLoader();
try
{
return(excelFileLoader.LoadExcelFile(fileName));
}
catch
{
return(excelFileLoader.CreateNewExcelFile(fileName));
}
}
public static void LoadSalesReports(string sourceArchiveFilePath)
{
var salesReportImporter = new SalesReportsImporter();
var excelFileLoader = new ExcelFileLoader();
excelFileLoader.AddDataImporter(salesReportImporter);
var zipArchiveLoader = new ZipArchiveLoader();
zipArchiveLoader.AddFileLoader(excelFileLoader);
zipArchiveLoader.Load(sourceArchiveFilePath);
}
