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