Exemplo n.º 1
0
        public void GenerateReportOuputDir()
        {
            pMain._SetLanguageAndRegional();
            _BenchmarkUser sCurrentUser = _gLib._ReturnCurrentUser();

            if (sCurrentUser.ToString() == "Others")
            {
                _gLib._MsgBox("Warning !!!", "Your are NOT allowed to create folders in \\mercer.com\\US_Data\\Shared\\Dfl\\Data1\\RSS\\SQA drive, Please contact Cindy or Webber if you have to!");
                Environment.Exit(0);
            }
            else
            {
                string sMainDir = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_CA_Benchmark_2\Production\";
                string sPostFix = Config.sProductionVerison + "_" + _gLib._ReturnDateStampYYYYMMDD();

                _gLib._MsgBoxYesNo("Are you sure to create folders under below directory ?", sMainDir);

                sOutputFund09 = _gLib._CreateDirectory(sMainDir + "Fund09\\" + sPostFix + "\\");
            }


            string sContent = "";

            sContent = sContent + "sOutputFund09 = @\"" + sOutputFund09 + "\";" + Environment.NewLine;

            _gLib._PrintReportDirectory(sContent);
        }
Exemplo n.º 2
0
        //////public string sOutputAccounting_Valuation2012_InterestSensitivity585_Prod = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_NL_Benchmark_004\Production\Valuation 2012\InterestSensitivity 5.85%\7.3.2_20181121_B\";



        public void GenerateReportOuputDir()
        {
            pMain._SetLanguageAndRegional();
            if (!Config.bReportsStoreLocal)
            {
                _BenchmarkUser sCurrentUser = _gLib._ReturnCurrentUser();
                if (sCurrentUser.ToString() == "Others")
                {
                    _gLib._MsgBox("Warning !!!", "Your are NOT allowed to create folders in \\mercer.com\\US_Data\\Shared\\Dfl\\Data1\\RSS\\SQA drive, Please contact Cindy or Webber if you have to!");
                    Environment.Exit(0);
                }
                else
                {
                    string sMainDir = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_NL_Benchmark_004\Existing\";
                    string sPostFix = _gLib._ReturnDateStampYYYYMMDD() + "_" + Config.eEnv.ToString();

                    //////_gLib._MsgBoxYesNo("Are you sure to create folders under below directory ?", sMainDir);

                    sOutputAccounting_Conversion2011         = _gLib._CreateDirectory(sMainDir + "Conversion 2011\\" + sPostFix + "\\");
                    sOutputAccounting_Valuation2012_Baseline = _gLib._CreateDirectory(sMainDir + "Valuation 2012\\Baseline\\" + sPostFix + "\\");

                    //////sOutputAccounting_Valuation2012_InterestSensitivity585 = _gLib._CreateDirectory(sMainDir + "Valuation 2012\\InterestSensitivity 5.85%\\" + sPostFix + "\\");
                }
            }

            string sContent = "";

            sContent = sContent + "sOutputAccounting_Conversion2011 = @\"" + sOutputAccounting_Conversion2011 + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting_Valuation2012_Baseline = @\"" + sOutputAccounting_Valuation2012_Baseline + "\";" + Environment.NewLine;

            ////sContent = sContent + "sOutputAccounting_Valuation2012_InterestSensitivity585 = @\"" + sOutputAccounting_Valuation2012_InterestSensitivity585 + "\";" + Environment.NewLine;
            _gLib._PrintReportDirectory(sContent);
        }
Exemplo n.º 3
0
        public void GenerateReportOuputDir()
        {
            pMain._SetLanguageAndRegional();

            if (!Config.bReportsStoreLocal)
            {
                _BenchmarkUser sCurrentUser = _gLib._ReturnCurrentUser();
                if (sCurrentUser.ToString() == "Others")
                {
                    _gLib._MsgBox("Warning !!!", "Your are NOT allowed to create folders in \\mercer.com\\US_Data\\Shared\\Dfl\\Data1\\RSS\\SQA drive, Please contact Cindy or Webber if you have to!");
                    Environment.Exit(0);
                }
                else
                {
                    string sMainDir = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_009_Saks\Existing\";
                    string sPostFix = _gLib._ReturnDateStampYYYYMMDD() + "_" + Config.eEnv.ToString();
                    sOutputFunding_2005Funding_Baseline       = _gLib._CreateDirectory(sMainDir + "2005 Funding\\" + sPostFix + "\\");
                    sOutputFunding_2006Funding_Baseline       = _gLib._CreateDirectory(sMainDir + "2006 Funding\\" + sPostFix + "\\");
                    sOutputAccounting_Accounting2005_Baseline = _gLib._CreateDirectory(sMainDir + "Accounting 2005\\" + sPostFix + "\\");
                    sOutputAccounting_Accounting2006_Baseline = _gLib._CreateDirectory(sMainDir + "Accounting 2006\\" + sPostFix + "\\");
                }
            }


            string sContent = "";

            sContent = sContent + "sOutputFunding_2005Funding_Baseline = @\"" + sOutputFunding_2005Funding_Baseline + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputFunding_2006Funding_Baseline = @\"" + sOutputFunding_2006Funding_Baseline + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting_Accounting2005_Baseline = @\"" + sOutputAccounting_Accounting2005_Baseline + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting_Accounting2006_Baseline = @\"" + sOutputAccounting_Accounting2006_Baseline + "\";" + Environment.NewLine;

            _gLib._PrintReportDirectory(sContent);
        }
