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