/// <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); } }