Exemplo n.º 4
0
        public void GenerateReportOuputDir()
        {
            pMain._SetLanguageAndRegional();

            if (!Config.bReportsStoreLocal)
            {
                _BenchmarkUser sCurrentUser = _gLib._ReturnCurrentUser();
                if (sCurrentUser.ToString() == "Others")
                {
                    _gLib._MsgBox("Warning !!!", "Your are NOT allowed to create folders in \\mercer.com\\US_Data\\Shared\\Dfl\\Data1\\RSS\\SQA drive, Please contact Cindy or Webber if you have to!");
                    Environment.Exit(0);
                }
                else
                {
                    string sMainDir = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_007_Keihin\Create New\";
                    string sPostFix = _gLib._ReturnDateStampYYYYMMDD() + "_" + Config.eEnv.ToString();

                    //////_gLib._MsgBoxYesNo("Are you sure to create folders under below directory ?", sMainDir);

                    sOutputFunding2005    = _gLib._CreateDirectory(sMainDir + "Funding 2005\\" + sPostFix + "\\");
                    sOutputFunding2006    = _gLib._CreateDirectory(sMainDir + "Funding 2006\\" + sPostFix + "\\");
                    sOutputAccounting2005 = _gLib._CreateDirectory(sMainDir + "2005 Accounting\\" + sPostFix + "\\");
                    sOutputAccounting2006 = _gLib._CreateDirectory(sMainDir + "2006 Accounting\\" + sPostFix + "\\");
                }
            }
            else
            {
                // get the main reports directory
                string sDir = Directory.GetCurrentDirectory();
                for (int i = 0; i < 3; i++)
                {
                    DirectoryInfo info = Directory.GetParent(sDir);
                    sDir = info.FullName;
                }

                /// this is for VS2012 folder structure
                sDir = sDir + "\\" + Config._ReturnProjectName() + "\\_Reports\\";

                //////sDir = sDir + "\\_TestLog\\";

                string sMainDir = sDir + "US007_" + _gLib._ReturnDateStampYYYYMMDD();

                //////_gLib._MsgBoxYesNo("Are you sure to create folders under below directory ?", sMainDir);

                _gLib._CreateDirectory(sMainDir);
                sOutputFunding2005    = _gLib._CreateDirectory(sMainDir + "\\Funding2005\\");
                sOutputFunding2006    = _gLib._CreateDirectory(sMainDir + "\\Funding2006\\");
                sOutputAccounting2005 = _gLib._CreateDirectory(sMainDir + "\\Accounting2005\\");
                sOutputAccounting2006 = _gLib._CreateDirectory(sMainDir + "\\Accounting2006\\");
            }

            string sContent = "";

            sContent = sContent + "sOutputFunding2005 = @\"" + sOutputFunding2005 + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputFunding2006 = @\"" + sOutputFunding2006 + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting2005 = @\"" + sOutputAccounting2005 + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting2006 = @\"" + sOutputAccounting2006 + "\";" + Environment.NewLine;

            _gLib._PrintReportDirectory(sContent);
        }
Exemplo n.º 5
0
        public void GenerateReportOuputDir()
        {
            pMain._SetLanguageAndRegional();
            if (!Config.bReportsStoreLocal)
            {
                _BenchmarkUser sCurrentUser = _gLib._ReturnCurrentUser();
                if (sCurrentUser.ToString() == "Others")
                {
                    _gLib._MsgBox("Warning !!!", "Your are NOT allowed to create folders in \\mercer.com\\US_Data\\Shared\\Dfl\\Data1\\RSS\\SQA drive, Please contact Cindy or Webber if you have to!");
                    Environment.Exit(0);
                }
                else
                {
                    string sMainDir = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_019_PPA\Existing\";
                    string sPostFix = _gLib._ReturnDateStampYYYYMMDD() + "_" + Config.eEnv.ToString();

                    //////_gLib._MsgBoxYesNo("Are you sure to create folders under below directory ?", sMainDir);


                    sFunding2018_FutureValRun    = _gLib._CreateDirectory(sMainDir + "Funding\\1.1.2018 Funding Valuation\\Future Val Run\\" + sPostFix + "\\");
                    sAccounting2018_FutureValRun = _gLib._CreateDirectory(sMainDir + "Accounting\\1.1.2018 Accounting Valuation\\Future Val Run\\" + sPostFix + "\\");
                }
            }
            else
            {
            }

            string sContent = "";

            sContent = sContent + "sFunding2018_FutureValRun = @\"" + sFunding2018_FutureValRun + "\";" + Environment.NewLine;
            sContent = sContent + "sAccounting2018_FutureValRun = @\"" + sAccounting2018_FutureValRun + "\";" + Environment.NewLine;

            _gLib._PrintReportDirectory(sContent);
        }
Exemplo n.º 6
0
        public void GenerateReportOuputDir()
        {
            pMain._SetLanguageAndRegional();

            if (!Config.bReportsStoreLocal)
            {
                _BenchmarkUser sCurrentUser = _gLib._ReturnCurrentUser();
                if (sCurrentUser.ToString() == "Others")
                {
                    _gLib._MsgBox("Warning !!!", "Your are NOT allowed to create folders in \\mercer.com\\US_Data\\Shared\\Dfl\\Data1\\RSS\\SQA drive, Please contact Cindy or Webber if you have to!");
                    Environment.Exit(0);
                }
                else
                {
                    string sMainDir = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_017_NDT\Existing\";
                    string sPostFix = _gLib._ReturnDateStampYYYYMMDD() + "_" + Config.eEnv.ToString();


                    sOutputPlan1_NDT2017_DBandDCProspective     = _gLib._CreateDirectory(sMainDir + "NDT 2017\\DB and DC Prospective\\" + sPostFix + "\\");
                    sOutputPlan2_NDT2016EOYand2017_runonlyNHCEs = _gLib._CreateDirectory(sMainDir + "NDT 2016 EOY and 2017\\run only NHCEs\\" + sPostFix + "\\");
                }
            }


            string sContent = "";

            sContent = sContent + "sOutputPlan1_NDT2017_DBandDCProspective = @\"" + sOutputPlan1_NDT2017_DBandDCProspective + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputPlan2_NDT2016EOYand2017_runonlyNHCEs = @\"" + sOutputPlan2_NDT2016EOYand2017_runonlyNHCEs + "\";" + Environment.NewLine;


            _gLib._PrintReportDirectory(sContent);
        }
