private void CreateXlsxReports(XmlDocument xmlReport) { PayRunIOWebGlobeClass prWG = new PayRunIOWebGlobeClass(); //Get employer number. string coNo = prWG.GetEmployerNumber(xmlReport); //Create the Excel workbook string outgoingFolder = btnEditSavePDFReports.Text; string startDate = dateStartDate.Text.Replace('/', '.'); string endDate = dateEndDate.Text.Replace('/', '.'); string workBookName; PicoXLSX.Workbook workbook = null; switch (comboBoxChooseReport.Text) { case "Pre Report": workBookName = outgoingFolder + "\\" + coNo + "_PreReport(" + startDate + "-" + endDate + ").xlsx"; workbook = prWG.CreatePreReportWorkbook(xmlReport, workBookName); break; case "Bottomline Bank Report": workBookName = outgoingFolder + "\\" + coNo + "_BottomlineBankReport.xlsx"; workbook = prWG.CreateBottomlineReportWorkbook(xmlReport, workBookName); break; } workbook.Save(); }
private void CreatePDFReports(XmlDocument xmlReport) { PayRunIOWebGlobeClass prWG = new PayRunIOWebGlobeClass(); string reportName = null; string assemblyName = "PayRunIOClassLibrary"; XtraReport xtraReport = new XtraReport(); switch (comboBoxChooseReport.Text) { case "Combined Payroll Run Report": reportName = "CombinedPayrollRunReport"; xtraReport = prWG.CreatePDFReport(xmlReport, reportName, assemblyName); reportName = "CombinedPayrollRunReport"; break; case "Department Within Branch Payroll Run Details Report": reportName = "CombinedPayrollRunReport"; xtraReport = prWG.CreatePDFReport(xmlReport, reportName, assemblyName); reportName = "DepartmentWithinBranchPayrollRunDetailsReport"; break; case "Note And Coin Requirement Report": reportName = "NoteAndCoinRequirementReport"; assemblyName = "PayRunIOClassLibrary"; xtraReport = prWG.CreatePDFReport(xmlReport, reportName, assemblyName); break; case "Current Attachment Of Earnings Orders": reportName = "CurrentAttachmentOfEarningsOrders"; assemblyName = "PayRunIOClassLibrary"; xtraReport = prWG.CreatePDFReport(xmlReport, reportName, assemblyName); break; case "Pay Component Exception Report": reportName = "PayComponentExceptionReport"; assemblyName = "PayRunIOClassLibrary"; xtraReport = prWG.CreatePDFReport(xmlReport, reportName, assemblyName); break; case "Pension Contributions To Date Report": reportName = "PensionContributionsToDateReport"; assemblyName = "PayRunIOClassLibrary"; xtraReport = prWG.CreatePDFReport(xmlReport, reportName, assemblyName); break; case "P11 Substitute": reportName = "P11Substitute"; assemblyName = "PayRunIOClassLibrary"; xtraReport = prWG.CreatePDFReport(xmlReport, reportName, assemblyName); break; case "P32 Report": reportName = "P32Report"; assemblyName = "PayRunIOClassLibrary"; xtraReport = prWG.CreatePDFReport(xmlReport, reportName, assemblyName); break; case "EPS Report": reportName = "EPSReport"; assemblyName = "PayRunIOClassLibrary"; xtraReport = prWG.CreatePDFReport(xmlReport, reportName, assemblyName); break; case "Apprenticeship Levy Report": reportName = "ApprenticeshipLevyReport"; assemblyName = "PayRunIOClassLibrary"; xtraReport = prWG.CreatePDFReport(xmlReport, reportName, assemblyName); break; case "Statutory Absence Report": reportName = "StatutoryAbsenceReport"; assemblyName = "PayRunIOClassLibrary"; xtraReport = prWG.CreatePDFReport(xmlReport, reportName, assemblyName); break; case "Statutory Sick Pay Paid Report": reportName = "StatutorySickPayPaidReport"; assemblyName = "PayRunIOClassLibrary"; xtraReport = prWG.CreatePDFReport(xmlReport, reportName, assemblyName); break; default: break; } string docName = btnEditSavePDFReports.Text + "\\" + txtEditParameter1.Text + "_" + reportName + ".pdf"; SavePDFReport(xtraReport, docName); }