public void Write(HouseholdBook householdBook)
{
WriteTitle();
WriteHeaderRow();
foreach (var householdPost in householdBook.HouseholdPosts)
{
PrintHouseholdPost(householdPost);
}
}
public void Write(HouseholdBook householdBook)
{
WriteTitle(_worksheetWriter);
WriteHeaderRow(_worksheetWriter);
var unknownHousholdPost = householdBook.RetrieveHouseholdPost(Category.Unknown);
foreach (var transaction in unknownHousholdPost.OriginalTransactions)
{
PrintTransaction(transaction);
}
}
public HouseholdBook CreateHouseholdBook()
{
var transactions = _transactionProvider.ProvideTransactions();
var householdBook = new HouseholdBook();
foreach (Banktransaction transaction in transactions.ToList())
{
var category = _transactionCategorizer.DetermineCategory(transaction.Description);
var householdPost = householdBook.RetrieveHouseholdPost(category);
householdPost.AddTransaction(transaction.Description, transaction.Amount, YearMonth.FromDateTime(transaction.Date), transaction.TransactionDirection);
transactions.Remove(transaction);
}
return(householdBook);
}
public async Task WriteAsync(HouseholdBook householdBook)
{
_excelPackage.Workbook.Properties.Author = "W. Fennis";
_excelPackage.Workbook.Properties.Title = "Householdbook";
_excelPackage.Workbook.Properties.Subject = "Export";
_excelPackage.Workbook.Properties.Created = DateTime.Now;
ExcelWorksheet householdBookWorksheet = _excelPackage.Workbook.Worksheets.Add("Householdbook");
var householdPostWorksheet = new HouseholdPostWorksheet(householdBookWorksheet);
householdPostWorksheet.Write(householdBook);
ExcelWorksheet unknownTransactions = _excelPackage.Workbook.Worksheets.Add("Unknown Transactions");
var unknownTransactionsWorksheet = new UnknownTransactionsWorksheet(unknownTransactions);
unknownTransactionsWorksheet.Write(householdBook);
await _excelPackage.SaveAsync();
}