Exemplo n.º 7
0
        public void GenerateReportOuputDir()
        {
            pMain._SetLanguageAndRegional();

            if (!Config.bReportsStoreLocal)
            {
                _BenchmarkUser sCurrentUser = _gLib._ReturnCurrentUser();
                if (sCurrentUser.ToString() == "Others")
                {
                    _gLib._MsgBox("Warning !!!", "Your are NOT allowed to create folders in \\mercer.com\\US_Data\\Shared\\Dfl\\Data1\\RSS\\SQA drive, Please contact Cindy or Webber if you have to!");
                    Environment.Exit(0);
                }
                else
                {
                    string sMainDir = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_DE_Benchmark_005\Create New\Val\";
                    string sPostFix = _gLib._ReturnDateStampYYYYMMDD() + "_" + Config.eEnv.ToString();

                    //////_gLib._MsgBoxYesNo("Are you sure to create folders under below directory ?", sMainDir);

                    sOutputPension_Stichtag2010 = _gLib._CreateDirectory(sMainDir + "Stichtag2010\\" + sPostFix + "\\");
                }
            }


            string sContent = "";

            sContent = sContent + "sOutputPension_Stichtag2010 = @\"" + sOutputPension_Stichtag2010 + "\";" + Environment.NewLine;

            _gLib._PrintReportDirectory(sContent);
        }
Exemplo n.º 8
0
        public void GenerateReportOuputDir()
        {
            pMain._SetLanguageAndRegional();
            if (!Config.bReportsStoreLocal)
            {
                _BenchmarkUser sCurrentUser = _gLib._ReturnCurrentUser();
                if (sCurrentUser.ToString() == "Others")
                {
                    _gLib._MsgBox("Warning !!!", "Your are NOT allowed to create folders in \\mercer.com\\US_Data\\Shared\\Dfl\\Data1\\RSS\\SQA drive, Please contact Cindy or Webber if you have to!");
                    Environment.Exit(0);
                }
                else
                {
                    string sMainDir = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_019_PPA\Create New\";
                    string sPostFix = _gLib._ReturnDateStampYYYYMMDD() + "_" + Config.eEnv.ToString();

                    //sFunding2017 = _gLib._CreateDirectory(sMainDir + "Funding\\1.1.2017 Funding Valuation\\Baseline\\" + sPostFix + "\\");
                    //sFunding2018_OptOutPrescribedMort = _gLib._CreateDirectory(sMainDir + "Funding\\1.1.2018 Funding Valuation\\OptOut_Prescribed Mort\\" + sPostFix + "\\");
                    sFunding2018_FutureValRun = _gLib._CreateDirectory(sMainDir + "Funding\\1.1.2018 Funding Valuation\\Future Val Run\\" + sPostFix + "\\");
                    //sAccounting2017 = _gLib._CreateDirectory(sMainDir + "Accounting\\1.1.2017 Accounting Valuation\\Baseline\\" + sPostFix + "\\");
                    sAccounting2018_FutureValRun = _gLib._CreateDirectory(sMainDir + "Accounting\\1.1.2018 Accounting Valuation\\Future Val Run\\" + sPostFix + "\\");
                }
            }
            else
            {
                // get the main reports directory
                string sDir = Directory.GetCurrentDirectory();
                for (int i = 0; i < 3; i++)
                {
                    DirectoryInfo info = Directory.GetParent(sDir);
                    sDir = info.FullName;
                }

                sDir = sDir + "\\" + Config._ReturnProjectName() + "\\_Reports\\";

                string sMainDir = sDir + "US019_" + _gLib._ReturnDateStampYYYYMMDD();

                _gLib._CreateDirectory(sMainDir);
                //sFunding2017 = _gLib._CreateDirectory(sMainDir + "\\Funding_1.1.2017 Funding Valuation_Baseline\\");
                //sFunding2018_OptOutPrescribedMort = _gLib._CreateDirectory(sMainDir + "\\Funding_1.1.2018FundingValuation_OptOut_PrescribedMort\\");
                sFunding2018_FutureValRun = _gLib._CreateDirectory(sMainDir + "\\Funding_1.1.2018FundingValuation_FutureValRun\\\\");
                //sAccounting2017 = _gLib._CreateDirectory(sMainDir + "\\Accounting_1.1.2017AccountingValuation_Baseline\\");
                sAccounting2018_FutureValRun = _gLib._CreateDirectory(sMainDir + "\\Accounting_1.1.2018AccountingValuation_FutureValRun\\");
            }

            string sContent = "";

            //sContent = sContent + "sFunding2017 = @\"" + sFunding2017 + "\";" + Environment.NewLine;
            // sContent = sContent + "sFunding2018_OptOutPrescribedMort = @\"" + sFunding2018_OptOutPrescribedMort + "\";" + Environment.NewLine;
            sContent = sContent + "sFunding2018_FutureValRun = @\"" + sFunding2018_FutureValRun + "\";" + Environment.NewLine;
            // sContent = sContent + "sAccounting2017 = @\"" + sAccounting2017 + "\";" + Environment.NewLine;
            sContent = sContent + "sAccounting2018_FutureValRun = @\"" + sAccounting2018_FutureValRun + "\";" + Environment.NewLine;

            _gLib._PrintReportDirectory(sContent);
        }
