private void loadRehabInfo()
{
chosenID = clsLoan.LoanID(propertyMenu.TitleOfSelectedItem);
clsLoan l = new clsLoan(chosenID);
if ((l.Status() == clsLoan.State.PendingSale) || (l.Status() == clsLoan.State.Sold))
{
this.LoanStatusTextField.TextColor = NSColor.Red;
this.LoanStatusTextField.StringValue = l.Status().ToString().ToUpper();
if (l.Status() == clsLoan.State.PendingSale)
{
this.LoanStatusTextField.StringValue += " *** CHECK PAYOFF LETTER";
}
}
else
{
this.LoanStatusTextField.TextColor = NSColor.Black;
this.LoanStatusTextField.StringValue = l.Status().ToString();
}
rehabDrawDisplayTrue.StringValue = "Payed draws:" + "\n";
rehabDrawDisplayFalse.StringValue = "Not payed draws:" + "\n";
// Repopulate Cashflow ID Pop Up
this.CashflowIDPopUp.RemoveAllItems();
this.CashflowIDPopUp.AddItem("Select Cashflow");
double trueTotal = 0;
double falseTotal = 0;
foreach (clsCashflow cashFlow in l.Cashflows())
{
if (cashFlow.TypeID() == clsCashflow.Type.RehabDraw && cashFlow.DeleteDate() > System.DateTime.Today)
{
if (cashFlow.Actual() == true)
{
trueTotal += cashFlow.Amount();
rehabDrawDisplayTrue.StringValue += "Date: " + cashFlow.PayDate().ToString("MM/dd/yyyy hh:mm") + ", ";
rehabDrawDisplayTrue.StringValue += "Amount: " + "$" + (-cashFlow.Amount()).ToString("00,000.00") + ", ";
rehabDrawDisplayTrue.StringValue += "Payed: " + cashFlow.Actual() + "\n";
}
else
{
falseTotal += cashFlow.Amount();
rehabDrawDisplayFalse.StringValue += "Date: " + cashFlow.PayDate().ToString("MM/dd/yyyy hh:mm") + ", ";
rehabDrawDisplayFalse.StringValue += "Amount: " + "$" + (-cashFlow.Amount()).ToString("00,000.00") + ", ";
rehabDrawDisplayFalse.StringValue += "Payed: " + cashFlow.Actual() + ", ";
rehabDrawDisplayFalse.StringValue += "Cashflow ID: " + cashFlow.ID() + "\n";
this.CashflowIDPopUp.AddItem(cashFlow.ID().ToString());
}
}
}
//After each cashflows are filtered, display the total
trueTotal = -trueTotal;
falseTotal = -falseTotal;
rehabDrawDisplayTrue.StringValue += "Total amount: " + "$" + trueTotal.ToString("00,000.00");
rehabDrawDisplayFalse.StringValue += "Total amount: " + "$" + falseTotal.ToString("00,000.00");
}
private void WriteLoanAuditHTML(int loanID, DateTime dtStart, DateTime dtEnd, System.IO.StreamWriter sw, List <double> totals, string rowIDName)
{
clsEntity titleHolder;
clsEntity coBorrower;
int totalsIndex = 0;
double value;
clsLoan loanStart = new clsLoan(loanID).LoanAsOf(dtStart);
clsLoan loanEnd = new clsLoan(loanID).LoanAsOf(dtEnd);
titleHolder = new clsEntity(loanEnd.TitleHolderID());
coBorrower = new clsEntity(loanEnd.CoBorrowerID());
if ((loanEnd.Status() != clsLoan.State.Cancelled) && (loanStart.Status() != clsLoan.State.Sold))
{
sw.WriteLine("<tr ID=" + rowIDName + ">");
sw.Write("<td align=\"left\">" + loanEnd.Property().Address() + "</td>");
// write values
value = loanStart.Balance(dtStart);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
value = loanEnd.Balance(dtEnd) - loanStart.Balance(dtStart) + loanEnd.PrincipalPaid(dtEnd);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
value = loanEnd.PrincipalPaid(dtEnd);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
value = loanEnd.Balance(dtEnd);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
value = loanEnd.AccruedInterest(dtEnd);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
value = loanEnd.InterestPaid(dtEnd);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
value = loanEnd.Rate();
sw.Write("<td align=\"right\">" + value.ToString("0.00%") + "</td>");
sw.Write("<td>" + titleHolder.Name() + "</td>");
sw.Write("<td>" + coBorrower.Name() + "</td>");
sw.WriteLine();
sw.WriteLine("</tr>");
sw.Flush();
}
}
private void WriteLoanAudit(int loanID, DateTime dtStart, DateTime dtEnd, System.IO.StreamWriter streamWriter)
{
clsLoan loanEnd = new clsLoan(loanID).LoanAsOf(dtEnd);
clsLoan loanStart = new clsLoan(loanID).LoanAsOf(dtStart);
if ((loanEnd.Status() != clsLoan.State.Cancelled) && (loanStart.Status() != clsLoan.State.Sold))
{
streamWriter.Write(loanEnd.Property().Address() + ",");
streamWriter.Write(loanStart.Balance(dtStart).ToString() + ",");
double dAdditions = loanEnd.Balance(dtEnd) - loanStart.Balance(dtStart) + loanEnd.PrincipalPaid(dtEnd);
streamWriter.Write(dAdditions.ToString() + ",");
streamWriter.Write(loanEnd.PrincipalPaid(dtEnd).ToString() + ",");
streamWriter.Write(loanEnd.Balance(dtEnd).ToString() + ",");
streamWriter.Write(loanEnd.AccruedInterest(dtEnd).ToString() + ",");
streamWriter.WriteLine(loanEnd.InterestPaid(dtEnd).ToString());
streamWriter.Flush();
}
}
private void WriteLoanStatusHTML(int loanID, DateTime dtAsOf, System.IO.StreamWriter sw, List <double> totals, string rowIDName)
{
clsEntity titleHolder;
clsEntity coBorrower;
clsEntity titleCompany;
int totalsIndex = 0;
double value;
clsLoan loan = new clsLoan(loanID).LoanAsOf(dtAsOf);
titleHolder = new clsEntity(loan.TitleHolderID());
titleCompany = new clsEntity(loan.TitleCompanyID());
coBorrower = new clsEntity(loan.CoBorrowerID());
clsLoan.State eStatus = loan.Status();
sw.WriteLine("<tr ID=" + rowIDName + ">");
sw.Write("<td align=\"left\">" + loan.Property().Address() + "</td>");
if (eStatus.ToString().Length > 10)
{
sw.Write("<td align=\"left\">" + eStatus.ToString().ToUpper().Substring(0, 10) + "</td>");
}
else
{
sw.Write("<td align=\"left\">" + eStatus.ToString().ToUpper() + "</td>");
}
if (eStatus == clsLoan.State.Cancelled)
{
for (int i = 0; i < 16; i++)
{
sw.Write("<td></td>");
totalsIndex++;
}
}
else
{
if (loan.Status() == clsLoan.State.Sold)
{
for (int i = 0; i < 3; i++)
{
sw.Write("<td></td>");
totalsIndex++;
}
if (loan.AccruedAdditionalInterest(dtAsOf) > 0D)
{
value = loan.AccruedAdditionalInterest(dtAsOf);
totals[totalsIndex] += value;
sw.Write("<td align=\"right\">" + value + "</td>");
}
for (int i = 0; i < 3; i++)
{
sw.Write("<td></td>");
totalsIndex++;
}
value = loan.PrincipalPaid(dtAsOf);
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
totals[totalsIndex] += value;
totalsIndex++;
value = loan.InterestPaid(dtAsOf);
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
totals[totalsIndex] += value;
totalsIndex++;
value = loan.PointsPaid(dtAsOf);
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
totals[totalsIndex] += value;
totalsIndex++;
value = loan.AdditionalInterestPaid(dtAsOf);
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
totals[totalsIndex] += value;
totalsIndex++;
value = loan.Return(false);
sw.Write("<td align=\"right\">" + value.ToString("#0.00%") + "</td>");
totals[totalsIndex] += value;
totalsIndex++;
value = loan.IRR(false);
sw.Write("<td align=\"right\">" + value.ToString("#0.00%") + "</td>");
totals[totalsIndex] += value;
totalsIndex++;
}
else if (loan.Status() == clsLoan.State.PartiallySold)
{
value = loan.Balance(dtAsOf);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
value = loan.AccruedInterest(dtAsOf);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
value = loan.ProjectedHardInterest();
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
value = loan.AccruedAdditionalInterest(dtAsOf);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value + "</td>");
value = loan.Return(false);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#0.00%") + "</td>");
value = loan.IRR(false);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#0.00%") + "</td>");
value = loan.PrincipalPaid(dtAsOf);
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
totals[totalsIndex] += value;
totalsIndex++;
value = loan.InterestPaid(dtAsOf);
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
totals[totalsIndex] += value;
totalsIndex++;
value = loan.PointsPaid(dtAsOf);
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
totals[totalsIndex] += value;
totalsIndex++;
value = loan.AdditionalInterestPaid(dtAsOf);
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
totals[totalsIndex] += value;
totalsIndex++;
value = loan.Return(false);
sw.Write("<td align=\"right\">" + value.ToString("#0.00%") + "</td>");
totals[totalsIndex] += value;
totalsIndex++;
value = loan.IRR(false);
sw.Write("<td align=\"right\">" + value.ToString("#0.00%") + "</td>");
totals[totalsIndex] += value;
totalsIndex++;
}
else
{
value = loan.Balance(dtAsOf);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
value = loan.AccruedInterest(dtAsOf);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
value = loan.ProjectedHardInterest();
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
value = loan.ProjectedAdditionalInterest(dtAsOf);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
value = loan.Return(false);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#0.00%") + "</td>");
value = loan.IRR(false);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#0.00%") + "</td>");
for (int i = 0; i < 2; i++)
{
sw.Write("<td></td>");
totalsIndex++;
}
value = loan.PointsPaid(dtAsOf);
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
totals[totalsIndex] += value;
totalsIndex++;
for (int i = 0; i < 3; i++)
{
sw.Write("<td></td>");
totalsIndex++;
}
}
value = loan.RehabRemain(dtAsOf);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
value = loan.RehabSpent(dtAsOf);
totals[totalsIndex] += value;
totalsIndex++;
sw.Write("<td align=\"right\">" + value.ToString("#,##0.00") + "</td>");
sw.Write("<td align=\"right\">" + loan.SaleDate().ToShortDateString() + "</td>");
sw.Write("<td align=\"right\">" + loan.OriginationDate().ToShortDateString() + "</td>");
sw.Write("<td align=\"right\">" + (loan.SaleDate() - loan.OriginationDate()).TotalDays.ToString() + "</td>");
}
sw.Write("<td>" + titleHolder.Name() + "</td>");
sw.Write("<td>" + coBorrower.Name() + "</td>");
sw.Write("<td>" + titleCompany.Name() + "</td>");
sw.Write("<td>" + loan.Rate().ToString("#0.00%") + "</td>");
sw.Write("<td>" + loan.PenaltyRate().ToString("#0.00%") + "</td>");
sw.Write("<td>" + (loan.Points() * 0.01).ToString("#0.00%") + "</td>");
sw.Write("<td>" + loan.ProfitSplit().ToString("#0.00%") + "</td>");
sw.Write("<td>" + loan.OriginationDate().ToShortDateString() + "</td>");
sw.Write("<td>" + loan.MaturityDate().ToShortDateString() + "</td>");
sw.Write("<td>" + loan.GrossReturn(false).ToString("#0.00%") + "</td>");
sw.Write("<td>" + loan.GrossReturn(true).ToString("#0.00%") + "</td>");
sw.Write("<td>" + loan.Return(true).ToString("#0.00%") + "</td>");
sw.Write("<td>" + loan.IRR(true).ToString("#0.00%") + "</td>");
sw.Write("<td>" + loan.FirstRehabEstimate().ToString("#,##0.00") + "</td>");
sw.WriteLine();
sw.WriteLine("</tr>");
sw.Flush();
}
private void WriteLoan(int loanID, DateTime dtAsOf, System.IO.StreamWriter sw)
{
clsEntity titleHolder;
clsEntity coBorrower;
clsEntity titleCompany;
clsLoan loan = new clsLoan(loanID).LoanAsOf(dtAsOf);
titleHolder = new clsEntity(loan.TitleHolderID());
titleCompany = new clsEntity(loan.TitleCompanyID());
coBorrower = new clsEntity(loan.CoBorrowerID());
clsLoan.State eStatus = loan.Status();
sw.Write(loan.Property().Address() + ",");
sw.Write(eStatus.ToString().ToUpper() + ",");
if (eStatus == clsLoan.State.Cancelled)
{
sw.Write(",,,,,,,,,,,,,,,,");
}
else
{
if (loan.Status() == clsLoan.State.Sold)
{
sw.Write(",,,");
if (loan.AccruedAdditionalInterest(dtAsOf) > 0D)
{
sw.Write(loan.AccruedAdditionalInterest(dtAsOf));
}
sw.Write(",,,");
sw.Write(loan.PrincipalPaid(dtAsOf).ToString() + ",");
sw.Write(loan.InterestPaid(dtAsOf).ToString() + ",");
sw.Write(loan.AdditionalInterestPaid(dtAsOf).ToString() + ",");
sw.Write(loan.Return(false).ToString() + ",");
sw.Write(loan.IRR(false).ToString() + ",");
}
else if (loan.Status() == clsLoan.State.PartiallySold)
{
sw.Write(loan.Balance(dtAsOf).ToString() + ",");
sw.Write(loan.AccruedInterest(dtAsOf).ToString() + ",");
sw.Write(loan.ProjectedHardInterest().ToString() + ",");
if (loan.AccruedAdditionalInterest(dtAsOf) > 0D)
{
sw.Write(loan.AccruedAdditionalInterest(dtAsOf));
}
sw.Write(",");
sw.Write(loan.Return(false).ToString() + ",");
sw.Write(loan.IRR(false).ToString() + ",");
sw.Write(loan.PrincipalPaid(dtAsOf).ToString() + ",");
sw.Write(loan.InterestPaid(dtAsOf).ToString() + ",");
sw.Write(loan.AdditionalInterestPaid(dtAsOf).ToString() + ",");
sw.Write(loan.Return(false).ToString() + ",");
sw.Write(loan.IRR(false).ToString() + ",");
}
else
{
sw.Write(loan.Balance(dtAsOf).ToString() + ",");
sw.Write(loan.AccruedInterest(dtAsOf).ToString() + ",");
sw.Write(loan.ProjectedHardInterest().ToString() + ",");
sw.Write(loan.ProjectedAdditionalInterest(dtAsOf).ToString() + ",");
sw.Write(loan.Return(false).ToString() + ",");
sw.Write(loan.IRR(false).ToString() + ",");
sw.Write(",,,,,");
}
sw.Write(loan.RehabRemain(dtAsOf).ToString() + ",");
sw.Write(loan.RehabSpent(dtAsOf).ToString() + ",");
sw.Write(loan.SaleDate().ToShortDateString() + ",");
sw.Write(loan.OriginationDate().ToShortDateString() + ",");
sw.Write((loan.SaleDate() - loan.OriginationDate()).TotalDays.ToString() + ",");
}
sw.Write(titleHolder.Name() + ",");
sw.Write(coBorrower.Name() + ",");
sw.Write(titleCompany.Name() + ",");
sw.Write(loan.Rate().ToString() + ",");
sw.Write(loan.PenaltyRate().ToString() + ",");
sw.Write(loan.OriginationDate().ToShortDateString() + ",");
sw.Write(loan.MaturityDate().ToShortDateString() + ",");
sw.Write(loan.GrossReturn(false).ToString() + ",");
sw.Write(loan.GrossReturn(true).ToString() + ",");
sw.Write(loan.Return(true).ToString() + ",");
sw.Write(loan.IRR(true).ToString() + ",");
sw.Write(loan.FirstRehabEstimate().ToString() + ",");
sw.WriteLine();
sw.Flush();
}
private void CalculateAggregates(DateTime startDate, DateTime endDate)
{
// Balances: Total made, less each quarters repayment, adding to Net Balance
double dTotalLent = 0D;
double dRepaidPeriod = 0D;
double dRepaidPreviously = 0D;
double dNetBalance = 0D;
double dTotalCommitted = 0D;
double dTotalRehabRemain = 0D;
double dSaleContracts = 0D;
double dSaleListings = 0D;
double dPendingAcq = 0D;
double dPartialBalance = 0D;
// Accrued: Total accrued FTD, less this period payments, less prior payments, (=accrued end of period),
// less accrued end of prev period, adding to net accrued this period
// (+) paid this period (+) additional interest paid this period (+) add'l accrued this period = Net Income Period
double dHardInterestPaidThisPeriod = 0D;
double dHardInterestPaidPreviously = 0D;
double dAccruedThisPeriod = 0D;
double dAdditionalInterestPaidThisPeriod = 0D;
double dAdditionalInterestAccruedThisPeriod = 0D;
double dAdditionalInterestAccruedPreviousPeriod = 0D;
double dPointsPaidThisPeriod = 0D;
double dAccruedFTD = 0D;
double dAccruedNetAtStartDate = 0D;
// Loan-by-loan:
// (+) Total Accrual FTD (+) interest paid this period (-) interest paid previous periods
// (+) Additional Paid this period (+) additional accrued this period (-) additional accrued last period
int iStateCount = Enum.GetNames(typeof(clsLoan.State)).Length;
int[,] iLoansByStatus = new int[iStateCount, 2];
int[] iUncancelledCount = new int[2];
for (int i = 0; i < iStateCount; i++)
{
iLoansByStatus[i, 0] = iLoansByStatus[i, 1] = 0;
}
// loop through loans
clsCSVTable tbl = new clsCSVTable(clsLoan.strLoanPath);
for (int i = 0; i < tbl.Length(); i++)
{
if (this.lenderLoanIDs.Contains(i))
{
clsLoan loan = new clsLoan(i);
clsLoan loanAsOfEndDate = loan.LoanAsOf(endDate);
if (loan.FindDate(clsCashflow.Type.AcquisitionPrice, true, false) <= endDate)
{
iLoansByStatus[(int)loan.LoanAsOf(startDate).Status(), 0]++;
iLoansByStatus[(int)loanAsOfEndDate.Status(), 1]++;
dTotalLent += loan.Balance(endDate) + loan.PrincipalPaid(endDate);
dTotalRehabRemain += loanAsOfEndDate.RehabRemain(endDate);
dRepaidPeriod += loan.PrincipalPaid(endDate) - loan.PrincipalPaid(startDate);
dRepaidPreviously += loan.PrincipalPaid(startDate);
dHardInterestPaidPreviously += loan.HardInterestPaid(startDate);
dHardInterestPaidThisPeriod += loan.HardInterestPaid(endDate) - loan.HardInterestPaid(startDate);
dPointsPaidThisPeriod += loan.PointsPaid(endDate) - loan.PointsPaid(startDate);
dAccruedThisPeriod += loan.AccruedInterest(endDate) - loan.AccruedInterest(startDate);
dAdditionalInterestPaidThisPeriod += loan.AdditionalInterestPaid(endDate) - loan.AdditionalInterestPaid(startDate);
dAdditionalInterestAccruedThisPeriod += loan.AccruedAdditionalInterest(endDate); // needs fixing
dAdditionalInterestAccruedPreviousPeriod += loan.AccruedAdditionalInterest(startDate); // needs fixing
dAccruedFTD += loan.AccruedInterest(endDate) + loan.HardInterestPaid(endDate);
dAccruedNetAtStartDate += loan.AccruedInterest(startDate);
if (loanAsOfEndDate.Status() == clsLoan.State.Listed)
{
dSaleListings += loan.Balance(endDate);
}
if (loanAsOfEndDate.Status() == clsLoan.State.PendingSale)
{
dSaleContracts += loan.Balance(endDate);
}
if (loanAsOfEndDate.Status() == clsLoan.State.PendingAcquisition)
{
dPendingAcq += loan.AcquisitionCost(false);
}
if (loanAsOfEndDate.Status() == clsLoan.State.PartiallySold)
{
dPartialBalance += loan.Balance(endDate);
}
}
}
}
dTotalCommitted = dTotalLent + dTotalRehabRemain + dPendingAcq;
dNetBalance = dTotalLent - dRepaidPeriod - dRepaidPreviously;
for (int i = 0; i < 2; i++)
{
iUncancelledCount[i] = iLoansByStatus[(int)clsLoan.State.Listed, i];
iUncancelledCount[i] += iLoansByStatus[(int)clsLoan.State.PendingAcquisition, i];
iUncancelledCount[i] += iLoansByStatus[(int)clsLoan.State.PendingSale, i];
iUncancelledCount[i] += iLoansByStatus[(int)clsLoan.State.Rehab, i];
iUncancelledCount[i] += iLoansByStatus[(int)clsLoan.State.Sold, i];
iUncancelledCount[i] += iLoansByStatus[(int)clsLoan.State.PartiallySold, i];
}
int iRepaidCount = iLoansByStatus[(int)clsLoan.State.Sold, 1] - iLoansByStatus[(int)clsLoan.State.Sold, 0];
int iOutstandingCount = iUncancelledCount[1] - iLoansByStatus[(int)clsLoan.State.Sold, 1];
// Display Results
this.ReportSummaryTextLabel.StringValue = "";
this.ReportSummaryTextLabel.StringValue += " Total Committed: \t" + dTotalCommitted.ToString("00,000,000.00");
this.ReportSummaryTextLabel.StringValue += "(" + iUncancelledCount[1].ToString("000") + ")" + "\t";
this.ReportSummaryTextLabel.StringValue += "\n Total Loan Given: \t" + dTotalLent.ToString("00,000,000.00");
this.ReportSummaryTextLabel.StringValue += "(" + (iUncancelledCount[1] - iLoansByStatus[(int)clsLoan.State.PendingAcquisition, 1]).ToString("000") + ")" + "\t";
this.ReportSummaryTextLabel.StringValue += "FTD Accrual: \t" + dAccruedFTD.ToString("000,000.00");
this.ReportSummaryTextLabel.StringValue += "\n Repaid Period: \t" + dRepaidPeriod.ToString("00,000,000.00");
this.ReportSummaryTextLabel.StringValue += "(" + iRepaidCount.ToString("000") + ")" + "\t";
this.ReportSummaryTextLabel.StringValue += "(-)Paid Period: \t" + dHardInterestPaidThisPeriod.ToString("000,000.00");
this.ReportSummaryTextLabel.StringValue += "\n Repaid Previously: \t" + dRepaidPreviously.ToString("00,000,000.00");
this.ReportSummaryTextLabel.StringValue += "(" + iLoansByStatus[(int)clsLoan.State.Sold, 0].ToString("000") + ")" + "\t";
this.ReportSummaryTextLabel.StringValue += "(-)Paid Prev: \t" + dHardInterestPaidPreviously.ToString("000,000.00");
this.ReportSummaryTextLabel.StringValue += "\n Loans Outstanding: \t" + dNetBalance.ToString("00,000,000.00");
this.ReportSummaryTextLabel.StringValue += "(" + iOutstandingCount.ToString("000") + ")" + "\t";
this.ReportSummaryTextLabel.StringValue += "Net Accrued: \t" + (dAccruedFTD - dHardInterestPaidThisPeriod - dHardInterestPaidPreviously).ToString("000,000.00");
this.ReportSummaryTextLabel.StringValue += "\n \t \t";
this.ReportSummaryTextLabel.StringValue += "(-)Start Accr: \t" + dAccruedNetAtStartDate.ToString("000,000.00");
this.ReportSummaryTextLabel.StringValue += "\n Sale Contracts \t" + dSaleContracts.ToString("00,000,000.00");
this.ReportSummaryTextLabel.StringValue += "(" + iLoansByStatus[(int)clsLoan.State.PendingSale, 1].ToString("000") + ")" + "\t";
this.ReportSummaryTextLabel.StringValue += "Period Accr: \t" + (dAccruedFTD - dHardInterestPaidThisPeriod - dHardInterestPaidPreviously - dAccruedNetAtStartDate).ToString("000,000.00");
this.ReportSummaryTextLabel.StringValue += "\n Sale Listings \t" + dSaleListings.ToString("00,000,000.00");
this.ReportSummaryTextLabel.StringValue += "(" + iLoansByStatus[(int)clsLoan.State.Listed, 1].ToString("000") + ")" + "\t";
this.ReportSummaryTextLabel.StringValue += " \t";
this.ReportSummaryTextLabel.StringValue += "(+) Addl Paid : \t" + dAdditionalInterestPaidThisPeriod.ToString("000,000.00");
this.ReportSummaryTextLabel.StringValue += "\n \t \t \t";
this.ReportSummaryTextLabel.StringValue += "(+) Addl Accrue: \t" + dAdditionalInterestAccruedThisPeriod.ToString("000,000.00");
this.ReportSummaryTextLabel.StringValue += "\n \t \t \t";
this.ReportSummaryTextLabel.StringValue += "(-) Prior Accru: \t" + dAdditionalInterestAccruedPreviousPeriod.ToString("000,000.00");
this.ReportSummaryTextLabel.StringValue += "\n \t \t";
this.ReportSummaryTextLabel.StringValue += "(+) Additional: \t" + (dAdditionalInterestPaidThisPeriod + dAdditionalInterestAccruedThisPeriod - dAdditionalInterestAccruedPreviousPeriod).ToString("000,000.00");
this.ReportSummaryTextLabel.StringValue += "\n \t \t";
this.ReportSummaryTextLabel.StringValue += "(+) Hard Paid : \t" + dHardInterestPaidThisPeriod.ToString("000,000.00");
this.ReportSummaryTextLabel.StringValue += "\n \t \t";
this.ReportSummaryTextLabel.StringValue += "(+) Points Paid :\t" + dPointsPaidThisPeriod.ToString("000,000.00");
this.ReportSummaryTextLabel.StringValue += "\n \t \t";
this.ReportSummaryTextLabel.StringValue += "Net Income Per: \t" + (dAccruedFTD - dHardInterestPaidPreviously - dAccruedNetAtStartDate + dAdditionalInterestPaidThisPeriod + dAdditionalInterestAccruedThisPeriod - dAdditionalInterestAccruedPreviousPeriod + dPointsPaidThisPeriod).ToString("000,000.00");
}
partial void RunReportPressed(NSButton sender)
{
// open file
string fileName = "/Volumes/GoogleDrive/Shared Drives/Resilience/Reports/DocumentStatus";
fileName += System.DateTime.Today.ToString("yyyyMMdd");
fileName += "." + this.LenderPopUpButton.TitleOfSelectedItem;
fileName += ".htm";
System.IO.StreamWriter sw = new System.IO.StreamWriter(fileName);
// write beginning tags and header
sw.WriteLine("<!DOCTYPE html><html>");
sw.WriteLine("<head>");
sw.WriteLine("<style>");
sw.WriteLine("th {text-decoration:underline;}");
sw.WriteLine("tr {background-color:WhiteSmoke;}");
sw.WriteLine("td#MUSTHAVE {background-color:Red;}");
sw.WriteLine("td#MIGHTHAVE {background-color:Orange;}");
sw.WriteLine("td#SHOULDHAVE {background-color:Yellow;}");
sw.WriteLine("td#TODO {background-color:Green;}");
sw.WriteLine("td#COMPLETE {background-color:White;}");
sw.WriteLine("tr#HEADER {background-color:White;}");
sw.WriteLine("</style>");
sw.WriteLine("</head>");
// html body
sw.WriteLine("<body>");
sw.WriteLine("<h1>Document Status Report " + System.DateTime.Today.ToString("MM/dd/yyyy") + "</h1>");
sw.WriteLine("<table style=\"width:auto\">");
WriteHTMLHeaderRow(sw);
// loop through loans
clsCSVTable tbl = new clsCSVTable(clsLoan.strLoanPath);
clsCSVTable tblDocuments = new clsCSVTable(clsDocument.strDocumentPath);
clsCSVTable tblDocumentRecords = new clsCSVTable(clsDocumentRecord.strDocumentRecordPath);
for (int i = 0; i < tbl.Length(); i++)
{
if (this.lenderLoanIDs.Contains(i))
{
// load document list
clsLoan loan = new clsLoan(i);
Dictionary <int, clsDocument> documentList = new Dictionary <int, clsDocument>();
List <int> documentListIDs = new List <int>();
documentListIDs = tblDocuments.Matches(clsDocument.PropertyColumn, loan.PropertyID().ToString());
// load document records
List <clsDocumentRecord> documentRecordList = new List <clsDocumentRecord>();
List <int> documentRecordIDs = new List <int>();
List <clsDocument.Type> documentTypes = new List <clsDocument.Type>();
foreach (int id in documentListIDs)
{
documentList.Add(id, new clsDocument(id));
foreach (int recID in tblDocumentRecords.Matches(clsDocumentRecord.DocumentColumn, id.ToString()))
{
documentRecordIDs.Add(recID);
documentRecordList.Add(new clsDocumentRecord(recID));
documentTypes.Add(documentList[id].DocumentType());
}
}
// write loan to report
this.WriteLoanHTML(loan.Property().Address(), loan.Status(), sw, documentRecordList, documentTypes);
}
}
// end of doc tags
this.WriteHTMLFooter(sw);
sw.WriteLine("</table></body></html>");
sw.Flush();
}