public DocumentRetrieval OpenFileAttachment(int attachmentId)
        {
            DocumentRetrieval doc        = new DocumentRetrieval();
            DocumentModel     document   = _context.Documents.Where(p => p.FK_Attachment_Id == attachmentId).Single();
            AttachmentsModel  attachment = _context.Attachments.First(p => p.Id == attachmentId);

            doc.DocData  = Convert.FromBase64String(document.DocumentData);
            doc.DocType  = attachment.FileType;
            doc.FileName = attachment.FileName;
            return(doc);
        }
        public ActionResult OpenAttachment(int attachmentId)
        {
            var attachmentMeta           = _context.Attachments.Where(p => p.FK_Id == attachmentId);
            DocumentRetrieval attachment = _util.OpenFileAttachment(attachmentId);

            using (Stream file = System.IO.File.OpenWrite($"c:\\temp\\BPD01Content\\{attachment.FileName}"))
            {
                file.Write(attachment.DocData, 0, attachment.DocData.Length);
            }

            return(RedirectToAction("Index"));
        }