Exemplo n.º 9
0
        public void GenerateReportOuputDir()
        {
            pMain._SetLanguageAndRegional();
            if (!Config.bReportsStoreLocal)
            {
                _BenchmarkUser sCurrentUser = _gLib._ReturnCurrentUser();
                if (sCurrentUser.ToString() == "Others")
                {
                    _gLib._MsgBox("Warning !!!", "Your are NOT allowed to create folders in \\mercer.com\\US_Data\\Shared\\Dfl\\Data1\\RSS\\SQA drive, Please contact Cindy or Webber if you have to!");
                    Environment.Exit(0);
                }
                else
                {
                    string sMainDir = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_11_Nebraska\Existing DNT\";
                    string sPostFix = _gLib._ReturnDateStampYYYYMMDD() + "_" + Config.eEnv.ToString();

                    //////_gLib._MsgBoxYesNo("Are you sure to create folders under below directory ?", sMainDir);
                    sOutputFunding_valJuly2019_UpdateProvisions        = _gLib._CreateDirectory(sMainDir + "val 7.1.2019\\update provisions for 2019\\" + sPostFix + "\\");
                    sOutputFunding_valJuly2019_updateFIForASOP51       = _gLib._CreateDirectory(sMainDir + "val 7.1.2019\\update FI for ASOP 51\\" + sPostFix + "\\");
                    sOutputAccounting_July2018FASVal_UpdateCashBalance = _gLib._CreateDirectory(sMainDir + "July 2018 FAS Val\\Update Cash Balance\\" + sPostFix + "\\");
                }
            }
            else
            {
                // get the main reports directory
                string sDir = Directory.GetCurrentDirectory();
                for (int i = 0; i < 3; i++)
                {
                    DirectoryInfo info = Directory.GetParent(sDir);
                    sDir = info.FullName;
                }

                /// this is for VS2012 folder structure
                sDir = sDir + "\\" + Config._ReturnProjectName() + "\\_Reports\\";

                //////sDir = sDir + "\\_TestLog\\";

                string sMainDir = sDir + "US011_" + _gLib._ReturnDateStampYYYYMMDD();

                //////_gLib._MsgBoxYesNo("Are you sure to create folders under below directory ?", sMainDir);

                _gLib._CreateDirectory(sMainDir);
                sOutputFunding_valJuly2019_UpdateProvisions        = _gLib._CreateDirectory(sMainDir + "\\val 7.1.2019\\update provisions for 2019\\");
                sOutputFunding_valJuly2019_updateFIForASOP51       = _gLib._CreateDirectory(sMainDir + "\\val 7.1.2019\\update FI for ASOP 51\\");
                sOutputAccounting_July2018FASVal_UpdateCashBalance = _gLib._CreateDirectory(sMainDir + "\\Accounting_July2018FASVal\\Update Cash Balance\\");
            }

            string sContent = "";

            sContent = sContent + "sOutputFunding_valJuly2019_UpdateProvisions = @\"" + sOutputFunding_valJuly2019_UpdateProvisions + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputFunding_valJuly2019_updateFIForASOP51 = @\"" + sOutputFunding_valJuly2019_updateFIForASOP51 + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting_July2018FASVal_UpdateCashBalance = @\"" + sOutputAccounting_July2018FASVal_UpdateCashBalance + "\";" + Environment.NewLine;

            _gLib._PrintReportDirectory(sContent);
        }
