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