public void CorrectWorkbookDoNotGenertateNoteTest() { FileInfo fI = new FileInfo(_filePathCorrect); if (fI.Exists) { _ssr = new SpreadSheetReader(fI.FullName, false, false); } else { throw new FileLoadException("cannot load the input file"); } _ssr.ReadDataFromFile(); Assert.IsTrue(_ssr.ColumnMapping.ContainsKey(ImportColumnName.PaymentDate)); Assert.IsFalse(_ssr.ColumnMapping.ContainsKey(ImportColumnName.NoteTitle)); Assert.IsFalse(_ssr.ColumnMapping.ContainsKey(ImportColumnName.NoteID)); Assert.IsFalse(_ssr.ColumnMapping.ContainsKey(ImportColumnName.NoteDate)); Assert.IsFalse(_ssr.ColumnMapping.ContainsKey(ImportColumnName.NoteAmount)); Assert.IsTrue(_ssr.ColumnMapping.ContainsKey(ImportColumnName.NIP)); Assert.IsTrue(_ssr.ColumnMapping.ContainsKey(ImportColumnName.LP)); Assert.IsTrue(_ssr.ColumnMapping.ContainsKey(ImportColumnName.AccountNumber)); Assert.IsTrue(_ssr.ColumnMapping.Count == 4); }
public void Setup() { FileInfo fI = new FileInfo("importSettings.json"); fI.CopyTo("importSettingsCopy.json", true); fI = new FileInfo(_configFilePath); if (fI.Exists) { fI.CopyTo("importSettings.json", true); } else { throw new FileLoadException("cannot load the input config"); } fI = new FileInfo(_filePath); if (fI.Exists) { _ssr = new SpreadSheetReader(fI.FullName, true, true); } else { throw new FileLoadException("cannot load the input file"); } }
private void ReadInputFile(string filePath, SearchSettings searchSettings, IProgress <string> progress) { DateTime startTime = DateTime.Now; progress.Report(string.Format("{0}: Rozpoczęto wczytywanie danych z pliku.\n", DateTime.Now.ToLongTimeString())); progress.Report(string.Format("{0}: Nazwa pliku: {1}.\n", DateTime.Now.ToLongTimeString(), searchSettings.InputFileName)); progress.Report(string.Format("{0}: Pełna ścieżka pliku: {1}\\{2}.\n", DateTime.Now.ToLongTimeString(), searchSettings.InputFileDir, searchSettings.InputFileName)); SpreadSheetReader ssReader = new SpreadSheetReader(filePath, searchSettings.GenerateNotes, searchSettings.VerifyAlsoForInvoiceDate); _companiesReadFromFile = ssReader.ReadDataFromFile(); }
public void Setup() { FileInfo fI = new FileInfo(_filePath); if (fI.Exists) { _ssr = new SpreadSheetReader(fI.FullName, true, true); } else { throw new FileLoadException("cannot load the input file"); } }
public void MissingOneNoteHeaderSheet() { FileInfo fI = new FileInfo(_filePathNoteissing); if (fI.Exists) { _ssr = new SpreadSheetReader(fI.FullName, true, false); } else { throw new FileLoadException("cannot load the input file"); } SpreadSheetReaderMissingColumnsException e = Assert.Throws <SpreadSheetReaderMissingColumnsException>(() => _ssr.ReadDataFromFile()); Assert.IsTrue(e.Message.Contains("Nie wszystkie kolumny s¹ obecne")); }
public void NipInCorrectTest() { FileInfo fI = new FileInfo(_filePathNipInCorrect); if (fI.Exists) { _ssr = new SpreadSheetReader(fI.FullName, true, false); } else { throw new FileLoadException("cannot load the input file"); } InputCompany firstInputCompanies = _ssr.ReadDataFromFile()[0]; Assert.AreEqual(InputCompanyFormatError.NIPFormatError, firstInputCompanies.FormatErrors[0]); }
public void CorrectWorkbookDoNotGenertateNoteTest() { FileInfo fI = new FileInfo(_filePathCorrect); if (fI.Exists) { _ssr = new SpreadSheetReader(fI.FullName, false, false); } else { throw new FileLoadException("cannot load the input file"); } var companies = _ssr.ReadDataFromFile(); Assert.IsTrue(_ssr.ColumnMapping.ContainsKey(ImportColumnName.PaymentDate)); Assert.IsFalse(_ssr.ColumnMapping.ContainsKey(ImportColumnName.NoteTitle)); Assert.IsFalse(_ssr.ColumnMapping.ContainsKey(ImportColumnName.NoteID)); Assert.IsFalse(_ssr.ColumnMapping.ContainsKey(ImportColumnName.NoteDate)); Assert.IsFalse(_ssr.ColumnMapping.ContainsKey(ImportColumnName.NoteAmount)); Assert.IsTrue(_ssr.ColumnMapping.ContainsKey(ImportColumnName.NIP)); Assert.IsTrue(_ssr.ColumnMapping.ContainsKey(ImportColumnName.LP)); Assert.IsTrue(_ssr.ColumnMapping.ContainsKey(ImportColumnName.AccountNumber)); Assert.IsTrue(_ssr.ColumnMapping.Count == 4); Assert.IsTrue(companies.Count == 5); InputCompany comp = companies[3]; Assert.AreEqual("03124061751111001095041381", comp.BankAccountNumber); Assert.AreEqual(InputCompany.GetID(8, "4", "7811767696"), comp.ID); Assert.AreEqual("4", comp.LP); Assert.AreEqual(8, comp.RowNumber); Assert.AreEqual("7811767696", comp.NIP); Assert.IsNull(comp.NoteDate); Assert.IsNull(comp.NoteID); Assert.IsNull(comp.NoteNettoAmount); Assert.IsNull(comp.NoteTitle); Assert.AreEqual("15.02.2019r.", comp.PaymentDate); Assert.AreEqual(8, comp.RowNumber); }
public void CorrectWorkbookGenertateNoteTest() { FileInfo fI = new FileInfo(_filePathCorrect); if (fI.Exists) { _ssr = new SpreadSheetReader(fI.FullName, true, false); } else { throw new FileLoadException("cannot load the input file"); } var companies = _ssr.ReadDataFromFile(); Assert.IsTrue(_ssr.ColumnMapping.ContainsKey(ImportColumnName.PaymentDate)); Assert.IsTrue(_ssr.ColumnMapping.ContainsKey(ImportColumnName.NoteTitle)); Assert.IsTrue(_ssr.ColumnMapping.ContainsKey(ImportColumnName.NoteID)); Assert.IsTrue(_ssr.ColumnMapping.ContainsKey(ImportColumnName.NoteDate)); Assert.IsTrue(_ssr.ColumnMapping.ContainsKey(ImportColumnName.NoteAmount)); Assert.IsTrue(_ssr.ColumnMapping.ContainsKey(ImportColumnName.NIP)); Assert.IsTrue(_ssr.ColumnMapping.ContainsKey(ImportColumnName.LP)); Assert.IsTrue(_ssr.ColumnMapping.ContainsKey(ImportColumnName.AccountNumber)); Assert.IsTrue(_ssr.ColumnMapping.Count == 8); Assert.IsTrue(companies.Count == 5); InputCompany comp = companies[0]; Assert.AreEqual("46124017501111001068892448", comp.BankAccountNumber); Assert.AreEqual("5+1-7792369887", comp.ID); Assert.AreEqual("1", comp.LP); Assert.AreEqual(5, comp.RowNumber); Assert.AreEqual("7792369887", comp.NIP); Assert.AreEqual("12.01.2019r.", comp.NoteDate); Assert.AreEqual("12", comp.NoteID); Assert.AreEqual("1000", comp.NoteNettoAmount); Assert.AreEqual("Q1", comp.NoteTitle); Assert.AreEqual("15.02.2019r.", comp.PaymentDate); Assert.AreEqual(5, comp.RowNumber); }