Esempio n. 1
0
        public void TestGenerateICHEmail()
        {
            TVerificationResultCollection VerificationResults = new TVerificationResultCollection();

            int    PeriodNumber        = 5;
            int    ICHProcessingNumber = 1;
            int    CurrencyType        = 1; //base
            string FileName            = TAppSettingsManager.GetValue("Server.PathTemp") + Path.DirectorySeparatorChar + "TestGenerateICHEmail.csv";
            bool   SendEmail           = true;

            // make sure there is a valid email destination
            if (TGenFilesReports.GetICHEmailAddress(null).Length == 0)
            {
                string sqlStatement =
                    String.Format("INSERT INTO PUB_{0}({1},{2},{3},{4}) VALUES (?,?,?,?)",
                                  AEmailDestinationTable.GetTableDBName(),
                                  AEmailDestinationTable.GetFileCodeDBName(),
                                  AEmailDestinationTable.GetConditionalValueDBName(),
                                  AEmailDestinationTable.GetPartnerKeyDBName(),
                                  AEmailDestinationTable.GetEmailAddressDBName());

                OdbcParameter parameter;

                List <OdbcParameter> parameters = new List <OdbcParameter>();
                parameter       = new OdbcParameter("name", OdbcType.VarChar);
                parameter.Value = MFinanceConstants.EMAIL_FILE_CODE_STEWARDSHIP;
                parameters.Add(parameter);
                parameter       = new OdbcParameter("condition", OdbcType.VarChar);
                parameter.Value = Convert.ToInt64(MFinanceConstants.ICH_COST_CENTRE) / 100;
                parameters.Add(parameter);
                parameter       = new OdbcParameter("partnerkey", OdbcType.Int);
                parameter.Value = Convert.ToInt64(MFinanceConstants.ICH_COST_CENTRE) * 10000;
                parameters.Add(parameter);
                parameter       = new OdbcParameter("email", OdbcType.VarChar);
                parameter.Value = TAppSettingsManager.GetValue("ClearingHouse.EmailAddress");
                parameters.Add(parameter);

                bool           SubmissionOK  = true;
                TDBTransaction DBTransaction = null;
                DBAccess.GDBAccessObj.BeginAutoTransaction(IsolationLevel.Serializable, ref DBTransaction, ref SubmissionOK,
                                                           delegate
                {
                    DBAccess.GDBAccessObj.ExecuteNonQuery(sqlStatement, DBTransaction, parameters.ToArray());
                    DBAccess.GDBAccessObj.CommitTransaction();
                });
            }

            TGenFilesReports.GenerateStewardshipFile(FLedgerNumber,
                                                     PeriodNumber,
                                                     ICHProcessingNumber,
                                                     CurrencyType,
                                                     FileName,
                                                     SendEmail,
                                                     out VerificationResults);

            CommonNUnitFunctions.EnsureNullOrOnlyNonCriticalVerificationResults(VerificationResults,
                                                                                "Performing ICH Email File Generation Failed!");
        }
Esempio n. 2
0
        public void TestGenerateStewardshipFile()
        {
            ImportAdminFees();

            TVerificationResultCollection VerificationResults = new TVerificationResultCollection();

            int    PeriodNumber        = 5;
            int    ICHProcessingNumber = 1;
            int    CurrencyType        = 1; //base
            string FileName            = TAppSettingsManager.GetValue("Server.PathTemp") + Path.DirectorySeparatorChar + "Test.csv";
            bool   SendEmail           = false;

            TGenFilesReports.GenerateStewardshipFile(FLedgerNumber,
                                                     PeriodNumber,
                                                     ICHProcessingNumber,
                                                     CurrencyType,
                                                     FileName,
                                                     SendEmail,
                                                     out VerificationResults);

            CommonNUnitFunctions.EnsureNullOrOnlyNonCriticalVerificationResults(VerificationResults,
                                                                                "Performing Stewardship File Generation Failed!");
        }