Keeping Attachments in jobhead

[gpayne (Greg Payne)]

@IdleProgrammer Welcome. There are a lot of moving parts with this and you will need to hold all of the files contents in Callcontext variables or a ud temp table while they are being deleted and then put them back probably as new attachments. Epicor will remove the XfileAttch and XFileRef records and move the actual file to the deleted subdirectory.

References:

Copy Order Entry Attachment to Job Header

You can do a DB lookup on the existing attachment(s) during that BPM you are using and then create a new attachment with the same information as the original just a new RelatedToFile and Key set. BufferCopy with excludes would work great for this. This is what I have used in the past for creation of attachments. It’s more than what you need if you were to use BufferCopy to copy the order record and just alter the key fields. You would need to create a new attch record and then copy into that s…

REST Attachments

This is an example using DocStar but the BO’s are the same just use UploadFile instead of DocStarUploadFile //Read file from Disk into a byte array Byte[] bytes = File.ReadAllBytes(x); String fileData = Convert.ToBase64String(bytes); //Create the File Object to be uploaded to Epicor var file = new { fileName = System.IO.Path.GetFileName(x), data = fileData, …

/* Check if jobHead has attachment */

callContextBpmData.Character01 = string.Empty; // you should also clear this when the put back is completed.

Ice.Diagnostics.Log.WriteEntry("in check Job has attachment");

foreach (var jhRow in ds.JobHead.Where(w => w.Unchanged()))
{
    foreach (var atchRow in Db.XFileAttch.Where(x => x.Company == Session.CompanyID && x.RelatedToFile == "JobHead" && x.Key1 == jhRow.JobNum))
    {
        if(string.IsNullOrEmpty(callContextBpmData.Character01))
        {
            callContextBpmData.Character01 = atchRow.XFileRefNum.ToString();
        }
        else
        {
            callContextBpmData.Character01 = callContextBpmData.Character01 + "~" + atchRow.XFileRefNum.ToString();
        }
    }
    
    
    Ice.Diagnostics.Log.WriteEntry($"Job {jhRow.JobNum} Part {jhRow.PartNum} has these attachments {callContextBpmData.Character01}");
}