Exemplo n.º 10
0
        ////public string sOutputFunding_Valuation2011_LevelpopulationandMultipleDx_Prod = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_015_FutVal\Production\Funding\Valuation 2011\Level population and Multiple Dx\7.5_20191110_Franklin\";
        ////public string sOutputFunding_Valuation2011_ChangeprovisionsforFV_Prod = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_015_FutVal\Production\Funding\Valuation 2011\Change provisions for FV\7.4_20190417_Franklin\";

        ////public string sOutputAccounting_Conversion2010_Prod = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_015_FutVal\Production\Accounting\Conversion 2010\7.4_20190417_Franklin\";
        ////public string sOutputAccounting_Accounting2011_NEswithtestcriteria_Prod = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_015_FutVal\Production\Accounting\Accounting 2011\NEs with test criteria\7.4_20190417_Franklin\";


        public void GenerateReportOuputDir()
        {
            pMain._SetLanguageAndRegional();

            if (!Config.bReportsStoreLocal)
            {
                _BenchmarkUser sCurrentUser = _gLib._ReturnCurrentUser();
                if (sCurrentUser.ToString() == "Others")
                {
                    _gLib._MsgBox("Warning !!!", "Your are NOT allowed to create folders in \\mercer.com\\US_Data\\Shared\\Dfl\\Data1\\RSS\\SQA drive, Please contact Cindy or Webber if you have to!");
                    Environment.Exit(0);
                }
                else
                {
                    string sMainDir = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_015_FutVal\Existing\";
                    string sPostFix = _gLib._ReturnDateStampYYYYMMDD() + "_" + Config.eEnv.ToString();

                    //////_gLib._MsgBoxYesNo("Are you sure to create folders under below directory ?", sMainDir);

                    sOutputFunding_Valuation2011_Baseline     = _gLib._CreateDirectory(sMainDir + "Funding\\Valuation 2011\\Baseline\\" + sPostFix + "\\");
                    sOutputAccounting_Accounting2011_Baseline = _gLib._CreateDirectory(sMainDir + "Accounting\\Accounting 2011\\Baseline\\" + sPostFix + "\\");

                    ////sOutputFunding_Converson2010 = _gLib._CreateDirectory(sMainDir + "Funding\\Conversion 2010\\" + sPostFix + "\\");
                    ////sOutputFunding_Valuation2011_LevelpopulationandMultipleDx = _gLib._CreateDirectory(sMainDir + "Funding\\Valuation 2011\\Level population and Multiple Dx\\" + sPostFix + "\\");
                    ////sOutputFunding_Valuation2011_ChangeprovisionsforFV = _gLib._CreateDirectory(sMainDir + "Funding\\Valuation 2011\\Change provisions for FV\\" + sPostFix + "\\");
                    ////sOutputAccounting_Conversion2010 = _gLib._CreateDirectory(sMainDir + "Accounting\\Conversion 2010\\" + sPostFix + "\\");
                    ////sOutputAccounting_Accounting2011_NEswithtestcriteria = _gLib._CreateDirectory(sMainDir + "Accounting\\Accounting 2011\\NEs with test criteria\\" + sPostFix + "\\");
                }
            }


            string sContent = "";

            sContent = sContent + "sOutputFunding_Valuation2011_Baseline = @\"" + sOutputFunding_Valuation2011_Baseline + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting_Accounting2011_Baseline = @\"" + sOutputAccounting_Accounting2011_Baseline + "\";" + Environment.NewLine;

            ////sContent = sContent + "sOutputFunding_Converson2010 = @\"" + sOutputFunding_Converson2010 + "\";" + Environment.NewLine;
            ////sContent = sContent + "sOutputFunding_Valuation2011_LevelpopulationandMultipleDx = @\"" + sOutputFunding_Valuation2011_LevelpopulationandMultipleDx + "\";" + Environment.NewLine;
            ////sContent = sContent + "sOutputFunding_Valuation2011_ChangeprovisionsforFV = @\"" + sOutputFunding_Valuation2011_ChangeprovisionsforFV + "\";" + Environment.NewLine;
            ////sContent = sContent + "sOutputAccounting_Conversion2010 = @\"" + sOutputAccounting_Conversion2010 + "\";" + Environment.NewLine;
            ////sContent = sContent + "sOutputAccounting_Accounting2011_NEswithtestcriteria = @\"" + sOutputAccounting_Accounting2011_NEswithtestcriteria + "\";" + Environment.NewLine;


            _gLib._PrintReportDirectory(sContent);
        }
Exemplo n.º 11
0
        public void GenerateReportOuputDir()
        {
            pMain._SetLanguageAndRegional();
            if (!Config.bReportsStoreLocal)
            {
                _BenchmarkUser sCurrentUser = _gLib._ReturnCurrentUser();
                if (sCurrentUser.ToString() == "Others")
                {
                    _gLib._MsgBox("Warning !!!", "Your are NOT allowed to create folders in \\mercer.com\\US_Data\\Shared\\Dfl\\Data1\\RSS\\SQA drive, Please contact Cindy or Webber if you have to!");
                    Environment.Exit(0);
                }
                else
                {
                    string sMainDir = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_12_Knight\Existing\";
                    string sPostFix = _gLib._ReturnDateStampYYYYMMDD() + "_" + Config.eEnv.ToString();

                    //////_gLib._MsgBoxYesNo("Are you sure to create folders under below directory ?", sMainDir);


                    sConversion            = _gLib._CreateDirectory(sMainDir + "Funding Valuation\\Conversion\\" + sPostFix + "\\");
                    s2008Valuatoin_BurnCOB = _gLib._CreateDirectory(sMainDir + "Funding Valuation\\2008 Valuation\\Burn COB\\" + sPostFix + "\\");
                    //sPlanTerminationSetup_PBGC_Fields = _gLib._CreateDirectory(sMainDir + "Funding Valuation\\Plan Termination Setup\\PBGC_Fields\\" + sPostFix + "\\");
                    sPlanTerminationSetup_PBGC_4044 = _gLib._CreateDirectory(sMainDir + "Funding Valuation\\Plan Termination Setup\\PBGC_4044\\" + sPostFix + "\\");
                    sAccountingConversion           = _gLib._CreateDirectory(sMainDir + "Accounting Valuation\\Conversion\\" + sPostFix + "\\");
                }
            }


            string sContent = "";

            sContent = sContent + "sConversion = @\"" + sConversion + "\";" + Environment.NewLine;
            sContent = sContent + "s2008Valuatoin_BurnCOB = @\"" + s2008Valuatoin_BurnCOB + "\";" + Environment.NewLine;
            //sContent = sContent + "sPlanTerminationSetup_PBGC_Fields = @\"" + sPlanTerminationSetup_PBGC_Fields + "\";" + Environment.NewLine;
            sContent = sContent + "sPlanTerminationSetup_PBGC_4044 = @\"" + sPlanTerminationSetup_PBGC_4044 + "\";" + Environment.NewLine;
            sContent = sContent + "sAccountingConversion = @\"" + sAccountingConversion + "\";" + Environment.NewLine;

            _gLib._PrintReportDirectory(sContent);
        }
