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");
}
_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);
}
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 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);
}
public void ReadWorkbookWithNoCorrectSheetNameTest()
{
Assert.Throws <SpreadSheetReaderException>(() => _ssr.ReadDataFromFile());
}
public void ReadWorkbookWithNoHeaderTest()
{
SpreadSheetReaderHeaderException e = Assert.Throws <SpreadSheetReaderHeaderException>(() => _ssr.ReadDataFromFile());
Assert.IsTrue(e.Message.Contains("nag³ówka"));
}