public async Task CanRead_Transactions_IgnoresTransfers()
{
string csv = @"""2020112212345678,12345,123,123,123,123,123"",""11/22/2020"",""11/22/2020"",""Debit"",""-50.00000"","""",""500000000"",""Online Banking Transfer"","""",""Transfer"",""10000.00000"","""",""Online Banking Transfer""";
using var stream = AsStream(csv);
var csvImport = new StcuCsvImport(stream);
var items = await csvImport.GetItems().ToListAsync();
Assert.AreEqual(0, items.Count);
}
public async Task Import_WithDifferentEffectiveAndPostingDate_UsesPostingDate()
{
string csv = @"""2021013112784791,75120,210,201,446,006,044"",""1/31/2021"",""2/1/2021"",""Debit"",""-17.51000"","""",""531221069"",""Purchase MCDONALD'S F570,6321 N MONROE SPOKANE WAUS"",""Food & Dining"",""Debit Card"",""40653.62000"","""",""Purchase MCDONALD'S F570,6321 N MONROE SPOKANE WAUS""";
using var stream = AsStream(csv);
var csvImport = new StcuCsvImport(stream);
var items = await csvImport.GetItems().ToListAsync();
Assert.AreEqual(1, items.Count);
Assert.AreEqual(new DateTime(2021, 1, 31), items[0].Date);
}
public async Task CanRead_Checks()
{
string csv = @"""2020111912345678,12345,123,123,123,123,123"",""11/19/2020"",""11/19/2020"",""Check"",""-24.00000"",""1471"",""500000000"",""Check #1471"","""",""Check"",""10000.00000"","""",""Check #1471""";
using var stream = AsStream(csv);
var csvImport = new StcuCsvImport(stream);
var items = await csvImport.GetItems().ToListAsync();
Assert.AreEqual(1, items.Count);
Assert.AreEqual(new DateTime(2020, 11, 19), items[0].Date);
Assert.AreEqual("Check #1471", items[0].Description);
Assert.AreEqual(1, items[0].Details?.Count);
Assert.AreEqual(-2400, items[0].Details?[0].Amount);
}
public async Task CanRead_Credits()
{
string csv = @"""2020112012345678,12345,123,123,123,123,123"",""11/20/2020"",""11/20/2020"",""Credit"",""1234.56000"","""",""500000000"",""PAYROLL"","""",""ACH"",""10000.00000"","""",""PAYROLL""";
using var stream = AsStream(csv);
var csvImport = new StcuCsvImport(stream);
var items = await csvImport.GetItems().ToListAsync();
Assert.AreEqual(1, items.Count);
Assert.AreEqual(new DateTime(2020, 11, 20), items[0].Date);
Assert.AreEqual("PAYROLL", items[0].Description);
Assert.AreEqual(1, items[0].Details?.Count);
Assert.AreEqual(123456, items[0].Details?[0].Amount);
}
public async Task CanRead_Transactions()
{
string csv = @"""2020112312345678,12345,123,123,123,123,123"",""11/23/2020"",""11/23/2020"",""Debit"",""-21.77000"","""",""500000000"",""Purchase GOOGLE Play"",""Entertainment"",""Debit Card"",""10000.00000"","""",""Purchase GOOGLE Play""
""2020112212345678,123456,123,123,123,123,123"",""11/22/2020"",""11/23/2020"",""Debit"",""-23.48000"","""",""500000000"",""Purchase MCDONALD'S SPOKANE WAUS"",""Food & Dining"",""Debit Card"",""10000.00000"","""",""Purchase MCDONALD'S SPOKANE WAUS""";
using var stream = AsStream(csv);
var csvImport = new StcuCsvImport(stream);
var items = await csvImport.GetItems().ToListAsync();
Assert.AreEqual(2, items.Count);
Assert.AreEqual(new DateTime(2020, 11, 23), items[0].Date);
Assert.AreEqual("Purchase GOOGLE Play", items[0].Description);
Assert.AreEqual(1, items[0].Details?.Count);
Assert.AreEqual(-2177, items[0].Details?[0].Amount);
Assert.AreEqual(new DateTime(2020, 11, 22), items[1].Date);
Assert.AreEqual("Purchase MCDONALD'S SPOKANE WAUS", items[1].Description);
Assert.AreEqual(1, items[1].Details?.Count);
Assert.AreEqual(-2348, items[1].Details?[0].Amount);
}
