private static void WriteRow(IReportWriter writer, bool header, bool addExpanderCell, string name, IEnumerable <string> values)
{
if (header)
{
writer.StartHeaderRow();
}
else
{
writer.StartRow();
}
if (addExpanderCell)
{
writer.StartCell();
writer.EndCell();
}
writer.StartCell();
writer.WriteParagraph(name);
writer.EndCell();
foreach (string v in values)
{
writer.StartCell();
if (!string.IsNullOrEmpty(v))
{
writer.WriteNumber(v);
}
writer.EndCell();
}
writer.EndRow();
}
private void WriteCapitalGainsTotal(IReportWriter writer, decimal total)
{
writer.StartHeaderRow();
writer.StartCell();
writer.WriteParagraph("Total");
writer.EndCell();
writer.StartCell();
writer.EndCell();
writer.StartCell();
writer.EndCell();
writer.StartCell();
writer.EndCell();
writer.StartCell();
writer.EndCell();
writer.StartCell();
writer.EndCell();
writer.StartCell();
writer.EndCell();
writer.StartCell();
writer.EndCell();
writer.StartCell();
writer.WriteNumber(GiveUpTheFractionalPennies(total).ToString("C"));
writer.EndCell();
writer.EndRow();
}
private static void WriteRow(IReportWriter writer, string name, decimal balance)
{
writer.StartRow();
writer.StartCell();
writer.WriteParagraph(name);
writer.EndCell();
writer.StartCell();
writer.WriteNumber(balance.ToString("C"));
writer.EndCell();
writer.EndRow();
}
private void WriteSummaryRow(IReportWriter writer, String col1, String col2, String col3)
{
writer.StartCell();
writer.WriteParagraph(col1);
writer.EndCell();
writer.StartCell();
writer.WriteNumber(col2);
writer.EndCell();
writer.StartCell();
writer.WriteNumber(col3);
writer.EndCell();
writer.EndRow();
}
private void WriteRow(IReportWriter writer, bool header, bool addExpanderCell, string name, IEnumerable <CashFlowCell> cells)
{
if (header)
{
writer.StartHeaderRow();
}
else
{
writer.StartRow();
}
if (addExpanderCell)
{
writer.StartCell();
writer.EndCell();
}
writer.StartCell();
writer.WriteParagraph(name);
writer.EndCell();
foreach (CashFlowCell cell in cells)
{
writer.StartCell();
if (cell.Value != 0)
{
writer.WriteNumber(cell.Value.ToString("N0"));
if (cell.Data.Count > 0)
{
FlowDocumentReportWriter fw = (FlowDocumentReportWriter)writer;
Paragraph p = fw.CurrentParagraph;
p.Tag = cell;
p.PreviewMouseLeftButtonDown += OnReportCellMouseDown;
p.Cursor = Cursors.Arrow;
//p.TextDecorations.Add(TextDecorations.Underline);
//p.Foreground = Brushes.DarkSlateBlue;
p.SetResourceReference(Paragraph.ForegroundProperty, "HyperlinkForeground");
}
}
writer.EndCell();
}
writer.EndRow();
}
private void WriteHeaderRow(IReportWriter writer, String col1, String col2, String col3)
{
writer.StartHeaderRow();
writer.StartCell(1, 2);
writer.WriteParagraph(col1);
writer.EndCell();
writer.StartCell();
writer.WriteNumber(col2);
writer.EndCell();
writer.StartCell();
if (col3 != null)
{
writer.WriteNumber(col3);
writer.EndCell();
}
writer.EndRow();
}
private static void WriteRow(IReportWriter writer, string col1, string col2, string col3)
{
writer.StartRow();
writer.StartCell();
writer.WriteParagraph(col1);
writer.EndCell();
writer.StartCell();
writer.WriteParagraph(col2);
writer.EndCell();
writer.StartCell();
writer.WriteParagraph(col3);
writer.EndCell();
writer.EndRow();
}
private void WriteSummary(IReportWriter writer, List <SecurityPieData> data, string prefix, Predicate <Account> filter)
{
// compute summary
foreach (var securityGroup in calc.GetHoldingsBySecurityType(filter))
{
decimal marketValue = 0;
decimal gainLoss = 0;
SecurityType st = securityGroup.Key;
int count = 0;
foreach (SecurityPurchase i in securityGroup.Value)
{
if (i.UnitsRemaining > 0)
{
marketValue += i.MarketValue;
gainLoss += i.GainLoss;
count++;
}
}
string caption = prefix + Security.GetSecurityTypeCaption(st);
if (count > 0)
{
data.Add(new SecurityPieData()
{
Total = RoundToNearestCent(marketValue),
Name = caption
});
writer.StartRow();
writer.StartCell();
writer.WriteParagraph(caption);
writer.EndCell();
writer.StartCell();
writer.WriteNumber(marketValue.ToString("C"));
writer.EndCell();
writer.StartCell();
writer.WriteNumber(gainLoss.ToString("C"));
writer.EndCell();
writer.EndRow();
}
totalMarketValue += marketValue;
totalGainLoss += gainLoss;
}
}
private static void WriteHeader(IReportWriter writer, string caption)
{
writer.StartHeaderRow();
writer.StartCell(1, 2);
writer.WriteParagraph(caption);
writer.EndCell();
writer.EndRow();
}
private static void WriteRowHeaders(IReportWriter writer)
{
writer.StartHeaderRow();
writer.StartCell();
// optional expander button.
writer.EndCell();
writer.StartCell();
writer.WriteParagraph("Date Acquired");
writer.EndCell();
writer.StartCell();
writer.WriteParagraph("Description");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Quantity");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Price");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Market Value");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Unit Cost");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Cost Basis");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Gain/Loss");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("%");
writer.EndCell();
writer.EndRow();
}
void WriteCapitalGains(IReportWriter writer, SecuritySale data)
{
writer.StartRow();
writer.StartCell();
writer.WriteParagraph(data.Security.Name);
writer.EndCell();
writer.StartCell();
writer.WriteNumber(Rounded(data.UnitsSold, 3));
writer.EndCell();
writer.StartCell();
if (data.DateAcquired == null)
{
writer.WriteNumber("VARIOUS");
}
else
{
writer.WriteNumber(data.DateAcquired.Value.ToShortDateString());
}
writer.EndCell();
writer.StartCell();
writer.WriteNumber(data.CostBasisPerUnit.ToString("C"));
writer.EndCell();
writer.StartCell();
writer.WriteNumber(data.TotalCostBasis.ToString("C"));
writer.EndCell();
writer.StartCell();
writer.WriteNumber(data.DateSold.ToShortDateString());
writer.EndCell();
writer.StartCell();
writer.WriteNumber(data.SalePricePerUnit.ToString("C"));
writer.EndCell();
writer.StartCell();
writer.WriteNumber(data.SaleProceeds.ToString("C"));
writer.EndCell();
writer.StartCell();
writer.WriteNumber(GiveUpTheFractionalPennies(data.TotalGain).ToString("C"));
writer.EndCell();
writer.EndRow();
}
private static void WriteRow(IReportWriter writer, Color color, string name, decimal balance)
{
writer.StartRow();
writer.StartCell();
writer.WriteElement(new Rectangle()
{
Width = 20, Height = 16, Fill = new SolidColorBrush(color)
});
writer.EndCell();
writer.StartCell();
writer.WriteParagraph(name);
writer.EndCell();
writer.StartCell();
writer.WriteNumber(balance.ToString("C"));
writer.EndCell();
writer.EndRow();
}
public void Generate(IReportWriter writer)
{
writer.WriteHeading("Unaccepted Transactions");
Transactions transactions = myMoney.Transactions;
foreach (Account a in this.myMoney.Accounts.GetAccounts(true))
{
if (a.IsClosed)
{
continue;
}
bool first = true;
foreach (Transaction t in this.myMoney.Transactions.GetTransactionsFrom(a))
{
if (t.Unaccepted)
{
if (first)
{
writer.EndTable();
writer.WriteHeading(a.Name);
writer.StartTable();
writer.StartColumnDefinitions();
foreach (double minWidth in new double[] { 100, 300, 120 })
{
writer.WriteColumnDefinition(minWidth.ToString(), minWidth, double.MaxValue);
}
writer.EndColumnDefinitions();
writer.StartHeaderRow();
foreach (string header in new string[] { "Date", "Payee/Category/Memo", "Amount", })
{
writer.StartCell();
writer.WriteParagraph(header);
writer.EndCell();
}
writer.EndRow();
first = false;
}
WriteRow(writer, t.Date.ToShortDateString(), t.PayeeName ?? string.Empty, t.Amount.ToString("C"));
WriteRow(writer, string.Empty, t.CategoryName ?? string.Empty, string.Empty);
WriteRow(writer, string.Empty, t.Memo ?? string.Empty, string.Empty);
}
}
}
writer.EndTable();
writer.WriteParagraph("Generated on " + DateTime.Today.ToLongDateString(), System.Windows.FontStyles.Italic, System.Windows.FontWeights.Normal, System.Windows.Media.Brushes.Gray);
}
private void WriteSummaryRow(IReportWriter writer, Color c, String col1, String col2, String col3)
{
writer.StartCell();
writer.WriteElement(new Rectangle()
{
Width = 20, Height = 16, Fill = new SolidColorBrush(c)
});
writer.EndCell();
writer.StartCell();
writer.WriteParagraph(col1);
writer.EndCell();
writer.StartCell();
writer.WriteNumber(col2);
writer.EndCell();
writer.StartCell();
if (col3 != null)
{
writer.WriteNumber(col3);
writer.EndCell();
}
writer.EndRow();
}
void WriteHeaders(IReportWriter writer)
{
writer.StartTable();
writer.StartColumnDefinitions();
for (int i = 0; i < 9; i++)
{
writer.WriteColumnDefinition("Auto", 100, double.MaxValue);
}
writer.EndColumnDefinitions();
writer.StartHeaderRow();
writer.StartCell();
writer.WriteParagraph("Security");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Quantity");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Date Acquired");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Acquisition Price");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Cost Basis");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Date Sold");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Sale Price");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Proceeds");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Gain or Loss");
writer.EndCell();
writer.EndRow();
}
private void WriteRow(IReportWriter writer, bool expandable, bool header, FontWeight weight, DateTime?aquired, string description, string descriptionUrl, decimal?quantity, decimal?price, decimal marketValue, decimal?unitCost, decimal costBasis, decimal gainLoss)
{
if (header)
{
writer.StartHeaderRow();
}
else
{
writer.StartRow();
}
if (expandable)
{
writer.StartCell();
writer.EndCell();
}
writer.StartCell();
if (aquired.HasValue)
{
writer.WriteParagraph(aquired.Value.ToShortDateString(), FontStyles.Normal, weight, null);
}
writer.EndCell();
writer.StartCell();
writer.WriteParagraph(description, FontStyles.Normal, weight, null);
if (!string.IsNullOrEmpty(descriptionUrl))
{
FlowDocumentReportWriter fw = (FlowDocumentReportWriter)writer;
Paragraph p = fw.CurrentParagraph;
p.Tag = descriptionUrl;
p.PreviewMouseLeftButtonDown += OnReportCellMouseDown;
p.Cursor = Cursors.Arrow;
//p.TextDecorations.Add(TextDecorations.Underline);
p.SetResourceReference(Paragraph.ForegroundProperty, "HyperlinkForeground");
}
writer.EndCell();
writer.StartCell();
if (quantity.HasValue)
{
writer.WriteNumber(quantity.Value.ToString("N2"));
}
writer.EndCell();
writer.StartCell();
if (price.HasValue)
{
writer.WriteNumber(price.Value.ToString("N2"));
}
writer.EndCell();
writer.StartCell();
writer.WriteNumber(marketValue.ToString("N2"));
writer.EndCell();
writer.StartCell();
if (unitCost.HasValue)
{
writer.WriteNumber(unitCost.Value.ToString("N2"));
}
writer.EndCell();
writer.StartCell();
writer.WriteNumber(costBasis.ToString("N2"));
writer.EndCell();
writer.StartCell();
writer.WriteNumber(gainLoss.ToString("N2"));
writer.EndCell();
writer.StartCell();
decimal percent = costBasis == 0 ? 0 : (gainLoss / costBasis) * 100;
writer.WriteNumber(percent.ToString("N0"));
writer.EndCell();
writer.EndRow();
}
public void Generate(IReportWriter writer)
{
writer.WriteHeading("Net Worth Statement");
List <PieData> data = new List <PieData>();
// outer table contains 2 columns, left is the summary table, right is the pie chart.
writer.StartTable();
writer.StartColumnDefinitions();
writer.WriteColumnDefinition("420", 420, 420);
writer.WriteColumnDefinition("620", 620, 620);
writer.EndColumnDefinitions();
writer.StartRow();
writer.StartCell();
// inner table contains the "data"
writer.StartTable();
writer.StartColumnDefinitions();
foreach (double width in new double[] { 300, 100 })
{
writer.WriteColumnDefinition(width.ToString(), width, width);
}
writer.EndColumnDefinitions();
WriteHeader(writer, "Liquid Assets");
decimal totalBalance = 0;
decimal balance = 0;
bool hasTaxDeferred = false;
bool hasRetirement = false;
Transactions transactions = myMoney.Transactions;
foreach (Account a in this.myMoney.Accounts.GetAccounts(true))
{
if (a.Type == AccountType.Retirement)
{
hasRetirement = true;
continue;
}
if (a.IsTaxDeferred)
{
hasTaxDeferred = true;
}
if (a.Type == AccountType.Credit ||
a.Type == AccountType.Asset ||
a.Type == AccountType.Brokerage ||
a.Type == AccountType.CategoryFund ||
a.Type == AccountType.Loan)
{
continue;
}
balance += a.BalanceNormalized;
}
if (balance > 0)
{
data.Add(new PieData()
{
Name = "Cash", Total = balance
});
}
WriteRow(writer, "Cash", balance);
totalBalance += balance;
balance = this.myMoney.GetInvestmentCashBalance(new Predicate <Account>((a) => { return(!a.IsClosed && (a.Type == AccountType.Brokerage)); }));
if (balance > 0)
{
data.Add(new PieData()
{
Name = "Investment Cash", Total = balance
});
}
WriteRow(writer, "Investment Cash", balance);
totalBalance += balance;
bool hasNoneRetirement = false;
if (hasRetirement)
{
WriteHeader(writer, "Retirement Assets");
balance = this.myMoney.GetInvestmentCashBalance(new Predicate <Account>((a) => { return(!a.IsClosed && a.Type == AccountType.Retirement); }));
if (balance > 0)
{
data.Add(new PieData()
{
Name = "Retirement Cash", Total = balance
});
}
WriteRow(writer, "Retirement Cash", balance);
totalBalance += balance;
totalBalance += WriteSecurities(writer, data, "Retirement ", new Predicate <Account>((a) => { return(a.Type == AccountType.Retirement); }), out hasNoneRetirement);
}
bool hasNoneTypeTaxDeferred = false;
if (hasTaxDeferred)
{
WriteHeader(writer, "Tax Deferred Assets");
totalBalance += WriteSecurities(writer, data, "Tax Deferred ", new Predicate <Account>((a) => { return(a.Type == AccountType.Brokerage && a.IsTaxDeferred); }), out hasNoneTypeTaxDeferred);
}
balance = 0;
WriteHeader(writer, "Long Term Assets");
foreach (Account a in this.myMoney.Accounts.GetAccounts(true))
{
if ((a.Type == AccountType.Loan || a.Type == AccountType.Asset) && a.Balance > 0) // then this is a loan out to someone else...
{
if (a.BalanceNormalized > 0)
{
data.Add(new PieData()
{
Name = a.Name, Total = a.BalanceNormalized
});
}
WriteRow(writer, a.Name, a.BalanceNormalized);
totalBalance += a.BalanceNormalized;
}
}
bool hasNoneType = false;
totalBalance += WriteSecurities(writer, data, "", new Predicate <Account>((a) => { return(a.Type == AccountType.Brokerage && !a.IsTaxDeferred); }), out hasNoneType);
balance = 0;
WriteHeader(writer, "Liabilities");
foreach (Account a in this.myMoney.Accounts.GetAccounts(true))
{
if (a.Type != AccountType.Credit)
{
continue;
}
balance += a.BalanceNormalized;
}
totalBalance += balance;
if (balance > 0)
{
data.Add(new PieData()
{
Name = "Credit", Total = balance
});
}
WriteRow(writer, "Credit", balance);
balance = 0;
foreach (Account a in this.myMoney.Accounts.GetAccounts(true))
{
if (a.Type == AccountType.Loan && a.BalanceNormalized < 0)
{
balance += a.BalanceNormalized;
if (a.BalanceNormalized > 0)
{
data.Add(new PieData()
{
Name = a.Name, Total = a.BalanceNormalized
});
}
WriteRow(writer, a.Name, a.BalanceNormalized);
}
}
totalBalance += balance;
writer.StartFooterRow();
writer.StartCell();
writer.WriteParagraph("Total");
writer.EndCell();
writer.StartCell();
writer.WriteNumber(totalBalance.ToString("C"));
writer.EndCell();
writer.EndRow();
writer.EndTable();
writer.EndCell();
writer.StartCell();
// pie chart
Chart chart = new Chart();
chart.MinWidth = 600;
chart.MinHeight = 400;
chart.BorderThickness = new Thickness(0);
chart.VerticalAlignment = VerticalAlignment.Top;
PieSeries series = new PieSeries();
series.IndependentValueBinding = new Binding("Name");
series.DependentValueBinding = new Binding("Total");
chart.Series.Add(series);
series.ItemsSource = data;
writer.WriteElement(chart);
writer.EndCell();
writer.EndRow();
writer.EndTable();
if (hasNoneRetirement || hasNoneTypeTaxDeferred || hasNoneType)
{
writer.WriteParagraph("(*) One ore more of your securities has no SecurityType, you can fix this using View/Securities",
System.Windows.FontStyles.Italic, System.Windows.FontWeights.Normal, System.Windows.Media.Brushes.Maroon);
}
writer.WriteParagraph("Generated on " + DateTime.Today.ToLongDateString(), System.Windows.FontStyles.Italic, System.Windows.FontWeights.Normal, System.Windows.Media.Brushes.Gray);
}
bool GenerateForm(TaxForm form, IReportWriter writer, ICollection <Transaction> transactions)
{
var byCategory = new Dictionary <Category, decimal>();
// could be one to many mapping.
Dictionary <TaxCategory, List <Category> > map = new Dictionary <TaxCategory, List <Category> >();
// find our matching category
foreach (TaxCategory tc in form.Categories)
{
foreach (Category c in this.myMoney.Categories.GetCategories())
{
if (c.TaxRefNum == tc.RefNum)
{
byCategory[c] = 0M;
List <Category> list = null;
if (!map.TryGetValue(tc, out list))
{
list = new List <Category>();
map[tc] = list;
}
list.Add(c);
}
}
}
bool found = false;
// summarize the year.
foreach (Transaction t in transactions)
{
if (t.Date.Year == this.year)
{
found |= Summarize(byCategory, t);
}
}
if (!found)
{
return(false);
}
writer.WriteHeading("Form " + form.Name);
writer.StartTable();
writer.StartColumnDefinitions();
writer.WriteColumnDefinition("20", 20, 20); // expander column
writer.WriteColumnDefinition("300", 300, 300); // row category name
writer.WriteColumnDefinition("100", 100, 00); // row value
writer.EndColumnDefinitions();
foreach (TaxCategory tc in form.Categories)
{
List <Category> list = null;
if (map.TryGetValue(tc, out list))
{
if (list.Count > 1)
{
decimal total = 0;
foreach (Category c in list)
{
total += byCategory[c];
}
if (total != 0)
{
writer.StartExpandableRowGroup();
// header row for the total.
writer.StartRow();
writer.StartCell();
writer.WriteParagraph(tc.Name);
writer.EndCell();
writer.StartCell();
writer.WriteNumber(total.ToString("N0"));
writer.EndCell();
writer.EndRow();
foreach (Category c in list)
{
decimal v = byCategory[c];
if (v != 0)
{
writer.StartRow();
writer.StartCell();
writer.WriteParagraph(" " + c.GetFullName());
writer.EndCell();
writer.StartCell();
writer.WriteNumber(v.ToString("N0"));
AddHyperlink(c, writer);
writer.EndCell();
writer.EndRow();
}
}
writer.EndExpandableRowGroup();
}
}
else if (list.Count == 1)
{
Category c = list[0];
decimal v = byCategory[c];
if (v != 0)
{
writer.StartRow();
writer.StartCell(); // null expander
writer.EndCell();
writer.StartCell();
writer.WriteParagraph(tc.Name);
writer.EndCell();
writer.StartCell();
writer.WriteNumber(v.ToString("N0"));
AddHyperlink(c, writer);
writer.EndCell();
writer.EndRow();
}
}
}
}
writer.EndTable();
return(true);
}
public void Generate(IReportWriter writer)
{
flowwriter = writer as FlowDocumentReportWriter;
calc = new CostBasisCalculator(this.myMoney, this.reportDate);
string heading = "Investment Portfolio Summary";
if (this.account != null)
{
heading += " for " + account.Name + " (" + account.AccountId + ")";
}
writer.WriteHeading(heading);
if (reportDate.Date != DateTime.Today)
{
writer.WriteSubHeading("As of " + reportDate.Date.AddDays(-1).ToLongDateString());
}
totalMarketValue = 0;
totalGainLoss = 0;
// outer table contains 2 columns, left is the summary table, right is the pie chart.
writer.StartTable();
writer.StartColumnDefinitions();
writer.WriteColumnDefinition("Auto", 100, double.MaxValue);
writer.WriteColumnDefinition("Auto", 100, double.MaxValue);
writer.EndColumnDefinitions();
writer.StartRow();
writer.StartCell();
writer.StartTable();
writer.StartColumnDefinitions();
foreach (double minWidth in new double[] { 300, 100, 100 })
{
writer.WriteColumnDefinition("Auto", minWidth, double.MaxValue);
}
writer.EndColumnDefinitions();
List <SecurityPieData> data = new List <SecurityPieData>();
if (account == null)
{
WriteSummary(writer, data, TaxableIncomeType.None, "Retirement Tax Free ", new Predicate <Account>((a) => { return(!a.IsClosed && !a.IsTaxDeferred && a.Type == AccountType.Retirement); }), true);
WriteSummary(writer, data, TaxableIncomeType.All, "Retirement ", new Predicate <Account>((a) => { return(!a.IsClosed && a.IsTaxDeferred && a.Type == AccountType.Retirement); }), true);
WriteSummary(writer, data, TaxableIncomeType.All, "Tax Deferred ", new Predicate <Account>((a) => { return(!a.IsClosed && a.IsTaxDeferred && a.Type == AccountType.Brokerage); }), true);
WriteSummary(writer, data, TaxableIncomeType.Gains, "", new Predicate <Account>((a) => { return(!a.IsClosed && !a.IsTaxDeferred && a.Type == AccountType.Brokerage); }), true);
}
else
{
TaxableIncomeType taxableIncomeType;
if (account.IsTaxDeferred)
{
taxableIncomeType = TaxableIncomeType.All;
}
else
{
if (account.Type == AccountType.Retirement)
{
// Currently treating this combination as tax free
taxableIncomeType = TaxableIncomeType.None;
}
else
{
taxableIncomeType = TaxableIncomeType.Gains;
}
}
WriteSummary(writer, data, taxableIncomeType, "", new Predicate <Account>((a) => { return(a == account); }), false);
}
WriteheaderRow(writer, "Total", totalMarketValue.ToString("C"), totalGainLoss.ToString("C"));
writer.EndTable();
writer.EndCell();
// pie chart
Chart chart = new Chart();
chart.MinWidth = 400;
chart.MinHeight = 300;
chart.BorderThickness = new Thickness(0);
chart.Padding = new Thickness(0);
chart.Margin = new Thickness(0, 00, 0, 0);
chart.VerticalAlignment = VerticalAlignment.Top;
chart.HorizontalAlignment = HorizontalAlignment.Left;
PieSeries series = new PieSeries();
series.IndependentValueBinding = new Binding("Name");
series.DependentValueBinding = new Binding("Total");
chart.Series.Add(series);
series.ItemsSource = data;
writer.StartCell();
writer.WriteElement(chart);
writer.EndCell();
// end the outer table.
writer.EndTable();
totalMarketValue = 0;
totalGainLoss = 0;
List <SecuritySale> errors = new List <SecuritySale>(calc.GetPendingSales(new Predicate <Account>((a) => { return(a == account); })));
if (errors.Count > 0)
{
writer.WriteSubHeading("Pending Sales");
foreach (var sp in errors)
{
writer.WriteParagraph(string.Format("Pending sale of {1} units of '{2}' from account '{0}' recorded on {3}", sp.Account.Name, sp.UnitsSold, sp.Security.Name, sp.DateSold.ToShortDateString()));
}
}
if (account == null)
{
WriteDetails(writer, "Retirement Tax Free ", new Predicate <Account>((a) => { return(!a.IsClosed && !a.IsTaxDeferred && a.Type == AccountType.Retirement); }));
WriteDetails(writer, "Retirement ", new Predicate <Account>((a) => { return(!a.IsClosed && a.IsTaxDeferred && a.Type == AccountType.Retirement); }));
WriteDetails(writer, "Tax Deferred ", new Predicate <Account>((a) => { return(!a.IsClosed && a.IsTaxDeferred && a.Type == AccountType.Brokerage); }));
WriteDetails(writer, "", new Predicate <Account>((a) => { return(!a.IsClosed && !a.IsTaxDeferred && a.Type == AccountType.Brokerage); }));
}
else
{
WriteDetails(writer, "", new Predicate <Account>((a) => { return(a == account); }));
}
}
private void GenerateCapitalGains(IReportWriter writer)
{
var calculator = new CapitalGainsTaxCalculator(this.money, this.endDate, this.consolidateOnDateSold, true);
List <SecuritySale> errors = new List <SecuritySale>(from s in calculator.GetSales() where s.Error != null select s);
if (errors.Count > 0)
{
writer.WriteHeading("Errors Found");
foreach (SecuritySale error in errors)
{
writer.WriteParagraph(error.Error.Message);
}
}
if ((from u in calculator.Unknown where InRange(u.DateSold) select u).Any())
{
writer.WriteHeading("Capital Gains with Unknown Cost Basis");
writer.StartTable();
writer.StartColumnDefinitions();
for (int i = 0; i < 4; i++)
{
writer.WriteColumnDefinition("Auto", 100, double.MaxValue);
}
writer.EndColumnDefinitions();
writer.StartHeaderRow();
writer.StartCell();
writer.WriteParagraph("Security");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Quantity");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Date Sold");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Sale Price");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Proceeds");
writer.EndCell();
writer.EndRow();
foreach (var data in calculator.Unknown)
{
if (!InRange(data.DateSold))
{
continue;
}
writer.StartRow();
writer.StartCell();
writer.WriteParagraph(data.Security.Name);
writer.EndCell();
writer.StartCell();
writer.WriteNumber(Rounded(data.UnitsSold, 3));
writer.EndCell();
writer.StartCell();
writer.WriteNumber(data.DateSold.ToShortDateString());
writer.EndCell();
writer.StartCell();
writer.WriteNumber(data.SalePricePerUnit.ToString("C"));
writer.EndCell();
writer.StartCell();
writer.WriteNumber(data.SaleProceeds.ToString("C"));
writer.EndCell();
}
writer.EndTable();
}
if (calculator.ShortTerm.Count > 0)
{
decimal total = 0;
writer.WriteHeading("Short Term Capital Gains and Losses");
WriteHeaders(writer);
foreach (var data in calculator.ShortTerm)
{
if (!InRange(data.DateSold))
{
continue;
}
WriteCapitalGains(writer, data);
total += data.TotalGain;
}
WriteCapitalGainsTotal(writer, total);
writer.EndTable();
}
if (calculator.LongTerm.Count > 0)
{
decimal total = 0;
writer.WriteHeading("Long Term Capital Gains and Losses");
WriteHeaders(writer);
foreach (var data in calculator.LongTerm)
{
if (!InRange(data.DateSold))
{
continue;
}
WriteCapitalGains(writer, data);
total += data.TotalGain;
}
WriteCapitalGainsTotal(writer, total);
}
writer.EndTable();
}
public void Generate(IReportWriter writer)
{
flowwriter = writer as FlowDocumentReportWriter;
calc = new CostBasisCalculator(this.myMoney, this.reportDate);
string heading = "Investment Portfolio Summary";
if (this.selectedGroup != null)
{
heading = "Investment Portfolio - " + this.selectedGroup.Type;
}
if (this.account != null)
{
heading += " for " + account.Name + " (" + account.AccountId + ")";
}
writer.WriteHeading(heading);
if (reportDate.Date != DateTime.Today)
{
writer.WriteSubHeading("As of " + reportDate.Date.AddDays(-1).ToLongDateString());
}
totalMarketValue = 0;
totalGainLoss = 0;
// outer table contains 2 columns, left is the summary table, right is the pie chart.
writer.StartTable();
writer.StartColumnDefinitions();
writer.WriteColumnDefinition("Auto", 100, double.MaxValue);
writer.WriteColumnDefinition("Auto", 100, double.MaxValue);
writer.EndColumnDefinitions();
writer.StartRow();
writer.StartCell();
writer.StartTable();
writer.StartColumnDefinitions();
writer.WriteColumnDefinition("30", 30, 30);
foreach (double minWidth in new double[] { 300, 100, 100 })
{
writer.WriteColumnDefinition("Auto", minWidth, double.MaxValue);
}
writer.EndColumnDefinitions();
var series = new ChartDataSeries()
{
Name = "Portfolio"
};
IList <ChartDataValue> data = series.Values;
if (account == null)
{
if (this.selectedGroup != null)
{
WriteSummary(writer, data, TaxStatus.Taxable, null, null, false);
}
else
{
WriteSummary(writer, data, TaxStatus.TaxFree, "Tax Free ", new Predicate <Account>((a) => { return(!a.IsClosed && a.IsTaxFree && IsInvestmentAccount(a)); }), true);
WriteSummary(writer, data, TaxStatus.TaxDeferred, "Tax Deferred ", new Predicate <Account>((a) => { return(!a.IsClosed && a.IsTaxDeferred && IsInvestmentAccount(a)); }), true);
WriteSummary(writer, data, TaxStatus.Taxable, "Taxable ", new Predicate <Account>((a) => { return(!a.IsClosed && !a.IsTaxDeferred && !a.IsTaxFree && IsInvestmentAccount(a)); }), true);
}
}
else
{
WriteSummary(writer, data, account.TaxStatus, "", new Predicate <Account>((a) => { return(a == account); }), false);
}
WriteHeaderRow(writer, "Total", totalMarketValue.ToString("C"), totalGainLoss.ToString("C"));
writer.EndTable();
writer.EndCell();
// pie chart
AnimatingPieChart chart = new AnimatingPieChart();
chart.Width = 400;
chart.Height = 300;
chart.BorderThickness = new Thickness(0);
chart.Padding = new Thickness(0);
chart.Margin = new Thickness(0, 00, 0, 0);
chart.VerticalAlignment = VerticalAlignment.Top;
chart.HorizontalAlignment = HorizontalAlignment.Left;
chart.Series = series;
chart.ToolTipGenerator = OnGenerateToolTip;
chart.PieSliceClicked += OnPieSliceClicked;
writer.StartCell();
writer.WriteElement(chart);
writer.EndCell();
// end the outer table.
writer.EndTable();
totalMarketValue = 0;
totalGainLoss = 0;
if (this.selectedGroup != null)
{
WriteDetails(writer, "", this.selectedGroup);
}
else
{
List <SecuritySale> errors = new List <SecuritySale>(calc.GetPendingSales(new Predicate <Account>((a) => { return(a == account); })));
if (errors.Count > 0)
{
writer.WriteSubHeading("Pending Sales");
foreach (var sp in errors)
{
writer.WriteParagraph(string.Format("Pending sale of {1} units of '{2}' from account '{0}' recorded on {3}", sp.Account.Name, sp.UnitsSold, sp.Security.Name, sp.DateSold.ToShortDateString()));
}
}
if (account == null)
{
WriteDetails(writer, "Tax Free ", new Predicate <Account>((a) => { return(!a.IsClosed && a.IsTaxFree && IsInvestmentAccount(a)); }));
WriteDetails(writer, "Tax Deferred ", new Predicate <Account>((a) => { return(!a.IsClosed && a.IsTaxDeferred && IsInvestmentAccount(a)); }));
WriteDetails(writer, "Taxable ", new Predicate <Account>((a) => { return(!a.IsClosed && !a.IsTaxFree && !a.IsTaxDeferred && IsInvestmentAccount(a)); }));
}
else
{
WriteDetails(writer, "", new Predicate <Account>((a) => { return(a == account); }));
}
}
}
public override void Generate(IReportWriter writer)
{
writer.WriteHeading("Budget Report");
this.rows = new Dictionary <string, BudgetRow>();
this.columns = new Dictionary <DateTime, BudgetColumn>();
foreach (Category rc in money.Categories.GetRootCategories())
{
if (rc.Type != CategoryType.Expense)
{
continue;
}
string rowHeader = rc.Name;
this.CategoryFilter = rc;
// Add column for the budget itself.
BudgetColumn budgetColumn;
if (!columns.TryGetValue(DateTime.MinValue, out budgetColumn))
{
budgetColumn = new BudgetColumn()
{
Name = BudgetColumnHeader,
};
columns[DateTime.MinValue] = budgetColumn;
}
budgetColumn.Total += rc.Budget;
foreach (BudgetData b in this.Compute())
{
BudgetRow row = null;
if (!rows.TryGetValue(rowHeader, out row))
{
row = new BudgetRow()
{
Name = rowHeader,
Budget = rc.Budget
};
rows[rowHeader] = row;
}
DateTime budgetDate = new DateTime(b.BudgetDate.Year, b.BudgetDate.Month, 1);
row.Actuals.Add((decimal)b.Actual);
row.Headers.Add(b.Name);
// Add column for this BudgetData
BudgetColumn col;
if (!columns.TryGetValue(budgetDate, out col))
{
col = new BudgetColumn()
{
Date = budgetDate,
Name = b.Name
};
columns[budgetDate] = col;
}
col.Total += (decimal)b.Actual;
}
}
writer.StartTable();
writer.StartColumnDefinitions();
writer.WriteColumnDefinition("300", 300, 300); // category names
foreach (var pair in from p in columns orderby p.Key select p)
{
writer.WriteColumnDefinition("Auto", 100, double.MaxValue); // decimal values.
}
writer.WriteColumnDefinition("Auto", 100, double.MaxValue); // total.
writer.EndColumnDefinitions();
// write table headers
List <string> master = new List <string>();
writer.StartHeaderRow();
writer.StartCell();
writer.EndCell();
foreach (var pair in from p in columns orderby p.Key select p)
{
BudgetColumn c = pair.Value;
string name = c.Name;
if (name != BudgetColumnHeader)
{
master.Add(name); // list of all columns we have found (not including "Budget" column)
}
writer.StartCell();
writer.WriteNumber(name);
writer.EndCell();
}
writer.StartCell();
writer.WriteNumber("Balance");
writer.EndCell();
writer.EndRow();
Brush overBudgetBrush = Brushes.Red;
decimal totalBalance = 0;
// Now write out the rows.
foreach (BudgetRow row in from r in rows.Values orderby r.Name select r)
{
writer.StartRow();
writer.StartCell();
writer.WriteParagraph(row.Name);
writer.EndCell();
writer.StartCell();
decimal budget = row.Budget;
writer.WriteNumber(budget.ToString("C"));
writer.EndCell();
decimal balance = 0;
foreach (string col in master)
{
writer.StartCell();
int i = row.Headers.IndexOf(col);
if (i >= 0)
{
decimal actual = row.Actuals[i];
writer.WriteNumber(actual.ToString("C"), FontStyles.Normal, FontWeights.Normal,
actual > budget ? overBudgetBrush : null);
balance += (row.Budget - actual);
}
writer.EndCell();
}
totalBalance += balance;
writer.StartCell();
writer.WriteNumber(balance.ToString("C"));
writer.EndCell();
writer.EndRow();
}
// Now write out the totals.
writer.StartHeaderRow();
writer.StartCell();
writer.EndCell();
foreach (var pair in from p in columns orderby p.Key select p)
{
BudgetColumn c = pair.Value;
writer.StartCell();
writer.WriteNumber(c.Total.ToString("C"));
writer.EndCell();
}
writer.StartCell();
writer.WriteNumber(totalBalance.ToString("C"));
writer.EndCell();
writer.EndRow();
writer.EndTable();
writer.WriteParagraph("Generated on " + DateTime.Today.ToLongDateString(), System.Windows.FontStyles.Italic, System.Windows.FontWeights.Normal, System.Windows.Media.Brushes.Gray);
}
public void Generate(IReportWriter writer)
{
flowwriter = writer as FlowDocumentReportWriter;
calc = new CostBasisCalculator(this.myMoney, this.reportDate);
string heading = "Investment Portfolio Summary";
if (this.account != null)
{
heading += " for " + account.Name + " (" + account.AccountId + ")";
}
writer.WriteHeading(heading);
if (reportDate.Date != DateTime.Today)
{
writer.WriteSubHeading("As of " + reportDate.Date.AddDays(-1).ToLongDateString());
}
totalMarketValue = 0;
totalGainLoss = 0;
// outer table contains 2 columns, left is the summary table, right is the pie chart.
writer.StartTable();
writer.StartColumnDefinitions();
writer.WriteColumnDefinition("Auto", 100, double.MaxValue);
writer.WriteColumnDefinition("Auto", 100, double.MaxValue);
writer.EndColumnDefinitions();
writer.StartRow();
writer.StartCell();
writer.StartTable();
writer.StartColumnDefinitions();
foreach (double minWidth in new double[] { 300, 100, 100 })
{
writer.WriteColumnDefinition("Auto", minWidth, double.MaxValue);
}
writer.EndColumnDefinitions();
writer.StartHeaderRow();
writer.StartCell();
writer.WriteParagraph("Security Type");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Market Value");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Gain/Loss");
writer.EndCell();
writer.EndRow();
List <SecurityPieData> data = new List <SecurityPieData>();
decimal cash = this.myMoney.GetInvestmentCashBalance(account);
if (cash > 0)
{
writer.StartRow();
writer.StartCell();
writer.WriteParagraph("Cash");
writer.EndCell();
writer.StartCell();
writer.WriteNumber(cash.ToString("C"));
writer.EndCell();
writer.EndRow();
data.Add(new SecurityPieData()
{
Total = RoundToNearestCent(cash),
Name = "Cash"
});
}
totalMarketValue += cash;
if (account == null)
{
WriteSummary(writer, data, "Tax Deferred ", new Predicate <Account>((a) => { return(a.IsTaxDeferred); }));
WriteSummary(writer, data, "", new Predicate <Account>((a) => { return(!a.IsTaxDeferred); }));
}
else
{
WriteSummary(writer, data, "", new Predicate <Account>((a) => { return(a == account); }));
}
writer.StartHeaderRow();
writer.StartCell();
writer.WriteParagraph("Total");
writer.EndCell();
writer.StartCell();
writer.WriteNumber(totalMarketValue.ToString("C"));
writer.EndCell();
writer.StartCell();
writer.WriteNumber(totalGainLoss.ToString("C"));
writer.EndCell();
writer.EndRow();
writer.EndTable();
writer.EndCell();
// pie chart
Chart chart = new Chart();
chart.MinWidth = 400;
chart.MinHeight = 300;
chart.BorderThickness = new Thickness(0);
chart.Padding = new Thickness(0);
chart.Margin = new Thickness(0, 00, 0, 0);
chart.VerticalAlignment = VerticalAlignment.Top;
chart.HorizontalAlignment = HorizontalAlignment.Left;
PieSeries series = new PieSeries();
series.IndependentValueBinding = new Binding("Name");
series.DependentValueBinding = new Binding("Total");
chart.Series.Add(series);
series.ItemsSource = data;
writer.StartCell();
writer.WriteElement(chart);
writer.EndCell();
// end the outer table.
writer.EndTable();
totalMarketValue = 0;
totalGainLoss = 0;
List <SecuritySale> errors = new List <SecuritySale>(calc.GetPendingSales(new Predicate <Account>((a) => { return(a == account); })));
if (errors.Count > 0)
{
writer.WriteSubHeading("Pending Sales");
foreach (var sp in errors)
{
writer.WriteParagraph(string.Format("Pending sale of {1} units of '{2}' from account '{0}' recorded on {3}", sp.Account.Name, sp.UnitsSold, sp.Security.Name, sp.DateSold.ToShortDateString()));
}
}
if (account == null)
{
WriteDetails(writer, "Tax Deferred ", new Predicate <Account>((a) => { return(a.IsTaxDeferred); }));
WriteDetails(writer, "", new Predicate <Account>((a) => { return(!a.IsTaxDeferred); }));
}
else
{
WriteDetails(writer, "", new Predicate <Account>((a) => { return(a == account); }));
}
}
private void GenerateCategories(IReportWriter writer)
{
TaxCategoryCollection taxCategories = new TaxCategoryCollection();
List <TaxCategory> list = taxCategories.GenerateGroups(money, this.startDate, this.endDate);
if (list == null)
{
writer.WriteParagraph("You have not associated any categories with tax categories.");
writer.WriteParagraph("Please use the Category Properties dialog to associate tax categories then try again.");
return;
}
writer.WriteHeading("Tax Categories");
writer.StartTable();
writer.StartColumnDefinitions();
writer.WriteColumnDefinition("auto", 100, double.MaxValue);
writer.WriteColumnDefinition("auto", 100, double.MaxValue);
writer.WriteColumnDefinition("auto", 100, double.MaxValue);
writer.EndColumnDefinitions();
writer.StartHeaderRow();
writer.StartCell();
writer.WriteParagraph("Category");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Amount");
writer.EndCell();
writer.StartCell();
writer.WriteNumber("Tax Excempt");
writer.EndCell();
writer.EndRow();
decimal tax = GetSalesTax();
writer.StartRow();
writer.StartCell();
writer.WriteParagraph("Sales Tax");
writer.EndCell();
writer.StartCell();
writer.WriteNumber(tax.ToString("C"), FontStyles.Normal, FontWeights.Bold, null);
writer.EndCell();
writer.EndRow();
foreach (TaxCategory tc in list)
{
writer.StartHeaderRow();
writer.StartCell();
writer.WriteParagraph(tc.Name);
writer.EndCell();
writer.StartCell();
writer.EndCell();
writer.EndRow();
decimal sum = 0;
IDictionary <string, List <Transaction> > groups = tc.Groups;
foreach (KeyValuePair <string, List <Transaction> > subtotal in groups)
{
writer.StartRow();
writer.StartCell();
writer.WriteParagraph(subtotal.Key);
writer.EndCell();
decimal value = 0;
decimal taxExempt = 0;
foreach (Transaction t in subtotal.Value)
{
var amount = t.Amount;
if (t.Investment != null && t.Investment.Security != null && t.Investment.Security.Taxable == YesNo.No)
{
taxExempt += amount;
}
else
{
value += amount;
}
}
if (tc.DefaultSign < 0)
{
value = value * -1;
}
writer.StartCell();
writer.WriteNumber(value.ToString("C"));
writer.EndCell();
writer.StartCell();
if (taxExempt > 0)
{
writer.WriteNumber(taxExempt.ToString("C"));
}
writer.EndCell();
writer.EndRow();
sum += value;
}
writer.StartRow();
writer.StartCell();
writer.EndCell();
writer.StartCell();
writer.WriteNumber(sum.ToString("C"), FontStyles.Normal, FontWeights.Bold, null);
writer.EndCell();
writer.EndRow();
}
writer.EndTable();
}
bool GenerateForm(TaxForm form, IReportWriter writer, ICollection <Transaction> transactions)
{
var byCategory = new Dictionary <Category, decimal>();
// could be one to many mapping.
Dictionary <TaxCategory, List <Category> > map = new Dictionary <TaxCategory, List <Category> >();
// find our matching category
foreach (TaxCategory tc in form.Categories)
{
foreach (Category c in this.myMoney.Categories.GetCategories())
{
if (c.TaxRefNum == tc.RefNum)
{
byCategory[c] = 0M;
List <Category> list = null;
if (!map.TryGetValue(tc, out list))
{
list = new List <Category>();
map[tc] = list;
}
list.Add(c);
}
}
}
bool found = false;
// summarize the year.
foreach (Transaction t in transactions)
{
if (t.Transfer != null || t.IsDeleted || t.Status == TransactionStatus.Void)
{
continue;
}
bool include = t.Date >= this.startDate && t.Date < this.endDate;
var extra = myMoney.TransactionExtras.FindByTransaction(t.Id);
if (extra != null && extra.TaxYear != -1)
{
var taxYearStartDate = new DateTime(extra.TaxYear, fiscalYearStart + 1, 1);
if (fiscalYearStart > 0)
{
// Note: "FY2020" means July 2019 to July 2020, in other words
// it is the end date that represents the year.
taxYearStartDate = taxYearStartDate.AddYears(-1);
}
var taxYearEndDate = taxYearStartDate.AddYears(1);
include = taxYearStartDate >= this.startDate && taxYearEndDate <= this.endDate;
}
if (include)
{
found |= Summarize(byCategory, t);
}
}
if (!found)
{
return(false);
}
writer.WriteHeading("Form " + form.Name);
writer.StartTable();
writer.StartColumnDefinitions();
writer.WriteColumnDefinition("20", 20, 20); // expander column
writer.WriteColumnDefinition("300", 300, 300); // row category name
writer.WriteColumnDefinition("100", 100, 00); // row value
writer.EndColumnDefinitions();
foreach (TaxCategory tc in form.Categories)
{
List <Category> list = null;
if (map.TryGetValue(tc, out list))
{
if (list.Count > 1)
{
decimal total = 0;
foreach (Category c in list)
{
total += byCategory[c];
}
if (total != 0)
{
writer.StartExpandableRowGroup();
// header row for the total.
writer.StartRow();
writer.StartCell();
writer.WriteParagraph(tc.Name);
writer.EndCell();
writer.StartCell();
writer.WriteNumber(total.ToString("N0"));
writer.EndCell();
writer.EndRow();
foreach (Category c in list)
{
decimal v = byCategory[c];
if (v != 0)
{
writer.StartRow();
writer.StartCell();
writer.WriteParagraph(" " + c.GetFullName());
writer.EndCell();
writer.StartCell();
writer.WriteNumber(v.ToString("N0"));
AddHyperlink(c, writer);
writer.EndCell();
writer.EndRow();
}
}
writer.EndExpandableRowGroup();
}
}
else if (list.Count == 1)
{
Category c = list[0];
decimal v = byCategory[c];
if (v != 0)
{
writer.StartRow();
writer.StartCell(); // null expander
writer.EndCell();
writer.StartCell();
writer.WriteParagraph(tc.Name);
writer.EndCell();
writer.StartCell();
writer.WriteNumber(v.ToString("N0"));
AddHyperlink(c, writer);
writer.EndCell();
writer.EndRow();
}
}
}
}
writer.EndTable();
return(true);
}
public void Generate(IReportWriter writer)
{
writer.WriteHeading("Net Worth Statement");
var series = new ChartDataSeries()
{
Name = "Net Worth"
};
IList <ChartDataValue> data = series.Values;
// outer table contains 2 columns, left is the summary table, right is the pie chart.
writer.StartTable();
writer.StartColumnDefinitions();
writer.WriteColumnDefinition("450", 450, 450);
writer.WriteColumnDefinition("620", 620, 620);
writer.EndColumnDefinitions();
writer.StartRow();
writer.StartCell();
// inner table contains the "data"
writer.StartTable();
writer.StartColumnDefinitions();
writer.WriteColumnDefinition("30", 30, 30);
writer.WriteColumnDefinition("300", 300, 300);
writer.WriteColumnDefinition("Auto", 100, double.MaxValue);
writer.EndColumnDefinitions();
WriteHeader(writer, "Cash");
decimal totalBalance = 0;
decimal balance = 0;
bool hasTaxDeferred = false;
bool hasTaxFree = false;
Transactions transactions = myMoney.Transactions;
foreach (Account a in this.myMoney.Accounts.GetAccounts(true))
{
if (a.IsTaxDeferred)
{
hasTaxDeferred = true;
}
if (a.IsTaxFree)
{
hasTaxFree = true;
}
if (a.Type == AccountType.Credit ||
a.Type == AccountType.Asset ||
a.Type == AccountType.Brokerage ||
a.Type == AccountType.Retirement ||
a.Type == AccountType.CategoryFund ||
a.Type == AccountType.Loan)
{
continue;
}
balance += a.BalanceNormalized;
}
// Non-investment Cash
var color = GetRandomColor();
if (balance > 0)
{
data.Add(new ChartDataValue()
{
Label = "Cash", Value = (double)balance, Color = color
});
}
WriteRow(writer, color, "Cash", balance);
totalBalance += balance;
// Investment Cash
balance = this.myMoney.GetInvestmentCashBalanceNormalized(new Predicate <Account>((a) => { return(!a.IsClosed && IsInvestmentAccount(a)); }));
color = GetRandomColor();
data.Add(new ChartDataValue()
{
Label = "Investment Cash", Value = (double)balance, Color = color
});
WriteRow(writer, color, "Investment Cash", balance);
totalBalance += balance;
bool hasNoneTypeTaxDeferred = false;
if (hasTaxDeferred)
{
WriteHeader(writer, "Tax Deferred Assets");
totalBalance += WriteSecurities(writer, data, "Tax Deferred ", new Predicate <Account>((a) => { return(a.IsTaxDeferred); }), out hasNoneTypeTaxDeferred);
}
bool hasNoneTypeTaxFree = false;
if (hasTaxFree)
{
WriteHeader(writer, "Tax Free Assets");
totalBalance += WriteSecurities(writer, data, "Tax Free ", new Predicate <Account>((a) => { return(a.IsTaxFree); }), out hasNoneTypeTaxFree);
}
balance = 0;
WriteHeader(writer, "Other Assets");
foreach (Account a in this.myMoney.Accounts.GetAccounts(true))
{
if ((a.Type == AccountType.Loan || a.Type == AccountType.Asset) && a.Balance > 0) // then this is a loan out to someone else...
{
color = GetRandomColor();
if (a.BalanceNormalized > 0)
{
data.Add(new ChartDataValue()
{
Label = a.Name, Value = (double)a.BalanceNormalized, Color = color
});
}
WriteRow(writer, color, a.Name, a.BalanceNormalized);
totalBalance += a.BalanceNormalized;
}
}
bool hasNoneType = false;
totalBalance += WriteSecurities(writer, data, "", new Predicate <Account>((a) => { return(IsInvestmentAccount(a) && !a.IsTaxDeferred && !a.IsTaxFree); }), out hasNoneType);
balance = 0;
WriteHeader(writer, "Liabilities");
foreach (Account a in this.myMoney.Accounts.GetAccounts(true))
{
if (a.Type != AccountType.Credit)
{
continue;
}
balance += a.BalanceNormalized;
}
totalBalance += balance;
color = GetRandomColor();
if (balance > 0)
{
data.Add(new ChartDataValue()
{
Label = "Credit", Value = (double)balance, Color = color
});
}
WriteRow(writer, color, "Credit", balance);
balance = 0;
foreach (Account a in this.myMoney.Accounts.GetAccounts(true))
{
if (a.Type == AccountType.Loan && a.BalanceNormalized < 0)
{
balance += a.BalanceNormalized;
color = GetRandomColor();
if (a.BalanceNormalized > 0)
{
data.Add(new ChartDataValue()
{
Label = a.Name, Value = (double)a.BalanceNormalized, Color = color
});
}
WriteRow(writer, color, a.Name, a.BalanceNormalized);
}
}
totalBalance += balance;
writer.StartFooterRow();
writer.StartCell(1, 2);
writer.WriteParagraph("Total");
writer.EndCell();
writer.StartCell();
writer.WriteNumber(totalBalance.ToString("C"));
writer.EndCell();
writer.EndRow();
writer.EndTable();
writer.EndCell();
writer.StartCell();
// pie chart
AnimatingPieChart chart = new AnimatingPieChart();
chart.Width = 600;
chart.Height = 400;
chart.BorderThickness = new Thickness(0);
chart.VerticalAlignment = VerticalAlignment.Top;
chart.Series = series;
chart.ToolTipGenerator = OnGenerateToolTip;
chart.PieSliceClicked += OnPieSliceClicked;
writer.WriteElement(chart);
writer.EndCell();
writer.EndRow();
writer.EndTable();
if (hasNoneTypeTaxDeferred || hasNoneTypeTaxFree || hasNoneType)
{
writer.WriteParagraph("(*) One ore more of your securities has no SecurityType, you can fix this using View/Securities",
System.Windows.FontStyles.Italic, System.Windows.FontWeights.Normal, System.Windows.Media.Brushes.Maroon);
}
writer.WriteParagraph("Generated on " + DateTime.Today.ToLongDateString(), System.Windows.FontStyles.Italic, System.Windows.FontWeights.Normal, System.Windows.Media.Brushes.Gray);
}