Ice.Mail.SmtpMailer issues with attachments

Epicor ERP 10
,
4

Sure, it’s a UBAQ Method Directive so it can run on a schedule. Most of the email code is already posted above. Sharepoint may be the issue.

image
image1154×883 57.5 KB

// Initialize Actions
Func<string, string> GetCompanyAddressAction = (CompanyID) => {

  var Company_Row =
    (from sc in Db.SysCompany.With(LockHint.NoLock)
    where sc.Company == CompanyID
    select new { sc.EmailFromAddr, sc.EmailFromLabel }).FirstOrDefault();

  if (Company_Row != null) {
    return string.Format(@"""{0}"" <{1}>", Company_Row.EmailFromLabel.Trim(), Company_Row.EmailFromAddr.Trim());
  }

  return string.Empty;
};

foreach(var ttResults_Row in ttResults) {
  // Initialize Variables
  string EmailTO = "";
  string EmailCC = "emailrecipientsgoehere@mail.com";
  string EmailBCC = "";
  string EmailSubject = "";
  string EmailBody = "";


  if (ttResults_Row != null)
  {    
  
      string templatePath = @"\\filepath";
      string attachmentPath = @"\\filepath" + ttResults_Row.DMRCorAct1_ActionID.ToString() + @".sysconfig";
      
      //Edit shortcut file attachment to point to correct CAR
      string text = File.ReadAllText(templatePath);
      text = Regex.Replace(text, @"<RecordID>\d*</RecordID>", @"<RecordID>" + ttResults_Row.DMRCorAct1_ActionID.ToString() + @"</RecordID>");
      File.WriteAllText(attachmentPath, text);
      text = "";
      text = null;

      EmailSubject = "Corrective Action Due - ActionID: " + ttResults_Row.DMRCorAct1_ActionID + " - Due Date: " + ttResults_Row.DMRCorAct_DuDate;
      
      EmailBody = "The corrective action request (ActionID: " + ttResults_Row.DMRCorAct1_ActionID +") that was assigned to you is due as of " + ttResults_Row.DMRCorAct_DuDate + ".<br>You can view the request by opening the link attached, or from the 'Corrective Action Request' Module in Epicor.<br><br>Once complete, enter the 'Action Complete' date in the Corrective Action Module to move the process forward.<br><br>Brief Overview:<br>" +  ttResults_Row.DMRCorAct_Description;
      
      EmailTO = ttResults_Row.EmpBasic_EMailAddress; //uncomment for golive
      
      if(EmailTO != "") {
        // Send Email
        using( Ice.Mail.SmtpMailer mailer = new Ice.Mail.SmtpMailer(this.Session))
        {  
            using( FileStream attachmentStream = File.Open(attachmentPath, FileMode.Open))
            {
            var message = new Ice.Mail.SmtpMail();
            message.SetFrom( GetCompanyAddressAction("93546") );
            message.SetTo(EmailTO);
            message.SetCC(EmailCC);
            message.SetBcc(EmailBCC);
            message.SetSubject(EmailSubject);
            message.SetBody(EmailBody);
            message.IsBodyHtml = true;
            //Add Attachments
            Dictionary<string, Stream> attachments = new Dictionary<string, Stream>();
            attachments.Add("CorrectiveAction" + ttResults_Row.DMRCorAct1_ActionID.ToString() + ".sysconfig" , attachmentStream);
            //Send 
            mailer.Send(message, attachments);
            }
        }
        
      }
      File.Delete(attachmentPath);
   }
}

Directive usings and references:

using System;
using System.IO;
using System.Text.RegularExpressions;
1 Like