/// <summary>
/// Valuation
/// </summary>
/// <param name="record"></param>
/// <param name="parcel"></param>
private void Valuation(TaxAuthorityPaymentRecord record, ParcelInformation parcel)
{
string first_six = parcel.client_po_number.Substring(0, 6);
string[] array = new string[3];
array[0] = "NTN";
array[1] = "TCTI";
array[2] = "CTCSD";
currentrow++;
if (DataFunctions.StrInString(first_six, array))
{
ColorMergedRow(currentrow, 7.5);
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = 15;
sheet1.Range["A" + currentrow, "B" + currentrow].Merge();
sheet1.Range["H" + currentrow, "I" + currentrow].Merge();
sheet1.Range["J" + currentrow, "K" + currentrow].Merge();
CellValue("A" + currentrow, "Millage Rate Information", 8, font: "Calibri");
DrawBorder("A" + currentrow, "B" + currentrow);
CellValue("C" + currentrow, "Millage Rate:", 8, Excel.XlHAlign.xlHAlignRight, font: "Calibri");
CellValue("D" + currentrow, String.Format("{0:C}", record.tax_information.milage_rate), 8);
DrawBorder("A" + currentrow, "B" + currentrow);
DrawBorder("A" + (currentrow + 1), "B" + (currentrow + 1));
DrawBorder("C" + currentrow, "D" + (currentrow + 1));
DrawBorder("E" + currentrow, "G" + (currentrow + 1));
DrawBorder("H" + currentrow, "I" + (currentrow + 1));
DrawBorder("J" + currentrow, "K" + (currentrow + 1));
CellValue("H" + currentrow, "Assessed Value:", 8, Excel.XlHAlign.xlHAlignRight, font: "Calibri");
CellValue("J" + currentrow, String.Format("{0:C}", record.assessed_value), 8);
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = 15;
CellValue("A" + currentrow, "Next due Date:", 8, Excel.XlHAlign.xlHAlignRight, font: "Calibri");
CellValue("B" + currentrow, DataFunctions.DateToString(record.tax_information.milage_next_due), 8);
CellValue("C" + currentrow, "Land:", 8, Excel.XlHAlign.xlHAlignRight, font: "Calibri");
CellValue("D" + currentrow, String.Format("{0:C}", record.land_value), 8);
sheet1.Range["E" + currentrow, "F" + currentrow].Merge();
CellValue("E" + currentrow, "Improvement:", 8, Excel.XlHAlign.xlHAlignCenter, font: "Calibri");
CellValue("G" + currentrow, String.Format("{0:C}", record.improved_value), 6);
CellValue("I" + currentrow, "Total:", 8, Excel.XlHAlign.xlHAlignCenter, font: "Calibri");
sheet1.Range["J" + currentrow, "K" + currentrow].Merge();
CellValue("J" + currentrow, String.Format("{0:C}", record.total_value), 8);
}
else
{
ColorMergedRow(currentrow, 7.5);
}
}
/// <summary>
/// PaymentInstallments
/// </summary>
/// <param name="record"></param>
private void PaymentInstallments(TaxAuthorityPaymentRecord record)
{
currentrow++;
this.ColorMergedRow(currentrow, 7.5);
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = 15;
sheet1.Range["D" + currentrow, "E" + currentrow].Merge();
sheet1.Range["H" + currentrow, "I" + currentrow].Merge();
sheet1.Range["J" + currentrow, "K" + currentrow].Merge();
DrawBorder("A" + currentrow, "B" + currentrow);
DrawBorder("C" + currentrow, "E" + currentrow);
DrawBorder("F" + currentrow, "G" + currentrow);
DrawBorder("H" + currentrow, "K" + currentrow);
CellValue("A" + currentrow, "Tax Year:", 8, font: "Calibri");
CellValue("B" + currentrow, record.installments[0].year, 8);
CellValue("C" + currentrow, "Tax Type:", 8, font: "Calibri");
CellValue("D" + currentrow, record.tax_type, 8);
CellValue("F" + currentrow, "Fiscal Year:", 6, font: "Calibri");
CellValue("G" + currentrow, record.tax_authority.fiscal_year, 6, font: "Calibri");
CellValue("H" + currentrow, "Installment Info:", 8, font: "Calibri");
CellValue("J" + currentrow, record.tax_authority.schedule, 8, font: "Calibri");
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = 15;
DrawBorder("A" + currentrow, "K" + currentrow);
sheet1.Range["B" + currentrow, "K" + currentrow].Merge();
CellValue("A" + currentrow, "Total Tax Billed:", 8, font: "Calibri");
CellValue("B" + currentrow, string.Format("{0:C}", DataFunctions.TotalBilled(record.installments)), 8);
string[] install_titles = new string[4];
install_titles[0] = "1st Installment:";
install_titles[1] = "2nd Installment:";
install_titles[2] = "3rd Installment:";
install_titles[3] = "4th Installment:";
int len = install_titles.Length;
int i = 0;
foreach (PaymentInstallment install in record.installments)
{
currentrow++;
sheet1.Range["B" + currentrow, "C" + currentrow].Merge();
sheet1.Cells[currentrow, "A"].RowHeight = 26.25;
DrawCellBorder(currentrow, "A");
DrawBorder("B" + currentrow, "C" + currentrow);
DrawBorder("D" + currentrow, "E" + currentrow);
DrawBorder("F" + currentrow, "G" + currentrow);
DrawBorder("H" + currentrow, "I" + currentrow);
DrawBorder("J" + currentrow, "K" + currentrow);
CellValue("A" + currentrow, install_titles[i], 8, valign: Excel.XlVAlign.xlVAlignTop, font: "Calibri");
Checkboxes(currentrow, "B", DataFunctions.IsPaid(install.date_paid));
CellValue("D" + currentrow, "Due Date:", 8, valign: Excel.XlVAlign.xlVAlignTop, font: "Calibri");
CellValue("E" + currentrow, DataFunctions.DateToString(install.date_due), 8);
CellValue("F" + currentrow, "Paid Date:", 8, valign: Excel.XlVAlign.xlVAlignTop, font: "Calibri");
CellValue("G" + currentrow, DataFunctions.DateToString(install.date_paid), 8);
CellValue("H" + currentrow, "Delinquent\nDate:", 8, valign: Excel.XlVAlign.xlVAlignTop, font: "Calibri");
CellValue("I" + currentrow, DataFunctions.DateToString(install.date_due.AddDays(1)), 8);
CellValue("J" + currentrow, "Billed\nPaid:", 8, valign: Excel.XlVAlign.xlVAlignTop, font: "Calibri");
CellValue("K" + currentrow, String.Format("{0:C}", install.base_amount) + "\n" + String.Format("{0:C}", install.paid), 8);
i++;
}
for (int j = i; j < 4; j++)
{
currentrow++;
CellValue("A" + currentrow, install_titles[i], 8, valign: Excel.XlVAlign.xlVAlignTop, font: "Calibri");
Checkboxes(currentrow, "C", "p Paid p Unpaid");
sheet1.Range["B" + currentrow, "C" + currentrow].Merge();
CellValue("D" + currentrow, "Due Date:", 8, valign: Excel.XlVAlign.xlVAlignTop, font: "Calibri");
CellValue("F" + currentrow, "Paid Date:", 8, valign: Excel.XlVAlign.xlVAlignTop, font: "Calibri");
CellValue("H" + currentrow, "Delinquent\nDate:", 8, valign: Excel.XlVAlign.xlVAlignTop, font: "Calibri");
CellValue("J" + currentrow, "Billed\nPaid:", 8, valign: Excel.XlVAlign.xlVAlignTop, font: "Calibri");
i++;
}
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = 15;
sheet1.Range["A" + currentrow, "G" + currentrow].Merge();
sheet1.Range["A" + (currentrow + 1), "G" + (currentrow + 2)].Merge();
sheet1.Range["H" + currentrow, "K" + currentrow].Merge();
sheet1.Range["H" + (currentrow + 1), "K" + (currentrow + 1)].Merge();
sheet1.Range["H" + (currentrow + 2), "K" + (currentrow + 2)].Merge();
DrawBorder("A" + currentrow, "G" + (currentrow + 2));
DrawBorder("H" + currentrow, "K" + (currentrow + 1));
DrawBorder("H" + (currentrow + 2), "K" + (currentrow + 5));
DrawBorder("A" + (currentrow + 3), "G" + (currentrow + 5));
CellValue("A" + currentrow, "Notes:", 8, font: "Calibri", underline: true);
string notes = BuildNote(record);
CellValue("A" + (currentrow + 1), notes, 8, valign: Excel.XlVAlign.xlVAlignTop);
CellValue("H" + currentrow, "Phone Number:", 8, font: "Calibri");
CellValue("H" + (currentrow + 1), record.tax_authority.payment_phone_string, 8, valign: Excel.XlVAlign.xlVAlignTop);
currentrow++;
var height = DataFunctions.StringHeight(notes, 8, 600);
sheet1.Cells[currentrow, "A"].RowHeight = height;
sheet1.Range["A" + currentrow, "G" + (currentrow + 1)].Merge();
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = 15;
CellValue("H" + currentrow, "Payee Name and Address:", 8, font: "Calibri", underline: true);
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = 15;
sheet1.Range["A" + currentrow, "B" + currentrow].Merge();
sheet1.Range["C" + currentrow, "G" + currentrow].Merge();
sheet1.Range["H" + currentrow, "K" + currentrow].Merge();
CellValue("A" + currentrow, "Discounts Available:", 8, font: "Calibri");
CellValue("H" + currentrow, record.tax_authority.payment_name, 8, valign: Excel.XlVAlign.xlVAlignTop);
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = 15;
sheet1.Range["A" + currentrow, "G" + (currentrow + 1)].Merge();
sheet1.Range["H" + currentrow, "K" + currentrow].Merge();
sheet1.Range["H" + (currentrow + 1), "K" + (currentrow + 1)].Merge();
CellValue("A" + currentrow, record.tax_authority.discounts, 8, valign: Excel.XlVAlign.xlVAlignTop);
CellValue("H" + currentrow, record.tax_authority.payment_string_address, 8, valign: Excel.XlVAlign.xlVAlignTop);
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = 15;
CellValue("H" + currentrow, record.tax_authority.payment_city_state_zip, 8, valign: Excel.XlVAlign.xlVAlignTop);
}
/// <summary>
/// Header
/// </summary>
/// <param name="parcel"></param>
private void Header(ParcelInformation parcel)
{
currentrow++;
DrawBorder("A" + currentrow, "K" + (currentrow + 11));
sheet1.Range["A" + currentrow, "K" + currentrow].Merge();
sheet1.Cells[currentrow, "A"].RowHeight = default_row_height;
CellValue("A" + currentrow, "Tax Certification", 10, Excel.XlHAlign.xlHAlignCenter, font: "Calibri");
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = default_row_height;
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = default_row_height;
sheet1.Range["E" + currentrow, "F" + currentrow].Merge();
sheet1.Range["G" + currentrow, "H" + currentrow].Merge();
CellValue("E" + currentrow, "Verified as of:", 10, Excel.XlHAlign.xlHAlignRight, font: "Calibri");
CellValue("G" + currentrow, DataFunctions.DateToString(parcel.effective_date));
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = 6.75;
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = default_row_height;
sheet1.Range["A" + currentrow, "B" + currentrow].Merge();
sheet1.Range["C" + currentrow, "F" + currentrow].Merge();
sheet1.Range["H" + currentrow, "I" + currentrow].Merge();
sheet1.Range["J" + currentrow, "K" + currentrow].Merge();
CellValue("A" + currentrow, "PO Number:", 8, font: "Calibri");
CellValue("C" + currentrow, parcel.client_po_number, 8);
CellValue("H" + currentrow, "Assessed Valuation:", 8, font: "Calibri");
CellValue("J" + currentrow, string.Format("{0:C}", parcel.assessed_valuation), 8, Excel.XlHAlign.xlHAlignRight);
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = default_row_height;
sheet1.Range["A" + currentrow, "B" + currentrow].Merge();
sheet1.Range["C" + currentrow, "F" + currentrow].Merge();
sheet1.Range["I" + currentrow, "K" + currentrow].Merge();
CellValue("A" + currentrow, "Property Owner:", 8, font: "Calibri");
CellValue("C" + currentrow, parcel.assessed_owners, 8);
CellValue("H" + currentrow, "County:", 8, font: "Calibri");
CellValue("I" + currentrow, parcel.county, 8, Excel.XlHAlign.xlHAlignCenter);
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = default_row_height;
sheet1.Range["A" + currentrow, "B" + currentrow].Merge();
sheet1.Range["C" + currentrow, "F" + currentrow].Merge();
CellValue("A" + currentrow, "Tax Address:", 8, font: "Calibri");
CellValue("C" + currentrow, parcel.assessed_address, 8);
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = default_row_height;
sheet1.Range["A" + currentrow, "B" + currentrow].Merge();
sheet1.Range["C" + currentrow, "F" + currentrow].Merge();
CellValue("A" + currentrow, "Town/City:", 8, font: "Calibri");
CellValue("C" + currentrow, DataFunctions.TownCity(parcel.payment_records), 8);
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = default_row_height;
sheet1.Range["A" + currentrow, "B" + currentrow].Merge();
sheet1.Range["C" + currentrow, "F" + currentrow].Merge();
CellValue("A" + currentrow, "Parcel ID:", 8, font: "Calibri");
CellValue("C" + currentrow, parcel.parcel_number, 8);
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = default_row_height;
sheet1.Range["A" + currentrow, "B" + currentrow].Merge();
sheet1.Range["C" + currentrow, "F" + currentrow].Merge();
sheet1.Range["I" + currentrow, "K" + currentrow].Merge();
CellValue("A" + currentrow, "School District:", 8, font: "Calibri");
CellValue("C" + currentrow, DataFunctions.SchoolDistrict(parcel.payment_records), 8);
CellValue("H" + currentrow, "Class Code:", 8, font: "Calibri");
CellValue("I" + currentrow, parcel.class_code, 8);
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = 9;
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = default_row_height;
sheet1.Range["B" + currentrow, "C" + currentrow].Merge();
sheet1.Range["E" + currentrow, "K" + currentrow].Merge();
DrawGrid("B" + currentrow, "C" + currentrow);
CellValue("A" + currentrow, "Exemptions:", 8, font: "Calibri");
Checkboxes(currentrow, "B", DataFunctions.HasExemptions(parcel.payment_records));
CellValue("D" + currentrow, "Description:", 8, font: "Calibri");
CellValue("E" + currentrow, DataFunctions.ExemptionString(parcel.payment_records, parcel.state), 8);
}