Exemplo n.º 12
0
        public void GenerateReportOuputDir()
        {
            pMain._SetLanguageAndRegional();

            _BenchmarkUser sCurrentUser = _gLib._ReturnCurrentUser();

            if (sCurrentUser.ToString() == "Others")
            {
                _gLib._MsgBox("Warning !!!", "Your are NOT allowed to create folders in \\mercer.com\\US_Data\\Shared\\Dfl\\Data1\\RSS\\SQA drive, Please contact Cindy or Webber if you have to!");
                Environment.Exit(0);
            }
            else
            {
                string sMainDir = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_019_PPA\Production\";
                string sPostFix = Config.sProductionVerison + "_" + _gLib._ReturnDateStampYYYYMMDD();

                sPostFix = sPostFix + "_Franklin";
                //sPostFix = sPostFix + "_Dallas";

                sFunding2017 = _gLib._CreateDirectory(sMainDir + "Funding\\1.1.2017 Funding Valuation\\Baseline\\" + sPostFix + "\\");
                sFunding2018_OptOutPrescribedMort = _gLib._CreateDirectory(sMainDir + "Funding\\1.1.2018 Funding Valuation\\OptOut_Prescribed Mort\\" + sPostFix + "\\");
                sFunding2018_FutureValRun         = _gLib._CreateDirectory(sMainDir + "Funding\\1.1.2018 Funding Valuation\\Future Val Run\\" + sPostFix + "\\");
                sAccounting2017 = _gLib._CreateDirectory(sMainDir + "Accounting\\1.1.2017 Accounting Valuation\\Baseline\\" + sPostFix + "\\");
                sAccounting2018_FutureValRun = _gLib._CreateDirectory(sMainDir + "Accounting\\1.1.2018 Accounting Valuation\\Future Val Run\\" + sPostFix + "\\");
            }

            string sContent = "";

            sContent = sContent + "sFunding2017 = @\"" + sFunding2017 + "\";" + Environment.NewLine;
            sContent = sContent + "sFunding2018_OptOutPrescribedMort = @\"" + sFunding2018_OptOutPrescribedMort + "\";" + Environment.NewLine;
            sContent = sContent + "sFunding2018_FutureValRun = @\"" + sFunding2018_FutureValRun + "\";" + Environment.NewLine;
            sContent = sContent + "sAccounting2017 = @\"" + sAccounting2017 + "\";" + Environment.NewLine;
            sContent = sContent + "sAccounting2018_FutureValRun = @\"" + sAccounting2018_FutureValRun + "\";" + Environment.NewLine;

            _gLib._PrintReportDirectory(sContent);
        }
Exemplo n.º 13
0
        public void GenerateReportOuputDir()
        {
            pMain._SetLanguageAndRegional();

            if (!Config.bReportsStoreLocal)
            {
                _BenchmarkUser sCurrentUser = _gLib._ReturnCurrentUser();
                if (sCurrentUser.ToString() == "Others")
                {
                    _gLib._MsgBox("Warning !!!", "Your are NOT allowed to create folders in \\mercer.com\\US_Data\\Shared\\Dfl\\Data1\\RSS\\SQA drive, Please contact Cindy or Webber if you have to!");
                    Environment.Exit(0);
                }
                else
                {
                    string sMainDir = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_CA_Benchmark_4\Existing\";
                    string sPostFix = _gLib._ReturnDateStampYYYYMMDD() + "_" + Config.eEnv.ToString();

                    //////_gLib._MsgBoxYesNo("Are you sure to create folders under below directory ?", sMainDir);


                    sOutputFunding_Funding2008_Baseline       = _gLib._CreateDirectory(sMainDir + "Funding\\Funding2008\\Baseline\\" + sPostFix + "\\");
                    sOutputFunding_Funding2008_UpdateSolvency = _gLib._CreateDirectory(sMainDir + "Funding\\Funding2008\\UpdateSolvency\\" + sPostFix + "\\");
                    sOutputFunding_Funding2008_MortalityProj  = _gLib._CreateDirectory(sMainDir + "Funding\\Funding2008\\MortalityProj\\" + sPostFix + "\\");
                    sOutputAccounting_Accounting2008          = _gLib._CreateDirectory(sMainDir + "Accounting\\Accounting2008\\" + sPostFix + "\\");
                }
            }

            string sContent = "";

            sContent = sContent + "sOutputFunding_Funding2008_Baseline = @\"" + sOutputFunding_Funding2008_Baseline + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputFunding_Funding2008_UpdateSolvency = @\"" + sOutputFunding_Funding2008_UpdateSolvency + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputFunding_Funding2008_MortalityProj = @\"" + sOutputFunding_Funding2008_MortalityProj + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting_Accounting2008 = @\"" + sOutputAccounting_Accounting2008 + "\";" + Environment.NewLine;

            _gLib._PrintReportDirectory(sContent);
        }
Exemplo n.º 14
0
        public void GenerateReportOuputDir()
        {
            pMain._SetLanguageAndRegional();

            _BenchmarkUser sCurrentUser = _gLib._ReturnCurrentUser();

            if (sCurrentUser.ToString() == "Others")
            {
                _gLib._MsgBox("Warning !!!", "Your are NOT allowed to create folders in \\mercer.com\\US_Data\\Shared\\Dfl\\Data1\\RSS\\SQA drive, Please contact Cindy or Webber if you have to!");
                Environment.Exit(0);
            }
            else
            {
                string sMainDir = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_BM_007_Keihin\Existing\";
                string sPostFix = _gLib._ReturnDateStampYYYYMMDD() + "_" + Config.eEnv.ToString() + "_Cloud";

                //////sPostFix = sPostFix + "_Franklin";

                //////_gLib._MsgBoxYesNo("Are you sure to create folders under below directory ?", sMainDir);

                sOutputFunding2005    = _gLib._CreateDirectory(sMainDir + "Funding 2005\\" + sPostFix + "\\");
                sOutputFunding2006    = _gLib._CreateDirectory(sMainDir + "Funding 2006\\" + sPostFix + "\\");
                sOutputAccounting2005 = _gLib._CreateDirectory(sMainDir + "2005 Accounting\\" + sPostFix + "\\");
                sOutputAccounting2006 = _gLib._CreateDirectory(sMainDir + "2006 Accounting\\" + sPostFix + "\\");
            }


            string sContent = "";

            sContent = sContent + "sOutputFunding2005 = @\"" + sOutputFunding2005 + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputFunding2006 = @\"" + sOutputFunding2006 + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting2005 = @\"" + sOutputAccounting2005 + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting2006 = @\"" + sOutputAccounting2006 + "\";" + Environment.NewLine;

            _gLib._PrintReportDirectory(sContent);
        }
