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!"); }
/// <summary> /// get the Email address for the International Clearing House, where the stewardship should be sent to /// </summary> /// <param name="ADBTransaction"></param> /// <returns></returns> public static string GetICHEmailAddress(TDBTransaction ADBTransaction) { AEmailDestinationTable AEmailDestTable = new AEmailDestinationTable(); AEmailDestinationRow TemplateRow2 = (AEmailDestinationRow)AEmailDestTable.NewRowTyped(false); TemplateRow2.FileCode = MFinanceConstants.EMAIL_FILE_CODE_STEWARDSHIP; AEmailDestinationTable AEmailDestinationTable = AEmailDestinationAccess.LoadUsingTemplate(TemplateRow2, ADBTransaction); if (AEmailDestinationTable.Count == 0) { return string.Empty; } else { return ((AEmailDestinationRow)AEmailDestinationTable.Rows[0]).EmailAddress; } }