private List <BankTransferItem> GetBankTransferItem()
{
List <BankTransferItem> BankTransferItems = new List <BankTransferItem>();
List <DAL.psuedovwPayrollMaster> payroll = rep.GetPayrollMaster(_current, _period, _year);
foreach (DAL.Bank bank in rep.GetBanks())
{
BankTransferItem bti = new BankTransferItem();
bti.BankCode = bank.BankCode;
bti.BankName = bank.BankName;
var Items = from p in payroll
where p.BankCode == bank.BankCode
select new TransferItem
{
AccountNo = p.BankAccount,
Amount = p.NetPay,
BankSortCode = p.BankSortCode,
BranchName = p.BranchName,
EmpName = p.Surname.Trim() + ", " + p.OtherNames,
EmpNo = p.EmpNo
};
bti.TransferItems = Items.ToList();
if (Items.Count() > 0)
{
BankTransferItems.Add(bti);
}
}
return(BankTransferItems);
}
private void AddBankTransferItem(BankTransferItem bti)
{
//document header
AddDocHeader();
Table bankTransferTable = new Table(5);
bankTransferTable.Padding = 1;
bankTransferTable.Spacing = 1;
bankTransferTable.WidthPercentage = 100;
Cell A = new Cell(new Phrase("Bank : " + bti.BankName, tcFont));
A.HorizontalAlignment = Cell.ALIGN_CENTER;
A.Colspan = 5;
bankTransferTable.AddCell(A);
//add table header
AddBankTransferItemTableHeaders(bankTransferTable);
//add table details
foreach (var ti in bti.TransferItems)
{
AddTransferItem(ti, bankTransferTable);
}
//add table totals
AddBankTransferItemTableTotals(bti, bankTransferTable);
document.Add(bankTransferTable);
}
private void AddBankTransferItem(BankTransferItem bti)
{
try
{
Table _bankTransferTable = new Table(5);
_bankTransferTable.WidthPercentage = 100;
_bankTransferTable.Padding = 1;
_bankTransferTable.Spacing = 1;
_bankTransferTable.Border = Table.NO_BORDER;
StringBuilder sb = new StringBuilder();
sb.AppendLine("The Manager");
sb.AppendLine(bti.BankName);
sb.AppendLine(bti.BranchName);
Cell salutation = new Cell(new Chunk(sb.ToString(), hfont2));
salutation.Border = Cell.NO_BORDER;
salutation.Colspan = 5;
_bankTransferTable.AddCell(salutation);
document.Add(_bankTransferTable);
document.Add(new Phrase("\n\nDear Sir/Madam", new Font(Font.TIMES_ROMAN, 8, Font.NORMAL)));
document.Add(new Phrase("\nRE: CREDIT TRANSFER - SALARY PROCESSING", new Font(Font.TIMES_ROMAN, 8, Font.BOLD | Font.UNDERLINE)));
document.Add(new Phrase("\n\nBelow is a list of Names, Banks, Branches, Account and Amounts to be credited in their respective Accounts", new Font(Font.TIMES_ROMAN, 8, Font.NORMAL)));
Table bankTransferTable = new Table(5);
bankTransferTable.Padding = 1;
bankTransferTable.Spacing = 1;
bankTransferTable.WidthPercentage = 100;
Cell A = new Cell(new Phrase("Bank : " + bti.BankName, tcFont));
A.HorizontalAlignment = Cell.ALIGN_CENTER;
A.Colspan = 5;
bankTransferTable.AddCell(A);
//addtable header
BodyAddtableHeaders(bankTransferTable);
//add table details
foreach (var ti in bti.TransferItems)
{
AddTransferItem(ti, bankTransferTable);
}
//add table totals
AddDocBodyTableTotal(bti, bankTransferTable);
document.Add(bankTransferTable);
}
catch (Exception ex)
{
Utils.ShowError(ex);
}
}
//table totals
private void AddBankTransferItemTableTotals(BankTransferItem bti, Table atable)
{
Cell E = new Cell(new Phrase("TOTAL", tHfont1));
E.HorizontalAlignment = Cell.ALIGN_LEFT;
E.Colspan = 4;
atable.AddCell(E);
Cell F = new Cell(new Phrase(string.Format(System.Globalization.CultureInfo.InvariantCulture, "{0:N0}", bti.Total), tcFont));
F.HorizontalAlignment = Cell.ALIGN_RIGHT;
atable.AddCell(F);
}
//table details
private void AddBodyTable(BankTransferItem bti, ref int row, ref int col)
{
row = row + 2; col = 1;
string cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, "Bank Name : " + bti.BankName, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
//add table header
AddBodytableHeaders(ref row, ref col);
//add table details
foreach (var ti in bti.TransferItems)
{
AddDocBodyTableDetails(ti, ref row, ref col);
}
AddDocBodyTableTotals(bti, ref row, ref col);
}
//table totals
private void AddDocBodyTableTotal(BankTransferItem bti, Table atable)
{
try
{
Cell E = new Cell(new Phrase("TOTAL", tHfont1));
E.HorizontalAlignment = Cell.ALIGN_LEFT;
E.Colspan = 4;
atable.AddCell(E);
Cell F = new Cell(new Phrase(string.Format(System.Globalization.CultureInfo.InvariantCulture, "{0:N0}", bti.Total), tcFont));
F.HorizontalAlignment = Cell.ALIGN_RIGHT;
atable.AddCell(F);
}
catch (Exception ex)
{
Utils.ShowError(ex);
}
}
private List <BankTransferItem> GetBankTransferItem()
{
List <BankTransferItem> BankTransferItems = new List <BankTransferItem>();
var _empnosforEmployer = from em in rep.GetAllActiveEmployees()
where em.EmployerId == employer.Id
select em.EmpNo;
List <string> Empnos = _empnosforEmployer.ToList();
var payrollmasterquery = from p in rep.GetPayrollMaster(_current, _period, _year)
where Empnos.Contains(p.EmpNo)
select p;
List <DAL.psuedovwPayrollMaster> payroll = payrollmasterquery.ToList();
foreach (DAL.Bank bank in rep.GetBanks())
{
BankTransferItem bti = new BankTransferItem();
bti.BankCode = bank.BankCode;
bti.BankName = bank.BankName;
var Items = from p in payroll
where p.BankCode == bank.BankCode
select new TransferItem
{
AccountNo = p.BankAccount,
Amount = p.NetPay,
BankSortCode = p.BankSortCode,
BranchName = p.BranchName,
EmpName = p.Surname.Trim() + ", " + p.OtherNames,
EmpNo = p.EmpNo
};
bti.TransferItems = Items.ToList();
if (Items.Count() > 0)
{
BankTransferItems.Add(bti);
}
}
return(BankTransferItems);
}
//table totals
private void AddDocBodyTableTotals(BankTransferItem bti, ref int row, ref int col)
{
row++; col = 1;
string cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, "Total Amount", cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
col++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, "", cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
col++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, "", cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
col++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, "", cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
col++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, bti.Total.ToString("#,##0"), cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
}