Exemplo n.º 15
0
        public void GenerateReportOuputDir()
        {
            pMain._SetLanguageAndRegional();
            if (!Config.bReportsStoreLocal)
            {
                _BenchmarkUser sCurrentUser = _gLib._ReturnCurrentUser();
                if (sCurrentUser.ToString() == "Others")
                {
                    _gLib._MsgBox("Warning !!!", "Your are NOT allowed to create folders in \\mercer.com\\US_Data\\Shared\\Dfl\\Data1\\RSS\\SQA drive, Please contact Cindy or Webber if you have to!");
                    Environment.Exit(0);
                }
                else
                {
                    string sMainDir = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_NL_Benchmark_004\Existing\";
                    string sPostFix = _gLib._ReturnDateStampYYYYMMDD() + "_" + Config.eEnv.ToString();

                    //////_gLib._MsgBoxYesNo("Are you sure to create folders under below directory ?", sMainDir);

                    sOutputAccounting_Conversion2011         = _gLib._CreateDirectory(sMainDir + "Conversion 2011\\" + sPostFix + "\\");
                    sOutputAccounting_Valuation2012_Baseline = _gLib._CreateDirectory(sMainDir + "Valuation 2012\\Baseline\\" + sPostFix + "\\");
                    sOutputAccounting_Valuation2012_IndexationSensitivity125 = _gLib._CreateDirectory(sMainDir + "Valuation 2012\\IndexationSensitivity 1.25%\\" + sPostFix + "\\");
                    sOutputAccounting_Valuation2012_IndexationSensitivity75  = _gLib._CreateDirectory(sMainDir + "Valuation 2012\\IndexationSensitivity 0.75%\\" + sPostFix + "\\");
                    sOutputAccounting_Valuation2012_InterestSensitivity585   = _gLib._CreateDirectory(sMainDir + "Valuation 2012\\InterestSensitivity 5.85%\\" + sPostFix + "\\");
                    sOutputAccounting_Valuation2012_InterestSensitivity535   = _gLib._CreateDirectory(sMainDir + "Valuation 2012\\InterestSensitivity 5.35%\\" + sPostFix + "\\");
                    sOutputAccounting_Valuation2012_PaySensitivity325        = _gLib._CreateDirectory(sMainDir + "Valuation 2012\\PaySensitivity 3.25%\\" + sPostFix + "\\");
                    sOutputAccounting_Valuation2012_PaySensitivity375        = _gLib._CreateDirectory(sMainDir + "Valuation 2012\\PaySensitivity 3.75%\\" + sPostFix + "\\");
                }
            }
            else
            {
                // get the main reports directory
                string sDir = Directory.GetCurrentDirectory();
                for (int i = 0; i < 3; i++)
                {
                    DirectoryInfo info = Directory.GetParent(sDir);
                    sDir = info.FullName;
                }

                /// this is for VS2012 folder structure
                sDir = sDir + "\\" + Config._ReturnProjectName() + "\\_Reports\\";

                //////sDir = sDir + "\\_TestLog\\";

                string sMainDir = sDir + "NL004_" + _gLib._ReturnDateStampYYYYMMDD();

                //////_gLib._MsgBoxYesNo("Are you sure to create folders under below directory ?", sMainDir);

                _gLib._CreateDirectory(sMainDir);
                sOutputAccounting_Conversion2011         = _gLib._CreateDirectory(sMainDir + "\\sOutputAccounting_Conversion2011\\");
                sOutputAccounting_Valuation2012_Baseline = _gLib._CreateDirectory(sMainDir + "\\sOutputAccounting_Valuation2012_Baseline\\");
                sOutputAccounting_Valuation2012_IndexationSensitivity125 = _gLib._CreateDirectory(sMainDir + "\\sOutputAccounting_Valuation2012_IndexationSensitivity125\\");
                sOutputAccounting_Valuation2012_IndexationSensitivity75  = _gLib._CreateDirectory(sMainDir + "\\sOutputAccounting_Valuation2012_IndexationSensitivity75\\");
                sOutputAccounting_Valuation2012_InterestSensitivity585   = _gLib._CreateDirectory(sMainDir + "\\sOutputAccounting_Valuation2012_InterestSensitivity585\\");
                sOutputAccounting_Valuation2012_InterestSensitivity535   = _gLib._CreateDirectory(sMainDir + "\\sOutputAccounting_Valuation2012_InterestSensitivity535\\");
                sOutputAccounting_Valuation2012_PaySensitivity325        = _gLib._CreateDirectory(sMainDir + "\\sOutputAccounting_Valuation2012_PaySensitivity325\\");
                sOutputAccounting_Valuation2012_PaySensitivity375        = _gLib._CreateDirectory(sMainDir + "\\sOutputAccounting_Valuation2012_PaySensitivity375\\");
            }

            string sContent = "";

            sContent = sContent + "sOutputAccounting_Conversion2011 = @\"" + sOutputAccounting_Conversion2011 + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting_Valuation2012_Baseline = @\"" + sOutputAccounting_Valuation2012_Baseline + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting_Valuation2012_IndexationSensitivity125 = @\"" + sOutputAccounting_Valuation2012_IndexationSensitivity125 + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting_Valuation2012_IndexationSensitivity75 = @\"" + sOutputAccounting_Valuation2012_IndexationSensitivity75 + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting_Valuation2012_InterestSensitivity585 = @\"" + sOutputAccounting_Valuation2012_InterestSensitivity585 + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting_Valuation2012_InterestSensitivity535 = @\"" + sOutputAccounting_Valuation2012_InterestSensitivity535 + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting_Valuation2012_PaySensitivity325 = @\"" + sOutputAccounting_Valuation2012_PaySensitivity325 + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputAccounting_Valuation2012_PaySensitivity375 = @\"" + sOutputAccounting_Valuation2012_PaySensitivity375 + "\";" + Environment.NewLine;
            _gLib._PrintReportDirectory(sContent);
        }
