private void PrintHouseholdPost(HouseholdPost householdPost)
{
int topIndex = _worksheetWriter.CurrentPosition.Y;
_worksheetWriter
.SetBackgroundColor(Color.LightYellow)
.Write(householdPost.Category.ToString())
.MoveRight();
int year = 2020;
for (int monthNumber = 1; monthNumber < 13; monthNumber++)
{
var yearMonth = new YearMonth(year, monthNumber);
var incomeInMonth = householdPost.GetIncome(yearMonth);
var expensesInMonth = householdPost.GetExpenses(yearMonth);
_worksheetWriter
.SetBackgroundColor(Color.FromArgb(255, 199, 206))
.SetFontColor(Color.Black)
.Write(-1 * expensesInMonth)
.MoveDown()
.SetBackgroundColor(Color.LightGreen)
.Write(incomeInMonth)
.MoveDown()
.SetBackgroundColor(Color.Gainsboro)
.SetFontColor(Color.Black)
.PlaceFormula(new Point(_worksheetWriter.CurrentPosition.X, topIndex), new Point(_worksheetWriter.CurrentPosition.X, _worksheetWriter.CurrentPosition.Y - 1), FormulaType.SUM)
.MoveRight()
.MoveUp()
.MoveUp();
}
_worksheetWriter
.PlaceFormula(new Point(2, _worksheetWriter.CurrentPosition.Y), new Point(_worksheetWriter.CurrentPosition.X - 1, _worksheetWriter.CurrentPosition.Y), FormulaType.SUM)
.MoveRight()
.PlaceFormula(new Point(2, _worksheetWriter.CurrentPosition.Y), new Point(_worksheetWriter.CurrentPosition.X - 2, _worksheetWriter.CurrentPosition.Y), FormulaType.AVERAGE)
.MoveDown()
.MoveLeft()
.PlaceFormula(new Point(2, _worksheetWriter.CurrentPosition.Y), new Point(_worksheetWriter.CurrentPosition.X - 1, _worksheetWriter.CurrentPosition.Y), FormulaType.SUM)
.MoveRight()
.PlaceFormula(new Point(2, _worksheetWriter.CurrentPosition.Y), new Point(_worksheetWriter.CurrentPosition.X - 2, _worksheetWriter.CurrentPosition.Y), FormulaType.AVERAGE)
.NewLine()
.NewLine()
.NewLine();
}
public void Initialize()
{
_fixture = new Fixture();
_sut = new HouseholdPost(_fixture.Create <Category>());
}
