private void Match_records <TThirdPartyType>(TThirdPartyType source, ICSVRecord match) where TThirdPartyType : ICSVRecord, new()
{
match.Matched = true;
(source as ICSVRecord).Matched = true;
match.Match = source;
(source as ICSVRecord).Match = match;
}
private string Get_description_without_specific_qualifier(ICSVRecord match)
{
string new_description = match.Description;
var qualifier_index_with_space_at_end = match.Description.IndexOf($"{_match_description_qualifier} ", StringComparison.CurrentCultureIgnoreCase);
if (qualifier_index_with_space_at_end >= 0)
{
new_description = match.Description.Remove(qualifier_index_with_space_at_end, _match_description_qualifier.Length + 1);
}
else
{
var qualifier_index_with_space_at_start = match.Description.IndexOf($" {_match_description_qualifier}", StringComparison.CurrentCultureIgnoreCase);
if (qualifier_index_with_space_at_start >= 0)
{
new_description = match.Description.Remove(qualifier_index_with_space_at_start, _match_description_qualifier.Length + 1);
}
else
{
var qualifier_index_no_space = match.Description.IndexOf(_match_description_qualifier, StringComparison.CurrentCultureIgnoreCase);
if (qualifier_index_no_space >= 0)
{
new_description = match.Description.Remove(qualifier_index_no_space, _match_description_qualifier.Length);
}
}
}
new_description = $"{new_description} {match.Main_amount().To_csv_string(true)}";
return(new_description);
}
private void Match_records(CredCard2Record source, ICSVRecord match)
{
match.Matched = true;
source.Matched = true;
match.Match = source;
source.Match = match;
}
public void Copy_from(ICSVRecord source)
{
if (source.GetType() == typeof(ExpectedIncomeRecord))
{
ExpectedIncomeRecord typed_source = source as ExpectedIncomeRecord;
Date = typed_source.Date;
Unreconciled_amount = typed_source.Unreconciled_amount;
Code = typed_source.Code;
Reconciled_amount = typed_source.Reconciled_amount;
Date_paid = typed_source.Date_paid;
Total_paid = typed_source.Total_paid;
Description = typed_source.Description;
SourceLine = typed_source.SourceLine;
OutputSourceLine = typed_source.OutputSourceLine;
Match = typed_source.Match;
Matched = typed_source.Matched;
Divider = typed_source.Divider;
}
else
{
throw (new Exception("Trying to copy record but it's not a ExpectedIncomeRecord type."));
}
}
public void Append_csv_record(String sheet_name, ICSVRecord csv_record)
{
Open_sheet(sheet_name);
var new_row_number = Last_row_number(sheet_name) + 1;
csv_record.Populate_spreadsheet_row(new ExcelRange(_current_worksheet.Cells), new_row_number);
_workbook.Save();
}
public void Create_from_match(DateTime date, double amount, string type, string description, int extra_info, ICSVRecord matched_record)
{
Match = matched_record;
Matched = true;
Date = date;
Amount = amount;
Description = description;
}
private ICSVRecord With_correct_days_per_month(ICSVRecord record, int new_year, int new_month)
{
int days_in_month = DateTime.DaysInMonth(new_year, new_month);
int day = record.Date.Day > days_in_month
? days_in_month
: record.Date.Day;
return(record.With_date(new DateTime(new_year, new_month, day)));
}
public void Create_from_match(DateTime date, double amount, string type, string description, int extra_info, ICSVRecord matched_record)
{
Match = matched_record;
Matched = true;
Date = date;
Unreconciled_amount = amount;
Type = type;
Description = description;
Cheque_number = extra_info;
}
public void Create_new_expenses_record_to_match_balance(ICSVRecord source_record, double balance)
{
if (File.Records != null)
{
File.Records.Add(new ExpectedIncomeRecord
{
Description = ReconConsts.UnknownExpense,
Unreconciled_amount = balance,
Match = source_record,
Matched = true,
Date = source_record.Date,
Date_paid = source_record.Date,
Total_paid = source_record.Main_amount(),
Code = Codes.Expenses
});
}
}
public void Update_expected_income_record_when_matched(ICSVRecord source_record, ICSVRecord match)
{
if (File.Records != null)
{
var matching_records = File.Records.Where(
x => x.Description.Remove_punctuation() == match.Description.Remove_punctuation() &&
x.Date == match.Date &&
x.Main_amount() == match.Main_amount());
if (matching_records.Count() == 1)
{
var matching_record = matching_records.ElementAt(0);
matching_record.Match = source_record;
matching_record.Matched = true;
matching_record.Date_paid = source_record.Date;
matching_record.Total_paid = source_record.Main_amount();
}
}
}
public void Copy_from(ICSVRecord source)
{
if (source.GetType() == typeof(CredCard2Record))
{
CredCard2Record typed_source = source as CredCard2Record;
Date = typed_source.Date;
Description = typed_source.Description;
Amount = typed_source.Amount;
SourceLine = typed_source.SourceLine;
OutputSourceLine = typed_source.OutputSourceLine;
Match = typed_source.Match;
Matched = typed_source.Matched;
Divider = typed_source.Divider;
}
else
{
throw (new Exception("Trying to copy record but it's not a CredCard2Record type."));
}
}
public void Copy_from(ICSVRecord source)
{
if (source.GetType() == typeof(ActualBankRecord))
{
ActualBankRecord typed_source = source as ActualBankRecord;
Date = typed_source.Date;
Type = typed_source.Type;
Description = typed_source.Description;
Amount = typed_source.Amount;
Balance = typed_source.Balance;
LastTransactionMarker = typed_source.LastTransactionMarker;
SourceLine = typed_source.SourceLine;
OutputSourceLine = typed_source.OutputSourceLine;
Match = typed_source.Match;
Matched = typed_source.Matched;
Divider = typed_source.Divider;
}
else
{
throw (new Exception("Trying to copy record but it's not a ActualBankRecord type."));
}
}
public void Copy_from(ICSVRecord source)
{
if (source.GetType() == typeof(BankRecord))
{
BankRecord typed_source = source as BankRecord;
Date = typed_source.Date;
Unreconciled_amount = typed_source.Unreconciled_amount;
Type = typed_source.Type;
Description = typed_source.Description;
Reconciled_amount = typed_source.Reconciled_amount;
Cheque_number = typed_source.Cheque_number;
SourceLine = typed_source.SourceLine;
OutputSourceLine = typed_source.OutputSourceLine;
Match = typed_source.Match;
Matched = typed_source.Matched;
Divider = typed_source.Divider;
}
else
{
throw (new Exception("Trying to copy record but it's not a BankRecord type."));
}
}
public String Read_last_row_as_csv(String sheet_name, ICSVRecord csv_record)
{
return(_spreadsheet_io.Read_last_row_as_csv(sheet_name, csv_record));
}
public void Copy_from(ICSVRecord source)
{
throw new NotImplementedException();
}
public String Read_last_row_as_csv(String sheet_name, ICSVRecord csv_record)
{
csv_record.Read_from_spreadsheet_row(Read_last_row(sheet_name));
return(csv_record.To_csv());
}
public void Append_csv_record(String sheet_name, ICSVRecord csv_record)
{
Inner_spreadsheet.Append_csv_record(sheet_name, csv_record);
}
public string Read_last_row_as_csv(string sheet_name, ICSVRecord csv_record)
{
return(Inner_spreadsheet.Read_last_row_as_csv(sheet_name, csv_record));
}
public void Create_from_match(DateTime date, double amount, string type, string description, int extra_info,
ICSVRecord matched_record)
{
throw new NotImplementedException();
}
/// ///////////////////////////////////////////////////////////////////////////////
/// /// ///////////////////////////////////////////////////////////////////////////////
/// /// ///////////////////////////////////////////////////////////////////////////////
/// /// ///////////////////////////////////////////////////////////////////////////////
public void Append_csv_record(string sheet_name, ICSVRecord csv_record)
{
}
public void Create_new_expenses_record_to_match_balance(ICSVRecord source_record, double balance)
{
_expected_income_file.Create_new_expenses_record_to_match_balance(source_record, balance);
}
public String Read_specified_row_as_csv(String sheet_name, int row_number, ICSVRecord csv_record)
{
csv_record.Read_from_spreadsheet_row(_spreadsheet_io.Read_specified_row(sheet_name, row_number));
return(csv_record.To_csv());
}
public void Create_from_match(DateTime date, double amount, string type, string description, int extra_info,
ICSVRecord matched_record)
{
}
public string Read_last_row_as_csv(string sheet_name, ICSVRecord csv_record)
{
_debug_log.Append_to_file_as_source_line($"{Get_method_name()}: sheetName {sheet_name}");
return("");
}
public void Update_expected_income_record_when_matched(ICSVRecord source_record, ICSVRecord matched_record)
{
_expected_income_file.Update_expected_income_record_when_matched(source_record, matched_record);
}
