/// <summary>
/// Content
/// </summary>
/// <param name="parcel"></param>
private void Content(ParcelInformation parcel)
{
foreach (TaxAuthorityPaymentRecord record in parcel.payment_records)
{
Valuation(record, parcel);
if (delq_section_flag == 0)
{
Delinquent(record);
delq_section_flag++;
}
PaymentInstallments(record);
}
}
/// <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>
/// 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);
}
public static ClientOrder GetSampleOrder()
{
ClientOrder client_order = new ClientOrder();
ReportConfig report_config = new ReportConfig();
report_config.disclaimer = "We have made every effort to ensure the accuracy of this tax information. However, due to the frequency with which municipalities revise their fees and other specifications, we cannot assume liability for any discrepancy in the taxes. In the event that tax amounts have changed, please notify us so we can update our records. Possible revenue bond charges for sewer and water pursuant to state statutes and local ordinances when connection to the system is made by the owner. The exact current and continuing charges depend on all the facts. Contact local officials for details. This report is based on best available information at the time. This is for informational purposes only and will not appear on title policy.\r\nPatent Pending ";
client_order.report_config = report_config;
ClientConfig client_config = new ClientConfig();
client_config.base_path = @"D:\Programming\0_crap\";
client_config.report_name = "Tax_Research.xlsx";
client_config.logo = @"D:\Programming\0_crap\logo.jpg";
client_order.client_config = client_config;
ParcelInformation parcel = new ParcelInformation();
parcel.client_po_number = "U NTN-ARS-12345";
parcel.researcher = "erice";
parcel.owner_1 = "Buddy Rice";
parcel.owner_2 = "Ashley Gonzalez";
parcel.address = "427 8th Ave N";
parcel.city = "Saint Petersburg";
parcel.state = "FL";
parcel.zip_code = "33701";
parcel.county = "PINELLAS";
parcel.searched_address = "427 8th Ave N";
parcel.searched_city = "Saint Petersburg";
parcel.searched_state = "FL";
parcel.searched_zip_code = "33701";
parcel.assessed_owner_1 = "Buddy Rice";
parcel.assessed_owner_2 = "Ashley Gonzalez";
parcel.parcel_number = "18-31-17-77814-001-0060";
parcel.effective_date = DateTime.Parse("2018-05-01");
parcel.legal_desc = "SAFFORD'S ADD REVISED BLK 1, E 75FT OF LOTS 6 AND 7";
parcel.class_code = "Apartments (10 units to 49 units)";
parcel.assessed_valuation = 408980.00M;
TaxAuthorityPaymentRecord payment_record = new TaxAuthorityPaymentRecord();
payment_record.tax_type = "County";
payment_record.additional_data = "";
payment_record.research_notes = "";
payment_record.lump_sum = 1;
payment_record.ex_homestead = 0;
payment_record.ex_disabled = 0;
payment_record.ex_veteran = 1;
payment_record.ex_mortgage = 0;
payment_record.ex_star = 0;
payment_record.ex_elderly = 0;
payment_record.ex_other = string.Empty;
payment_record.assessed_value = 408980.00M;
payment_record.land_value = 225600.00M;
payment_record.improved_value = 45100.00M;
payment_record.unincorporated = 0;
payment_record.lawsuit = string.Empty;
payment_record.lawsuit_case = string.Empty;
TaxAuthority tax_authority = new TaxAuthority();
tax_authority.name = "Pinellas County Tax Collector";
tax_authority.payment_name = "Pinellas County Tax Collector";
tax_authority.current_tax_year = "2018";
tax_authority.discounts = "N/A";
tax_authority.duplicate_bill_fee = 5.00M;
tax_authority.fiscal_year = "2018";
tax_authority.payment_address_1 = "1800 66th Street North";
tax_authority.payment_address_2 = "suite ABC";
tax_authority.payment_city = "St.Petersburg";
tax_authority.payment_state = "FL";
tax_authority.payment_zip = "33710";
tax_authority.payment_phone = "(727)123-4567";
tax_authority.payment_ext = "9876";
tax_authority.schedule = "Annually";
tax_authority.ta_other_notes = "Pinellas County is the only taxing authority for this property.\n\nPinellas County collects annually due by 7/15 with an option to pay in installments due by 7/15, 10/15, 1/15 & 4/15.\n\nThere is a 10 day grace period for installment 1 only.\n\nPINELLAS COUNTY DOES NOT PROVIDE PAID DATES; PAYMENTS ARE PROCESSED AS PAID TIMELY BY THE DUE DATE.";
payment_record.tax_authority = tax_authority;
TaxInformation tax_info = new TaxInformation();
tax_info.jurisdiction_name = "Pinellas County Tax Collector";
tax_info.jurisdiction_type = "County";
tax_info.tax_rate = 0.00M;
tax_info.exemptions = "Veterine Exemption";
tax_info.milage_rate = 22.0150M;
tax_info.milage_next_due = DateTime.Parse("2018-12-01");
PaymentInstallment install_1 = new PaymentInstallment();
install_1.amount_due = 0.00M;
install_1.paid = 2459.89M;
install_1.base_amount = 2459.89M;
install_1.date_due = DateTime.Parse("2017-12-31");
install_1.date_good_thru = DateTime.Parse("2018-02-28");
install_1.date_paid = DateTime.Parse("2018-02-01");
install_1.delinquent_amount = 0.00M;
install_1.install = 1;
install_1.is_delinquent = 0;
install_1.is_estimate = 0;
install_1.is_exempt = 0;
install_1.is_partial = 0;
install_1.one_month = 0.00M;
install_1.two_month = 0.00M;
payment_record.installments.Add(install_1);
PaymentInstallment install_2 = new PaymentInstallment();
install_2.amount_due = 0.00M;
install_2.paid = 2459.89M;
install_2.base_amount = 2459.89M;
install_2.date_due = DateTime.Parse("2017-12-31");
install_2.date_good_thru = DateTime.Parse("2018-02-01");
install_2.date_paid = DateTime.Parse("2018-02-01");
install_2.delinquent_amount = 0.00M;
install_2.install = 2;
install_2.is_delinquent = 0;
install_2.is_estimate = 0;
install_2.is_exempt = 0;
install_2.is_partial = 0;
install_2.one_month = 0.00M;
install_2.two_month = 0.00M;
payment_record.installments.Add(install_2);
PaymentInstallment install_3 = new PaymentInstallment();
install_3.amount_due = 0.00M;
install_3.paid = 2459.89M;
install_3.base_amount = 2459.89M;
install_3.date_due = DateTime.Parse("2017-12-31");
install_3.date_good_thru = DateTime.Parse("2018-02-01");
install_3.date_paid = DateTime.Parse("2018-02-01");
install_3.delinquent_amount = 0.00M;
install_3.install = 3;
install_3.is_delinquent = 0;
install_3.is_estimate = 0;
install_3.is_exempt = 0;
install_3.is_partial = 0;
install_3.one_month = 0.00M;
install_3.two_month = 0.00M;
payment_record.installments.Add(install_3);
PaymentInstallment install_4 = new PaymentInstallment();
install_4.amount_due = 2459.89M;
install_4.base_amount = 2459.89M;
install_4.date_due = DateTime.Parse("2017-12-31");
install_4.date_good_thru = DateTime.Parse("2018-02-01");
install_4.date_paid = DateTime.MinValue;
install_4.delinquent_amount = 0.00M;
install_4.install = 4;
install_4.is_delinquent = 1;
install_4.is_estimate = 0;
install_4.is_exempt = 0;
install_4.is_partial = 0;
install_4.one_month = 0.00M;
install_4.two_month = 0.00M;
payment_record.installments.Add(install_4);
payment_record.tax_information = tax_info;
parcel.payment_records.Add(payment_record);
client_order.Parcels.Add(parcel);
return(client_order);
}
