public void test_Debug()
{
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);
Environment.Exit(0);
_gLib._MsgBox("Congratulations!", "Finished!");
_gLib._Wait(1);
}
public void MyTestInitialize()
{
dicResultIndex.Clear();
dicResultIndex.Add("iTimeStart", "2");
dicResultIndex.Add("iTimeEnd", "3");
dicResultIndex.Add("iLaunchNodeProperty_1", "4");
dicResultIndex.Add("iLaunchNodeProperty_2", "5");
dicResultIndex.Add("iLaunchNodeProperty_3", "6");
dicResultIndex.Add("iLaunchNodeProperty_4", "7");
dicResultIndex.Add("iLaunchNodeProperty_5", "8");
dicResultIndex.Add("iLaunchNodeProperty_6", "9");
dicResultIndex.Add("iLaunchNodeProperty_7", "10");
dicResultIndex.Add("iLaunchNodeProperty_8", "11");
dicResultIndex.Add("iLaunchNodeProperty_9", "12");
dicResultIndex.Add("iLaunchNodeProperty_10", "13");
dicResultIndex.Add("iAddNodeSuccess_1", "14");
dicResultIndex.Add("iAddNodeSuccess_2", "15");
dicResultIndex.Add("iAddNodeSuccess_3", "16");
dicResultIndex.Add("iAddNodeSuccess_4", "17");
dicResultIndex.Add("iAddNodeSuccess_5", "18");
dicResultIndex.Add("iAddNodeSuccess_6", "19");
dicResultIndex.Add("iAddNodeSuccess_7", "20");
dicResultIndex.Add("iAddNodeSuccess_8", "21");
dicResultIndex.Add("iAddNodeSuccess_9", "22");
dicResultIndex.Add("iAddNodeSuccess_10", "23");
dicPosition.Clear();
dicPosition.Add("X_1", "400");
dicPosition.Add("Y_1", "320");
dicPosition.Add("X_2", "400");
dicPosition.Add("Y_2", "378");
dicPosition.Add("X_3", "350");
dicPosition.Add("Y_3", "436");
dicPosition.Add("X_4", "350");
dicPosition.Add("Y_4", "490");
dicPosition.Add("X_5", "350");
dicPosition.Add("Y_5", "530");
dicPosition.Add("X_6", "400");
dicPosition.Add("Y_6", "320");
dicPosition.Add("X_7", "470");
dicPosition.Add("Y_7", "380");
dicPosition.Add("X_8", "435");
dicPosition.Add("Y_8", "435");
dicPosition.Add("X_9", "435");
dicPosition.Add("Y_9", "490");
dicPosition.Add("X_10", "435");
dicPosition.Add("Y_10", "530");
}
public static void Print()
{
var dict = new MyDictionary <int, Guid>();
for (var i = 0; i < 5; i++)
{
dict.Add(new KeyValuePair <int, Guid>(i, Guid.NewGuid()));
}
PrintDictionary(dict);
Console.WriteLine($"Contains key 1? {dict.ContainsKey(1)}");
Console.WriteLine($"Contains key 11? {dict.ContainsKey(11)}");
Console.WriteLine($"TryGetValue 1: {dict.TryGetValue(1, out var r1)}, {r1}");
Console.WriteLine($"TryGetValue 100: {dict.TryGetValue(100, out var r2)}, {r2}");
Console.WriteLine();
Console.WriteLine($"Removing key 1? {dict.Remove(1)}");
Console.WriteLine($"Removing key 11? {dict.Remove(11)}");
Console.WriteLine($"Removing key 3? {dict.Remove(3)}");
PrintDictionary(dict);
Console.WriteLine($"Add existing key 2.");
dict.Add(2, Guid.NewGuid());
PrintDictionary(dict);
Console.WriteLine("Indexers.");
Console.WriteLine("Adding 5.");
dict[5] = Guid.NewGuid();
PrintDictionary(dict);
Console.WriteLine("Overwrite 5.");
dict[5] = Guid.NewGuid();
PrintDictionary(dict);
Console.WriteLine();
Console.WriteLine($"\nAdding keys 1 and 11.");
dict.Add(new KeyValuePair <int, Guid>(1, Guid.NewGuid()));
dict.Add(new KeyValuePair <int, Guid>(11, Guid.NewGuid()));
PrintDictionary(dict);
Console.WriteLine($"\nClearing and reinitializing.");
dict.Clear();
for (var i = 0; i < 5; i++)
{
dict.Add(new KeyValuePair <int, Guid>(i, Guid.NewGuid()));
}
PrintDictionary(dict);
}
public void MyDictionaryClearTest()
{
KeyValuePair <int, string>[] pairs =
{
new KeyValuePair <int, string>(50, "Vasya"),
new KeyValuePair <int, string>(38, "Stepan"),
new KeyValuePair <int, string>(77, "Lilo"),
new KeyValuePair <int, string>(13, "Stich"),
new KeyValuePair <int, string>(20, "Alladin"),
new KeyValuePair <int, string>(90, "Gaben"),
new KeyValuePair <int, string>(45, "IceFrog")
};
MyDictionary <int, string> dict = new MyDictionary <int, string>(pairs);
Assert.AreEqual(7, dict.Count);
dict.Clear();
Assert.AreEqual(0, dict.Count);
}
public void ClearExample()
{
DictionaryBase <string, int> dictionary = new MyDictionary
{
{ "cat", 1 },
{ "dog", 2 },
{ "canary", 3 }
};
// There should be 3 items in the dictionary.
Assert.AreEqual(3, dictionary.Count);
// Clear the dictionary
dictionary.Clear();
// The dictionary should be empty.
Assert.AreEqual(0, dictionary.Count);
// No cat here..
Assert.IsFalse(dictionary.ContainsKey("cat"));
}
/// <summary>
/// 2015-Dec-9
/// [email protected]
///
/// sample:
/// dic.Clear();
/// dic.Add("PopVerify", "Pop");
/// dic.Add("LongName", "");
/// dic.Add("ShortName", "");
/// dic.Add("OK", "");
/// pActuarialReport._SI_TreeViewAddItem(dic);
/// </summary>
/// <param name="dic"></param>
public void _SI_TreeViewAddItem(MyDictionary dic)
{
string sFunctionName = "_PopVerify_Main";
_gLib._Report(_PassFailStep.Step, "Function <" + sFunctionName + "> Starts:");
int X = this.wRetirementStudio.wTreeView.Tree.Width / 2;
int Y = this.wRetirementStudio.wTreeView.Tree.Height / 2;
// Mouse.Click(this.wRetirementStudio.wFlowTree.flowTree, MouseButtons.Right, ModifierKeys.None, new Point(iPosX, iPosY));
try
{
Mouse.Click(this.wRetirementStudio.wTreeView.Tree, MouseButtons.Right, ModifierKeys.None, new Point(X, Y));
}
catch (Exception ex)
{
_gLib._Report(_PassFailStep.Fail, "Function <" + sFunctionName + "> fail to Right Click on Node Flow Tree. Because of Exception thrown: " + Environment.NewLine + ex.Message);
_gLib._MsgBoxYesNo("Continue Testing?", "Fail: Function <" + sFunctionName + "> fail to Right Click on Node Flow Tree. Because of Exception thrown: " + Environment.NewLine + ex.Message);
}
WinWindow wWin = new WinWindow();
wWin.SearchProperties.Add(WinWindow.PropertyNames.AccessibleName, "DropDown");
wWin.SearchProperties.Add(WinWindow.PropertyNames.ClassName, "WindowsForms10.Window", PropertyExpressionOperator.Contains);
wWin.SearchConfigurations.Add(SearchConfiguration.AlwaysSearch);
wWin.SearchConfigurations.Add(SearchConfiguration.VisibleOnly);
MyDictionary dicTmp = new MyDictionary();
dicTmp.Clear();
dicTmp.Add("Level_1", "Add");
_gLib._MenuSelectWin(0, wWin, dicTmp);
_gLib._SetSyncUDWin("FPGrid", this.wAddSubsidiary.wLongName.txt, dic["LongName"], 0);
_gLib._SetSyncUDWin("FPGrid", this.wAddSubsidiary.wShortName.txt, dic["ShortName"], 0);
_gLib._SetSyncUDWin("FPGrid", this.wAddSubsidiary.wOK.btn, dic["OK"], 0);
}
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 _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_CheckListEU()
{
#region Initialize - Create Test Ouput File/Dir
_gLib._CreateDirectory(sOutput_EU, false);
#endregion
#region General
//////////////////////////////////////////////////// iGeneral_OnlineHelp
dic.Clear();
dic.Add("MenuItem_1", "Help");
dic.Add("MenuItem_2", "Retirement Studio Help");
dic.Add("MenuItem_3", "");
pMain._MenuSelect(dic);
_gLib._SetSyncUDWin("US", pMain.wRetirementStudioHelp.wTreeView.tree.tvUS, "Click", 0);
_gLib._SetSyncUDWin("FAQs", pMain.wRetirementStudioHelp.wTreeView.tree.tvUS.tvFAQs, "Click", 0);
_gLib._SetSyncUDWin("AccessRetirementStudioFAQ", pMain.wRetirementStudioHelp.wTreeView.tree.tvUS.tvFAQs.tvAccessRetirementStudioFAQ, "Click", 0);
_gLib._SetSyncUDWin("Word - Close", pMain.wWord.wTitleBar.btnClose, "Click", 0);
_gLib._SetSyncUDWin("TitleBar", pMain.wRetirementStudioHelp.wTitleBar, "Click", 0);
_gLib._SetSyncUDWin("Close", pMain.wRetirementStudioHelp.wTitleBar.btnClose, "Click", 0);
_gLib._KillProcessByName("WINWORD");
mLog_EU.LogInfo(iGeneral_OnlineHelp, iLog_EU, Config.sTester);
#endregion
#region Valuation
//////////////////////////////////////////////////// iVal_RunER
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", "Stichtag 2011 Final");
dic.Add("CheckPopup", "False");
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("RunValuation", "Click");
pMain._PopVerify_RunOptions(dic);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("OK", "Click");
pMain._PopVerify_EnterpriseRunSubmitted(dic);
//////////////////////////////////////////////////// iVal_ParamPrint_FromNode
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", "Parameter Print");
dic.Add("MenuItem_2", "");
pMain._FlowTreeRightSelect(dic);
pMain._SelectTab("Parameter Print Report");
pOutputManager._WaitForLoading();
_gLib._Exists("Parameter Print Report", pOutputManager.wRetirementStudio.wToolbar_btn.btnNextPage.btn, Config.iTimeout * 3, true);
_gLib._Enabled("Parameter Print Report", pOutputManager.wRetirementStudio.wToolbar_btn.btnNextPage.btn, Config.iTimeout * 3, true);
pMain._SelectTab("Parameter Print Report");
pMain._Home_ToolbarClick_Top(false);
mLog_EU.LogInfo(iVal_ParamPrint_FromNode, iLog_EU, Config.sTester);
//////////////////////////////////////////////////// iVal_RunER, iVal_RunCompleteMsg
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");
dic.Add("MenuItem_2", "");
pMain._FlowTreeRightSelect(dic);
pMain._EnterpriseRun("Group Job Successfully Complete", true);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("OK", "Click");
dic.Add("VerifyMsg", "True");
pMain._PopVerify_GroupJobSuccessfullyComplete(dic);
////////////////_gLib._Wait(1);
////////////////dic.Clear();
////////////////dic.Add("PopVerify", "Pop");
////////////////dic.Add("OK", "Click");
////////////////pMain._PopVerify_GroupJobSuccessfullyComplete(dic);
mLog_EU.LogInfo(iVal_RunER, iLog_EU, Config.sTester);
mLog_EU.LogInfo(iVal_RunCompleteMsg, iLog_EU, Config.sTester);
//////////////////////////////////////////////////// iCloseAndReEnter
pMain._SelectTab("Stichtag 2011 Final");
pMain._Home_ToolbarClick_Top(true);
pMain._Home_ToolbarClick_Top(false);
_gLib._SetSyncUDWin("Close", pMain.wRetirementStudio.tbHome_TitleBar.btnClose, "Click", 0);
_gLib._Cmd(Config.sStudioLaunchDir);
pMain._SelectTab("Home");
mLog_EU.LogInfo(iGeneral_OpenStudio, iLog_EU, Config.sTester);
mLog_EU.LogInfo(iGeneral_CloseAndReEnter, iLog_EU, Config.sTester);
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", "Stichtag 2011 Final");
dic.Add("CheckPopup", "False");
pMain._PopVerify_Home_RightPane(dic);
pMain._SelectTab("Stichtag 2011 Final");
_gLib._KillProcessByName("Mercer.RetirementStudio.Messaging.MessagingClientApp");
_gLib._KillProcessByName("Mercer.RetirementStudio.Messaging.MessagingClientApp");
//////////////////////////////////////////////////// iVal_ParamPrint
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");
dic.Add("CheckOMSetupPopup", "");
pMain._FlowTreeRightSelect(dic);
pMain._SelectTab("Output Manager");
pOutputManager._ExportReport_Others(sOutput_EU, "Parameter Print", "RollForward", true, true);
mLog_EU.LogInfo(iVal_ParamPrint, iLog_EU, Config.sTester);
//////////////////////////////////////////////////// iVal_Rpt_ValSum
pMain._SelectTab("Output Manager");
pOutputManager._ExportReport_Common(sOutput_EU, "Valuation Summary", "RollForward", true, true);
mLog_EU.LogInfo(iVal_Rpt_ValSum, iLog_EU, Config.sTester);
//////////////////////////////////////////////////// iVal_Rpt_ValSum_DrillDown
pOutputManager._Navigate(Config.eCountry, "Valuation Summary", "RollForward", true);
pOutputManager._SelectTab("Valuation Summary");
pOutputManager._WaitForLoading();
_gLib._SetSyncUDWin("ZeroLiabilities", pOutputManager.wRetirementStudio.wReportClient.clientReport, "Click", 0, false, 88, 120);
pOutputManager._SelectTab("Valuation Summary");
pOutputManager._WaitForLoading();
_gLib._SetSyncUDWin("ZeroLiabilities", pOutputManager.wRetirementStudio.wReportClient.clientReport, "Click", 0, false, 470, 768);
pOutputManager._SelectTab("Valuation Summary");
_gLib._SetSyncUDWin("None", pOutputManager.wRetirementStudio.wGroup_None.rdNone, "True", 0);
_gLib._SetSyncUDWin("Process", pOutputManager.wRetirementStudio.wProcess.btnProcess, "Click", 0);
pOutputManager._WaitForLoading();
pOutputManager._SelectTab("Valuation Summary");
_gLib._SetSyncUDWin("View", pOutputManager.wRetirementStudio.wView.btnView, "Click", 0);
_gLib._SetSyncUDWin("Export", pOutputManager.wRetirementStudio.wExport.btnExport, "Click", 0);
pOutputManager._SaveAs(sOutput_EU + "zValuationSummary_ZeroLiabilities_byNone.xls");
_gLib._SetSyncUDWin("OK", pOutputManager.wExtractSuccessfullyCreated_Popup.wOK.btnOK, "Click", Config.iTimeout * 3);
_gLib._FileExists(sOutput_EU + "zValuationSummary_ZeroLiabilities_byNone.xlsx", Config.iTimeout, true);
mLog_EU.LogInfo(iVal_Rpt_ValSum_DrillDown, iLog_EU, Config.sTester);
//////////////////////////////////////////////////// iVal_Rpt_DetailedResults
pMain._SelectTab("Output Manager");
pOutputManager._ExportReport_Common(sOutput_EU, "Liabilities Detailed Results", "RollForward", true, true);
mLog_EU.LogInfo(iVal_Rpt_DetailedResults, iLog_EU, Config.sTester);
//////////////////////////////////////////////////// iVal_Rpt_TCLO
pMain._SelectTab("Output Manager");
pOutputManager._ExportReport_Others(sOutput_EU, "Test Cases", "RollForward", true, true);
mLog_EU.LogInfo(iVal_Rpt_TCLO, iLog_EU, Config.sTester);
//////////////////////////////////////////////////// iVal_Rpt_IOE
pMain._SelectTab("Output Manager");
pOutputManager._ExportReport_Others(sOutput_EU, "IOE", "RollForward", false, true);
mLog_EU.LogInfo(iVal_Rpt_IOE, iLog_EU, Config.sTester);
//////////////////////////////////////////////////// iVal_GolbeExportWithBreaks
pMain._SelectTab("Output Manager");
pOutputManager._Navigate(Config.eCountry, "Liability Set for Globe Export", "RollForward", true);
pOutputManager._SelectTab("Liability Set for Globe Export");
pOutputManager._WaitForLoading();
_gLib._SetSyncUDWin("Liability Set for Globe Export - ALL", pOutputManager.wRetirementStudio.wReportClient.clientReport, "Click", 0, false, 88, 120); // qa
/////////_gLib._SetSyncUDWin("Liability Set for Globe Export - ALL", pOutputManager.wRetirementStudio.wReportClient.clientReport, "Click", 0, false, 65, 120); // prod
_gLib._SetSyncUDWin("View", pOutputManager.wRetirementStudio.wProcess.btnProcess, "Click", 0);
pOutputManager._SelectTab("Liability Set for Globe Export");
pOutputManager._WaitForLoading();
pOutputManager._SelectTab("Liability Set for Globe Export");
_gLib._Enabled("Toolbar", pOutputManager.wRetirementStudio.wToolbar, Config.iTimeout);
for (int i = 0; i <= 10; i++)
{
try
{
_gLib._SetSyncUDWin("Export Button", pOutputManager.wRetirementStudio.wToolbar.miExport, "Click", 0, false, 10, 10);
_gLib._SendKeysUDWin("Export Menu", pOutputManager.wRetirementStudio.wToolbar.miExport, "{Down}{Down}{Down}{Enter}");
if (_gLib._Exists("wReplaceExportedLiabSet", pOutputManager.wReplaceExportedLiabSet, Config.iTimeout / 10, false))
{
break;
}
}
catch (Exception ex)
{ }
}
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("OK", "Click");
dic.Add("VerifyMsg", "True");
pOutputManager._PopVerify_ReplaceExportedLiabilitySet(dic);
mLog_EU.LogInfo(iVal_GolbeExportWithBreaks, iLog_EU, Config.sTester);
pMain._SelectTab("Output Manager");
pMain._Home_ToolbarClick_Top(true);
pMain._Home_ToolbarClick_Top(false);
//////////////////////////////////////////////////// iVal_AddNewValNode
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", "Add Valuation Node");
pMain._FlowTreeRightSelect(dic);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("ValNodeName", "DeploymentTest");
dic.Add("LiabilityValuationDate", "");
dic.Add("Data_AddNew", "True");
dic.Add("Data_Name", "");
dic.Add("Data_Edit", "");
dic.Add("Assumptions_AddNew", "True");
dic.Add("Assumptions_Name", "");
dic.Add("Assumptions_Edit", "");
dic.Add("MethodsLiabilities_AddNew", "True");
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("Stichtag 2011 Final");
mLog_EU.LogInfo(iVal_AddNewValNode, iLog_EU, Config.sTester);
//////////////////////////////////////////////////// iVal_ConsumeSnapshot
pMain._SelectTab("Stichtag 2011 Final");
dic.Clear();
dic.Add("iMaxRowNum", "");
dic.Add("iMaxColNum", "");
dic.Add("iSelectRowNum", "4");
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", "");
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", "Val2011");
dic.Add("OK", "Click");
dic.Add("RetainThePreviousUnload", "");
dic.Add("SpecifyANewSnapshotRetainingPrevious", "");
dic.Add("SpecifyANewSnapshotRevertingAllFields", "True");
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", "");
dic.Add("ImportDataandApplyMapping", "Click");
pParticipantDataSet._PopVerify_ParticipantDataSet(dic);
pMain._SelectTab("Participant DataSet");
pMain._Home_ToolbarClick_Top(true);
pMain._Home_ToolbarClick_Top(false);
pMain._SelectTab("Stichtag 2011 Final");
mLog_EU.LogInfo(iVal_ConsumeSnapshot, iLog_EU, Config.sTester);
//////////////////////////////////////////////////// iVal_RunITC, iVal_RunITC_TCLO
pMain._SelectTab("Stichtag 2011 Final");
dic.Clear();
dic.Add("iMaxRowNum", "");
dic.Add("iMaxColNum", "");
dic.Add("iSelectRowNum", "4");
dic.Add("iSelectColNum", "1");
dic.Add("MenuItem_1", "Test Case");
dic.Add("MenuItem_2", "");
pMain._FlowTreeRightSelect(dic);
pMain._SelectTab("Test Case Library");
dic.Clear();
dic.Add("SelectionCriteria", "$emp.BirthDate=\"11/27/1946\"");
dic.Add("iResultRow", "1");
pTestCaseLibrary._AddTestCase(dic);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("RunSelectedTestLife", "Click");
pTestCaseLibrary._PopVerify_TestCaseLibrary(dic);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("AllLiabilityTypes", "True");
dic.Add("PPA_NAR_Min", "");
dic.Add("PPA_NAR_Max", "");
dic.Add("PPA_NAR_PVVB", "");
dic.Add("PBGC_NAR_PVVB", "");
dic.Add("FAS35_PVAB", "");
dic.Add("FAS35_PVVB", "");
dic.Add("Funding", "");
dic.Add("PayoutProjection", "");
dic.Add("RunSelected", "Click");
pTestCaseLibrary._PopVerify_TestCaseRunOption(dic);
_gLib._Enabled("Recalculate", pTestCaseLibrary.wTestCaseViewer.wRecalculate, Config.iTimeout * 3, true);
_gLib._Exists("Recalculate", pTestCaseLibrary.wTestCaseViewer.wViewTestCaseInExcel.txt.link, Config.iTimeout * 3, true);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("ViewTestCaseInExcel", "Click");
dic.Add("Close", "");
pTestCaseLibrary._PopVerify_TestCaseViewer(dic);
_gLib._Exists("Excel", pOutputManager.wExcel, Config.iTimeout * 3, true);
_gLib._KillProcessByName("EXCEL");
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("ViewTestCaseInExcel", "");
dic.Add("Close", "Click");
pTestCaseLibrary._PopVerify_TestCaseViewer(dic);
pMain._SelectTab("Test Case Library");
pMain._Home_ToolbarClick_Top(true);
pMain._Home_ToolbarClick_Top(false);
mLog_EU.LogInfo(iVal_RunITC, iLog_EU, Config.sTester);
mLog_EU.LogInfo(iVal_RunITC_TCLO, iLog_EU, Config.sTester);
//////////////////////////////////////////////////// iVal_IndividualListing
pMain._SelectTab("Stichtag 2011 Final");
dic.Clear();
dic.Add("iMaxRowNum", "");
dic.Add("iMaxColNum", "");
dic.Add("iSelectRowNum", "4");
dic.Add("iSelectColNum", "1");
dic.Add("MenuItem_1", "Actuarial Report");
dic.Add("MenuItem_2", "Edit Parameters");
pMain._FlowTreeRightSelect(dic);
pActuarialReport._SelectTab("Report Contents");
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("Copy", "click");
dic.Add("CopyAStandLayout", "true");
dic.Add("Template", "Direct promise default");
dic.Add("OK", "click");
pActuarialReport._ManageIndividualListingLayouts(dic);
pActuarialReport._SelectTab("Report Contents");
mLog_EU.LogInfo(iVal_IndividualListing, iLog_EU, Config.sTester);
//////////////////////////////////////////////////// iLaunchReportBuilder, iCustomRptTmpAndAccessible
pActuarialReport._SelectTab("Report Contents");
_gLib._SetSyncUDWin("wIndividualListingLayouts", pActuarialReport.wRetirementStudio.wRC_IndividualListingLayouts.listSpd, "Click", 0, false, 20, 15);
_gLib._SetSyncUDWin("Edit", pActuarialReport.wRetirementStudio.wRC_Edit.btn, "Click", 0);
_gLib._SetSyncUDWin("wReportBuilderDataSource - OK", pMain.wReportBuilderDataSource.wOK.btn, "Click", 0);
_gLib._SetSyncUDWin("wIE - Allow", pMain.wIE.wAllow.btn, "Click", 0);
_gLib._SetSyncUDWin("Report Builder Title", pMain.wSQLReportBuilder.wTitle.toolbar, "Click", 0);
_gLib._SetSyncUDWin("Report Builder - Close", pMain.wSQLReportBuilder.wClose.btn, "Click", 0);
pActuarialReport._SelectTab("Report Contents");
_gLib._SetSyncUDWin("wIndividualListingLayouts", pActuarialReport.wRetirementStudio.wRC_IndividualListingLayouts.listSpd, "Click", 0, false, 20, 15);
_gLib._SetSyncUDWin("Delete", pActuarialReport.wRetirementStudio.wRC_Delete.btn, "Click", 0);
pActuarialReport._SelectTab("Report Contents");
pMain._Home_ToolbarClick_Top(true);
pMain._Home_ToolbarClick_Top(false);
mLog_EU.LogInfo(iLaunchReportBuilder, iLog_EU, Config.sTester);
mLog_EU.LogInfo(iCustomRptTmpAndAccessible, iLog_EU, Config.sTester);
//////////////////////////////////////////////////// Delete the added test node
pMain._SelectTab("Stichtag 2011 Final");
dic.Clear();
dic.Add("iMaxRowNum", "");
dic.Add("iMaxColNum", "");
dic.Add("iSelectRowNum", "4");
dic.Add("iSelectColNum", "1");
dic.Add("iPosX", "");
dic.Add("iPosY", "");
dic.Add("MenuItem_1", "Delete Valuation Node");
dic.Add("MenuItem_2", "");
pMain._FlowTreeRightSelect(dic);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("OK", "Click");
pMain._PopVerify_DeleteValuationNode(dic);
pMain._SelectTab("Stichtag 2011 Final");
pMain._Home_ToolbarClick_Top(true);
pMain._Home_ToolbarClick_Top(false);
#endregion
#region Data
//////////////////////////////////////////////////// iData_Open
dic.Clear();
dic.Add("Country", Config.eCountry.ToString());
dic.Add("Level_1", Config.sClientName);
dic.Add("Level_2", Config.sPlanName);
dic.Add("Level_3", "ParticipantData");
pMain._HomeTreeViewSelect_Favorites(0, dic);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("AddServiceInstance", "");
dic.Add("ServiceToOpen", "Stichtag2011");
dic.Add("CheckPopup", "False");
pMain._PopVerify_Home_RightPane(dic);
pMain._SelectTab("Stichtag2011");
mLog_EU.LogInfo(iData_Open, iLog_EU, Config.sTester);
////////////////////////////////////////////////// iData_Upload
dic.Clear();
dic.Add("Level_1", "Stichtag2011");
dic.Add("Level_2", "Upload Data");
pData._TreeViewSelect(dic);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("LocalFile", "");
dic.Add("GRSUnloadFile", "");
dic.Add("SharepointFile", "");
dic.Add("RepositoryFileName", "");
dic.Add("Browse", "Click");
dic.Add("Upload", "");
pData._PopVerify_UploadData(dic);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("FileName", sOuput_Main + "\\Templates\\" + sUpLoadDataFileName);
dic.Add("Open", "Click");
dic.Add("Cancel", "");
pMain._PopVerify_FileOpen(dic);
sUpLoadDataFileName = sUpLoadDataFileName.Replace(".xlsx", _gLib._ReturnDateStampYYYYMMDDHHMMSS() + ".xls");
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("LocalFile", "");
dic.Add("GRSUnloadFile", "");
dic.Add("SharepointFile", "");
dic.Add("RepositoryFileName", sUpLoadDataFileName);
dic.Add("Browse", "");
dic.Add("Upload", "Click");
pData._PopVerify_UploadData(dic);
pMain._SelectTab("Stichtag2011");
mLog_EU.LogInfo(iData_Upload, iLog_EU, Config.sTester);
////////////////////////////////////////////////// iData_Import
dic.Clear();
dic.Add("Level_1", "Stichtag2011");
dic.Add("Level_2", "Imports");
dic.Add("MenuItem", "Add new file");
pData._TreeViewRightSelect(dic);
sImportName = sImportName + _gLib._ReturnDateStampYYYYMMDDHHMMSS();
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("FileDefinitionName", sImportName);
dic.Add("FileType", "");
dic.Add("Browse", "Click");
dic.Add("Preview", "");
pData._PopVerify_IP_SelectFile(dic);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("FileName", sUpLoadDataFileName);
dic.Add("OK", "Click");
dic.Add("Cancel", "");
pData._PopVerify_IP_SelectFile_FileSelection(dic);
pData._SelectTab("Mapping");
pData._IP_Mapping_Initialize("Personal Information", "Personal Information", 1, 0, 1, "IsEligible_VOParent");
pData._IP_Mapping_ClickEdit("USC", true);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("Lookup", "");
dic.Add("OK", "Click");
pData._PopVerify_IP_Mapping_Transformation(dic);
mLog_EU.LogInfo(iData_Import, iLog_EU, Config.sTester);
////////////////////////////////////////////////// iData_LV
pData._SelectTab("Validate & Load");
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("Status", "");
dic.Add("LoadBlankData", "");
dic.Add("MatchingIsCaseSensitive", "");
dic.Add("IgnoreGoneRecordsForMatching", "");
dic.Add("ValidateData", "");
dic.Add("LoadData", "");
dic.Add("ValidateAndLoadData", "Click");
pData._PopVerify_IP_ValidateAndLoad(dic);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("Message", "");
dic.Add("OK", "Click");
pData._PopVerify_IP_ValidateAndLoad_Popup(dic);
pData._SelectTab("Validate & Load");
mLog_EU.LogInfo(iData_LV, iLog_EU, Config.sTester);
////////////////////////////////////////////////// iData_Derivation
dic.Clear();
dic.Add("Level_1", "Stichtag2011");
dic.Add("Level_2", "Derivation Groups");
dic.Add("MenuItem", "Add new derivation group");
pData._TreeViewRightSelect(dic);
sDerivationName = sDerivationName + _gLib._ReturnDateStampYYYYMMDDHHMMSS();
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("DerivationGroupName", sDerivationName);
dic.Add("Filter", "");
dic.Add("MoveUp", "");
dic.Add("MoveDown", "");
dic.Add("Add", "");
dic.Add("Insert", "");
dic.Add("Delete", "");
dic.Add("AddWorkFields", "");
dic.Add("CalculateAndPreview", "");
dic.Add("SaveToWarehouse", "");
pData._PopVerify_DerivationGroups(dic);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("DerivationGroupName", "");
dic.Add("Filter", "");
dic.Add("MoveUp", "");
dic.Add("MoveDown", "");
dic.Add("Add", "Click");
dic.Add("Insert", "");
dic.Add("Delete", "");
dic.Add("AddWorkFields", "");
dic.Add("CalculateAndPreview", "");
dic.Add("SaveToWarehouse", "");
pData._PopVerify_DerivationGroups(dic);
dic.Clear();
dic.Add("iRow", "1");
dic.Add("Apply", "");
dic.Add("DerivedField", "Name");
dic.Add("DerivedField_SearchFromIndex", "");
dic.Add("Type", "");
dic.Add("Edit", "Click");
pData._DG_DerivationGrid(dic);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("Name", "");
dic.Add("SelectInputFields", "");
dic.Add("StandardorCustomFilter", "");
dic.Add("Filter", "");
dic.Add("CustomExpression", "");
dic.Add("CustomExpression_Formula", "");
dic.Add("Formula", "=\"DPTest\"");
dic.Add("Previous", "");
dic.Add("Next", "");
dic.Add("OK", "Click");
pData._PopVerify_DG_DerivationDefinition(dic);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("DerivationGroupName", "");
dic.Add("Filter", "");
dic.Add("MoveUp", "");
dic.Add("MoveDown", "");
dic.Add("Add", "");
dic.Add("Insert", "");
dic.Add("Delete", "");
dic.Add("AddWorkFields", "");
dic.Add("CalculateAndPreview", "Click");
dic.Add("SaveToWarehouse", "Click");
pData._PopVerify_DerivationGroups(dic);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("OK", "Click");
pData._PopVerify_DG_SaveDerivedValuesToWarehouse_Popup(dic);
pMain._SelectTab("Stichtag2011");
mLog_EU.LogInfo(iData_Derivation, iLog_EU, Config.sTester);
////////////////////////////////////////////////// iData_Snapshot
dic.Clear();
dic.Add("Level_1", "Stichtag2011");
dic.Add("Level_2", "Snapshots");
dic.Add("MenuItem", "Add new snapshot");
pData._TreeViewRightSelect(dic);
dic.Clear();
dic.Add("Level_1", "Include all");
dic.Add("Level_2", "Personal Information");
pData._TreeViewSelect_Snapshots(dic, true);
sSnapshotName = sSnapshotName + _gLib._ReturnDateStampYYYYMMDDHHMMSS();
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("SnapshotName", sSnapshotName);
dic.Add("UseLatestDate", "");
dic.Add("Preview", "");
dic.Add("PublishSnapshot", "");
dic.Add("CreateExtract", "");
pData._PopVerify_Snapshots(dic);
pMain._Home_ToolbarClick_Top(true);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("SnapshotName", "");
dic.Add("UseLatestDate", "");
dic.Add("Preview", "Click");
dic.Add("PublishSnapshot", "Click");
dic.Add("CreateExtract", "");
pData._PopVerify_Snapshots(dic);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("OK", "click");
pData._PopVerify_SP_Snapshots_Popup(dic);
pData._ts_SP_CreateExtract(sOutput_EU + "Data2013_SnapshotExtract.xlsx");
pMain._SelectTab("Stichtag2011");
mLog_EU.LogInfo(iData_Snapshot, iLog_EU, Config.sTester);
#endregion
_gLib._MsgBox("Completed!", "Please undo the DPTest Steps and delete Import/Derivation/Snapshot start with DPTest_");
_gLib._MsgBox("Warning!", "Please save & close data service and click OK to complete this testing.");
_gLib._MsgBox("Have a nice day!", "Greeting from WEBBER!");
}
/// <summary>
/// 2013-May-21
/// [email protected]
///
/// sample:
/// dic.Clear();
/// dic.Add("PopVerify", "Pop");
/// dic.Add("iRow", "1");
/// dic.Add("BreakFields", "TPlan");
/// dic.Add("TextSubstitution", "Click");
/// dic.Add("Remove", "Click");
/// dic.Add("OK", "");
/// pReportBreaks._PopVerify_ReportBreaks(dic);
/// </summary>
/// <param name="dic"></param>
public void _PopVerify_ReportBreaks(MyDictionary dic)
{
string sFunctionName = "_PopVerify_ReportBreaks";
_gLib._Report(_PassFailStep.Step, "Funcon <" + sFunctionName + "> Starts:");
if (dic["PopVerify"] == "Pop")
{
int iRow = 1;
int End_Y = 5;
if (dic["iRow"] != "")
{
iRow = Convert.ToInt32(dic["iRow"]);
}
End_Y = (iRow - 1) * (this.wReportBreaks.wBreakField_FPGrid.grid.Height / 6) + 8;
if (dic["BreakFields"] != "")
{
_gLib._SetSyncUDWin("FPGrid", this.wReportBreaks.wBreakField_FPGrid.grid, "Click", 0, false, 80, End_Y);
string sChar = dic["BreakFields"].Substring(0, 1);
_gLib._SendKeysUDWin("FPGrid", this.wReportBreaks.wBreakField_FPGrid.grid, sChar);
_gLib._SetSyncUDWin("BreakFields", this.wReportBreaks.wBreakField.cbo, dic["BreakFields"], 0);
}
if (dic["Remove"] != "")
{
try
{
_gLib._SetSyncUDWin("FPGrid", this.wReportBreaks.wBreakField_FPGrid.grid, "Click", 0, false, 80, End_Y);
_gLib._SetSyncUDWin("FPGrid", this.wReportBreaks.wBreakField_FPGrid.grid, "Click", 0, false, 80, End_Y);
Mouse.Click(this.wReportBreaks.wBreakField_FPGrid.grid, MouseButtons.Right, ModifierKeys.None, new Point(80, End_Y));
}
catch (Exception ex)
{
_gLib._Report(_PassFailStep.Fail, "Function <" + sFunctionName + "> fail to Right Click on Node Flow Tree. Because of Exception thrown: " + Environment.NewLine + ex.Message);
_gLib._MsgBoxYesNo("Continue Testing?", "Fail: Function <" + sFunctionName + "> fail to Right Click on Node Flow Tree. Because of Exception thrown: " + Environment.NewLine + ex.Message);
}
WinWindow wWin = new WinWindow();
wWin.SearchProperties.Add(WinWindow.PropertyNames.AccessibleName, "DropDown");
wWin.SearchProperties.Add(WinWindow.PropertyNames.ClassName, "WindowsForms10.Window", PropertyExpressionOperator.Contains);
wWin.SearchConfigurations.Add(SearchConfiguration.AlwaysSearch);
wWin.SearchConfigurations.Add(SearchConfiguration.VisibleOnly);
MyDictionary dicTmp = new MyDictionary();
dicTmp.Clear();
dicTmp.Add("Level_1", "Remove");
_gLib._MenuSelectWin(0, wWin, dicTmp);
}
_gLib._SetSyncUDWin("TextSubstitution", this.wReportBreaks.wTextSubstitution.btn, dic["TextSubstitution"], 0);
_gLib._SetSyncUDWin("OK", this.wReportBreaks.wOK.btn, dic["OK"], 0);
}
_gLib._Report(_PassFailStep.Step, "Function <" + sFunctionName + "> Ends:");
}
public static void Clear()
{
map.Clear();
}
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.
}
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 Clear()
{
m_DataContainer.Clear();
}
public string _OpenServiceWithEffectiveDate(int iIndex, string sYear)
{
string sFunctionName = "_OpenServiceWithEffectiveDate";
int ixPos = 80;
int iyPos = 30;
int iyStep = 20;
string sServiceToOpen = "";
pMain._SelectTab("Home");
#region check service property to identify the expected service year
try
{
Mouse.Click(pMain.wRetirementStudio.wHome_TableView.cHome_TableView, MouseButtons.Right, ModifierKeys.None, new Point(ixPos, iyPos + iyStep * (iIndex - 1)));
}
catch (Exception ex)
{
_gLib._Report(_PassFailStep.Fail, "\t\tFunction <" + sFunctionName + "> fail to Right click on <Home Service Pane>. Because of Exception thrown: " + Environment.NewLine + ex.Message);
_gLib._MsgBoxYesNo("Continue Testing?", "Fail: Function <" + sFunctionName + "> fail to Right click on <Home Service Pane>. Because of Exception thrown: " + Environment.NewLine + ex.Message);
}
WinWindow wWin = new WinWindow();
wWin.SearchProperties.Add(WinWindow.PropertyNames.AccessibleName, "DropDown");
wWin.SearchProperties.Add(WinWindow.PropertyNames.ClassName, "WindowsForms10.Window", PropertyExpressionOperator.Contains);
wWin.SearchConfigurations.Add(SearchConfiguration.AlwaysSearch);
wWin.SearchConfigurations.Add(SearchConfiguration.VisibleOnly);
if (!_gLib._Exists("DropDown Menu Parent Win", wWin, 1, false))
{
try
{
Mouse.Click(pMain.wRetirementStudio.wHome_TableView.cHome_TableView, MouseButtons.Right, ModifierKeys.None, new Point(ixPos, iyPos + iyStep * (iIndex - 1)));
}
catch (Exception ex)
{
_gLib._Report(_PassFailStep.Fail, "\t\tFunction <" + sFunctionName + "> fail to Right click on <Home Service Pane>. Because of Exception thrown: " + Environment.NewLine + ex.Message);
_gLib._MsgBoxYesNo("Continue Testing?", "Fail: Function <" + sFunctionName + "> fail to Right click on <Home Service Pane>. Because of Exception thrown: " + Environment.NewLine + ex.Message);
}
}
if (_gLib._Exists("DropDown Menu Parent Win", wWin, 0, false))
{
WinMenuItem mi = new WinMenuItem((UITestControl)wWin);
mi.SearchConfigurations.Add(SearchConfiguration.ExpandWhileSearching);
mi.SearchProperties.Add(WinMenuItem.PropertyNames.Name, "Properties");
if (_gLib._Enabled("", mi, 0, false))
{
MyDictionary dicTmp = new MyDictionary();
dicTmp.Clear();
dicTmp.Add("Level_1", "Properties");
_gLib._MenuSelectWin(0, wWin, dicTmp);
string sInfo = pMain.wHome_DataServiceProperties.wEffectiveDate.txtEffectiveDate.GetProperty("Value").ToString();
sServiceToOpen = pMain.wHome_DataServiceProperties.wName.txtName.GetProperty("Value").ToString();
_gLib._SetSyncUDWin("wHome_DataServiceProperties", pMain.wHome_DataServiceProperties.wCancel.btnCancel, "Click", 0);
if (sInfo.Contains(sYear))
{
_gLib._SetSyncUDWin("Home - Right Pane", pMain.wRetirementStudio.wHome_TableView.cHome_TableView, "Click", 0, false, ixPos, iyPos + iyStep * (iIndex - 1));
if (_gLib._Exists("wServiceInstanceLocked", pMain.wServiceInstanceLocked, 1, 1, false))
{
_gLib._SetSyncUDWin("wServiceInstanceLocked", pMain.wServiceInstanceLocked.wTitle, "Click", 0);
_gLib._SetSyncUDWin("Cancel", pMain.wServiceInstanceLocked.wCancel.btn, "Click", 0);
return("E_ServiceLocked");
}
return(sServiceToOpen);
}
else
{
return("");
}
}
else
{
return("END");
}
}
else
{
return("E_Unknown");
}
#endregion
}
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
}
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_ANZ001_RB()
{
this.GenerateReportOuputDir();
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 2014");
pMain._PopVerify_Home_RightPane(dic);
pMain._SelectTab("Accounting 2014");
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", "ServiceFromBenAccDate");
dic.Add("Pay", "SalaryCurrentYear");
dic.Add("CurrentYear", "True");
dic.Add("PriorYear", "");
dic.Add("CashBanlance", "TotalEmployeeContributions");
dic.Add("Pension", "#1#");
dic.Add("AllLiabilityTypes", "");
dic.Add("Acc_AccumulatedBenefitObligation", "True");
dic.Add("Acc_ProjectedBenefitObligation", "True");
dic.Add("EntryAgeNormal", "");
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);
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 with 1 NP", true);
pMain._SelectTab("Accounting 2014");
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", "Click");
dic.Add("Checker", "");
dic.Add("Reviewer", "");
dic.Add("Setup", "");
pOutputManager._PopVerify_OutputManager(dic);
pOutputManager._ExportReport_Others(sOutputAccounting_Accounting2014, "Parameter Print", "Conversion", true, false);
pOutputManager._ExportReport_Common(sOutputAccounting_Accounting2014, "Valuation Summary", "Conversion", true, false);
if (Config.bDownloadReports_PDF)
{
pOutputManager._ExportReport_Others(sOutputAccounting_Accounting2014, "Liability Summary", "Conversion", true, false);
pOutputManager._ExportReport_DrillDown(sOutputAccounting_Accounting2014, "Liability Summary", "Conversion", true, false, 0);
pOutputManager._ExportReport_Common(sOutputAccounting_Accounting2014, "Member Statistics", "Conversion", true, false);
pOutputManager._ExportReport_DrillDown(sOutputAccounting_Accounting2014, "Conversion Diagnostic", "Conversion", true, false, 0);
pOutputManager._ExportReport_Others(sOutputAccounting_Accounting2014, "Conversion Diagnostic", "Conversion", true, false);
pOutputManager._ExportReport_Common(sOutputAccounting_Accounting2014, "Test Case List", "Conversion", true, false);
pOutputManager._ExportReport_Common(sOutputAccounting_Accounting2014, "Detailed Results", "Conversion", true, false);
pOutputManager._ExportReport_Others(sOutputAccounting_Accounting2014, "Individual Output", "Conversion", true, false);
pOutputManager._ExportReport_Others(sOutputAccounting_Accounting2014, "Test Cases", "Conversion", true, false);
pOutputManager._ExportReport_Others(sOutputAccounting_Accounting2014, "Payout Projection", "Conversion", true, false);
pOutputManager._ExportReport_Common(sOutputAccounting_Accounting2014, "FAS Expected Benefit Pmts", "Conversion", true, false);
}
if (Config.bDownloadReports_EXCEL)
{
pOutputManager._ExportReport_Others(sOutputAccounting_Accounting2014, "Liability Summary", "Conversion", false, false);
pOutputManager._ExportReport_DrillDown(sOutputAccounting_Accounting2014, "Liability Summary", "Conversion", false, false, 0);
pOutputManager._ExportReport_Common(sOutputAccounting_Accounting2014, "Member Statistics", "Conversion", false, false);
pOutputManager._ExportReport_DrillDown(sOutputAccounting_Accounting2014, "Conversion Diagnostic", "Conversion", false, false, 0);
pOutputManager._ExportReport_Others(sOutputAccounting_Accounting2014, "Conversion Diagnostic", "Conversion", false, false);
pOutputManager._ExportReport_Common(sOutputAccounting_Accounting2014, "Test Case List", "Conversion", false, false);
pOutputManager._ExportReport_Common(sOutputAccounting_Accounting2014, "Detailed Results", "Conversion", false, false);
pOutputManager._ExportReport_Common(sOutputAccounting_Accounting2014, "Detailed Results by Plan Def", "Conversion", false, false);
pOutputManager._ExportReport_Common(sOutputAccounting_Accounting2014, "Valuation Summary", "Conversion", false, false);
pOutputManager._ExportReport_Others(sOutputAccounting_Accounting2014, "Individual Output", "Conversion", false, false);
pOutputManager._ExportReport_Others(sOutputAccounting_Accounting2014, "IOE", "Conversion", false, false);
pOutputManager._ExportReport_Others(sOutputAccounting_Accounting2014, "Payout Projection", "Conversion", false, false);
pOutputManager._ExportReport_Common(sOutputAccounting_Accounting2014, "FAS Expected Benefit Pmts", "Conversion", false, false);
}
pMain._SelectTab("Output Manager");
pMain._Home_ToolbarClick_Top(true);
pMain._Home_ToolbarClick_Top(false);
pMain._SelectTab("Accounting 2014");
dic.Clear();
dic.Add("iMaxRowNum", "");
dic.Add("iMaxColNum", "");
dic.Add("iSelectRowNum", "1");
dic.Add("iSelectColNum", "1");
dic.Add("MenuItem_1", "Parameter Print");
pMain._FlowTreeRightSelect(dic);
pOutputManager._ParameterPrint_Standalone(sOutputAccounting_Accounting2014);
pMain._Home_ToolbarClick_Top(true);
pMain._Home_ToolbarClick_Top(false);
_gLib._MsgBox("Congratulations!", "Finished!");
}
/// <summary>
/// 2015-Dec-4
/// [email protected]
///
/// sample:
/// dic.Clear();
/// dic.Add("PopVerify", "Pop");
/// dic.Add("iRow", "1");
/// dic.Add("BreakFieldValue", "");
/// dic.Add("SubstitutionText", "");
/// dic.Add("Remove", "Click");
/// dic.Add("OK", "");
/// pReportBreaks._BreakFieldTextSubstitution_TextSubstitution(dic);
/// </summary>
/// <param name="dic"></param>
public void _BreakFieldTextSubstitution_TextSubstitution(MyDictionary dic)
{
string sFunctionName = "_PopVerify_ReportBreaks";
_gLib._Report(_PassFailStep.Step, "Funcon <" + sFunctionName + "> Starts:");
if (dic["PopVerify"] == "Pop")
{
int iRow = 1;
string sRow = "";
if (dic["iRow"] != "")
{
iRow = Convert.ToInt32(dic["iRow"]);
}
for (int i = 2; i <= iRow; i++)
{
sRow = sRow + "{Down}";
}
if (dic["BreakFieldValue"] != "")
{
_gLib._SetSyncUDWin("FPGrid", this.wBreakfieldtextsubstitution.wTextSubstitution.grid, "Click", 0, false, 20, 25);
_gLib._SendKeysUDWin("FPGrid", this.wBreakfieldtextsubstitution.wTextSubstitution.grid, "{PageUp}{PageUp}" + sRow, 0);
_gLib._SendKeysUDWin("FPGrid", this.wBreakfieldtextsubstitution.wTextSubstitution.grid, dic["BreakFieldValue"], 0);
_gLib._SendKeysUDWin("FPGrid", this.wBreakfieldtextsubstitution.wTextSubstitution.grid, "{Enter}{PageUp}{PageUp}{Home}" + sRow, 0);
if (this._fp._ReturnSelectRowContent(this.wBreakfieldtextsubstitution.wTextSubstitution.grid) != dic["BreakFieldValue"])
{
_gLib._MsgBoxYesNo("", "Function failed: The exception value is: " + dic["BreakFieldValue"] + "but the actual value is: " + this._fp._ReturnSelectRowContent(this.wBreakfieldtextsubstitution.wTextSubstitution.grid));
}
}
if (dic["SubstitutionText"] != "")
{
_gLib._SetSyncUDWin("FPGrid", this.wBreakfieldtextsubstitution.wTextSubstitution.grid, "Click", 0, false, 20, 25);
_gLib._SendKeysUDWin("FPGrid", this.wBreakfieldtextsubstitution.wTextSubstitution.grid, "{PageUp}{PageUp}{Home}" + sRow + "{Tab}", 0);
_gLib._SendKeysUDWin("FPGrid", this.wBreakfieldtextsubstitution.wTextSubstitution.grid, dic["SubstitutionText"], 0);
_gLib._SendKeysUDWin("FPGrid", this.wBreakfieldtextsubstitution.wTextSubstitution.grid, "{Enter}{PageUp}{PageUp}{Home}" + sRow + "{Tab}", 0);
if (this._fp._ReturnSelectRowContent(this.wBreakfieldtextsubstitution.wTextSubstitution.grid) != dic["SubstitutionText"])
{
_gLib._MsgBoxYesNo("", "Function failed: The exception value is: " + dic["SubstitutionText"] + "but the actual value is: " + this._fp._ReturnSelectRowContent(this.wBreakfieldtextsubstitution.wTextSubstitution.grid));
}
}
if (dic["Remove"] != "")
{
_gLib._SetSyncUDWin("FPGrid", this.wBreakfieldtextsubstitution.wTextSubstitution.grid, "Click", 0, false, 20, 25);
_gLib._SendKeysUDWin("FPGrid", this.wBreakfieldtextsubstitution.wTextSubstitution.grid, "{PageUp}{PageUp}{Home}" + sRow, 0);
try
{
Mouse.Click(this.wBreakfieldtextsubstitution.wTextSubstitution.grid, MouseButtons.Right, ModifierKeys.None, new Point(30, 30));
}
catch (Exception ex)
{
_gLib._Report(_PassFailStep.Fail, "Function <" + sFunctionName + "> fail to Right Click on Node Flow Tree. Because of Exception thrown: " + Environment.NewLine + ex.Message);
_gLib._MsgBoxYesNo("Continue Testing?", "Fail: Function <" + sFunctionName + "> fail to Right Click on Node Flow Tree. Because of Exception thrown: " + Environment.NewLine + ex.Message);
}
WinWindow wWin = new WinWindow();
wWin.SearchProperties.Add(WinWindow.PropertyNames.AccessibleName, "DropDown");
wWin.SearchProperties.Add(WinWindow.PropertyNames.ClassName, "WindowsForms10.Window", PropertyExpressionOperator.Contains);
wWin.SearchConfigurations.Add(SearchConfiguration.AlwaysSearch);
wWin.SearchConfigurations.Add(SearchConfiguration.VisibleOnly);
MyDictionary dicTmp = new MyDictionary();
dicTmp.Clear();
dicTmp.Add("Level_1", "Remove");
_gLib._MenuSelectWin(0, wWin, dicTmp);
}
_gLib._SetSyncUDWin("OK", this.wBreakfieldtextsubstitution.wOK.btn, dic["OK"], 0);
}
_gLib._Report(_PassFailStep.Step, "Function <" + sFunctionName + "> Ends:");
}
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_UK004_RB()
{
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", "Valuation June 2008");
pMain._PopVerify_Home_RightPane(dic);
pMain._SelectTab("Valuation June 2008");
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", "PayVectorCurrentYear");
dic.Add("CurrentYear", "True");
dic.Add("PriorYear", "");
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("Valuation June 2008");
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 June 2008");
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(Config.eCountry, sOutputFunding_ValuationJune2008, "Parameter Print", "Conversion", true, true);
pOutputManager._ExportReport_Others(Config.eCountry, sOutputFunding_ValuationJune2008, "Test Cases", "Conversion", true, true);
if (Config.bDownloadReports_PDF)
{
pOutputManager._ExportReport_Others(Config.eCountry, sOutputFunding_ValuationJune2008, "Liability Summary", "Conversion", true, true);
pOutputManager._ExportReport_Common(Config.eCountry, sOutputFunding_ValuationJune2008, "Member Statistics", "Conversion", true, true);
pOutputManager._ExportReport_DrillDown(sOutputFunding_ValuationJune2008, "Conversion Diagnostic", "Conversion", true, true, 0);
pOutputManager._ExportReport_Common(Config.eCountry, sOutputFunding_ValuationJune2008, "Valuation Summary", "Conversion", true, true);
pOutputManager._ExportReport_Others(Config.eCountry, sOutputFunding_ValuationJune2008, "Individual Output", "Conversion", true, true);
}
if (Config.bDownloadReports_EXCEL)
{
pOutputManager._ExportReport_Others(Config.eCountry, sOutputFunding_ValuationJune2008, "Liability Summary", "Conversion", false, true);
pOutputManager._ExportReport_Common(Config.eCountry, sOutputFunding_ValuationJune2008, "Member Statistics", "Conversion", false, true);
pOutputManager._ExportReport_DrillDown(sOutputFunding_ValuationJune2008, "Conversion Diagnostic", "Conversion", false, true, 0);
pOutputManager._ExportReport_Common(Config.eCountry, sOutputFunding_ValuationJune2008, "Detailed Results", "Conversion", false, true);
pOutputManager._ExportReport_Others(Config.eCountry, sOutputFunding_ValuationJune2008, "Detailed Results with Ben Type splits", "Conversion", false, true);
pOutputManager._ExportReport_Common(Config.eCountry, sOutputFunding_ValuationJune2008, "Valuation Summary", "Conversion", false, true);
pOutputManager._ExportReport_Others(Config.eCountry, sOutputFunding_ValuationJune2008, "Individual Output", "Conversion", false, true);
pOutputManager._ExportReport_Others(Config.eCountry, sOutputFunding_ValuationJune2008, "IOE", "Conversion", false, true);
pOutputManager._ExportReport_Others(Config.eCountry, sOutputFunding_ValuationJune2008, "Payout Projection - Benefit Cashflows", "Conversion", false, true);
pOutputManager._ExportReport_Others(Config.eCountry, sOutputFunding_ValuationJune2008, "Payout Projection - Other Info", "Conversion", false, true);
}
pMain._SelectTab("Valuation June 2008");
pMain._Home_ToolbarClick_Top(true);
pMain._Home_ToolbarClick_Top(false);
_gLib._MsgBox("Congratulations!", "Finished!");
}
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 testVAL_Load_BV()
{
_gLib._MsgBox("Warning!", "Make sure the Val serivce is opened <" + sValService + "> Click OK to start!");
pMain._SelectTab(sValService);
for (int i = 1; i <= 10; i++)
{
#region Step 1 - Add Node
pMain._SelectTab("Valuation2012");
dic.Clear();
dic.Add("iMaxRowNum", "");
dic.Add("iMaxColNum", "");
dic.Add("iSelectRowNum", "");
dic.Add("iSelectColNum", "");
dic.Add("iPosX", dicBaselinePosition["X_" + i.ToString()]);
dic.Add("iPosY", dicBaselinePosition["Y_" + i.ToString()]);
dic.Add("MenuItem_1", "Add Valuation Node");
dic.Add("MenuItem_2", "");
pMain._FlowTreeRightSelect(dic);
dic.Clear();
dic.Add("PopVerify", "Pop");
dic.Add("ValNodeName", "Node00" + i.ToString());
dic.Add("LiabilityValuationDate", "");
dic.Add("Data_AddNew", "True");
dic.Add("Data_Name", "");
dic.Add("Data_Edit", "");
dic.Add("Assumptions_AddNew", "True");
dic.Add("Assumptions_Name", "");
dic.Add("Assumptions_Edit", "");
dic.Add("MethodsLiabilities_AddNew", "True");
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("Valuation2012");
#endregion
}
pMain._SelectTab("Valuation2012");
_gLib._MsgBox("Congratulations!", "Click OK to stop!");
}
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");
}
/// <summary>
/// 2015-June-26
/// [email protected]
///
/// sample:
/// pTrancheDefinition._DefinitionFPGrid_RightSelect("Active", 1, "Pre1997", "Edit Tranche");
/// pTrancheDefinition._DefinitionFPGrid_RightSelect("Deferred", 1, "Pre1997", "Edit Tranche");
/// pTrancheDefinition._DefinitionFPGrid_RightSelect("Pensioner", 1, "Pre1997", "Edit Tranche");
/// pTrancheDefinition._DefinitionFPGrid_RightSelect("Pensioner", 3, "Pst2005", "Edit Tranche");
/// </summary>
/// <param name="sType"></param>
/// <param name="sMenuItem"></param>
public void _DefinitionFPGrid_RightSelect(string sType, int iRow, string sLabel, string sMenuItem)
{
string sFunctionName = "_DefinitionFPGrid_RightSelect";
_gLib._Report(_PassFailStep.Step, "Function <" + sFunctionName + "> Starts:");
string sActLabel = "";
string sDownKeys = "{PageUp}";
for (int i = 1; i < iRow; i++)
{
sDownKeys = sDownKeys + "{Down}";
}
WinClient grid = new WinClient();
switch (sType)
{
case "Active":
grid = this.wRetirementStudio.wActive_Definitions_FPGrid.grid;
break;
case "Deferred":
grid = this.wRetirementStudio.wDeferred_Definitions_FPGrid.grid;
break;
case "Pensioner":
grid = this.wRetirementStudio.wPensioner_Definitions_FPGrid.grid;
break;
default:
_gLib._MsgBoxYesNo("Continue Testing?", "Fail: Function <" + sFunctionName + "> failed because input Type does NOT exists.");
break;
}
_gLib._SetSyncUDWin(sType, grid, "Click", 0, false, 30, 40);
_gLib._SendKeysUDWin(sType, grid, sDownKeys);
sActLabel = _fp._ReturnSelectRowContentByClipboard(grid);
if (!sActLabel.ToUpper().Contains(sLabel.ToUpper()))
{
_gLib._Report(_PassFailStep.Fail, "Function <" + sFunctionName + "> fail to find label <" + sLabel + "> at row <" + iRow + "> on grid <" + sType + ">");
_gLib._MsgBoxYesNo("Continue Testing?", "Fail: Function <" + sFunctionName + "> fail to find label <" + sLabel + "> at row <" + iRow + "> on grid <" + sType + ">");
}
else
{
try
{
Mouse.Click(grid, MouseButtons.Right, ModifierKeys.None, new Point(30, 40 + (iRow - 1) * 20));
}
catch (Exception ex)
{
_gLib._Report(_PassFailStep.Fail, "Function <" + sFunctionName + "> fail to Right click ongrid <" + sType + ">. Because of Exception thrown: " + Environment.NewLine + ex.Message);
_gLib._MsgBoxYesNo("Continue Testing?", "Fail: Function <" + sFunctionName + "> fail to Right click on TreeView item <" + sType + ">. Because of Exception thrown: " + Environment.NewLine + ex.Message);
}
WinWindow wWin = new WinWindow();
wWin.SearchProperties.Add(WinWindow.PropertyNames.AccessibleName, "DropDown");
wWin.SearchProperties.Add(WinWindow.PropertyNames.ClassName, "WindowsForms10.Window", PropertyExpressionOperator.Contains);
wWin.SearchConfigurations.Add(SearchConfiguration.AlwaysSearch);
wWin.SearchConfigurations.Add(SearchConfiguration.VisibleOnly);
if (_gLib._Exists("DropDown Menu Parent Win", wWin, 0))
{
MyDictionary dicTmp = new MyDictionary();
dicTmp.Clear();
dicTmp.Add("Level_1", sMenuItem);
_gLib._MenuSelectWin(0, wWin, dicTmp);
}
}
_gLib._Report(_PassFailStep.Step, "Function <" + sFunctionName + "> Ends:");
}
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 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_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");
}
