/// <summary>
/// Delinquent
/// </summary>
/// <param name="record"></param>
private void Delinquent(TaxAuthorityPaymentRecord record)
{
currentrow++;
this.ColorMergedRow(currentrow, 7.5);
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = 15;
sheet1.Range["A" + currentrow, "F" + currentrow].Merge();
CellValue("A" + currentrow, "DELINQUENT TAXES", 8, Excel.XlHAlign.xlHAlignCenter, font: "Cambri", bold: true, underline: true);
CellValue("H" + currentrow, "Payable to:", 8, font: "Calibri", bold: true, underline: true);
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = 15;
sheet1.Range["A" + currentrow, "C" + currentrow].Merge();
sheet1.Range["D" + currentrow, "G" + currentrow].Merge();
sheet1.Range["H" + currentrow, "K" + currentrow].Merge();
CellValue("A" + currentrow, "Delinquencies have been verified with:", 8, font: "Calibri");
CellValue("H" + currentrow, record.tax_authority.payment_string_address, 8);
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = 15;
sheet1.Range["A" + currentrow, "B" + currentrow].Merge();
sheet1.Range["C" + currentrow, "D" + currentrow].Merge();
sheet1.Range["H" + currentrow, "K" + currentrow].Merge();
CellValue("A" + currentrow, "TAXES DELINQUENT?", 8, font: "Calibri");
Checkboxes(currentrow, "C", DataFunctions.IsDelinquent(record.installments));
CellValue("H" + currentrow, record.tax_authority.payment_city_state_zip, 8);
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = 15;
sheet1.Range["A" + currentrow, "C" + currentrow].Merge();
sheet1.Range["D" + currentrow, "G" + currentrow].Merge();
sheet1.Range["H" + currentrow, "K" + currentrow].Merge();
CellValue("A" + currentrow, "Description of delinquent taxes:", 8, font: "Calibri");
currentrow++;
sheet1.Cells[currentrow, "A"].RowHeight = 15;
sheet1.Range["A" + currentrow, "G" + currentrow].Merge();
sheet1.Range["I" + currentrow, "K" + currentrow].Merge();
sheet1.Cells[currentrow, "A"].WrapText = true;
CellValue("H" + currentrow, "Phone:", 8, font: "Calibri");
CellValue("I" + currentrow, record.tax_authority.payment_phone_string, 8);
DrawBorder("A" + (currentrow - 5), "G" + (currentrow - 2));
DrawBorder("H" + (currentrow - 5), "K" + (currentrow - 1));
DrawBorder("A" + (currentrow - 1), "G" + currentrow);
DrawBorder("H" + currentrow, "K" + currentrow);
DrawBorder("C" + (currentrow - 2), "D" + (currentrow - 2));
if (String.Compare(DataFunctions.IsDelinquent(record.installments, false), "Yes") == 0)
{
string desc = DataFunctions.DelinquencyDescription(record.installments);
CellValue("H" + (currentrow - 3), record.tax_authority.payment_string_address, 8);
CellValue("H" + (currentrow - 2), record.tax_authority.payment_city_state_zip, 8);
CellValue("I" + currentrow, record.tax_authority.payment_phone_string, 8);
CellValue("A" + currentrow, desc, 8);
sheet1.Cells[currentrow, "A"].WrapText = true;
var height = DataFunctions.StringHeight(desc, 8, 600);
sheet1.Cells[currentrow, "A"].RowHeight = height;
CellValue("H" + (currentrow - 3), record.tax_authority.payment_string_address, 8);
}
}