public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { Report_Payroll_LongServicePaymentSeverancePayment_List rpt = new Report_Payroll_LongServicePaymentSeverancePayment_List(); rpt.Site = this.Site; return(rpt); }
public override ReportDocument GenerateReport() { string HierarchyLevel1 = string.Empty; string HierarchyLevel2 = string.Empty; string HierarchyLevel3 = string.Empty; if (values.Count > 0) { DataSet.Payroll_LongServicePaymentSeverancePayment_List ds = new DataSet.Payroll_LongServicePaymentSeverancePayment_List(); ArrayList HierarchyLevelList = EHierarchyLevel.db.select(dbConn, new DBFilter()); foreach (EHierarchyLevel HierarchyLevel in HierarchyLevelList) { if (HierarchyLevel.HLevelSeqNo.Equals(1)) { HierarchyLevel1 = HierarchyLevel.HLevelDesc; } else if (HierarchyLevel.HLevelSeqNo.Equals(2)) { HierarchyLevel2 = HierarchyLevel.HLevelDesc; } else if (HierarchyLevel.HLevelSeqNo.Equals(3)) { HierarchyLevel3 = HierarchyLevel.HLevelDesc; } } foreach (object obj in values) { int EmpID = -1; if (obj is int) { EmpID = (int)obj; } else if (obj is EEmpPersonalInfo) { EmpID = ((EEmpPersonalInfo)obj).EmpID; } ImportEmployeeDetailRow(ds.employeedetail, EmpID, AsOfDate); DataSet.Payroll_LongServicePaymentSeverancePayment_List.LongServicePaymentSeverancePaymentRow row = ds.LongServicePaymentSeverancePayment.NewLongServicePaymentSeverancePaymentRow(); row.EmpID = EmpID; HROne.Payroll.FinalPaymentProcess finalPaymentProcess = new HROne.Payroll.FinalPaymentProcess(dbConn, EmpID, AsOfDate, string.Empty); string remark; row.LongServicePayment = finalPaymentProcess.GetLongServicePaymentSeverancePaymentAmount(true, out remark); row.SeverancePayment = finalPaymentProcess.GetLongServicePaymentSeverancePaymentAmount(false, out remark); DBFilter mpfRecordFilter = new DBFilter(); DBFilter empPayrollFilter = new DBFilter(); empPayrollFilter.add(new Match("ep.EmpID", EmpID)); empPayrollFilter.add(new MatchField("ep.EmpPayrollID", "MPFRecord.EmpPayrollID")); mpfRecordFilter.add(new Exists("EmpPayroll ep", empPayrollFilter)); ArrayList mpfRecordList = EMPFRecord.db.select(dbConn, mpfRecordFilter); double mpfEmployerContribution = 0; foreach (EMPFRecord mpfRecord in mpfRecordList) { mpfEmployerContribution += mpfRecord.MPFRecActMCER; } row.EmployerContribution = mpfEmployerContribution; ds.LongServicePaymentSeverancePayment.Rows.Add(row); } if (reportDocument == null) { reportDocument = new ReportTemplate.Report_Payroll_LongServicePaymentSeverancePayment_List(); } else { } reportDocument.SetDataSource(ds); reportDocument.SetParameterValue("HierarchyLevel1", HierarchyLevel1); reportDocument.SetParameterValue("HierarchyLevel2", HierarchyLevel2); reportDocument.SetParameterValue("HierarchyLevel3", HierarchyLevel3); if (reportDocument.ParameterFields["AsOfDate"] != null) { reportDocument.SetParameterValue("AsOfDate", this.AsOfDate); } return(reportDocument); } else { return(null); } }