/*Build the document**/
private void AddDocHeader(ref int row, ref int col)
{
//createHeaders(int row, int col, string htext, string cell1, string cell2, int mergeColumns, string b, bool font, int size, string fcolor)
col = 2; row = 1;
string cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, _bbtreportmodel.employername, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
row++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, _bbtreportmodel.employeraddress, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
row++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, _bbtreportmodel.EmployerTelephone, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
row++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, "Printed On: " + _bbtreportmodel.PrintedOn.ToString("dd-dddd-MMMM-yyyy"), cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
//Bank address
row = row + 2; col = 1;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, "THE MANAGER", cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
row++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, _bbtreportmodel.Bank, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
row++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, _bbtreportmodel.BankBranch, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
//Salutation
row = row + 2; col = 1;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, "Dear Sir / Madam", cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
row = row + 2;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, "RE: CREDIT TRANSFER - SALARY PROCESSING", cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
row = row + 2;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, "Below is a list of Names, Banks, Branches, Accounts and Amounts to be credited in their respective accounts", cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
}
/*Build the document**/
private void AddDocHeader(ref int row, ref int col)
{
//createHeaders(int row, int col, string htext, string cell1, string cell2, int mergeColumns, string b, bool font, int size, string fcolor)
col = 2; row = 1;
string cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, payeModel.employername, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
row++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, payeModel.employeraddress, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
row++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, "PAYEE", cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
row++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, payeModel.ReportName, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
row++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, "Printed on: " + payeModel.PrintedOn.ToString("dd-dddd-MMMM-yyyy"), cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
}
/*Build the document**/
private void AddDocHeader(ref int row, ref int col)
{
//createHeaders(int row, int col, string htext, string cell1, string cell2, int mergeColumns, string b, bool font, int size, string fcolor)
col = 2; row = 1;
string cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, _nhifreportmodel.EmployerName, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
row++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, _nhifreportmodel.EmpAddress, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
row++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, "NHIF", cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
row++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, "Employer's NHIF No ..." + _nhifreportmodel.EmployerCode.Trim() + "...", cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
row++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, _nhifreportmodel.ReportName, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
row++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, "Printed on: " + _nhifreportmodel.PrintedOn.ToString("dd-dddd-MMMM-yyyy"), cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
}