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);
        }