public void Will_find_multiple_balance_rows_when_result_is_ambiguous_because_multiple_early_records_exist_that_point_to_different_recent_records()
{
// Arrange
string balance_row_desc_01 = "Potential balance row 01";
string balance_row_desc_02 = "Potential balance row 02";
var fake_records = new List <ActualBankRecord>
{
// most recent records
new ActualBankRecord {
Amount = -10, Balance = 900.00, Date = new DateTime(2020, 1, 4), Description = balance_row_desc_02
},
new ActualBankRecord {
Amount = -10, Balance = 910.00, Date = new DateTime(2020, 1, 4)
},
new ActualBankRecord {
Amount = -10, Balance = 920.00, Date = new DateTime(2020, 1, 4), Description = balance_row_desc_01
},
// middle records
new ActualBankRecord {
Amount = -10, Balance = 930.00, Date = new DateTime(2020, 1, 3)
},
new ActualBankRecord {
Amount = -10, Balance = 940.00, Date = new DateTime(2020, 1, 3)
},
new ActualBankRecord {
Amount = -10, Balance = 950.00, Date = new DateTime(2020, 1, 2)
},
new ActualBankRecord {
Amount = -10, Balance = 960.00, Date = new DateTime(2020, 1, 2)
},
// earliest records
new ActualBankRecord {
Amount = -10, Balance = 970.00, Date = new DateTime(2020, 1, 1)
},
new ActualBankRecord {
Amount = -20, Balance = 980.00, Date = new DateTime(2020, 1, 1)
},
new ActualBankRecord {
Amount = -20, Balance = 1000.00, Date = new DateTime(2020, 1, 1), Description = "This record could point at balance_row_desc_01"
},
new ActualBankRecord {
Amount = 30, Balance = 1020.00, Date = new DateTime(2020, 1, 1)
},
new ActualBankRecord {
Amount = -10, Balance = 990.00, Date = new DateTime(2020, 1, 1)
},
};
var mock_actual_bank_file = new Mock <ICSVFile <ActualBankRecord> >();
mock_actual_bank_file.Setup(x => x.Records).Returns(fake_records);
var actual_bank_out_file = new ActualBankOutFile(mock_actual_bank_file.Object);
// Act
var result = actual_bank_out_file.Get_potential_balance_rows();
// Assert
Assert.AreEqual(2, result.Count());
Assert.IsTrue(result.Any(x => x.Description == balance_row_desc_01));
Assert.IsTrue(result.Any(x => x.Description == balance_row_desc_02));
}
private void Update_bank_balance(
ActualBankOutFile actual_bank_out_file,
ISpreadsheet spreadsheet,
IInputOutput input_output)
{
input_output.Output_line("Writing bank balance to spreadsheet...");
IList <ActualBankRecord> potential_balance_rows = actual_bank_out_file.Get_potential_balance_rows().ToList();
if (!potential_balance_rows.Any())
{
input_output.Output_line("");
input_output.Get_generic_input(ReconConsts.CantFindBalanceRow);
}
else
{
ActualBankRecord balance_row = Choose_balance_row(potential_balance_rows, input_output);
string balance_description = String.Format(
ReconConsts.BankBalanceDescription,
ReconConsts.Bank_descriptor,
balance_row.Description,
balance_row.Main_amount().To_csv_string(true),
balance_row.Date.ToString(@"dd\/MM\/yyyy"));
spreadsheet.Update_balance_on_totals_sheet(
Codes.Bank_bal,
balance_row.Balance,
balance_description,
balance_column: ReconConsts.BankBalanceAmountColumn,
text_column: ReconConsts.BankBalanceTextColumn,
code_column: ReconConsts.BankBalanceCodeColumn,
input_output: input_output);
}
}
public void Will_find_balance_row_when_records_are_not_in_correct_order()
{
// Arrange
string balance_row_description = "Balance row";
var fake_records = new List <ActualBankRecord>
{
// most recent records
new ActualBankRecord {
Amount = -10, Balance = 910.00, Date = new DateTime(2020, 1, 4)
},
new ActualBankRecord {
Amount = -10, Balance = 920.00, Date = new DateTime(2020, 1, 4)
},
new ActualBankRecord {
Amount = -10, Balance = 900.00, Date = new DateTime(2020, 1, 4), Description = balance_row_description
},
// middle records
new ActualBankRecord {
Amount = -10, Balance = 930.00, Date = new DateTime(2020, 1, 3)
},
new ActualBankRecord {
Amount = -10, Balance = 940.00, Date = new DateTime(2020, 1, 3)
},
new ActualBankRecord {
Amount = -10, Balance = 950.00, Date = new DateTime(2020, 1, 2)
},
new ActualBankRecord {
Amount = -10, Balance = 960.00, Date = new DateTime(2020, 1, 2)
},
// earliest records
new ActualBankRecord {
Amount = -10, Balance = 990.00, Date = new DateTime(2020, 1, 1), Description = "First row"
},
new ActualBankRecord {
Amount = -10, Balance = 970.00, Date = new DateTime(2020, 1, 1)
},
new ActualBankRecord {
Amount = -10, Balance = 980.00, Date = new DateTime(2020, 1, 1)
},
};
var mock_actual_bank_file = new Mock <ICSVFile <ActualBankRecord> >();
mock_actual_bank_file.Setup(x => x.Records).Returns(fake_records);
var actual_bank_out_file = new ActualBankOutFile(mock_actual_bank_file.Object);
// Act
var result = actual_bank_out_file.Get_potential_balance_rows();
// Assert
Assert.AreEqual(1, result.Count());
Assert.AreEqual(balance_row_description, result.ToList()[0].Description);
}
public void Will_find_balance_row_when_most_recent_transaction_has_no_balance()
{
// Arrange
string balance_row_description = "Balance row";
var fake_records = new List <ActualBankRecord>
{
// pending record with no balance
new ActualBankRecord {
Amount = -10, Balance = 0.00, Date = new DateTime(2020, 1, 5)
},
// most recent records
new ActualBankRecord {
Amount = -10, Balance = 940.00, Date = new DateTime(2020, 1, 4), Description = balance_row_description
},
new ActualBankRecord {
Amount = -10, Balance = 950.00, Date = new DateTime(2020, 1, 4)
},
new ActualBankRecord {
Amount = -10, Balance = 960.00, Date = new DateTime(2020, 1, 4)
},
// earliest records
new ActualBankRecord {
Amount = -10, Balance = 970.00, Date = new DateTime(2020, 1, 1)
},
new ActualBankRecord {
Amount = -10, Balance = 980.00, Date = new DateTime(2020, 1, 1)
},
new ActualBankRecord {
Amount = -10, Balance = 990.00, Date = new DateTime(2020, 1, 1)
},
};
var mock_actual_bank_file = new Mock <ICSVFile <ActualBankRecord> >();
mock_actual_bank_file.Setup(x => x.Records).Returns(fake_records);
var actual_bank_out_file = new ActualBankOutFile(mock_actual_bank_file.Object);
// Act
var result = actual_bank_out_file.Get_potential_balance_rows();
// Assert
Assert.AreEqual(1, result.Count());
Assert.AreEqual(balance_row_description, result.ToList()[0].Description);
}
