public void Will_populate_cred_card2_in_out_record_cells()
{
// Arrange
var cred_card2_in_out_record = new CredCard2InOutRecord
{
Date = new DateTime(year: 2017, month: 4, day: 1),
Unreconciled_amount = 22.48,
Description = "New description which will overwrite what's normally there.",
Reconciled_amount = 661234.56
};
var cells = _spreadsheet.Current_cells("CredCard");
var last_row_number = _spreadsheet.Last_row_number("CredCard");
var previous_record = new CredCard2InOutRecord();
previous_record.Read_from_spreadsheet_row(_spreadsheet.Read_last_row("CredCard"));
// Act
cred_card2_in_out_record.Populate_spreadsheet_row(cells, last_row_number);
var new_row = _spreadsheet.Read_last_row("CredCard");
// Assert
Assert.AreEqual(cred_card2_in_out_record.Date, DateTime.FromOADate((double)new_row.Read_cell(0)));
Assert.AreEqual(cred_card2_in_out_record.Unreconciled_amount, (Double)new_row.Read_cell(1));
Assert.AreEqual(cred_card2_in_out_record.Description, (String)new_row.Read_cell(3));
Assert.AreEqual(cred_card2_in_out_record.Reconciled_amount, (Double)new_row.Read_cell(4));
// Clean up
previous_record.Populate_spreadsheet_row(cells, last_row_number);
}
public void Will_populate_zero_amounts_as_empty_cred_card2_in_out_record_cells()
{
// Arrange
var cred_card2_in_out_record = new CredCard2InOutRecord
{
Unreconciled_amount = 0,
Reconciled_amount = 0
};
var cells = _spreadsheet.Current_cells("CredCard");
var last_row_number = _spreadsheet.Last_row_number("CredCard");
var previous_record = new CredCard2InOutRecord();
previous_record.Read_from_spreadsheet_row(_spreadsheet.Read_last_row("CredCard"));
// Act
cred_card2_in_out_record.Populate_spreadsheet_row(cells, last_row_number);
var new_row = _spreadsheet.Read_last_row("CredCard");
// Assert
Assert.AreEqual(null, new_row.Read_cell(1));
Assert.AreEqual(null, new_row.Read_cell(4));
// Clean up
previous_record.Populate_spreadsheet_row(cells, last_row_number);
}
public void Will_populate_source_line_when_reading_from_cred_card2_in_out_record_cells()
{
// Arrange
String expected_source_line = String.Format("27/04/2018^£5.10^^pintipoplication^\"£10,567.89\"^");
var cred_card2_in_out_record = new CredCard2InOutRecord();
var cells = _spreadsheet.Read_last_row("CredCard");
// Act
cred_card2_in_out_record.Read_from_spreadsheet_row(cells);
// Assert
Assert.AreEqual(expected_source_line, cred_card2_in_out_record.OutputSourceLine);
}
public void Will_read_from_cred_card2_in_out_record_cells_when_there_is_a_null_reconciled_amount()
{
// Arrange
DateTime expected_date = new DateTime(year: 2018, month: 4, day: 25);
Double expected_unreconciled_amount = 4.90;
String expected_description = "pintipoplication";
Double expected_reconciled_amount = 0;
var cred_card2_in_out_record = new CredCard2InOutRecord();
var cells = _spreadsheet.Read_specified_row("CredCard", 8);
// Act
cred_card2_in_out_record.Read_from_spreadsheet_row(cells);
// Assert
Assert.AreEqual(expected_date, cred_card2_in_out_record.Date);
Assert.AreEqual(expected_unreconciled_amount, cred_card2_in_out_record.Unreconciled_amount);
Assert.AreEqual(expected_description, cred_card2_in_out_record.Description);
Assert.AreEqual(expected_reconciled_amount, cred_card2_in_out_record.Reconciled_amount);
}
public void Will_cope_with_cred_card2_in_out_cells_when_not_all_cells_are_populated()
{
// Arrange
String expected_description = "SOMETHING EXCITING & SOMEWHERE COOL";
var cred_card2_in_out_record = new CredCard2InOutRecord();
List <object> cells = new List <object>
{
(double)43405,
null,
null,
expected_description
};
// Act
cred_card2_in_out_record.Read_from_spreadsheet_row(new ExcelRow(cells));
// Assert
Assert.AreEqual(expected_description, cred_card2_in_out_record.Description);
}
public void Will_read_from_cred_card2_in_out_record_cells()
{
// Arrange
DateTime expected_date = new DateTime(year: 2018, month: 4, day: 27);
Double expected_unreconciled_amount = 5.10;
String expected_description = "pintipoplication";
Double expected_reconciled_amount = 10567.89;
var cred_card2_in_out_record = new CredCard2InOutRecord();
var cells = _spreadsheet.Read_last_row("CredCard");
// Act
cred_card2_in_out_record.Read_from_spreadsheet_row(cells);
// Assert
Assert.AreEqual(expected_date, cred_card2_in_out_record.Date);
Assert.AreEqual(expected_unreconciled_amount, cred_card2_in_out_record.Unreconciled_amount);
Assert.AreEqual(expected_description, cred_card2_in_out_record.Description);
Assert.AreEqual(expected_reconciled_amount, cred_card2_in_out_record.Reconciled_amount);
}
public void Will_insert_null_in_relevant_cell_when_cred_card2_in_out_record_is_not_matched()
{
// Arrange
var cred_card2_in_out_record = new CredCard2InOutRecord {
Matched = false
};
var cells = _spreadsheet.Current_cells("CredCard");
var last_row_number = _spreadsheet.Last_row_number("CredCard");
var previous_record = new CredCard2InOutRecord();
previous_record.Read_from_spreadsheet_row(_spreadsheet.Read_last_row("CredCard"));
// Act
cred_card2_in_out_record.Populate_spreadsheet_row(cells, last_row_number);
var new_row = _spreadsheet.Read_last_row("CredCard");
// Assert
Assert.AreEqual(null, (String)new_row.Read_cell(2));
// Clean up
previous_record.Populate_spreadsheet_row(cells, last_row_number);
}
public void Will_insert_divider_text_in_second_cell_when_cred_card2_in_out_record_is_divider()
{
// Arrange
var cred_card2_in_out_record = new CredCard2InOutRecord {
Divider = true
};
var cells = _spreadsheet.Current_cells("CredCard");
var last_row_number = _spreadsheet.Last_row_number("CredCard");
var previous_record = new CredCard2InOutRecord();
previous_record.Read_from_spreadsheet_row(_spreadsheet.Read_last_row("CredCard"));
// Act
cred_card2_in_out_record.Populate_spreadsheet_row(cells, last_row_number);
var new_row = _spreadsheet.Read_last_row("CredCard");
// Assert
Assert.AreEqual(ReconConsts.DividerText, (String)new_row.Read_cell(1));
// Clean up
previous_record.Populate_spreadsheet_row(cells, last_row_number);
}