Exemplo n.º 16
0
        public void GenerateReportOuputDir()
        {
            pMain._SetLanguageAndRegional();

            if (!Config.bReportsStoreLocal)
            {
                _BenchmarkUser sCurrentUser = _gLib._ReturnCurrentUser();
                if (sCurrentUser.ToString() == "Others")
                {
                    _gLib._MsgBox("Warning !!!", "Your are NOT allowed to create folders in \\mercer.com\\US_Data\\Shared\\Dfl\\Data1\\RSS\\SQA drive, Please contact Cindy or Webber if you have to!");
                    Environment.Exit(0);
                }
                else
                {
                    string sMainDir = @"\\mercer.com\US_Data\Shared\Dfl\Data1\RSS\SQA\RETIRE_STUDIO_BENCHMARK REPORTS\QA_DE_Benchmark_008\Existing DNT\Val\";
                    string sPostFix = _gLib._ReturnDateStampYYYYMMDD() + "_" + Config.eEnv.ToString();

                    //////_gLib._MsgBoxYesNo("Are you sure to create folders under below directory ?", sMainDir);

                    sOutputPension_Conversion2009        = _gLib._CreateDirectory(sMainDir + "Conversion 2009\\" + sPostFix + "\\");
                    sOutputPension_Stichtag2010_Baseline = _gLib._CreateDirectory(sMainDir + "Stichtag 2010\\Baseline\\" + sPostFix + "\\");
                    sOutputPension_Stichtag2010_PreliminaryAssumptions = _gLib._CreateDirectory(sMainDir + "Stichtag 2010\\Preliminary Assumptions\\" + sPostFix + "\\");
                    sOutputPension_Stichtag2011_Baseline = _gLib._CreateDirectory(sMainDir + "Stichtag 2011\\Baseline\\" + sPostFix + "\\");
                    sOutputPension_Stichtag2011_InterestSensitivityMINUS = _gLib._CreateDirectory(sMainDir + "Stichtag 2011\\Interest Sensitivity MINUS0.5%\\" + sPostFix + "\\");
                    sOutputPension_Stichtag2011_InterestSensitivityPLUS  = _gLib._CreateDirectory(sMainDir + "Stichtag 2011\\Interest Sensitivity PLUS0.5%\\" + sPostFix + "\\");
                }
            }
            else
            {
                // get the main reports directory
                string sDir = Directory.GetCurrentDirectory();
                for (int i = 0; i < 3; i++)
                {
                    DirectoryInfo info = Directory.GetParent(sDir);
                    sDir = info.FullName;
                }

                /// this is for VS2012 folder structure
                sDir = sDir + "\\" + Config._ReturnProjectName() + "\\_Reports\\";

                ////sDir = sDir + "\\_TestLog\\";

                string sMainDir = sDir + "DE008_" + _gLib._ReturnDateStampYYYYMMDD();

                //////_gLib._MsgBoxYesNo("Are you sure to create folders under below directory ?", sMainDir);

                _gLib._CreateDirectory(sMainDir);
                sOutputPension_Conversion2009        = _gLib._CreateDirectory(sMainDir + "\\sOutputPension_Conversion2009\\");
                sOutputPension_Stichtag2010_Baseline = _gLib._CreateDirectory(sMainDir + "\\sOutputPension_Stichtag2010_Baseline\\");
                sOutputPension_Stichtag2010_PreliminaryAssumptions = _gLib._CreateDirectory(sMainDir + "\\sOutputPension_Stichtag2010_PreliminaryAssumptions\\");
                sOutputPension_Stichtag2011_Baseline = _gLib._CreateDirectory(sMainDir + "\\sOutputPension_Stichtag2011_Baseline\\");
                sOutputPension_Stichtag2011_InterestSensitivityMINUS = _gLib._CreateDirectory(sMainDir + "\\sOutputPension_Stichtag2011_InterestSensitivityMINUS\\");
                sOutputPension_Stichtag2011_InterestSensitivityPLUS  = _gLib._CreateDirectory(sMainDir + "\\sOutputPension_Stichtag2011_InterestSensitivityPLUS\\");
            }

            string sContent = "";

            sContent = sContent + "sOutputPension_Conversion2009 = @\"" + sOutputPension_Conversion2009 + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputPension_Stichtag2010_Baseline = @\"" + sOutputPension_Stichtag2010_Baseline + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputPension_Stichtag2010_PreliminaryAssumptions = @\"" + sOutputPension_Stichtag2010_PreliminaryAssumptions + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputPension_Stichtag2011_Baseline = @\"" + sOutputPension_Stichtag2011_Baseline + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputPension_Stichtag2011_InterestSensitivityMINUS = @\"" + sOutputPension_Stichtag2011_InterestSensitivityMINUS + "\";" + Environment.NewLine;
            sContent = sContent + "sOutputPension_Stichtag2011_InterestSensitivityPLUS = @\"" + sOutputPension_Stichtag2011_InterestSensitivityPLUS + "\";" + Environment.NewLine;
            _gLib._PrintReportDirectory(sContent);
        }