private List <printallemployees> GetEmployees()
{
try
{
List <printallemployees> esmr = new List <Models.printallemployees>();
List <Employee> employees = rep.GetAllActiveEmployeesforEmployer(_employer.Id);
foreach (var e in employees)
{
printallemployees emp = new printallemployees();
emp.employeenumber = e.EmpNo;
emp.employeename = e.Surname + ", " + e.OtherNames;
emp.gender = e.Gender;
emp.pinnumber = e.PINNo;
emp.idnumber = e.IDNo;
var _departmentquery = from dp in db.Departments
where dp.Id == e.DepartmentId
select dp;
Department _department = _departmentquery.FirstOrDefault();
emp.department = _department.Description;
emp.dateofemployment = e.DoE ?? DateTime.Today;
emp.basicpay = (decimal)e.BasicPay;
emp.paymentmode = e.PaymentMode;
esmr.Add(emp);
}
return(esmr);
}
catch (Exception ex)
{
Utils.ShowError(ex);
return(null);
}
}
//table details
private void AddBodyTableDetail(printallemployees paemp, ref int row, ref int col)
{
row++; col = 1;
string cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, paemp.employeenumber, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
col++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, paemp.employeename, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
col++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, paemp.gender, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
col++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, paemp.pinnumber, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
col++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, paemp.idnumber, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
col++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, paemp.department, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
col++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, paemp.dateofemployment.ToString("dd-MMM-yyyy"), cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
col++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, paemp.basicpay.ToString("#,##0"), cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
col++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, paemp.paymentmode, cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
}
//table details
private void AddTableDetails(printallemployees paemp)
{
Table employeesTable = new Table(9);
employeesTable.WidthPercentage = 100;
employeesTable.Padding = 1;
employeesTable.Spacing = 1;
Cell empno = new Cell(new Phrase(paemp.employeenumber.ToString(), rms8Bold));
empno.Border = Cell.RECTANGLE;
empno.HorizontalAlignment = Cell.ALIGN_LEFT;
employeesTable.AddCell(empno);
Cell empname = new Cell(new Phrase(paemp.employeename.ToString(), rms8Bold));
empname.Border = Cell.RECTANGLE;
empname.HorizontalAlignment = Cell.ALIGN_LEFT;
employeesTable.AddCell(empname);
Cell empgender = new Cell(new Phrase(paemp.gender, rms8Bold));
empgender.Border = Cell.RECTANGLE;
empgender.HorizontalAlignment = Cell.ALIGN_LEFT;
employeesTable.AddCell(empgender);
Cell pinnumber = new Cell(new Phrase(paemp.pinnumber, rms8Bold));
pinnumber.Border = Cell.RECTANGLE;
pinnumber.HorizontalAlignment = Cell.ALIGN_LEFT;
employeesTable.AddCell(pinnumber);
Cell idnumber = new Cell(new Phrase(paemp.idnumber, rms8Bold));
idnumber.Border = Cell.RECTANGLE;
idnumber.HorizontalAlignment = Cell.ALIGN_LEFT;
employeesTable.AddCell(idnumber);
Cell department = new Cell(new Phrase(paemp.department, rms8Bold));
department.Border = Cell.RECTANGLE;
department.HorizontalAlignment = Cell.ALIGN_LEFT;
employeesTable.AddCell(department);
Cell telephone = new Cell(new Phrase(paemp.dateofemployment.ToString("dd-MMM-yyyy"), rms8Bold));
telephone.Border = Cell.RECTANGLE;
telephone.HorizontalAlignment = Cell.ALIGN_LEFT;
employeesTable.AddCell(telephone);
Cell basic = new Cell(new Phrase(string.Format(System.Globalization.CultureInfo.InvariantCulture, "{0:N0}", paemp.basicpay), rms8Bold));
basic.Border = Cell.RECTANGLE;
basic.HorizontalAlignment = Cell.ALIGN_RIGHT;
employeesTable.AddCell(basic);
Cell paymentmode = new Cell(new Phrase(paemp.paymentmode, rms8Bold));
paymentmode.Border = Cell.RECTANGLE;
paymentmode.HorizontalAlignment = Cell.ALIGN_CENTER;
employeesTable.AddCell(paymentmode);
document.Add(employeesTable);
}