void t_CompareRpt_PlanTerminationSetup_PBGC_4044(string sPlanTerminationSetup_PBGC_4044) { if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("US012DNT", sPlanTerminationSetup_PBGC_4044_Prod, sPlanTerminationSetup_PBGC_4044); _compareReportsLib._Report(_PassFailStep.Description, "", "sPlanTerminationSetup_PBGC_4044"); _compareReportsLib.CompareExcel_Exact("PBGC4044LiabilitiesbyPlanDef.xlsx", 7, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0); Config.bThreadFinsihed = true; } }
void t_CompareRpt_Plan1_NDT2017_DCOnly(string sOutputPlan1_NDT2017_DCOnly) { if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("US017_DNT", sOutputPlan1_NDT2017_DCOnly_Prod, sOutputPlan1_NDT2017_DCOnly); _compareReportsLib._Report(_PassFailStep.Description, "", "Plan1_NDT2017_DCOnly"); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 0, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("CoverageTest.xlsx", 0, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("GeneralTest_GeneralTestSummary.xlsx", 0, 0, 0, 0, false); _compareReportsLib.CompareExcel_Exact("GeneralTest_CurrentTestingforEachHCE.xlsx", 0, 0, 0, 0, false); _compareReportsLib.CompareExcel_Exact("GeneralTest_CurrentTestingAccrualRates.xlsx", 0, 0, 0, 0, false); Config.bThreadFinsihed = true; } }
public void t_CompareRpt_Valuation2009_AttainedAge(string sOutputFunding_Valuation2009_AttainedAge) { if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("IR001DNT", sOutputFunding_Valuation2009_AttainedAge_Prod, sOutputFunding_Valuation2009_AttainedAge); _compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_Valuation2009_AttainedAge"); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_GoingConcern.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_Solvency.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_GoingConcern.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_Solvency.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResults.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0); Config.bThreadFinsihed = true; } }
void t_CompareRpt_Plan2_conversion2016_CopyofPFVS(string sOutputPlan2_conversion2016_CopyofPFVS) { if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("US017DNT", sOutputPlan2_conversion2016_CopyofPFVS_Prod, sOutputPlan2_conversion2016_CopyofPFVS); _compareReportsLib._Report(_PassFailStep.Description, "", "Plan2_conversion2016_CopyofPFV"); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0); Config.bThreadFinsihed = true; } }
void t_CompareRpt_Plan1_NDT2016_CopyofPFVS(string sOutputPlan1_NDT2016_CopyofPFVS) { if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("US017DNT", sOutputPlan1_NDT2016_CopyofPFVS_Prod, sOutputPlan1_NDT2016_CopyofPFVS); _compareReportsLib._Report(_PassFailStep.Description, "", "Plan1_NDT2016_CopyofPFVS"); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 0, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("CoverageTest.xlsx", 0, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("GeneralTest_GeneralTestSummary.xlsx", 0, 0, 0, 0, true); ////_compareReportsLib.CompareExcel_Exact("GeneralTest_CurrentTestingforEachHCE.xlsx", 0, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("GeneralTest_CurrentAndPriorTestingforEachHCE.xlsx", 0, 0, 0, 0); ////_compareReportsLib.CompareExcel_Exact("GeneralTest_CurrentPriorAndFutureTestingforEachHCE.xlsx", 0, 0, 0, 0); ////_compareReportsLib.CompareExcel_Exact("GeneralTest_CurrentTestingAccrualRates.xlsx", 0, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("GeneralTest_CurrentAndPriorTestingAccrualRates.xlsx", 0, 0, 0, 0); ////_compareReportsLib.CompareExcel_Exact("GeneralTest_CurrentPriorAndFutureTestingAccrualRates.xlsx", 0, 0, 0, 0); Config.bThreadFinsihed = true; } }
public void test_DE013_DNT() { this.GenerateReportOuputDir(); pMain._SelectTab("Home"); dic.Clear(); dic.Add("Country", Config.eCountry.ToString()); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "PensionValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "Pens2018_Cashouts"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("Pens2018_Cashouts"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("PayoutProjection", "False"); dic.Add("ApplyWithdrawalAdjustment", ""); dic.Add("IncludeIOE", ""); dic.Add("GenerateParameterPrint", "False"); dic.Add("GenerateTestCaseOutput", "False"); dic.Add("SaveResultsforAuditReport", ""); dic.Add("ApplyOverrides", "True"); dic.Add("RunLocally", ""); dic.Add("Pay", "N/A"); dic.Add("CurrentYear", "True"); dic.Add("PriorYear", ""); dic.Add("BreakByFundingVehicle", "False"); dic.Add("UseReportBreaks", "True"); dic.Add("AllLiabilityTypes", ""); dic.Add("Tax", "False"); dic.Add("Trade", "False"); dic.Add("InternationalAccountingABO", "False"); dic.Add("InternationalAccountingPBO", "True"); dic.Add("SelectVOs_AllVOs", ""); dic.Add("SelectVOs_VO1", "VO1"); dic.Add("SelectVOs_VO2", ""); dic.Add("SelectVOs_VO3", ""); dic.Add("SelectVOs_VO4", ""); dic.Add("SelectVOs_VO5", ""); dic.Add("SelectVOs_VO6", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("Pens2018_Cashouts"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("Pens2018_Cashouts"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputPension_Pens2018_Cashouts, "Data Matching Summary", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputPension_Pens2018_Cashouts, "Combined Status Code Summary", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputPension_Pens2018_Cashouts, "Gain / Loss Status Reconciliation", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputPension_Pens2018_Cashouts, "Gain / Loss Summary of Liability Reconciliation", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputPension_Pens2018_Cashouts, "Decrement Gain / Loss Detail", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputPension_Pens2018_Cashouts, "Decrement Age", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputPension_Pens2018_Cashouts, "Gain / Loss Participant Listing", "RollForward", false, true); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("DE013DNT", sOutputPension_Pens2018_Cashouts_Prod, sOutputPension_Pens2018_Cashouts); _compareReportsLib._Report(_PassFailStep.Description, "", "sOutputPension_Pens2018_Cashouts"); _compareReportsLib.CompareExcel_Exact("DataMatchingSummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("CombinedStatusCodeSummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("GainLossStatusReconciliation.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("GainLossSummaryofLiabilityReconciliation.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DecrementGainLossDetail.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DecrementAge.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("GainLossParticipantListing.xlsx", 4, 0, 0, 0); } _gLib._MsgBox("Congratulations!This client is done!", "For GLPL report only focus on check the total number "); }
public void t_CompareRpt_Valuation2011_Baseline(string sOutputFunding_Valuation2011_Baseline) { if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("US015CN", sOutputFunding_Valuation2011_Baseline_Prod, sOutputFunding_Valuation2011_Baseline); _compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_Valuation2011_Baseline"); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PPANARMax.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PPANARMin.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationToPriorYearByPlanDef_PPANARMax.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationToPriorYearByPlanDef_PPANARMin.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("StatusReconciliation.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_MovementAndRollforward.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_OutlierSummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_CheckingGroupStatistics.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("AgeServiceMatrix.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DataMatchingSummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("CombinedStatusCodeSummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("GainLossStatusReconciliation.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("GainLossSummaryofLiabilityReconciliation_PPANARMin.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ActiveDecrementGainLossDetail_PPANARMin.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DecrementAge.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("GainLossParticipantListing_PPANARMin.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPopulationProjection.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationSummary.xlsx", 12, new string[1] { "Sheet2" }); _compareReportsLib.CompareExcel_Exact("FutureValuationSummary.xlsx", 4, new string[1] { "Sheet1" }); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2011.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2012.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2013.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2014.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2015.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2016.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2021.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2031.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyGroup.xlsx", 12, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyYear.xlsx", 12, new string[1] { "Sheet2" }); _compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyYear.xlsx", 4, new string[1] { "Sheet1" }); Config.bThreadFinsihed = true; } }
public void _test_US006_DNT() { //sOutputBaseline = @"W:\Tmp\Lin\US006_20190529_Baseline_QA1\"; sOutputBaseline = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_006_Morgan_Stanley_EEP\Existing\January 2007 Valuation\20190614_QA1\"; sOutputBaseline_Prod = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_006_Morgan_Stanley_EEP\Production\January 2007 Valuation\000_7.4_Baseline\"; pMain._SetLanguageAndRegional(); //this.GenerateReportOuputDir(); #region January 2007 Valuation Baseline - Report pMain._SelectTab("Home"); dic.Clear(); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "FundingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "January 2007 Valuation"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("January 2007 Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Test Case"); pMain._FlowTreeRightSelect(dic); pMain._SelectTab("Test Case Library"); dic.Clear(); dic.Add("SelectionCriteria", "$emp.BirthDate=\"7/25/1956\" and $emp.HireDate1=\"5/18/1991\""); dic.Add("iResultRow", "1"); pTestCaseLibrary._AddTestCase(dic); dic.Clear(); dic.Add("SelectionCriteria", "$emp.BirthDate=\"07/13/1967\" and $emp.HireDate1=\"1/3/1991\""); dic.Add("iResultRow", "1"); pTestCaseLibrary._AddTestCase(dic); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); pMain._SelectTab("January 2007 Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_PPANAR_Min", ""); dic.Add("GL_PPANAR_Max", ""); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "$Service"); dic.Add("Pay", "PayPlanLimit"); dic.Add("CurrentYear", ""); dic.Add("PriorYear", "True"); dic.Add("CashBanlance", "AccruedBenefit1"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", ""); dic.Add("PPANotAtRiskLiabilityForMinimum", "True"); dic.Add("PPANotAtRiskLiabilityForMaximum", "True"); dic.Add("PPANotAtRishPresentValueOfVestedBenefits", "True"); dic.Add("PBGCNotAtRiskPresentValueOfVestedBenefits", "True"); dic.Add("FAS35PresentValueOfAccumulatedBenefits", "True"); dic.Add("FAS35PresentValueOfVestedBenefits", "True"); dic.Add("PPAAtRiskLiabilityForMinimum", ""); dic.Add("PPAAtRiskLiabilityForMaximum", ""); dic.Add("PPAAtRiskPresentValueOfVestedBenefits", ""); dic.Add("PBGCAtRiskPresentValueOfVestedBenefits", ""); dic.Add("EntryAgeNormal", ""); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("January 2007 Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("January 2007 Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputBaseline, "Liability Summary", "Conversion", true, true); pOutputManager._ExportReport_DrillDown_PDF_EXCEL(sOutputBaseline, "Liability Summary", "Conversion", true, true, 0); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputBaseline, "Member Statistics", "Conversion", true, true); pOutputManager._ExportReport_DrillDown_PDF_EXCEL(sOutputBaseline, "Conversion Diagnostic", "Conversion", true, true, 0); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputBaseline, "Test Case List", "Conversion", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputBaseline, "Detailed Results", "Conversion", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputBaseline, "Detailed Results by Plan Def", "Conversion", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputBaseline, "Valuation Summary", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputBaseline, "Individual Output", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputBaseline, "IOE", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputBaseline, "Parameter Print", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputBaseline, "Test Cases", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputBaseline, "Payout Projection", "Conversion", true, true); pMain._SelectTab("January 2007 Valuation"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion #region January 2007 Valuation Baseline - Compare if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("US006DNT", sOutputBaseline_Prod, sOutputBaseline); _compareReportsLib._Report(_PassFailStep.Description, "", "Baseline"); _compareReportsLib.CompareExcel_Exact("LiabilitySummary.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_ActiveMembers.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_DeferredMembers.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_Pensioners.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByNone.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByStatusCodes.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByCustom_Gender.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0, true); } #endregion _gLib._MsgBox("Congratulations!", "Finished!"); // To generate code for this test, select "Generate Code for Coded UI Test" from the shortcut menu and select one of the menu items. }
void t_CompareRpt_Funding_2006Funding_Baseline(string sOutputFunding_2006Funding_Baseline) { if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("US009CN", sOutputFunding_2006Funding_Baseline_Prod, sOutputFunding_2006Funding_Baseline); _compareReportsLib._Report(_PassFailStep.Description, "", "2006Funding_Baseline"); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_FAS35PVAB.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_FAS35PVVB.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PBGCNARPVVB.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PPANARMax.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PPANARMin.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PPANARPVVB.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationToPriorYearByPlanDef_FAS35PVAB.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationToPriorYearByPlanDef_FAS35PVVB.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationToPriorYearByPlanDef_PBGCNARPVVB.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationToPriorYearByPlanDef_PPANARMax.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationToPriorYearByPlanDef_PPANARMin.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationToPriorYearByPlanDef_PPANARPVVB.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("StatusReconciliation.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_MovementAndRollforward.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_OutlierSummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_CheckingGroupStatistics.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("AgeServiceMatrix.xlsx", 4, 0, 0, 0); //////////_compareReportsLib.CompareExcel_Exact("DataComparison.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DataMatchingSummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("CombinedStatusCodeSummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("GainLossStatusReconciliation.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("GainLossSummaryofLiabilityReconciliation_PPANARMin.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("GainLossSummaryofLiabilityReconciliation_PPANARMax.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ActiveDecrementGainLossDetail_PPANARMin.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ActiveDecrementGainLossDetail_PPANARMax.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DecrementAge.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("GainLossParticipantListing_PPANARMin.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("GainLossParticipantListing_PPANARMax.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilityComparison_PPANARMin.xlsx", 0, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilityComparison_PPANARMax.xlsx", 0, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0); Config.bThreadFinsihed = true; } }
public void _test_ANZ002_CN() { //this.GenerateReportOuputDir(); sOutputFunding_2014BenchmarkVal_REVISED50YearsFV = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_ANZ_002\CreateNew\Funding2014\Revised50YearsFV\20190829_QA1\"; #region 2014BenchmarkVal_REVISED50YearsFV_Prod //pMain._SelectTab("Home"); //dic.Clear(); //dic.Add("Country", Config.eCountry.ToString()); //dic.Add("Level_1", Config.sClientName); //dic.Add("Level_2", Config.sPlanName); //dic.Add("Level_3", "FundingValuations"); //pMain._HomeTreeViewSelect(0, dic); //dic.Clear(); //dic.Add("PopVerify", "Pop"); //dic.Add("AddServiceInstance", ""); //dic.Add("ServiceToOpen", "2014 Benchmark Val"); //pMain._PopVerify_Home_RightPane(dic); //pMain._SelectTab("2014 Benchmark Val"); //dic.Clear(); //dic.Add("iMaxRowNum", ""); //dic.Add("iMaxColNum", ""); //dic.Add("iSelectRowNum", "1"); //dic.Add("iSelectColNum", "1"); //dic.Add("MenuItem_1", "Add Valuation Node"); //pMain._FlowTreeRightSelect(dic); //dic.Clear(); //dic.Add("PopVerify", "Pop"); //dic.Add("ValNodeName", "Test_REVISED50YearFV"); //dic.Add("LiabilityValuationDate", ""); //dic.Add("Data_AddNew", ""); //dic.Add("Data_Name", ""); //dic.Add("Data_Edit", ""); //dic.Add("Assumptions_AddNew", ""); //dic.Add("Assumptions_Name", ""); //dic.Add("Assumptions_Edit", ""); //dic.Add("MethodsLiabilities_AddNew", ""); //dic.Add("MethodsLiabilities_Name", ""); //dic.Add("MethodsLiabilities_Edit", ""); //dic.Add("Provisions_AddNew", "true"); //dic.Add("Provisions_Name", ""); //dic.Add("Provisions_Edit", ""); //dic.Add("FundingInformation_AddNew", ""); //dic.Add("FundingInformation_Name", ""); //dic.Add("FundingInformation_Edit", ""); //dic.Add("OK", "Click"); //dic.Add("Cancel", ""); //pMain._PopVerify_ValuationNodeProperties(dic); //pMain._SelectTab("2014 Benchmark Val"); //dic.Clear(); //dic.Add("iMaxRowNum", ""); //dic.Add("iMaxColNum", "2"); //dic.Add("iSelectRowNum", "2"); //dic.Add("iSelectColNum", "2"); //dic.Add("MenuItem_1", "Provisions"); //dic.Add("MenuItem_2", "Edit Parameters"); //pMain._FlowTreeRightSelect(dic); //pMain._SelectTab("Provisions"); //dic.Clear(); //dic.Add("Level_1", "Provisions"); //dic.Add("Level_2", "Conversion Factors"); //dic.Add("Level_3", "PensionConversionFactor"); //dic.Add("MenuItem", "Add Condition"); //pAssumptions._TreeViewRightSelect(dic, "AgeEqual115"); //dic.Clear(); //dic.Add("Level_1", "Provisions"); //dic.Add("Level_2", "Conversion Factors"); //dic.Add("Level_3", "PensionConversionFactor"); //dic.Add("Level_4", "AgeEqual115"); //pAssumptions._TreeViewSelect(dic); //dic.Clear(); //dic.Add("PopVerify", "Pop"); //dic.Add("iRow", ""); //dic.Add("Name", ""); //dic.Add("Expression", "0"); //dic.Add("Validate", "Click"); //pAssumptions._PopVerify_Provision_CustomCode(dic); //pAssumptions._SelectTab("Conditions"); //dic.Clear(); //dic.Add("PopVerify", "Pop"); //dic.Add("PreDefinedEligibility", ""); //dic.Add("cboPreDefinedEligibility", ""); //dic.Add("LocalEligibility", ""); //dic.Add("txtLocalEligibility", ""); //dic.Add("AddToEligibilities", ""); //dic.Add("EligibilityCondition", "$Age = 115"); //dic.Add("Validate", "click"); //pAssumptions._PopVerify_Assmp_Decrement_Conditions(dic); //pMain._Home_ToolbarClick_Top(true); //pMain._Home_ToolbarClick_Top(false); //pMain._SelectTab("2014 Benchmark Val"); //dic.Clear(); //dic.Add("iMaxRowNum", ""); //dic.Add("iMaxColNum", "2"); //dic.Add("iSelectRowNum", "2"); //dic.Add("iSelectColNum", "2"); //dic.Add("MenuItem_1", "Future Valuation Options"); //pMain._FlowTreeRightSelect(dic); //pFutureValuationOption._SelectTab("Projection years"); //dic.Clear(); //dic.Add("PopVerify", "Pop"); //dic.Add("EveryYearForTheFirst", "1"); //dic.Add("AndEvery", "5"); //dic.Add("UpToincludingProjectionYear", "50"); //dic.Add("ProjectionYears", ""); //dic.Add("NumberOfRuns", ""); //dic.Add("RandomNumDismissed", ""); //dic.Add("FundingUpdateDate_UK", ""); //pFutureValuationOption._ProjectionYears(dic); //dic.Clear(); //dic.Add("PopVerify", "Pop"); //dic.Add("OK", "click"); //pFutureValuationOption._PopVerify_OK(dic); //pMain._SelectTab("2014 Benchmark Val"); //dic.Clear(); //dic.Add("iMaxRowNum", ""); //dic.Add("iMaxColNum", "2"); //dic.Add("iSelectRowNum", "2"); //dic.Add("iSelectColNum", "2"); //dic.Add("MenuItem_1", "Run"); //dic.Add("MenuItem_2", "Future Valuation Population Projection"); //pMain._FlowTreeRightSelect(dic); //pMain._SelectTab("2014 Benchmark Val"); //dic.Clear(); //dic.Add("iMaxRowNum", ""); //dic.Add("iMaxColNum", "2"); //dic.Add("iSelectRowNum", "2"); //dic.Add("iSelectColNum", "2"); //dic.Add("MenuItem_1", "View Run Status"); //pMain._FlowTreeRightSelect(dic); //pMain._EnterpriseRun("Group Job Successfully Complete", true, "FV Proj"); //_gLib._MsgBox("", "this will cost more than two hours"); //pMain._SelectTab("2014 Benchmark Val"); //dic.Clear(); //dic.Add("iMaxRowNum", ""); //dic.Add("iMaxColNum", "2"); //dic.Add("iSelectRowNum", "2"); //dic.Add("iSelectColNum", "2"); //dic.Add("MenuItem_1", "Run"); //dic.Add("MenuItem_2", "Future Valuation Liabilities"); //pMain._FlowTreeRightSelect(dic); //dic.Clear(); //dic.Add("PopVerify", "Pop"); //dic.Add("RunValuation", "Click"); //pMain._PopVerify_RunOptions(dic); //dic.Clear(); //dic.Add("PopVerify", "Pop"); //dic.Add("isANZ", "true"); //dic.Add("OK", "Click"); //pMain._PopVerify_EnterpriseRunSubmitted(dic); //pMain._SelectTab("2014 Benchmark Val"); //dic.Clear(); //dic.Add("iMaxRowNum", ""); //dic.Add("iMaxColNum", "2"); //dic.Add("iSelectRowNum", "2"); //dic.Add("iSelectColNum", "2"); //dic.Add("MenuItem_1", "View Run Status"); //pMain._FlowTreeRightSelect(dic); //pMain._EnterpriseRun("Group Job Successfully Complete", true, "FV Liab"); //pMain._SelectTab("2014 Benchmark Val"); //dic.Clear(); //dic.Add("iMaxRowNum", ""); //dic.Add("iMaxColNum", "2"); //dic.Add("iSelectRowNum", "2"); //dic.Add("iSelectColNum", "2"); //dic.Add("MenuItem_1", "View Output"); //pMain._FlowTreeRightSelect(dic); //dic.Clear(); //dic.Add("PopVerify", "Pop"); //dic.Add("Doer", "True"); //dic.Add("Checker", ""); //dic.Add("Reviewer", ""); //dic.Add("Setup", ""); //pOutputManager._PopVerify_OutputManager(dic); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Population Projection", "Conversion", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Summary", "Conversion", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Liabilities by Group", "Conversion", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Liabilities by Year", "Conversion", false, true); pOutputManager._ExportReport_FVPayouts_PDF_EXCEL(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Conversion", false, true); if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("ANZ002_CN", sOutputFunding_2014BenchmarkVal_REVISED50YearsFV_Prod, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV); _compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_2014BenchmarkVal_REVISED50YearsFV"); _compareReportsLib.CompareExcel_Exact("FutureValuationPopulationProjection.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationSummary.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2014.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2015.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2019.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2024.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2029.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2034.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2039.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2044.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2049.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2054.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2059.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2064.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyGroup.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyYear.xlsx", 4, 0, 0, 0, true); } pMain._SelectTab("Output Manager"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); pMain._SelectTab("2014 Benchmark Val"); pMain._Home_ToolbarClick_Top(true); #endregion _gLib._MsgBox("Congratulations!", "Completed!"); }
public void test_CA004_DNT() { #region MultiThreads Thread thrd_Funding_Funding2008_Baseline = new Thread(() => new CA004_DNT().t_CompareRpt_Funding_Funding2008_Baseline(sOutputFunding_Funding2008_Baseline)); #endregion this.GenerateReportOuputDir(); #region sOutputFunding_Funding2008_Baseline pMain._SelectTab("Home"); dic.Clear(); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "FundingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "Funding2008"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("Funding2008"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_GoingConcern", "True"); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "Credited"); dic.Add("Pay", "ProjPay"); dic.Add("CurrentYear", "True"); dic.Add("PriorYear", ""); dic.Add("CashBanlance", "ErAccountBalance1"); dic.Add("Pension", "AccruedBenefit1"); dic.Add("AllLiabilityTypes", ""); dic.Add("GoingConcernLiability", "True"); dic.Add("SolvencyLiability", "False"); dic.Add("WindUpLiability", "False"); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("Funding2008"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("Funding2008"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Parameter Print", "RollForward", true, true); ////////pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Test Cases", "RollForward", true, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Reconciliation to Prior Year", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Reconciliation to Prior Year by Plan Def", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Detailed Results", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Detailed Results by Plan Def", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Status Reconciliation", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Member Statistics", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Age Service Matrix", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Data Matching Summary", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Combined Status Code Summary", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Gain / Loss Status Reconciliation", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Gain / Loss Summary of Liability Reconciliation", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Active Decrement Gain / Loss Detail", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Decrement Age", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Gain / Loss Participant Listing", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Valuation Summary", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Individual Output", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "IOE", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_Funding2008_Baseline, "Payout Projection", "RollForward", false, true); thrd_Funding_Funding2008_Baseline.Start(); pMain._SelectTab("Funding2008"); pMain._Home_ToolbarClick_Top(true); #endregion #region sOutputAccounting_Accounting2008 pMain._SelectTab("Home"); dic.Clear(); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "AccountingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "2008 Accounting"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("2008 Accounting"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("Acc_GL_PBO", "True"); dic.Add("Acc_GL_ABO", ""); dic.Add("GL_PPANAR_Min", ""); dic.Add("GL_PPANAR_Max", ""); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "$Service"); dic.Add("Pay", "ProjPay"); dic.Add("CurrentYear", "True"); dic.Add("PriorYear", ""); dic.Add("CashBanlance", "ErAccountBalance1"); dic.Add("Pension", "AccruedBenefit1"); dic.Add("AllLiabilityTypes", ""); dic.Add("Acc_ProjectedBenefitObligation", "True"); dic.Add("Acc_AccumulatedBenefitObligation", "True"); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); dic.Add("OK", ""); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("2008 Accounting"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("2008 Accounting"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Parameter Print", "RollForward", true, false); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Test Cases", "RollForward", true, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Reconciliation to Prior Year", "RollForward", false, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Reconciliation to Prior Year by Plan Def", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Detailed Results", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Detailed Results by Plan Def", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Status Reconciliation", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Member Statistics", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Age Service Matrix", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Data Matching Summary", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Combined Status Code Summary", "RollForward", false, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Gain / Loss Status Reconciliation", "RollForward", false, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Gain / Loss Summary of Liability Reconciliation", "RollForward", false, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Active Decrement Gain / Loss Detail", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Decrement Age", "RollForward", false, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Gain / Loss Participant Listing", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Valuation Summary", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Individual Output", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "IOE", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Payout Projection", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "FAS Expected Benefit Pmts", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputAccounting_Accounting2008, "Liability Set for Globe Export", "RollForward", false, false); if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("CA004DNT", sOutputAccounting_Accounting2008_Prod, sOutputAccounting_Accounting2008); _compareReportsLib._Report(_PassFailStep.Description, "", "Accounting_Accounting2008"); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_ABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_ABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("StatusReconciliation.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("AgeServiceMatrix.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DataMatchingSummary.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("CombinedStatusCodeSummary.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("GainLossStatusReconciliation_ABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("GainLossStatusReconciliation_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("GainLossSummaryofLiabilityReconciliation_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ActiveDecrementGainLossDetail_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DecrementAge.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("GainLossParticipantListing_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FASExpectedBenefitPmts.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitySetforGlobeExport.xlsx", 4, 0, 0, 0, true); } pMain._SelectTab("Output Manager"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); pMain._SelectTab("2008 Accounting"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Parameter Print"); pMain._FlowTreeRightSelect(dic); pOutputManager._ParameterPrint_Standalone(sOutputAccounting_Accounting2008); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion _gLib._MsgBox("", "please manually compare parameter print for the last node, and this client is finished"); }
public void test_US010_DNT() { #region MultiThreads Thread thrd_Funding_July2006Valuation = new Thread(() => new US010_DNT().t_CompareRpt_Funding_July2006Valuation(sOutputFunding_July2006Valuation)); Thread thrd_Funding_July2007Valuation = new Thread(() => new US010_DNT().t_CompareRpt_Funding_July2007Valuation(sOutputFunding_July2007Valuation)); Thread thrd_Accounting_July2006FASVal = new Thread(() => new US010_DNT().t_CompareRpt_Accounting_July2006FASVal(sOutputAccounting_July2006FASVal)); #endregion this.GenerateReportOuputDir(); #region sOutputFunding_July2006Valuation pMain._SelectTab("Home"); dic.Clear(); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "FundingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "July 2006 Valuation"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("July 2006 Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_PPANAR_Min", ""); dic.Add("GL_PPANAR_Max", ""); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "CreditedService"); dic.Add("Pay", "N/A"); dic.Add("CurrentYear", ""); dic.Add("PriorYear", "True"); dic.Add("CashBanlance", "N/A"); dic.Add("Pension", "Beneficiary1Percent1"); dic.Add("AllLiabilityTypes", ""); dic.Add("PPANotAtRiskLiabilityForMinimum", "True"); dic.Add("PPANotAtRiskLiabilityForMaximum", "True"); dic.Add("PPANotAtRishPresentValueOfVestedBenefits", "True"); dic.Add("PBGCNotAtRiskPresentValueOfVestedBenefits", "True"); dic.Add("FAS35PresentValueOfAccumulatedBenefits", "True"); dic.Add("FAS35PresentValueOfVestedBenefits", "True"); dic.Add("PPAAtRiskLiabilityForMinimum", ""); dic.Add("PPAAtRiskLiabilityForMaximum", ""); dic.Add("PPAAtRiskPresentValueOfVestedBenefits", ""); dic.Add("PBGCAtRiskPresentValueOfVestedBenefits", ""); dic.Add("EntryAgeNormal", ""); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("July 2006 Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("July 2006 Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_July2006Valuation, "Parameter Print", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_July2006Valuation, "Test Cases", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_July2006Valuation, "Liability Summary", "Conversion", false, true); pOutputManager._ExportReport_DrillDown_PDF_EXCEL(sOutputFunding_July2006Valuation, "Liability Summary", "Conversion", false, true, 0); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_July2006Valuation, "Member Statistics", "Conversion", false, true); pOutputManager._ExportReport_DrillDown_PDF_EXCEL(sOutputFunding_July2006Valuation, "Conversion Diagnostic", "Conversion", false, true, 0); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_July2006Valuation, "Test Case List", "Conversion", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_July2006Valuation, "Detailed Results", "Conversion", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_July2006Valuation, "Detailed Results by Plan Def", "Conversion", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_July2006Valuation, "Valuation Summary", "Conversion", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_July2006Valuation, "Individual Output", "Conversion", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_July2006Valuation, "IOE", "Conversion", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_July2006Valuation, "Payout Projection", "Conversion", false, true); thrd_Funding_July2006Valuation.Start(); pMain._SelectTab("July 2006 Valuation"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion #region sOutputFunding_July2007Valuation pMain._SelectTab("Home"); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "July 2007 Valuation"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("July 2007 Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_PPANAR_Min", "True"); dic.Add("GL_PPANAR_Max", ""); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "$Service"); dic.Add("Pay", "N/A"); dic.Add("CurrentYear", "True"); dic.Add("PriorYear", ""); dic.Add("CashBanlance", "N/A"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", ""); dic.Add("PPANotAtRiskLiabilityForMinimum", "True"); dic.Add("PPANotAtRiskLiabilityForMaximum", "True"); dic.Add("PPANotAtRishPresentValueOfVestedBenefits", "True"); dic.Add("PBGCNotAtRiskPresentValueOfVestedBenefits", "True"); dic.Add("FAS35PresentValueOfAccumulatedBenefits", "True"); dic.Add("FAS35PresentValueOfVestedBenefits", "True"); dic.Add("PPAAtRiskLiabilityForMinimum", ""); dic.Add("PPAAtRiskLiabilityForMaximum", ""); dic.Add("PPAAtRiskPresentValueOfVestedBenefits", ""); dic.Add("PBGCAtRiskPresentValueOfVestedBenefits", ""); dic.Add("EntryAgeNormal", ""); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("July 2007 Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("July 2007 Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_July2007Valuation, "Parameter Print", "RollForward", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_July2007Valuation, "Test Cases", "RollForward", true, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_July2007Valuation, "Reconciliation to Prior Year", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_July2007Valuation, "Reconciliation to Prior Year by Plan Def", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_July2007Valuation, "Detailed Results", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_July2007Valuation, "Detailed Results by Plan Def", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_July2007Valuation, "Status Reconciliation", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_July2007Valuation, "Member Statistics", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_July2007Valuation, "Individual Checking Template", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_July2007Valuation, "Age Service Matrix", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_July2007Valuation, "Data Matching Summary", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_July2007Valuation, "Combined Status Code Summary", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_July2007Valuation, "Gain / Loss Status Reconciliation", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_July2007Valuation, "Gain / Loss Summary of Liability Reconciliation", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_July2007Valuation, "Active Decrement Gain / Loss Detail", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_July2007Valuation, "Decrement Age", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_July2007Valuation, "Gain / Loss Participant Listing", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_July2007Valuation, "Valuation Summary", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_July2007Valuation, "Individual Output", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_July2007Valuation, "IOE", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_July2007Valuation, "Payout Projection", "RollForward", false, true); thrd_Funding_July2007Valuation.Start(); pMain._SelectTab("July 2007 Valuation"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion #region sOutputAccounting_July2006FASVal pMain._SelectTab("Home"); dic.Clear(); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "AccountingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "July 2006 FAS Val"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("July 2006 FAS Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_PPANAR_Min", ""); dic.Add("GL_PPANAR_Max", ""); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "$Service"); dic.Add("Pay", "N/A"); dic.Add("CurrentYear", "True"); dic.Add("PriorYear", ""); dic.Add("CashBanlance", "N/A"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", ""); dic.Add("Acc_ProjectedBenefitObligation", "True"); dic.Add("Acc_AccumulatedBenefitObligation", "True"); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); dic.Add("OK", ""); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("July 2006 FAS Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("July 2006 FAS Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_July2006FASVal, "Parameter Print", "Conversion", true, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_July2006FASVal, "Test Cases", "Conversion", true, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_July2006FASVal, "Liability Summary", "Conversion", false, false); pOutputManager._ExportReport_DrillDown_PDF_EXCEL(sOutputAccounting_July2006FASVal, "Liability Summary", "Conversion", false, false, 0); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2006FASVal, "Member Statistics", "Conversion", false, false); pOutputManager._ExportReport_DrillDown_PDF_EXCEL(sOutputAccounting_July2006FASVal, "Conversion Diagnostic", "Conversion", false, false, 0); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_July2006FASVal, "Conversion Diagnostic", "Conversion", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2006FASVal, "Test Case List", "Conversion", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2006FASVal, "Detailed Results", "Conversion", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2006FASVal, "Detailed Results by Plan Def", "Conversion", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2006FASVal, "Valuation Summary", "Conversion", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_July2006FASVal, "Individual Output", "Conversion", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_July2006FASVal, "IOE", "Conversion", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_July2006FASVal, "Payout Projection", "Conversion", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2006FASVal, "FAS Expected Benefit Pmts", "Conversion", false, false); thrd_Accounting_July2006FASVal.Start(); pMain._SelectTab("July 2006 FAS Val"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion #region sOutputAccounting_July2007FASVal pMain._SelectTab("Home"); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "July 2007 FAS Val"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("July 2007 FAS Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("Acc_GL_PBO", "True"); dic.Add("Acc_GL_ABO", "True"); dic.Add("GL_PPANAR_Min", ""); dic.Add("GL_PPANAR_Max", ""); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "$Service"); dic.Add("Pay", "N/A"); dic.Add("CurrentYear", "True"); dic.Add("PriorYear", ""); dic.Add("CashBanlance", "N/A"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", ""); dic.Add("Acc_ProjectedBenefitObligation", "True"); dic.Add("Acc_AccumulatedBenefitObligation", "True"); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); dic.Add("OK", ""); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("July 2007 FAS Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("July 2007 FAS Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Parameter Print", "RollForward", true, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Test Cases", "RollForward", true, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Reconciliation to Prior Year", "RollForward", false, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Reconciliation to Prior Year by Plan Def", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Detailed Results", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Detailed Results by Plan Def", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Status Reconciliation", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Member Statistics", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Individual Checking Template", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Age Service Matrix", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Data Matching Summary", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Combined Status Code Summary", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Gain / Loss Status Reconciliation", "RollForward", false, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Gain / Loss Summary of Liability Reconciliation", "RollForward", false, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Active Decrement Gain / Loss Detail", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Decrement Age", "RollForward", false, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Gain / Loss Participant Listing", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Valuation Summary", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Individual Output", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_July2007FASVal, "IOE", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Payout Projection", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_July2007FASVal, "FAS Expected Benefit Pmts", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_July2007FASVal, "Liability Set for Globe Export", "RollForward", false, false); if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("US010DNT", sOutputAccounting_July2007FASVal_Prod, sOutputAccounting_July2007FASVal); _compareReportsLib._Report(_PassFailStep.Description, "", "Accounting_July2007FASVal"); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_ABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_ABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("StatusReconciliation.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_MovementAndRollforward.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_OutlierSummary.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_CheckingGroupStatistics.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("AgeServiceMatrix.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("CombinedStatusCodeSummary.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DataMatchingSummary.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("GainLossStatusReconciliation.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("GainLossSummaryofLiabilityReconciliation_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("GainLossSummaryofLiabilityReconciliation_ABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ActiveDecrementGainLossDetail_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ActiveDecrementGainLossDetail_ABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DecrementAge.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("GainLossParticipantListing_PBO.xlsx", 0, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("GainLossParticipantListing_ABO.xlsx", 0, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FASExpectedBenefitPmts.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitySetforGlobeExport.xlsx", 4, 0, 0, 0, true); } pMain._SelectTab("Output Manager"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); pMain._SelectTab("July 2007 FAS Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Parameter Print"); pMain._FlowTreeRightSelect(dic); pOutputManager._ParameterPrint_Standalone(sOutputAccounting_July2007FASVal); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion _gLib._MsgBox("", "please manually compare parameter print for the last node, and this client is finished"); }
public void t_CompareRpt_2010Valuation_AddDecrements(string sOutputFunding_2010Valuation_AddDecrements) { if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("IR001DNT", sOutputFunding_2010Valuation_AddDecrements_Prod, sOutputFunding_2010Valuation_AddDecrements); _compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_2010Valuation_AddDecrements"); _compareReportsLib.CompareExcel_Exact("LiabilityScenario_Solvency.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilityScenario_GoingConcern.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilityScenarioByPlanDef_Solvency.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilityScenarioByPlanDef_GoingConcern.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_Solvency.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_GoingConcern.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationToBaselineByPlanDef_Solvency.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationToBaselineByPlanDef_GoingConcern.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResults.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultsByPlanDef.xlsx", 4, 0, 0, 0); Config.bThreadFinsihed = true; } }
public void test_IR001_DNT() { #region MultiThreads Thread thrd_Valuation2009_AttainedAge = new Thread(() => new IR001_DNT().t_CompareRpt_Valuation2009_AttainedAge(sOutputFunding_Valuation2009_AttainedAge)); Thread thrd_2010Valuation_AddDecrements = new Thread(() => new IR001_DNT().t_CompareRpt_2010Valuation_AddDecrements(sOutputFunding_2010Valuation_AddDecrements)); Thread thrd_FASValuation2009 = new Thread(() => new IR001_DNT().t_CompareRpt_FASValuation2009(sOutputAccounting_FASValuation2009)); #endregion this.GenerateReportOuputDir(); #region sOutputFunding_Valuation2009_AttainedAge pMain._SelectTab("Home"); dic.Clear(); dic.Add("Country", Config.eCountry.ToString()); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "FundingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "Valuation 2009"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("Valuation 2009"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_GoingConcern", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "TotalService"); dic.Add("Pay", "PensionableSalary"); dic.Add("CurrentYear", "True"); dic.Add("PriorYear", ""); dic.Add("CashBanlance", "AdjustedInPayPension"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", ""); dic.Add("GoingConcernLiability", "True"); dic.Add("SolvencyLiability", "True"); dic.Add("WindUpLiability", ""); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("Valuation 2009"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("Valuation 2009"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_Valuation2009_AttainedAge, "Parameter Print", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_Valuation2009_AttainedAge, "Test Cases", "Conversion", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2009_AttainedAge, "Valuation Summary", "Conversion", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_Valuation2009_AttainedAge, "Individual Output", "Conversion", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_Valuation2009_AttainedAge, "IOE", "Conversion", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_Valuation2009_AttainedAge, "Payout Projection", "Conversion", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_Valuation2009_AttainedAge, "Reconciliation to Baseline", "Conversion", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_Valuation2009_AttainedAge, "Reconciliation to Baseline by Plan Def", "Conversion", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2009_AttainedAge, "Liabilities Detailed Results", "Conversion", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2009_AttainedAge, "Liabilities Detailed Results by Plan Def", "Conversion", false, true); thrd_Valuation2009_AttainedAge.Start(); pMain._SelectTab("Valuation 2009"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion #region sOutputFunding_2010Valuation_AddDecrements pMain._SelectTab("Home"); dic.Clear(); dic.Add("Country", Config.eCountry.ToString()); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "FundingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "2010 Valuation"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("2010 Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "3"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_GoingConcern", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "TotalService"); dic.Add("Pay", "PensionableSalary"); dic.Add("CurrentYear", "True"); dic.Add("PriorYear", ""); dic.Add("CashBanlance", "AdjustedInPayPension"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", ""); dic.Add("GoingConcernLiability", "True"); dic.Add("SolvencyLiability", "True"); dic.Add("WindUpLiability", ""); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("2010 Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "3"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("2010 Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "3"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_2010Valuation_AddDecrements, "Parameter Print", "RollForward", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_2010Valuation_AddDecrements, "Test Cases", "RollForward", true, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputFunding_2010Valuation_AddDecrements, "Liability Scenario", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputFunding_2010Valuation_AddDecrements, "Liability Scenario by Plan Def", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_2010Valuation_AddDecrements, "Valuation Summary", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_2010Valuation_AddDecrements, "Individual Output", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_2010Valuation_AddDecrements, "IOE", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_2010Valuation_AddDecrements, "Payout Projection", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputFunding_2010Valuation_AddDecrements, "Reconciliation to Baseline", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputFunding_2010Valuation_AddDecrements, "Reconciliation to Baseline by Plan Def", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_2010Valuation_AddDecrements, "Liabilities Detailed Results", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_2010Valuation_AddDecrements, "Liabilities Detailed Results by Plan Def", "RollForward", false, true); thrd_2010Valuation_AddDecrements.Start(); pMain._SelectTab("2010 Valuation"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion #region sOutputAccounting_FASValuation2009 pMain._SelectTab("Home"); dic.Clear(); dic.Add("Country", Config.eCountry.ToString()); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "AccountingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "FAS Valuation 2009"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("FAS Valuation 2009"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_GoingConcern", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "TotalService"); dic.Add("Pay", "PensionableSalary"); dic.Add("CurrentYear", ""); dic.Add("PriorYear", "True"); dic.Add("CashBanlance", "AdjustedInPayPension"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", ""); dic.Add("GoingConcernLiability", ""); dic.Add("SolvencyLiability", ""); dic.Add("WindUpLiability", ""); dic.Add("Acc_ProjectedBenefitObligation", "True"); dic.Add("Acc_AccumulatedBenefitObligation", "True"); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("FAS Valuation 2009"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("FAS Valuation 2009"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_FASValuation2009, "Parameter Print", "Conversion", true, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_FASValuation2009, "Test Cases", "Conversion", true, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_FASValuation2009, "Liability Summary", "Conversion", false, false); pOutputManager._ExportReport_DrillDown_PDF_EXCEL(sOutputAccounting_FASValuation2009, "Liability Summary", "Conversion", false, false, 0); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_FASValuation2009, "Member Statistics", "Conversion", false, false); pOutputManager._ExportReport_DrillDown_PDF_EXCEL(sOutputAccounting_FASValuation2009, "Conversion Diagnostic", "Conversion", false, false, 0); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_FASValuation2009, "Conversion Diagnostic", "Conversion", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_FASValuation2009, "Test Case List", "Conversion", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_FASValuation2009, "Detailed Results", "Conversion", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_FASValuation2009, "Detailed Results by Plan Def", "Conversion", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_FASValuation2009, "Valuation Summary", "Conversion", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_FASValuation2009, "Individual Output", "Conversion", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_FASValuation2009, "IOE", "Conversion", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_FASValuation2009, "Payout Projection", "Conversion", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_FASValuation2009, "FAS Expected Benefit Pmts", "Conversion", false, false); thrd_FASValuation2009.Start(); pMain._SelectTab("FAS Valuation 2009"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion #region sOutputAccounting_FASValuation2010_AddDecrements pMain._SelectTab("Home"); dic.Clear(); dic.Add("Country", Config.eCountry.ToString()); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "AccountingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "FAS Valuation 2010"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("FAS Valuation 2010"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "3"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("Acc_GL_PBO", ""); dic.Add("Acc_GL_ABO", ""); dic.Add("GL_PPANAR_Min", ""); dic.Add("GL_PPANAR_Max", ""); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "TotalService"); dic.Add("Pay", "PensionableSalary"); dic.Add("CurrentYear", ""); dic.Add("PriorYear", "True"); dic.Add("CashBanlance", "AdjustedInPayPension"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", ""); dic.Add("Acc_ProjectedBenefitObligation", "True"); dic.Add("Acc_AccumulatedBenefitObligation", "True"); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); dic.Add("OK", ""); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("FAS Valuation 2010"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "3"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("FAS Valuation 2010"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "3"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputAccounting_FASValuation2010_AddDecrements, "Parameter Print", "RollForward", true, false); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputAccounting_FASValuation2010_AddDecrements, "Test Cases", "RollForward", true, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputAccounting_FASValuation2010_AddDecrements, "Liability Scenario", "RollForward", false, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputAccounting_FASValuation2010_AddDecrements, "Liability Scenario by Plan Def", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputAccounting_FASValuation2010_AddDecrements, "Valuation Summary", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputAccounting_FASValuation2010_AddDecrements, "Individual Output", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputAccounting_FASValuation2010_AddDecrements, "IOE", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputAccounting_FASValuation2010_AddDecrements, "Payout Projection", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputAccounting_FASValuation2010_AddDecrements, "FAS Expected Benefit Pmts", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputAccounting_FASValuation2010_AddDecrements, "Liability Set for Globe Export", "RollForward", false, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputAccounting_FASValuation2010_AddDecrements, "Reconciliation to Baseline", "RollForward", false, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(Config.eCountry, sOutputAccounting_FASValuation2010_AddDecrements, "Reconciliation to Baseline by Plan Def", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputAccounting_FASValuation2010_AddDecrements, "Liabilities Detailed Results", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputAccounting_FASValuation2010_AddDecrements, "Liabilities Detailed Results by Plan Def", "RollForward", false, false); if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("IR001DNT", sOutputAccounting_FASValuation2010_AddDecrements_Prod, sOutputAccounting_FASValuation2010_AddDecrements); _compareReportsLib._Report(_PassFailStep.Description, "", "sOutputAccounting_FASValuation2010_AddDecrements"); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FASExpectedBenefitPmts.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilityScenario_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilityScenario_ABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_ABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_ABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_ABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResults.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitySetforGlobeExport.xlsx", 4, 0, 0, 0, true); } pMain._SelectTab("Output Manager"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); pMain._SelectTab("FAS Valuation 2010"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "3"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Parameter Print"); pMain._FlowTreeRightSelect(dic); pOutputManager._ParameterPrint_Standalone(sOutputAccounting_FASValuation2010_AddDecrements); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion _gLib._MsgBox("", "please manually compare parameter print for the last node, and this client is finished"); }
void t_CompareRpt_Funding2005(string sOutputFunding2005) { if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("US007DNT", sOutputFunding2005_Prod, sOutputFunding2005); _compareReportsLib._Report(_PassFailStep.Description, "", "Funding2005"); _compareReportsLib.CompareExcel_Exact("LiabilitySummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_ActiveMembers.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_DeferredMembers.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_Pensioners.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByNone.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByStatusCodes.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByCustom_Gender.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0); Config.bThreadFinsihed = true; } }
public void test_DE007_DNT() { #region MultiThreads Thread thrd_Conversion2010 = new Thread(() => new DE007_DNT().t_CompareRpt_Conversion2010(sOutputPension_Conversion2010)); #endregion this.GenerateReportOuputDir(); #region sOutputPension_Conversion2010 pMain._SelectTab("Home"); dic.Clear(); dic.Add("Country", Config.eCountry.ToString()); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "PensionValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "Conversion 2010"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("Conversion 2010"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("PayoutProjection", "True"); dic.Add("ApplyWithdrawalAdjustment", "True"); dic.Add("IncludeIOE", ""); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("SaveResultsforAuditReport", ""); dic.Add("ApplyOverrides", "True"); dic.Add("RunLocally", ""); dic.Add("Pay", "PP_PayProjection"); dic.Add("CurrentYear", "True"); dic.Add("PriorYear", ""); dic.Add("BreakByFundingVehicle", "True"); dic.Add("UseReportBreaks", "True"); dic.Add("AllLiabilityTypes", ""); dic.Add("Tax", "True"); dic.Add("Trade", "True"); dic.Add("InternationalAccountingABO", "True"); dic.Add("InternationalAccountingPBO", "True"); dic.Add("SelectVOs_AllVOs", ""); dic.Add("SelectVOs_VO1", "COND"); dic.Add("SelectVOs_VO2", ""); dic.Add("SelectVOs_VO3", ""); dic.Add("SelectVOs_VO4", ""); dic.Add("SelectVOs_VO5", ""); dic.Add("SelectVOs_VO6", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("Conversion 2010"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("Conversion 2010"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); if (Config.bDownloadReports_PDF) { pOutputManager._ExportReport_Others(sOutputPension_Conversion2010, "Liability Summary", "Conversion", true, true); pOutputManager._ExportReport_Common(sOutputPension_Conversion2010, "Member Statistics", "Conversion", true, true); pOutputManager._ExportReport_Others(sOutputPension_Conversion2010, "Conversion Diagnostic", "Conversion", true, true); pOutputManager._ExportReport_Common(sOutputPension_Conversion2010, "Test Case List", "Conversion", true, true); pOutputManager._ExportReport_Common(sOutputPension_Conversion2010, "Detailed Results", "Conversion", true, true); pOutputManager._ExportReport_Common(sOutputPension_Conversion2010, "Valuation Summary", "Conversion", true, true); pOutputManager._ExportReport_Common(sOutputPension_Conversion2010, "Valuation Summary for Excel Export", "Conversion", true, true); pOutputManager._ExportReport_Others(sOutputPension_Conversion2010, "Individual Output", "Conversion", true, true); pOutputManager._ExportReport_Others(sOutputPension_Conversion2010, "Parameter Print", "Conversion", true, true); pOutputManager._ExportReport_Others(sOutputPension_Conversion2010, "Parameter Summary", "Conversion", true, true); pOutputManager._ExportReport_Others(Config.eCountry, sOutputPension_Conversion2010, "Test Cases", "Conversion", true, true); pOutputManager._ExportReport_Others(Config.eCountry, sOutputPension_Conversion2010, "Payout Projection", "Conversion", true, true); pOutputManager._ExportReport_DrillDown(Config.eCountry, sOutputPension_Conversion2010, "Member Statistics", "Conversion", true, false, 0, new string[1] { "DriectPromise" }); pOutputManager._ExportReport_DrillDown(Config.eCountry, sOutputPension_Conversion2010, "Valuation Summary", "Conversion", true, false, 0, new string[1] { "DriectPromise" }); dic.Clear(); dic.Add("Group_ReportBreak", "True"); pOutputManager._ExportReport_Custom(Config.eCountry, sOutputPension_Conversion2010, "Payout Projection", "Conversion", true, true, dic); } if (Config.bDownloadReports_EXCEL) { pOutputManager._ExportReport_Others(sOutputPension_Conversion2010, "Liability Summary", "Conversion", false, true); pOutputManager._ExportReport_Common(sOutputPension_Conversion2010, "Member Statistics", "Conversion", false, true); pOutputManager._ExportReport_Others(sOutputPension_Conversion2010, "Conversion Diagnostic", "Conversion", false, true); pOutputManager._ExportReport_Common(sOutputPension_Conversion2010, "Test Case List", "Conversion", false, true); pOutputManager._ExportReport_Common(sOutputPension_Conversion2010, "Detailed Results", "Conversion", false, true); pOutputManager._ExportReport_Common(sOutputPension_Conversion2010, "Detailed Results by Plan Def", "Conversion", false, true); pOutputManager._ExportReport_Common(sOutputPension_Conversion2010, "Valuation Summary", "Conversion", false, true); pOutputManager._ExportReport_Common(sOutputPension_Conversion2010, "Valuation Summary for Excel Export", "Conversion", false, true); pOutputManager._ExportReport_Others(sOutputPension_Conversion2010, "Individual Output", "Conversion", false, true); pOutputManager._ExportReport_Others(sOutputPension_Conversion2010, "IOE", "Conversion", false, true); pOutputManager._ExportReport_Others(Config.eCountry, sOutputPension_Conversion2010, "Payout Projection", "Conversion", false, true); pOutputManager._ExportReport_DrillDown(Config.eCountry, sOutputPension_Conversion2010, "Member Statistics", "Conversion", false, true, 0, new string[1] { "DriectPromise" }); pOutputManager._ExportReport_DrillDown(Config.eCountry, sOutputPension_Conversion2010, "Valuation Summary", "Conversion", false, true, 0, new string[1] { "DriectPromise" }); dic.Clear(); dic.Add("Group_ReportBreak", "True"); pOutputManager._ExportReport_Custom(Config.eCountry, sOutputPension_Conversion2010, "Payout Projection", "Conversion", false, true, dic); } thrd_Conversion2010.Start(); pMain._SelectTab("Conversion 2010"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion #region sOutputPension_Stichtag2011_IFRSneueAnnahmen pMain._SelectTab("Home"); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "Stichtag 2011 Final"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("Stichtag 2011 Final"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "3"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("PayoutProjection", "True"); dic.Add("ApplyWithdrawalAdjustment", "True"); dic.Add("IncludeIOE", ""); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("SaveResultsforAuditReport", "True"); dic.Add("ApplyOverrides", "True"); dic.Add("RunLocally", ""); dic.Add("Pay", "PP_PayProjection"); dic.Add("CurrentYear", "True"); dic.Add("PriorYear", ""); dic.Add("BreakByFundingVehicle", "True"); dic.Add("UseReportBreaks", "True"); dic.Add("AllLiabilityTypes", ""); dic.Add("Tax", "True"); dic.Add("Trade", "True"); dic.Add("InternationalAccountingABO", "True"); dic.Add("InternationalAccountingPBO", "True"); dic.Add("SelectVOs_AllVOs", ""); dic.Add("SelectVOs_VO1", "COND"); dic.Add("SelectVOs_VO2", ""); dic.Add("SelectVOs_VO3", ""); dic.Add("SelectVOs_VO4", ""); dic.Add("SelectVOs_VO5", ""); dic.Add("SelectVOs_VO6", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("Stichtag 2011 Final"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "3"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("Stichtag 2011 Final"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "3"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Parameter Print", "RollForward", true, true); pOutputManager._ExportReport_Others(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Parameter Summary", "RollForward", true, true); pOutputManager._ExportReport_Others(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Test Cases", "RollForward", true, true); if (Config.bDownloadReports_PDF) { pOutputManager._ExportReport_SubReports(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Liability Scenario", "RollForward", true, true); pOutputManager._ExportReport_Common(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Valuation Summary", "RollForward", true, true); pOutputManager._ExportReport_Common(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Valuation Summary for Excel Export", "RollForward", true, true); pOutputManager._ExportReport_Others(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Individual Output", "RollForward", true, true); pOutputManager._ExportReport_Others(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Payout Projection", "RollForward", true, true); pOutputManager._ExportReport_Common(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "FAS Expected Benefit Pmts", "RollForward", true, true); pOutputManager._ExportReport_DrillDown(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Valuation Summary", "RollForward", true, true, 0, new string[1] { "DirectPromise" }); pOutputManager._ExportReport_DrillDown(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "FAS Expected Benefit Pmts", "RollForward", true, true, 0, new string[1] { "ALL" }); pOutputManager._ExportReport_DrillDown(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Liability Set for Globe Export", "RollForward", true, true, 0, new string[1] { "ALL" }); dic.Clear(); dic.Add("Group_ReportBreak", "True"); pOutputManager._ExportReport_Custom(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Payout Projection", "RollForward", true, true, dic); pOutputManager._ExportReport_SubReports(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Reconciliation to Baseline", "RollForward", true, true); pOutputManager._ExportReport_Common(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Liabilities Detailed Results", "RollForward", true, true); } if (Config.bDownloadReports_EXCEL) { pOutputManager._ExportReport_SubReports(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Liability Scenario", "RollForward", false, true); pOutputManager._ExportReport_SubReports(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Liability Scenario by Plan Def", "RollForward", false, true); pOutputManager._ExportReport_Common(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Valuation Summary", "RollForward", false, true); pOutputManager._ExportReport_Common(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Valuation Summary for Excel Export", "RollForward", false, true); pOutputManager._ExportReport_Others(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Individual Output", "RollForward", false, true); pOutputManager._ExportReport_Others(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "IOE", "RollForward", false, true); pOutputManager._ExportReport_Others(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Payout Projection", "RollForward", false, true); pOutputManager._ExportReport_Common(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "FAS Expected Benefit Pmts", "RollForward", false, true); pOutputManager._ExportReport_DrillDown(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Valuation Summary", "RollForward", false, true, 0, new string[1] { "DirectPromise" }); pOutputManager._ExportReport_DrillDown(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "FAS Expected Benefit Pmts", "RollForward", false, true, 0, new string[1] { "ALL" }); pOutputManager._ExportReport_DrillDown(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Liability Set for Globe Export", "RollForward", false, true, 0, new string[1] { "ALL" }); dic.Clear(); dic.Add("Group_ReportBreak", "True"); pOutputManager._ExportReport_Custom(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Payout Projection", "RollForward", false, true, dic); pOutputManager._ExportReport_SubReports(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Reconciliation to Baseline", "RollForward", false, true); pOutputManager._ExportReport_SubReports(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Reconciliation to Baseline by Plan Def", "RollForward", false, true); pOutputManager._ExportReport_Common(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Liabilities Detailed Results", "RollForward", false, true); pOutputManager._ExportReport_Common(Config.eCountry, sOutputPension_Stichtag2011_IFRSneueAnnahmen, "Liabilities Detailed Results by Plan Def", "RollForward", false, true); } if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("DE007DNT", sOutputPension_Stichtag2011_IFRSneueAnnahmen_Prod, sOutputPension_Stichtag2011_IFRSneueAnnahmen); _compareReportsLib._Report(_PassFailStep.Description, "", "sOutputPension_Stichtag2011_IFRSneueAnnahmen"); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummary_DirectPromise.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummaryforExcelExport.xlsx", 0, new int[0, 0] { }, new string[1] { "Tabellenblatt2" }, true); _compareReportsLib.CompareExcel_Exact("ValuationSummaryforExcelExport.xlsx", 0, new int[0, 0] { }, new string[1] { "Tabellenblatt3" }, true); //////_compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0 ,true); _compareReportsLib.CompareExcel_Exact("FASExpectedBenefitPmts.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FASExpectedBenefitPmts_ALL.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("PayoutProjection_ReportBreak.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_Tax.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_Trade.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_IntlAccountingPBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_IntlAccountingABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_Tax.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_Trade.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_IntlAccountingPBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_IntlAccountingABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResults.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitySetforGlobeExport_ALL.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilityScenario_Tax.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilityScenario_Trade.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilityScenario_IntlAccountingPBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilityScenario_IntlAccountingABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_Tax.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_Trade.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_IntlAccountingPBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_IntlAccountingABO.xlsx", 4, 0, 0, 0, true); } pMain._SelectTab("Stichtag 2011 Final"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion _gLib._MsgBox("Congratulations!", "Finished!"); }
public void t_CompareRpt_Conversion2010(string sOutputPension_Conversion2010) { if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("DE007DNT", sOutputPension_Conversion2010_Prod, sOutputPension_Conversion2010); _compareReportsLib._Report(_PassFailStep.Description, "", "sOutputPension_Conversion2010"); _compareReportsLib.CompareExcel_Exact("LiabilitySummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("MemberStatistics_DriectPromise.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ValuationSummaryforExcelExport.xlsx", 0, new int[0, 0] { }, new string[1] { "Tabellenblatt2" }); _compareReportsLib.CompareExcel_Exact("ValuationSummaryforExcelExport.xlsx", 0, new int[0, 0] { }, new string[1] { "Tabellenblatt3" }); _compareReportsLib.CompareExcel_Exact("ValuationSummary_DriectPromise.xlsx", 11, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0); //////////_compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("PayoutProjection_ReportBreak.xlsx", 4, 0, 0, 0); Config.bThreadFinsihed = true; } }
void t_CompareRpt_Accounting_July2006FASVal(string sOutputAccounting_July2006FASVal) { if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("US010DNT", sOutputAccounting_July2006FASVal_Prod, sOutputAccounting_July2006FASVal); _compareReportsLib._Report(_PassFailStep.Description, "", "Accounting_July2006FASVal"); _compareReportsLib.CompareExcel_Exact("LiabilitySummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_ActiveMembers.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_DeferredMembers.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_Pensioners.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByNone.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByStatusCodes.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByCustom_Gender.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("TestCaseList.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FASExpectedBenefitPmts.xlsx", 4, 0, 0, 0); Config.bThreadFinsihed = true; } }
void t_CompareRpt_Funding_Funding2008_Baseline(string sOutputFunding_Funding2008_Baseline) { if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("CA004DNT", sOutputFunding_Funding2008_Baseline_Prod, sOutputFunding_Funding2008_Baseline); _compareReportsLib._Report(_PassFailStep.Description, "", "Funding_Funding2008_Baseline"); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_GoingConcern.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationToPriorYearByPlanDef_GoingConcern.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("StatusReconciliation.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("AgeServiceMatrix.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DataMatchingSummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("CombinedStatusCodeSummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("GainLossStatusReconciliation_GoingConcern.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("GainLossSummaryofLiabilityReconciliation_GoingConcern.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ActiveDecrementGainLossDetail_GoingConcern.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DecrementAge.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("GainLossParticipantListing.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("PayoutProjection_GoingConcern.xlsx", 4, 0, 0, 0); Config.bThreadFinsihed = true; } }
public void test_US019_DNT() { #region MultiThreads Thread thrd_Funding2018_OptOutPrescribedMort = new Thread(() => new US019_DNT().t_CompareRpt_Funding2018_OptOutPrescribedMort(sFunding2018_OptOutPrescribedMort)); #endregion this.GenerateReportOuputDir(); #region 1.1.2018 Funding Valuation - OptOut_PrescribedMort node pMain._SelectTab("Home"); dic.Clear(); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "FundingValuations"); pMain._HomeTreeViewSelect(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "1.1.2018 Funding Valuation"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("1.1.2018 Funding Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_PPANAR_Min", ""); dic.Add("GL_PPANAR_Max", ""); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "$Service"); dic.Add("Pay", "N/A"); dic.Add("CurrentYear", ""); dic.Add("PriorYear", "True"); dic.Add("CashBanlance", "AccruedBenefit1"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", ""); dic.Add("PPANotAtRiskLiabilityForMinimum", "True"); dic.Add("PPANotAtRiskLiabilityForMaximum", "True"); dic.Add("PPANotAtRishPresentValueOfVestedBenefits", "True"); dic.Add("PBGCNotAtRiskPresentValueOfVestedBenefits", "False"); dic.Add("FAS35PresentValueOfAccumulatedBenefits", "False"); dic.Add("FAS35PresentValueOfVestedBenefits", "False"); dic.Add("PPAAtRiskLiabilityForMinimum", ""); dic.Add("PPAAtRiskLiabilityForMaximum", ""); dic.Add("PPAAtRiskPresentValueOfVestedBenefits", ""); dic.Add("PBGCAtRiskPresentValueOfVestedBenefits", ""); dic.Add("EntryAgeNormal", ""); dic.Add("PayoutProjectionCustomGroup", "DivisionCode"); dic.Add("RunValuation", "Click"); dic.Add("OK", ""); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("1.1.2018 Funding Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("1.1.2018 Funding Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others_PDF_EXCEL(sFunding2018_OptOutPrescribedMort, "Parameter Print", "RollForward", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sFunding2018_OptOutPrescribedMort, "Test Cases", "RollForward", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sFunding2018_OptOutPrescribedMort, "Valuation Summary", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sFunding2018_OptOutPrescribedMort, "Individual Output", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sFunding2018_OptOutPrescribedMort, "IOE", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sFunding2018_OptOutPrescribedMort, "Payout Projection", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sFunding2018_OptOutPrescribedMort, "Reconciliation to Baseline", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sFunding2018_OptOutPrescribedMort, "Reconciliation to Baseline by Plan Def", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sFunding2018_OptOutPrescribedMort, "Liabilities Detailed Results", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sFunding2018_OptOutPrescribedMort, "Liabilities Detailed Results by Plan Def", "RollForward", false, true); thrd_Funding2018_OptOutPrescribedMort.Start(); pMain._SelectTab("Output Manager"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); pMain._SelectTab("1.1.2018 Funding Valuation"); pMain._Home_ToolbarClick_Top(true); #endregion #region 1.1.2018 Accounting Valuation pMain._SelectTab("Home"); dic.Clear(); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "AccountingValuations"); pMain._HomeTreeViewSelect(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "1.1.2018 Accounting Valuation"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("1.1.2018 Accounting Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Future Valuation Population Projection"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("IAgreeToUnlock", "True"); dic.Add("OK", "Click"); pMain._PopVerify_CascadingUnlock(dic); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true, "FV Proj"); pMain._SelectTab("1.1.2018 Accounting Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Future Valuation Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_PPANAR_Min", ""); dic.Add("GL_PPANAR_Max", ""); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", ""); dic.Add("IncludeIOE", ""); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", ""); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "$Service"); dic.Add("Pay", "N/A"); dic.Add("CurrentYear", ""); dic.Add("PriorYear", "True"); dic.Add("CashBanlance", "AccruedBenefit1"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", ""); dic.Add("Acc_ProjectedBenefitObligation", "True"); dic.Add("Acc_AccumulatedBenefitObligation", "True"); dic.Add("PPANotAtRiskLiabilityForMinimum", ""); dic.Add("PPANotAtRiskLiabilityForMaximum", ""); dic.Add("PPANotAtRishPresentValueOfVestedBenefits", ""); dic.Add("PBGCNotAtRiskPresentValueOfVestedBenefits", ""); dic.Add("FAS35PresentValueOfAccumulatedBenefits", ""); dic.Add("FAS35PresentValueOfVestedBenefits", ""); dic.Add("PPAAtRiskLiabilityForMinimum", ""); dic.Add("PPAAtRiskLiabilityForMaximum", ""); dic.Add("PPAAtRiskPresentValueOfVestedBenefits", ""); dic.Add("PBGCAtRiskPresentValueOfVestedBenefits", ""); dic.Add("EntryAgeNormal", ""); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("1.1.2018 Accounting Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true, "FV Liab"); pMain._SelectTab("1.1.2018 Accounting Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others_PDF_EXCEL(sAccounting2018_FutureValRun, "Future Valuation Parameter Print", "RollForward", true, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sAccounting2018_FutureValRun, "Future Valuation Population Projection", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sAccounting2018_FutureValRun, "Future Valuation Summary", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sAccounting2018_FutureValRun, "Future Valuation Liabilities by Group", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sAccounting2018_FutureValRun, "Future Valuation Liabilities by Year", "RollForward", false, false); pOutputManager._ExportReport_FVPayouts_PDF_EXCEL(Config.eCountry, sAccounting2018_FutureValRun, "RollForward", false, false); if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("US019DNT", sAccounting2018_FutureValRun_Prod, sAccounting2018_FutureValRun); _compareReportsLib._Report(_PassFailStep.Description, "", "sAccounting2018_FutureValRun"); _compareReportsLib.CompareExcel_Exact("FutureValuationPopulationProjection.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationSummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2018.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2019.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2020.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2021.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2022.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2023.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2024.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2025.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2026.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2027.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2028.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2033.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2038.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyGroup.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyYear.xlsx", 4, 0, 0, 0); } #endregion _gLib._MsgBox("Congratulations!", "Finnally, you are done with US019!"); }
public void test_US009_CN() { #region MultiThreads Thread thrd_Funding_2006Funding_Baseline = new Thread(() => new US009_CN().t_CompareRpt_Funding_2006Funding_Baseline(sOutputFunding_2006Funding_Baseline)); #endregion this.GenerateReportOuputDir(); #region FundingValuations -- 2006 Funding #region 2006 Funding - create Service pMain._SelectTab("Home"); dic.Clear(); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "FundingValuations"); pMain._HomeTreeViewSelect(0, dic); _gLib._MsgBox("", "please delete RollForward service"); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", "Click"); dic.Add("ServiceToOpen", ""); pMain._PopVerify_Home_RightPane(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("ConversionService", ""); dic.Add("Name", "2006 Funding"); dic.Add("Parent", "2005 Funding"); dic.Add("ParentFinalValuationSet", ""); dic.Add("PlanYearBeginningIn", "2006"); dic.Add("FirstYearPlanUnderPPA", ""); dic.Add("RSC", ""); dic.Add("LocalMarket", ""); dic.Add("Shared", ""); dic.Add("OK", "Click"); dic.Add("Cancel", ""); pMain._PopVerify_Home_ServicePropeties(dic); pMain._SelectTab("Home"); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "2006 Funding"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("2006 Funding"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Roll Forward"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("ValNodeName", ""); dic.Add("LiabilityValuationDate", ""); dic.Add("Data_AddNew", "True"); dic.Add("Data_Name", ""); dic.Add("Data_Edit", ""); dic.Add("Assumptions_AddNew", ""); dic.Add("Assumptions_Name", ""); dic.Add("Assumptions_Edit", ""); dic.Add("MethodsLiabilities_AddNew", ""); dic.Add("MethodsLiabilities_Name", ""); dic.Add("MethodsLiabilities_Edit", ""); dic.Add("Provisions_AddNew", ""); dic.Add("Provisions_Name", ""); dic.Add("Provisions_Edit", ""); dic.Add("FundingInformation_AddNew", ""); dic.Add("FundingInformation_Name", ""); dic.Add("FundingInformation_Edit", ""); dic.Add("OK", "Click"); dic.Add("Cancel", ""); pMain._PopVerify_ValuationNodeProperties(dic); #endregion #region 2006 Funding - ParticipantData pMain._SelectTab("2006 Funding"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Data"); dic.Add("MenuItem_2", "Edit Parameters"); pMain._FlowTreeRightSelect(dic); pMain._SelectTab("Participant DataSet"); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("DataEffectiveDate", ""); dic.Add("Snapshot", "True"); dic.Add("GRSUnload", ""); dic.Add("GotoDataSystem", "Click"); dic.Add("AddField", ""); dic.Add("GRSInformation", ""); dic.Add("ImportDataandApplyMapping", ""); pParticipantDataSet._PopVerify_ParticipantDataSet(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("SnapshotName", "Snapshots2006"); dic.Add("SnapshotName_Parent", ""); dic.Add("OK", "Click"); dic.Add("RetainThePreviousUnload", ""); dic.Add("SpecifyANewSnapshotRetainingPrevious", ""); dic.Add("SpecifyANewSnapshotRevertingAllFields", ""); dic.Add("SpecifyANewUnload", ""); dic.Add("SelectSnapshotOption_OK", "Click"); pParticipantDataSet._PopVerify_SelectSnapshotDefinition(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("DataEffectiveDate", ""); dic.Add("Snapshot", ""); dic.Add("GRSUnload", ""); dic.Add("GotoDataSystem", ""); dic.Add("AddField", ""); dic.Add("GRSInformation", ""); dic.Add("CompareData", "False"); dic.Add("ImportDataandApplyMapping", "Click"); pParticipantDataSet._PopVerify_ParticipantDataSet(dic); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion #region 2006 Funding - Test Case pMain._SelectTab("2006 Funding"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Test Case"); pMain._FlowTreeRightSelect(dic); pMain._SelectTab("Test Case Library"); dic.Clear(); dic.Add("SelectionCriteria", "$emp.birthdate=\"9/19/1948\""); dic.Add("iResultRow", "1"); pTestCaseLibrary._AddTestCase(dic); dic.Clear(); dic.Add("SelectionCriteria", "$emp.birthdate=\"9/24/1905\""); dic.Add("iResultRow", "1"); pTestCaseLibrary._AddTestCase(dic); dic.Clear(); dic.Add("SelectionCriteria", "$emp.birthdate=\"6/29/1945\""); dic.Add("iResultRow", "1"); pTestCaseLibrary._AddTestCase(dic); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion #region 2006 Funding - Run Liability pMain._SelectTab("2006 Funding"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_PPANAR_Min", "True"); dic.Add("GL_PPANAR_Max", "True"); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", "True"); dic.Add("IncludeGainLossAgeGroupReportFields", ""); dic.Add("Service", "VestingService"); dic.Add("Pay", "NewPayProjection1"); dic.Add("CurrentYear", "True"); dic.Add("PriorYear", ""); dic.Add("CashBanlance", "N/A"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", ""); dic.Add("PPANotAtRiskLiabilityForMinimum", "True"); dic.Add("PPANotAtRiskLiabilityForMaximum", "True"); dic.Add("PPANotAtRishPresentValueOfVestedBenefits", "True"); dic.Add("PBGCNotAtRiskPresentValueOfVestedBenefits", "True"); dic.Add("FAS35PresentValueOfAccumulatedBenefits", "True"); dic.Add("FAS35PresentValueOfVestedBenefits", "True"); dic.Add("PPAAtRiskLiabilityForMinimum", "False"); dic.Add("PPAAtRiskLiabilityForMaximum", "False"); dic.Add("PPAAtRiskPresentValueOfVestedBenefits", "False"); dic.Add("PBGCAtRiskPresentValueOfVestedBenefits", "False"); dic.Add("EntryAgeNormal", "False"); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._Home_ToolbarClick_Top(false); #endregion #region 2006 Funding - Download reports pMain._SelectTab("2006 Funding"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); ////dic.Clear(); ////dic.Add("PopVerify", "Pop"); ////dic.Add("RemoveAll", ""); ////dic.Add("AddAll", "Click"); ////dic.Add("Node", ""); ////dic.Add("Add", ""); ////dic.Add("ShowSubtotalBreaks", ""); ////dic.Add("OK", "Click"); ////pOutputManager._PopVerify_OutputManagerSetup(dic); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Reconciliation to Prior Year", "RollForward", true, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Reconciliation to Prior Year by Plan Def", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Detailed Results", "RollForward", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Detailed Results by Plan Def", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Status Reconciliation", "RollForward", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Member Statistics", "RollForward", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Individual Checking Template", "RollForward", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Age Service Matrix", "RollForward", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Data Matching Summary", "RollForward", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Combined Status Code Summary", "RollForward", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Gain / Loss Status Reconciliation", "RollForward", true, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Gain / Loss Summary of Liability Reconciliation", "RollForward", true, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Active Decrement Gain / Loss Detail", "RollForward", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Decrement Age", "RollForward", true, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Gain / Loss Participant Listing", "RollForward", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Valuation Summary", "RollForward", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Individual Output", "RollForward", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Parameter Print", "RollForward", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Test Cases", "RollForward", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Payout Projection", "RollForward", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Age Service Matrix", "RollForward", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_2006Funding_Baseline, "Liability Set for FSM Export", "RollForward", true, false); thrd_Funding_2006Funding_Baseline.Start(); pMain._SelectTab("Output Manager"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); pMain._SelectTab("2006 Funding"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion #endregion #region AccountingValuations -- Accounting 2006 #region Accounting 2006 - create Service pMain._SelectTab("Home"); dic.Clear(); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "AccountingValuations"); pMain._HomeTreeViewSelect(0, dic); _gLib._MsgBox("", "please delete RollForward service"); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", "Click"); dic.Add("ServiceToOpen", ""); pMain._PopVerify_Home_RightPane(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("ConversionService", ""); dic.Add("Name", "Accounting 2006"); dic.Add("Parent", "Accounting 2005"); dic.Add("ParentFinalValuationSet", ""); dic.Add("FiscalYearEndingIn_Accounting", "2006"); dic.Add("RSC", ""); dic.Add("LocalMarket", ""); dic.Add("Shared", ""); dic.Add("OK", "Click"); dic.Add("Cancel", ""); pMain._PopVerify_Home_ServicePropeties(dic); pMain._SelectTab("Home"); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "Accounting 2006"); pMain._PopVerify_Home_RightPane(dic); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Roll Forward"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("ValNodeName", ""); dic.Add("LiabilityValuationDate", "01/01/2006"); dic.Add("Data_AddNew", "True"); dic.Add("Data_Name", "Data2006"); dic.Add("Data_Edit", ""); dic.Add("Assumptions_AddNew", ""); dic.Add("Assumptions_Name", ""); dic.Add("Assumptions_Edit", ""); dic.Add("MethodsLiabilities_AddNew", ""); dic.Add("MethodsLiabilities_Name", ""); dic.Add("MethodsLiabilities_Edit", ""); dic.Add("Provisions_AddNew", ""); dic.Add("Provisions_Name", ""); dic.Add("Provisions_Edit", ""); dic.Add("FundingInformation_AddNew", ""); dic.Add("FundingInformation_Name", ""); dic.Add("FundingInformation_Edit", ""); dic.Add("OK", "Click"); dic.Add("Cancel", ""); pMain._PopVerify_ValuationNodeProperties(dic); #endregion #region Accounting 2006 - ParticipantData pMain._SelectTab("Accounting 2006"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Data"); dic.Add("MenuItem_2", "Edit Parameters"); pMain._FlowTreeRightSelect(dic); pMain._SelectTab("Participant DataSet"); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("DataEffectiveDate", ""); dic.Add("Snapshot", "True"); dic.Add("GRSUnload", ""); dic.Add("GotoDataSystem", "Click"); dic.Add("AddField", ""); dic.Add("GRSInformation", ""); dic.Add("ImportDataandApplyMapping", ""); pParticipantDataSet._PopVerify_ParticipantDataSet(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("SnapshotName", "Snapshots2006"); dic.Add("SnapshotName_Parent", ""); dic.Add("OK", "Click"); dic.Add("RetainThePreviousUnload", ""); dic.Add("SpecifyANewSnapshotRetainingPrevious", ""); dic.Add("SpecifyANewSnapshotRevertingAllFields", ""); dic.Add("SpecifyANewUnload", ""); dic.Add("SelectSnapshotOption_OK", "Click"); pParticipantDataSet._PopVerify_SelectSnapshotDefinition(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("DataEffectiveDate", ""); dic.Add("Snapshot", ""); dic.Add("GRSUnload", ""); dic.Add("GotoDataSystem", ""); dic.Add("AddField", ""); dic.Add("GRSInformation", ""); dic.Add("CompareData", "False"); dic.Add("ImportDataandApplyMapping", "Click"); pParticipantDataSet._PopVerify_ParticipantDataSet(dic); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion #region Accounting 2006 - Test Case pMain._SelectTab("Accounting 2006"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Test Case"); pMain._FlowTreeRightSelect(dic); pMain._SelectTab("Test Case Library"); dic.Clear(); dic.Add("SelectionCriteria", "$emp.birthdate=\"9/19/1948\""); dic.Add("iResultRow", "1"); pTestCaseLibrary._AddTestCase(dic); dic.Clear(); dic.Add("SelectionCriteria", "$emp.birthdate=\"9/24/1905\""); dic.Add("iResultRow", "1"); pTestCaseLibrary._AddTestCase(dic); dic.Clear(); dic.Add("SelectionCriteria", "$emp.birthdate=\"6/29/1945\""); dic.Add("iResultRow", "1"); pTestCaseLibrary._AddTestCase(dic); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion #region Accounting 2006 - Run Liability pMain._SelectTab("Accounting 2006"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("Acc_GL_PBO", "True"); dic.Add("Acc_GL_ABO", "True"); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("IncludeGainLossAgeGroupReportFields", ""); dic.Add("Service", "$Service"); dic.Add("Pay", "NewPayProjection1"); dic.Add("CurrentYear", ""); dic.Add("PriorYear", "True"); dic.Add("CashBanlance", "AccdVestingService"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", "True"); dic.Add("PPANotAtRiskLiabilityForMinimum", ""); dic.Add("PPANotAtRiskLiabilityForMaximum", ""); dic.Add("PPANotAtRishPresentValueOfVestedBenefits", ""); dic.Add("PBGCNotAtRiskPresentValueOfVestedBenefits", ""); dic.Add("FAS35PresentValueOfAccumulatedBenefits", ""); dic.Add("FAS35PresentValueOfVestedBenefits", ""); dic.Add("PPAAtRiskLiabilityForMinimum", ""); dic.Add("PPAAtRiskLiabilityForMaximum", ""); dic.Add("PPAAtRiskPresentValueOfVestedBenefits", ""); dic.Add("PBGCAtRiskPresentValueOfVestedBenefits", ""); dic.Add("EntryAgeNormal", ""); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._Home_ToolbarClick_Top(false); #endregion #region Accounting 2006 - Download reports pMain._SelectTab("Accounting 2006"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pMain._SelectTab("Output Manager"); //dic.Clear(); //dic.Add("PopVerify", "Pop"); //dic.Add("RemoveAll", ""); //dic.Add("AddAll", "Click"); //dic.Add("Node", ""); //dic.Add("Add", ""); //dic.Add("ShowSubtotalBreaks", ""); //dic.Add("OK", "Click"); //pOutputManager._PopVerify_OutputManagerSetup(dic); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Reconciliation to Prior Year", "RollForward", true, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Reconciliation to Prior Year by Plan Def", "RollForward", true, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Detailed Results", "RollForward", true, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Detailed Results by Plan Def", "RollForward", true, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Status Reconciliation", "RollForward", true, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Member Statistics", "RollForward", true, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Individual Checking Template", "RollForward", true, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Age Service Matrix", "RollForward", true, false); //////////pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Data Comparison", "RollForward", true, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Data Matching Summary", "RollForward", true, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Combined Status Code Summary", "RollForward", true, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Gain / Loss Status Reconciliation", "RollForward", true, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Gain / Loss Summary of Liability Reconciliation", "RollForward", true, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Active Decrement Gain / Loss Detail", "RollForward", true, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Decrement Age", "RollForward", true, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Gain / Loss Participant Listing", "RollForward", true, false); //////////pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Liability Comparison", "RollForward", true, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Valuation Summary", "RollForward", true, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Individual Output", "RollForward", true, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "IOE", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Parameter Print", "RollForward", true, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Test Cases", "RollForward", true, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Payout Projection", "RollForward", true, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Age Service Matrix", "RollForward", true, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "FAS Expected Benefit Pmts", "RollForward", true, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Accounting2006_Baseline, "Liability Set for Globe Export", "RollForward", true, false); pMain._SelectTab("Output Manager"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); pMain._SelectTab("Accounting 2006"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("US009CN", sOutputAccounting_Accounting2006_Baseline_Prod, sOutputAccounting_Accounting2006_Baseline); _compareReportsLib._Report(_PassFailStep.Description, "", "Accounting2006_Baseline"); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_ABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_ABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("StatusReconciliation.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_MovementAndRollforward.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_OutlierSummary.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_CheckingGroupStatistics.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("AgeServiceMatrix.xlsx", 4, 0, 0, 0, true); ////////_compareReportsLib.CompareExcel_Exact("DataComparison.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DataMatchingSummary.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("CombinedStatusCodeSummary.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("GainLossStatusReconciliation.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("GainLossSummaryofLiabilityReconciliation_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("GainLossSummaryofLiabilityReconciliation_ABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ActiveDecrementGainLossDetail_PBO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ActiveDecrementGainLossDetail_ABO.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DecrementAge.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("GainLossParticipantListing_PBO.xlsx", 0, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("GainLossParticipantListing_ABO.xlsx", 0, 0, 0, 0, true); //////////_compareReportsLib.CompareExcel_Exact("LiabilityComparison_PBO.xlsx", 0, 0, 0, 0, true); //////////_compareReportsLib.CompareExcel_Exact("LiabilityComparison_ABO.xlsx", 0, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("AgeServiceMatrix_2.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FASExpectedBenefitPmts.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitySetforGlobeExport.xlsx", 4, 0, 0, 0, true); } #endregion #endregion }
void t_CompareRpt_Funding2018_OptOutPrescribedMort(string sFunding2018_OptOutPrescribedMort) { if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("US019DNT", sFunding2018_OptOutPrescribedMort_Prod, sFunding2018_OptOutPrescribedMort); _compareReportsLib._Report(_PassFailStep.Description, "", "sFunding2018_OptOutPrescribedMort"); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResults.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPANARMax.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPANARMin.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPANARPVVB.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_PPANARMax.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_PPANARMin.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_PPANARPVVB.xlsx", 4, 0, 0, 0); Config.bThreadFinsihed = true; } }
public void test_US006_DNT() { this.GenerateReportOuputDir(); pMain._SelectTab("Home"); dic.Clear(); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "FundingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "January 2007 Valuation"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("January 2007 Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_PPANAR_Min", ""); dic.Add("GL_PPANAR_Max", ""); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "$Service"); dic.Add("Pay", "PayPlanLimit"); dic.Add("CurrentYear", ""); dic.Add("PriorYear", "True"); dic.Add("CashBanlance", "AccruedBenefit1"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", ""); dic.Add("PPANotAtRiskLiabilityForMinimum", "True"); dic.Add("PPANotAtRiskLiabilityForMaximum", "True"); dic.Add("PPANotAtRishPresentValueOfVestedBenefits", "True"); dic.Add("PBGCNotAtRiskPresentValueOfVestedBenefits", "True"); dic.Add("FAS35PresentValueOfAccumulatedBenefits", "True"); dic.Add("FAS35PresentValueOfVestedBenefits", "True"); dic.Add("PPAAtRiskLiabilityForMinimum", ""); dic.Add("PPAAtRiskLiabilityForMaximum", ""); dic.Add("PPAAtRiskPresentValueOfVestedBenefits", ""); dic.Add("PBGCAtRiskPresentValueOfVestedBenefits", ""); dic.Add("EntryAgeNormal", ""); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("January 2007 Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("January 2007 Valuation"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputBaseline, "Parameter Print", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputBaseline, "Test Cases", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputBaseline, "Liability Summary", "Conversion", false, true); pOutputManager._ExportReport_DrillDown_PDF_EXCEL(sOutputBaseline, "Liability Summary", "Conversion", false, true, 0); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputBaseline, "Member Statistics", "Conversion", false, true); pOutputManager._ExportReport_DrillDown_PDF_EXCEL(sOutputBaseline, "Conversion Diagnostic", "Conversion", false, true, 0); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputBaseline, "Test Case List", "Conversion", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputBaseline, "Detailed Results", "Conversion", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputBaseline, "Detailed Results by Plan Def", "Conversion", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputBaseline, "Valuation Summary", "Conversion", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputBaseline, "Individual Output", "Conversion", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputBaseline, "IOE", "Conversion", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputBaseline, "Payout Projection", "Conversion", false, true); if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("US006DNT", sOutputBaseline_Prod, sOutputBaseline); _compareReportsLib._Report(_PassFailStep.Description, "", "Baseline"); _compareReportsLib.CompareExcel_Exact("LiabilitySummary.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_ActiveMembers.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_DeferredMembers.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_Pensioners.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByNone.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByStatusCodes.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByCustom_Gender.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0, true); } pMain._SelectTab("January 2007 Valuation"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); _gLib._MsgBox("Congratulations!", "Finished!"); }
public void test_NL003_DNT() { this.GenerateReportOuputDir(); #region sOutputAccounting_Valuation2009 pMain._SelectTab("Home"); dic.Clear(); dic.Add("Country", Config.eCountry.ToString()); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "AccountingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "Valuation 2009"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("Valuation 2009"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_GoingConcern", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "$Service"); dic.Add("Pay", "Pay1CurrentYear"); dic.Add("CurrentYear", ""); dic.Add("PriorYear", "True"); dic.Add("CashBanlance", "AccruedBenefit1"); dic.Add("Pension", "#1#"); dic.Add("AllLiabilityTypes", ""); dic.Add("GoingConcernLiability", ""); dic.Add("SolvencyLiability", ""); dic.Add("WindUpLiability", ""); dic.Add("Acc_ProjectedBenefitObligation", "True"); dic.Add("Acc_AccumulatedBenefitObligation", "True"); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("Valuation 2009"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("Valuation 2009"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Valuation2009, "Parameter Print", "Conversion", true, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Valuation2009, "Test Cases", "Conversion", true, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Valuation2009, "Liability Summary", "Conversion", false, false); pOutputManager._ExportReport_DrillDown_PDF_EXCEL(sOutputAccounting_Valuation2009, "Liability Summary", "Conversion", false, false, 0); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Valuation2009, "Member Statistics", "Conversion", false, false); pOutputManager._ExportReport_DrillDown_PDF_EXCEL(sOutputAccounting_Valuation2009, "Conversion Diagnostic", "Conversion", false, false, 0); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Valuation2009, "Conversion Diagnostic", "Conversion", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Valuation2009, "Test Case List", "Conversion", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Valuation2009, "Detailed Results", "Conversion", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Valuation2009, "Detailed Results by Plan Def", "Conversion", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Valuation2009, "Valuation Summary", "Conversion", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Valuation2009, "Individual Output", "Conversion", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Valuation2009, "IOE", "Conversion", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Valuation2009, "Payout Projection", "Conversion", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Valuation2009, "FAS Expected Benefit Pmts", "Conversion", false, false); if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("NL003DNT", sOutputAccounting_Valuation2009_Prod, sOutputAccounting_Valuation2009); _compareReportsLib._Report(_PassFailStep.Description, "", "sOutputAccounting_Valuation2009"); _compareReportsLib.CompareExcel_Exact("LiabilitySummary.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_ActiveMembers.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_DeferredMembers.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_Pensioners.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByNone.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByStatusCodes.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByCustom_Gender.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("TestCaseList.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FASExpectedBenefitPmts.xlsx", 4, 0, 0, 0, true); } pMain._SelectTab("Valuation 2009"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion _gLib._MsgBox("Congratulations!", "Finished!"); }
public void test_US015_DNT() { #region MultiThreads Thread thrd_Valuation2011_Baseline = new Thread(() => new US015_DNT().t_CompareRpt_Valuation2011_Baseline(sOutputFunding_Valuation2011_Baseline)); #endregion this.GenerateReportOuputDir(); #region sOutputFunding_Valuation2011_Baseline pMain._SelectTab("Home"); dic.Clear(); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "FundingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "Valuation 2011"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("Valuation 2011"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_PPANAR_Min", "True"); dic.Add("GL_PPANAR_Max", ""); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "VestingService"); dic.Add("Pay", "PayProjection1"); dic.Add("CurrentYear", ""); dic.Add("PriorYear", "True"); dic.Add("CashBanlance", "AccruedBenefit1"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", ""); dic.Add("PPANotAtRiskLiabilityForMinimum", "True"); dic.Add("PPANotAtRiskLiabilityForMaximum", "True"); dic.Add("PPANotAtRishPresentValueOfVestedBenefits", ""); dic.Add("PBGCNotAtRiskPresentValueOfVestedBenefits", ""); dic.Add("FAS35PresentValueOfAccumulatedBenefits", ""); dic.Add("FAS35PresentValueOfVestedBenefits", ""); dic.Add("PPAAtRiskLiabilityForMinimum", ""); dic.Add("PPAAtRiskLiabilityForMaximum", ""); dic.Add("PPAAtRiskPresentValueOfVestedBenefits", ""); dic.Add("PBGCAtRiskPresentValueOfVestedBenefits", ""); dic.Add("EntryAgeNormal", ""); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("Valuation 2011"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("Valuation 2011"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Future Valuation Population Projection"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("IAgreeToUnlock", "True"); dic.Add("OK", "Click"); pMain._PopVerify_CascadingUnlock(dic); pMain._SelectTab("Valuation 2011"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true, "FV Proj"); pMain._SelectTab("Valuation 2011"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Future Valuation Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_PPANAR_Min", ""); dic.Add("GL_PPANAR_Max", ""); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", ""); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", ""); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "VestingService"); dic.Add("Pay", "PayProjection1"); dic.Add("CurrentYear", ""); dic.Add("PriorYear", "True"); dic.Add("CashBanlance", "AccruedBenefit1"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", ""); dic.Add("PPANotAtRiskLiabilityForMinimum", "True"); dic.Add("PPANotAtRiskLiabilityForMaximum", "True"); dic.Add("PPANotAtRishPresentValueOfVestedBenefits", ""); dic.Add("PBGCNotAtRiskPresentValueOfVestedBenefits", ""); dic.Add("FAS35PresentValueOfAccumulatedBenefits", ""); dic.Add("FAS35PresentValueOfVestedBenefits", ""); dic.Add("PPAAtRiskLiabilityForMinimum", ""); dic.Add("PPAAtRiskLiabilityForMaximum", ""); dic.Add("PPAAtRiskPresentValueOfVestedBenefits", ""); dic.Add("PBGCAtRiskPresentValueOfVestedBenefits", ""); dic.Add("EntryAgeNormal", ""); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("Valuation 2011"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true, "FV Liab"); pMain._SelectTab("Valuation 2011"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Reconciliation to Prior Year", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Reconciliation to Prior Year by Plan Def", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Detailed Results", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Detailed Results by Plan Def", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Status Reconciliation", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Member Statistics", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Individual Checking Template", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Age Service Matrix", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Data Matching Summary", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Combined Status Code Summary", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Gain / Loss Status Reconciliation", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Gain / Loss Summary of Liability Reconciliation", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Active Decrement Gain / Loss Detail", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Decrement Age", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Gain / Loss Participant Listing", "RollForward", false, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Liability Scenario by Plan Def", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Valuation Summary", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Individual Output", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "IOE", "RollForward", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Payout Projection", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Future Valuation Population Projection", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Future Valuation Summary", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Future Valuation Liabilities by Group", "RollForward", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputFunding_Valuation2011_Baseline, "Future Valuation Liabilities by Year", "RollForward", false, true); pOutputManager._ExportReport_FVPayouts_PDF_EXCEL(Config.eCountry, sOutputFunding_Valuation2011_Baseline, "RollForward", false, true); thrd_Valuation2011_Baseline.Start(); pMain._SelectTab("Output Manager"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion #region sOutputAccounting_Accounting2011_Baseline pMain._SelectTab("Home"); dic.Clear(); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "AccountingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "Accounting 2011"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("Accounting 2011"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("Acc_GL_PBO", ""); dic.Add("Acc_GL_ABO", ""); dic.Add("GL_PPANAR_Min", ""); dic.Add("GL_PPANAR_Max", ""); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "VestingService"); dic.Add("Pay", "SalaryCurrentYear"); dic.Add("CurrentYear", "True"); dic.Add("PriorYear", ""); dic.Add("CashBanlance", "AccruedBenefit1"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", ""); dic.Add("Acc_ProjectedBenefitObligation", "True"); dic.Add("Acc_AccumulatedBenefitObligation", "True"); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); dic.Add("OK", ""); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("Accounting 2011"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("Accounting 2011"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Future Valuation Population Projection"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("IAgreeToUnlock", "True"); dic.Add("OK", "Click"); pMain._PopVerify_CascadingUnlock(dic); pMain._SelectTab("Accounting 2011"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true, "FV Proj"); pMain._SelectTab("Accounting 2011"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Future Valuation Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_PPANAR_Min", ""); dic.Add("GL_PPANAR_Max", ""); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", ""); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", ""); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "VestingService"); dic.Add("Pay", "SalaryCurrentYear"); dic.Add("CurrentYear", ""); dic.Add("PriorYear", "True"); dic.Add("CashBanlance", "AccruedBenefit1"); dic.Add("Pension", "Benefit1DB"); dic.Add("AllLiabilityTypes", ""); dic.Add("Acc_ProjectedBenefitObligation", "True"); dic.Add("Acc_AccumulatedBenefitObligation", "True"); dic.Add("PPANotAtRiskLiabilityForMinimum", ""); dic.Add("PPANotAtRiskLiabilityForMaximum", ""); dic.Add("PPANotAtRishPresentValueOfVestedBenefits", ""); dic.Add("PBGCNotAtRiskPresentValueOfVestedBenefits", ""); dic.Add("FAS35PresentValueOfAccumulatedBenefits", ""); dic.Add("FAS35PresentValueOfVestedBenefits", ""); dic.Add("PPAAtRiskLiabilityForMinimum", ""); dic.Add("PPAAtRiskLiabilityForMaximum", ""); dic.Add("PPAAtRiskPresentValueOfVestedBenefits", ""); dic.Add("PBGCAtRiskPresentValueOfVestedBenefits", ""); dic.Add("EntryAgeNormal", ""); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("Accounting 2011"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true, "FV Liab"); pMain._SelectTab("Accounting 2011"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Reconciliation to Prior Year", "RollForward", false, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Reconciliation to Prior Year by Plan Def", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Detailed Results", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Detailed Results by Plan Def", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Status Reconciliation", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Member Statistics", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Individual Checking Template", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Age Service Matrix", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Data Matching Summary", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Combined Status Code Summary", "RollForward", false, false); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Liability Scenario by Plan Def", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Valuation Summary", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Individual Output", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "IOE", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Payout Projection", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "FAS Expected Benefit Pmts", "RollForward", false, false); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Liability Set for Globe Export", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Future Valuation Population Projection", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Future Valuation Summary", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Future Valuation Liabilities by Group", "RollForward", false, false); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputAccounting_Accounting2011_Baseline, "Future Valuation Liabilities by Year", "RollForward", false, false); pOutputManager._ExportReport_FVPayouts(Config.eCountry, sOutputAccounting_Accounting2011_Baseline, "RollForward", false, false); if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("US015DNT", sOutputAccounting_Accounting2011_Baseline_Prod, sOutputAccounting_Accounting2011_Baseline); _compareReportsLib._Report(_PassFailStep.Description, "", "sOutputAccounting_Accounting2011_Baseline"); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PBO.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_ABO.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_PBO.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_ABO.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("StatusReconciliation.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_MovementAndRollforward.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_OutlierSummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_CheckingGroupStatistics.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("AgeServiceMatrix.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DataMatchingSummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("CombinedStatusCodeSummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FASExpectedBenefitPmts.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilitySetforGlobeExport.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPopulationProjection.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationSummary.xlsx", 12, new string[1] { "Sheet2" }); _compareReportsLib.CompareExcel_Exact("FutureValuationSummary.xlsx", 4, new string[1] { "Sheet1" }); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2011.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2012.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2013.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2014.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2015.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2016.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2021.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2031.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyGroup.xlsx", 12, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyYear.xlsx", 12, new string[1] { "Sheet2" }); _compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyYear.xlsx", 4, new string[1] { "Sheet1" }); Config.bThreadFinsihed = true; } pMain._SelectTab("Output Manager"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); #endregion _gLib._MsgBox("Congratulations!", "Finished!"); }
public void _test_DE002_DNT() { //this.GenerateReportOuputDir(); pMain._SetLanguageAndRegional(); sOutputPension_ChristianVal = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_DE_Benchmark_002\Existing DNT\"; #region Pension Valuation - ChristianVal - Baseline - Run ER pMain._SelectTab("Home"); dic.Clear(); dic.Add("Country", Config.eCountry.ToString()); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "PensionValuations"); pMain._HomeTreeViewSelect(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "ChristianVal"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("ChristianVal"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("PayoutProjection", "True"); dic.Add("ApplyWithdrawalAdjustment", "True"); dic.Add("IncludeIOE", ""); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("SaveResultsforAuditReport", ""); dic.Add("ApplyOverrides", "True"); dic.Add("RunLocally", ""); dic.Add("Pay", "PAYCurrentYear"); dic.Add("CurrentYear", "True"); dic.Add("PriorYear", ""); dic.Add("BreakByFundingVehicle", "False"); dic.Add("UseReportBreaks", "True"); dic.Add("AllLiabilityTypes", ""); dic.Add("Tax", "True"); dic.Add("Trade", "True"); dic.Add("InternationalAccountingABO", "True"); dic.Add("InternationalAccountingPBO", "True"); dic.Add("SelectVOs_AllVOs", "True"); dic.Add("SelectVOs_VO1", ""); dic.Add("SelectVOs_VO2", ""); dic.Add("SelectVOs_VO3", ""); dic.Add("SelectVOs_VO4", ""); dic.Add("SelectVOs_VO5", ""); dic.Add("SelectVOs_VO6", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("ChristianVal"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("ChristianVal"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); #endregion #region Pension Valuation - ChristianVal - Baseline - Reports //pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputPension_ChristianVal, "Parameter Print", "Conversion", true, true); //pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputPension_ChristianVal, "Liability Summary", "Conversion", true, true); //pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputPension_ChristianVal, "Member Statistics", "Conversion", true, true); //pOutputManager._ExportReport_DrillDown_PDF_EXCEL(Config.eCountry, sOutputPension_ChristianVal, "Member Statistics", "Conversion", true, false, 0, new string[7] { "Death", "VO7501", "VO8401", "VO8888", "VOVP11", "VOVP12", "VOVP13" }); //pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputPension_ChristianVal, "Conversion Diagnostic", "Conversion", true, true); //pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputPension_ChristianVal, "Test Case List", "Conversion", true, true); //pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputPension_ChristianVal, "Detailed Results", "Conversion", true, true); //pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputPension_ChristianVal, "Detailed Results by Plan Def", "Conversion", true, true); //pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputPension_ChristianVal, "Valuation Summary", "Conversion", true, true); //pOutputManager._ExportReport_DrillDown_PDF_EXCEL(Config.eCountry, sOutputPension_ChristianVal, "Valuation Summary", "Conversion", true, false, 0, new string[7] { "Death", "VO7501", "VO8401", "VO8888", "VOVP11", "VOVP12", "VOVP13" }); //pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputPension_ChristianVal, "Valuation Summary for Excel Export", "Conversion", true, true); //pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputPension_ChristianVal, "Individual Output", "Conversion", true, true); //pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputPension_ChristianVal, "IOE", "Conversion", true, true); //pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputPension_ChristianVal, "Parameter Summary", "Conversion", true, true); //pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputPension_ChristianVal, "Test Cases", "Conversion", true, true); //pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputPension_ChristianVal, "Payout Projection", "Conversion", true, true); //dic.Clear(); //dic.Add("Group_ReportBreak", "True"); //pOutputManager._ExportReport_Custom_PDF_EXCEL(Config.eCountry, sOutputPension_ChristianVal, "Payout Projection", "Conversion", true, true, dic); //pMain._SelectTab("ChristianVal"); //pMain._Home_ToolbarClick_Top(true); //pMain._Home_ToolbarClick_Top(false); //_gLib._MsgBox("ChristianVal - Baseline", "Reports Finished!"); #endregion #region Pension Valuation - ChristianVal - Baseline - CompareReports if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("DE002DNT", sOutputPension_ChristianVal_Prod, sOutputPension_ChristianVal); _compareReportsLib._Report(_PassFailStep.Description, "", "sOutputPension_ChristianVal"); _compareReportsLib.CompareExcel_Exact("LiabilitySummary.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("MemberStatistics_Death.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("MemberStatistics_VO7501.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("MemberStatistics_VO8401.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("MemberStatistics_VO8888.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("MemberStatistics_VOVP11.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("MemberStatistics_VOVP12.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("MemberStatistics_VOVP13.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummaryforExcelExport.xlsx", 0, new int[0, 0] { }, new string[1] { "Tabellenblatt2" }, true); _compareReportsLib.CompareExcel_Exact("ValuationSummaryforExcelExport.xlsx", 0, new int[0, 0] { }, new string[1] { "Tabellenblatt3" }, true); _compareReportsLib.CompareExcel_Exact("ValuationSummary_Death.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummary_VO7501.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummary_VO8401.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummary_VO8888.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummary_VOVP11.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummary_VOVP12.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummary_VOVP13.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0, true); ////////_compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0 ,true); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("PayoutProjection_ReportBreak.xlsx", 4, 0, 0, 0, true); _gLib._MsgBox("ChristianVal - Baseline", "Compare Reports Finished!"); } #endregion // To generate code for this test, select "Generate Code for Coded UI Test" from the shortcut menu and select one of the menu items. }
public void _test_US001_DNT() { this.GenerateReportOuputDir(); #region PIA_1 - US 002 Reports pMain._SelectTab("Home"); dic.Clear(); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "FundingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "PIA_1"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("PIA_1"); _gLib._MsgBoxYesNo("", "Right select \"Run - Liabilities\" under Node \"US 002\""); ////////////////////dic.Clear(); ////////////////////dic.Add("iMaxRowNum", ""); ////////////////////dic.Add("iMaxColNum", ""); ////////////////////dic.Add("iSelectRowNum", "4"); ////////////////////dic.Add("iSelectColNum", "1"); ////////////////////dic.Add("MenuItem_1", "Run"); ////////////////////dic.Add("MenuItem_2", "Liabilities"); ////////////////////pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("GL_PPANAR_Min", ""); dic.Add("GL_PPANAR_Max", ""); dic.Add("GL_EAN", ""); dic.Add("EstimateNextYearLiabilityForAFTAP", ""); dic.Add("PayoutProjection", "True"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "$Service"); dic.Add("Pay", "NewPayProjection1"); dic.Add("CurrentYear", ""); dic.Add("PriorYear", "True"); dic.Add("CashBanlance", "CustomDeath"); dic.Add("Pension", "#1#"); dic.Add("AllLiabilityTypes", ""); dic.Add("PPANotAtRiskLiabilityForMinimum", "True"); dic.Add("PPANotAtRiskLiabilityForMaximum", "True"); dic.Add("PPANotAtRishPresentValueOfVestedBenefits", "True"); dic.Add("PBGCNotAtRiskPresentValueOfVestedBenefits", "True"); dic.Add("FAS35PresentValueOfAccumulatedBenefits", "True"); dic.Add("FAS35PresentValueOfVestedBenefits", "True"); dic.Add("PPAAtRiskLiabilityForMinimum", ""); dic.Add("PPAAtRiskLiabilityForMaximum", ""); dic.Add("PPAAtRiskPresentValueOfVestedBenefits", ""); dic.Add("PBGCAtRiskPresentValueOfVestedBenefits", ""); dic.Add("EntryAgeNormal", ""); dic.Add("PayoutProjectionCustomGroup", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); _gLib._MsgBoxYesNo("", "Right select \"View Run Status\" under Node \"US 002\""); //////////////////dic.Clear(); //////////////////dic.Add("iMaxRowNum", ""); //////////////////dic.Add("iMaxColNum", ""); //////////////////dic.Add("iSelectRowNum", "4"); //////////////////dic.Add("iSelectColNum", "1"); //////////////////dic.Add("MenuItem_1", "View Run Status"); //////////////////pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("PIA_1"); _gLib._MsgBoxYesNo("", "Right select \"View Output\" under Node \"US 002\""); ////////////////////dic.Clear(); ////////////////////dic.Add("iMaxRowNum", ""); ////////////////////dic.Add("iMaxColNum", ""); ////////////////////dic.Add("iSelectRowNum", "4"); ////////////////////dic.Add("iSelectColNum", "1"); ////////////////////dic.Add("MenuItem_1", "View Output"); ////////////////////pMain._FlowTreeRightSelect(dic); pMain._SelectTab("Output Manager"); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputUS002, "Valuation Summary", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputUS002, "Individual Output", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputUS002, "IOE", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputUS002, "Parameter Print", "Conversion", true, true); ////////////////////pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputUS002, "Test Cases", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(sOutputUS002, "Payout Projection", "Conversion", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputUS002, "Liabilities Detailed Results", "Conversion", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(sOutputUS002, "Liabilities Detailed Results by Plan Def", "Conversion", true, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputUS002, "Reconciliation to Baseline", "Conversion", true, true); pOutputManager._ExportReport_SubReports_PDF_EXCEL(sOutputUS002, "Reconciliation to Baseline by Plan Def", "Conversion", true, true); #endregion #region PIA_1 - US 002 Compare if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("US001DNT", sOutputUS002_Prod, sOutputUS002); _compareReportsLib._Report(_PassFailStep.Description, "", "US002"); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResults.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultsByPlanDef.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_FAS35PVAB.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_FAS35PVVB.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PBGCNARPVVB.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPANARMax.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPANARMin.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPANARPVVB.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationToBaselineByPlanDef_FAS35PVAB.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationToBaselineByPlanDef_FAS35PVVB.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationToBaselineByPlanDef_PBGCNARPVVB.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationToBaselineByPlanDef_PPANARMax.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationToBaselineByPlanDef_PPANARMin.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ReconciliationToBaselineByPlanDef_PPANARPVVB.xlsx", 4, 0, 0, 0, true); } #endregion pMain._SelectTab("Output Manager"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); _gLib._MsgBoxYesNo("PIA_1 - US 002", "Finished!!"); // To generate code for this test, select "Generate Code for Coded UI Test" from the shortcut menu and select one of the menu items. }
public void test_ANZ002_DNT() { this.GenerateReportOuputDir(); #region 2014BMVal pMain._SelectTab("Home"); dic.Clear(); dic.Add("Country", Config.eCountry.ToString()); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "FundingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "2014 Benchmark Val"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("2014 Benchmark Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Future Valuation Population Projection"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("IAgreeToUnlock", "True"); dic.Add("OK", "Click"); pMain._PopVerify_CascadingUnlock(dic); pMain._SelectTab("2014 Benchmark Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true, "FV Proj"); pMain._SelectTab("2014 Benchmark Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Future Valuation Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("isANZ", "true"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("2014 Benchmark Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true, "FV Liab"); pMain._SelectTab("2014 Benchmark Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("Doer", "True"); dic.Add("Checker", ""); dic.Add("Reviewer", ""); dic.Add("Setup", ""); pOutputManager._PopVerify_OutputManager(dic); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Population Projection", "Conversion", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Summary", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Parameter Print", "Conversion", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Liabilities by Group", "Conversion", true, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Liabilities by Year", "Conversion", true, true); pOutputManager._ExportReport_FVPayouts_PDF_EXCEL(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Conversion", true, false); if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("ANZ002_DNT", sOutputFunding_2014BenchmarkVal_REVISED50YearsFV_Prod, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV); _compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_2014BenchmarkVal_REVISED50YearsFV"); _compareReportsLib.CompareExcel_Exact("FutureValuationPopulationProjection.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationSummary.xlsx", 4, new string[1] { "Sheet1" }, true); _compareReportsLib.CompareExcel_Exact("FutureValuationSummary.xlsx", 12, new string[1] { "Sheet2" }, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2014.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2015.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2019.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2024.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2029.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2034.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2039.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2044.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2049.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2054.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2059.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2064.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyGroup.xlsx", 12, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyYear.xlsx", 12, new string[1] { "Sheet2" }, true); _compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyYear.xlsx", 4, new string[1] { "Sheet1" }, true); } pMain._SelectTab("Output Manager"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); pMain._SelectTab("2014 Benchmark Val"); pMain._Home_ToolbarClick_Top(true); #endregion _gLib._MsgBox("!", "Finished"); }
public void test_UK005_DNT() { this.GenerateReportOuputDir(); pMain._SelectTab("Home"); dic.Clear(); dic.Add("Country", Config.eCountry.ToString()); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "FundingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "QA UK Benchmark 005"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("QA UK Benchmark 005"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("PayoutProjection", "True"); dic.Add("ApplyWithdrawalAdjustment", ""); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "True"); dic.Add("GenerateTestCaseOutput", "True"); dic.Add("Pay", "FinalPayCurrentYear"); dic.Add("CurrentYear", ""); dic.Add("PriorYear", "True"); dic.Add("PayoutProjectionCustomGroup", "#1#"); dic.Add("Major", ""); dic.Add("Intermediate", ""); dic.Add("Minor", ""); dic.Add("AllLiabilityTypes", ""); dic.Add("Funding", "True"); dic.Add("AltFunding1", "False"); dic.Add("AltFunding2", "False"); dic.Add("AltFunding3", "False"); dic.Add("Solvency", "True"); dic.Add("PPFS179", "True"); dic.Add("SelectVOs_AllVOs", ""); dic.Add("SelectVOs_VO1", "AllMembers"); dic.Add("SelectVOs_VO2", ""); dic.Add("SelectVOs_VO3", ""); dic.Add("SelectVOs_VO4", ""); dic.Add("SelectRecords", ""); dic.Add("Validate", ""); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("QA UK Benchmark 005"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("QA UK Benchmark 005"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBenchmark005, "Parameter Print", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBenchmark005, "Test Cases", "Conversion", true, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBenchmark005, "Liability Summary", "Conversion", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBenchmark005, "Member Statistics", "Conversion", false, true); pOutputManager._ExportReport_DrillDown_PDF_EXCEL(sOutputFunding_QAUKBenchmark005, "Conversion Diagnostic", "Conversion", false, true, 0); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBenchmark005, "Detailed Results", "Conversion", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBenchmark005, "Detailed Results with Ben Type splits", "Conversion", false, true); pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBenchmark005, "Valuation Summary", "Conversion", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBenchmark005, "Individual Output", "Conversion", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBenchmark005, "IOE", "Conversion", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBenchmark005, "Payout Projection - Benefit Cashflows", "Conversion", false, true); pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBenchmark005, "Payout Projection - Other Info", "Conversion", false, true); if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("UK005DNT", sOutputFunding_QAUKBenchmark005_Prod, sOutputFunding_QAUKBenchmark005); _compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_QAUKBenchmark005"); _compareReportsLib.CompareExcel_Exact("LiabilitySummary.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByNone.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByStatusCodes.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByCustom_Gender.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("DetailedResultswithBenTypesplits.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("PayoutProjection-BenefitCashflows.xlsx", 4, 0, 0, 0, true); _compareReportsLib.CompareExcel_Exact("PayoutProjection-OtherInfo.xlsx", 4, 0, 0, 0, true); } pMain._SelectTab("QA UK Benchmark 005"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); _gLib._MsgBox("Congratulations!", "Finished!"); }
public void test_ANZ002_RB() { this.GenerateReportOuputDir(); #region 2014BMVal_Baseline - ParticipantData pMain._SelectTab("Home"); dic.Clear(); dic.Add("Country", Config.eCountry.ToString()); dic.Add("Level_1", Config.sClientName); dic.Add("Level_2", Config.sPlanName); dic.Add("Level_3", "FundingValuations"); pMain._HomeTreeViewSelect_Favorites(0, dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AddServiceInstance", ""); dic.Add("ServiceToOpen", "2014 Benchmark Val"); pMain._PopVerify_Home_RightPane(dic); pMain._SelectTab("2014 Benchmark Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("AllLiabilityTypes", "true"); dic.Add("GoingConcernLiability", "True"); dic.Add("PayoutProjection", "true"); dic.Add("IncludeIOE", "True"); dic.Add("GenerateParameterPrint", "true"); dic.Add("GenerateTestCaseOutput", ""); dic.Add("IncludeGainLossResult", ""); dic.Add("Service", "$Service"); dic.Add("Pay", "SalaryCurrentYear"); dic.Add("CurrentYear", ""); dic.Add("PriorYear", "True"); dic.Add("CashBanlance", "AccrualRate"); dic.Add("Pension", "Benefit1DB"); dic.Add("RunValuation", "Click"); dic.Add("OK", ""); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("2014 Benchmark Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true); pMain._SelectTab("2014 Benchmark Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "1"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("Doer", "True"); dic.Add("Checker", ""); dic.Add("Reviewer", ""); dic.Add("Setup", ""); pOutputManager._PopVerify_OutputManager(dic); pOutputManager._ExportReport_Others(sOutputFunding_2014BenchmarkVal_Baseline, "Parameter Print", "Conversion", true, true); pOutputManager._ExportReport_Common(sOutputFunding_2014BenchmarkVal_Baseline, "Valuation Summary", "Conversion", true, true); if (Config.bDownloadReports_PDF) { pOutputManager._ExportReport_Others(sOutputFunding_2014BenchmarkVal_Baseline, "Liability Summary", "Conversion", true, true); pOutputManager._ExportReport_DrillDown(sOutputFunding_2014BenchmarkVal_Baseline, "Liability Summary", "Conversion", true, true, 0); pOutputManager._ExportReport_Common(sOutputFunding_2014BenchmarkVal_Baseline, "Member Statistics", "Conversion", true, true); pOutputManager._ExportReport_DrillDown(sOutputFunding_2014BenchmarkVal_Baseline, "Conversion Diagnostic", "Conversion", true, true, 0); pOutputManager._ExportReport_Others(sOutputFunding_2014BenchmarkVal_Baseline, "Conversion Diagnostic", "Conversion", true, true); pOutputManager._ExportReport_Common(sOutputFunding_2014BenchmarkVal_Baseline, "Detailed Results", "Conversion", true, true); pOutputManager._ExportReport_Others(sOutputFunding_2014BenchmarkVal_Baseline, "Individual Output", "Conversion", true, true); pOutputManager._ExportReport_Others(sOutputFunding_2014BenchmarkVal_Baseline, "Test Cases", "Conversion", true, true); pOutputManager._ExportReport_Others(sOutputFunding_2014BenchmarkVal_Baseline, "Payout Projection", "Conversion", true, true); } if (Config.bDownloadReports_EXCEL) { pOutputManager._ExportReport_Others(sOutputFunding_2014BenchmarkVal_Baseline, "Liability Summary", "Conversion", false, true); pOutputManager._ExportReport_DrillDown(sOutputFunding_2014BenchmarkVal_Baseline, "Liability Summary", "Conversion", false, true, 0); pOutputManager._ExportReport_Common(sOutputFunding_2014BenchmarkVal_Baseline, "Member Statistics", "Conversion", false, true); pOutputManager._ExportReport_DrillDown(sOutputFunding_2014BenchmarkVal_Baseline, "Conversion Diagnostic", "Conversion", false, true, 0); pOutputManager._ExportReport_Others(sOutputFunding_2014BenchmarkVal_Baseline, "Conversion Diagnostic", "Conversion", false, true); pOutputManager._ExportReport_Common(sOutputFunding_2014BenchmarkVal_Baseline, "Test Case List", "Conversion", false, true); pOutputManager._ExportReport_Common(sOutputFunding_2014BenchmarkVal_Baseline, "Detailed Results", "Conversion", false, true); pOutputManager._ExportReport_Common(sOutputFunding_2014BenchmarkVal_Baseline, "Detailed Results by Plan Def", "Conversion", false, true); pOutputManager._ExportReport_Others(sOutputFunding_2014BenchmarkVal_Baseline, "Individual Output", "Conversion", false, true); pOutputManager._ExportReport_Others(sOutputFunding_2014BenchmarkVal_Baseline, "IOE", "Conversion", false, true); pOutputManager._ExportReport_Others(sOutputFunding_2014BenchmarkVal_Baseline, "Payout Projection", "Conversion", false, true); } if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("ANZ002CreateNew", sOutputFunding_2014BenchmarkVal_Baseline_Prod, sOutputFunding_2014BenchmarkVal_Baseline); _compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_2014BenchmarkVal_Baseline"); _compareReportsLib.CompareExcel_Exact("LiabilitySummary.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_ActiveMembers.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_DeferredMembers.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("LiabilitySummary_Pensioners.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByNone.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByStatusCodes.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByCustom_Gender.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0); } pMain._SelectTab("Output Manager"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); pMain._SelectTab("2014 Benchmark Val"); pMain._Home_ToolbarClick_Top(true); #endregion #region 2014BenchmarkVal_REVISED50YearsFV_Prod pMain._SelectTab("2014 Benchmark Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Future Valuation Options"); pMain._FlowTreeRightSelect(dic); pFutureValuationOption._SelectTab("Projection years"); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("EveryYearForTheFirst", "1"); dic.Add("AndEvery", "5"); dic.Add("UpToincludingProjectionYear", "50"); dic.Add("ProjectionYears", ""); dic.Add("NumberOfRuns", ""); dic.Add("RandomNumDismissed", ""); dic.Add("FundingUpdateDate_UK", ""); pFutureValuationOption._ProjectionYears(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "click"); pFutureValuationOption._PopVerify_OK(dic); pMain._SelectTab("2014 Benchmark Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Future Valuation Population Projection"); pMain._FlowTreeRightSelect(dic); pMain._SelectTab("2014 Benchmark Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true, "FV Proj"); _gLib._MsgBoxYesNo("", "Please confirm the next FV ER would not effect the other college, because it'll cost 2 hours !!!"); pMain._SelectTab("2014 Benchmark Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "Run"); dic.Add("MenuItem_2", "Future Valuation Liabilities"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("RunValuation", "Click"); pMain._PopVerify_RunOptions(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("OK", "Click"); pMain._PopVerify_EnterpriseRunSubmitted(dic); pMain._SelectTab("2014 Benchmark Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Run Status"); pMain._FlowTreeRightSelect(dic); pMain._EnterpriseRun("Group Job Successfully Complete", true, "FV Liab"); pMain._SelectTab("2014 Benchmark Val"); dic.Clear(); dic.Add("iMaxRowNum", ""); dic.Add("iMaxColNum", ""); dic.Add("iSelectRowNum", "2"); dic.Add("iSelectColNum", "1"); dic.Add("MenuItem_1", "View Output"); pMain._FlowTreeRightSelect(dic); dic.Clear(); dic.Add("PopVerify", "Pop"); dic.Add("Doer", "True"); dic.Add("Checker", ""); dic.Add("Reviewer", ""); dic.Add("Setup", ""); pOutputManager._PopVerify_OutputManager(dic); if (Config.bDownloadReports_PDF) { pOutputManager._ExportReport_Common(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Population Projection", "Conversion", true, true); pOutputManager._ExportReport_Common(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Summary", "Conversion", true, true); pOutputManager._ExportReport_Others(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Parameter Print", "Conversion", true, true); pOutputManager._ExportReport_Common(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Liabilities by Group", "Conversion", true, true); pOutputManager._ExportReport_Common(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Liabilities by Year", "Conversion", true, true); pOutputManager._ExportReport_FVPayouts(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Conversion", true, false); } if (Config.bDownloadReports_EXCEL) { pOutputManager._ExportReport_Common(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Population Projection", "Conversion", false, true); pOutputManager._ExportReport_Common(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Summary", "Conversion", false, true); pOutputManager._ExportReport_Common(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Liabilities by Group", "Conversion", false, true); pOutputManager._ExportReport_Common(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Future Valuation Liabilities by Year", "Conversion", false, true); pOutputManager._ExportReport_FVPayouts(Config.eCountry, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV, "Conversion", false, true); } if (Config.bCompareReports) { CompareReportsLib _compareReportsLib = new CompareReportsLib("ANZ002_CN", sOutputFunding_2014BenchmarkVal_REVISED50YearsFV_Prod, sOutputFunding_2014BenchmarkVal_REVISED50YearsFV); _compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_2014BenchmarkVal_REVISED50YearsFV"); _compareReportsLib.CompareExcel_Exact("FutureValuationPopulationProjection.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationSummary.xlsx", 12, new string[1] { "Sheet2" }); _compareReportsLib.CompareExcel_Exact("FutureValuationSummary.xlsx", 4, new string[1] { "Sheet1" }); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2014.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2015.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2019.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2024.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2029.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2034.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2039.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2044.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2049.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2054.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2059.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2064.xlsx", 4, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyGroup.xlsx", 12, 0, 0, 0); _compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyYear.xlsx", 12, new string[1] { "Sheet2" }); _compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyYear.xlsx", 4, new string[1] { "Sheet1" }); } pMain._SelectTab("Output Manager"); pMain._Home_ToolbarClick_Top(true); pMain._Home_ToolbarClick_Top(false); pMain._SelectTab("2014 Benchmark Val"); pMain._Home_ToolbarClick_Top(true); #endregion _gLib._MsgBox("!", "Finished"); }