HYTOS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using ID2.Manager.Data.Models;

using ID2.Manager.Dapper.Repository;

namespace ID2.Manager.Controller.Controllers

{

    public class FileController : BaseController

    {

        public IEnumerable<FileInfo> GetFileList(string documentID)

        {

            using (FileRepository rep = new FileRepository(this._DbConnectionStr))

            {

                return rep.GetFileList(documentID);

            }

        }

        public bool SetUserInfo(List<FileInfo> fileList)

        {

            using (FileRepository rep = new FileRepository(this._DbConnectionStr))

            {

                return rep.SetFileInfo(fileList);

            }

        }

    }

}

    <Compile Include="Controllers\FileController.cs" />

    <Compile Include="Repository\FileRepository.cs" />

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using ID2.Manager.Data.Models;

namespace ID2.Manager.Dapper.Repository

{

    public class FileRepository : BaseRepository

    {

        public FileRepository(string connectionStr) : base(connectionStr) { }

        public IEnumerable<FileInfo> GetFileList(string documentID)

        {

            string query = $@"

select * from dbo.Files where RefDocID=@documentID order by CreatedDate";

            return Query<FileInfo>(query, new { documentID });

        }

        public bool SetFileInfo(List<FileInfo> fileList)

        {

            bool isSuccess = false;

            try

            {

                using (var transaction = base.BeginTransaction())

                {

                    foreach (FileInfo file in fileList)

                    {

                        string query = $@"

insert into dbo.Files (FileID, RefDocID, FileType, FileName, FilePath, FileData)

values

(

    lower(newid())

   ,@RefDocID

   ,@FileType

   ,@FileName

   ,@FilePath

   ,@FileData

)";

                        base.Execute(query, file, transaction);

                    }

                    transaction.Commit();

                    isSuccess = true;

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

            return isSuccess;

        }

    }

}

    <Compile Include="Models\FileInfo.cs" />

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Runtime.Serialization;

namespace ID2.Manager.Data.Models

{

    [DataContract]

    public class FileInfo

    {

        [DataMember]

        public string FileID { get; set; }

        [DataMember]

        public string RefDocID { get; set; }

        [DataMember]

        public string FileType { get; set; }

        [DataMember]

        public string FileName { get; set; }

        [DataMember]

        public string FilePath { get; set; }

        [DataMember]

        public byte[] FileData { get; set; }

        [DataMember]

        public DateTime CreatedDate { get; set; }

    }

}

            this.radBrowseEditorFile = new Telerik.WinControls.UI.RadBrowseEditor();

            this.radButtonSave = new Telerik.WinControls.UI.RadButton();

            this.tableLayoutPanel2.SuspendLayout();

            ((System.ComponentModel.ISupportInitialize)(this.radBrowseEditorFile)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.radButtonSave)).BeginInit();

            this.tableLayoutPanel2.ColumnCount = 2;

            this.tableLayoutPanel2.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Absolute, 80F));

            this.tableLayoutPanel2.Controls.Add(this.radBrowseEditorFile, 0, 0);

            this.tableLayoutPanel2.Controls.Add(this.radButtonSave, 1, 0);

            // radBrowseEditorFile

            // 

            this.radBrowseEditorFile.Anchor = System.Windows.Forms.AnchorStyles.Right;

            this.radBrowseEditorFile.Location = new System.Drawing.Point(451, 12);

            this.radBrowseEditorFile.Name = "radBrowseEditorFile";

            this.radBrowseEditorFile.Size = new System.Drawing.Size(400, 20);

            this.radBrowseEditorFile.TabIndex = 0;

            // 

            // radButtonSave

            // 

            this.radButtonSave.Anchor = System.Windows.Forms.AnchorStyles.Left;

            this.radButtonSave.Location = new System.Drawing.Point(857, 10);

            this.radButtonSave.Name = "radButtonSave";

            this.radButtonSave.Size = new System.Drawing.Size(74, 24);

            this.radButtonSave.TabIndex = 1;

            this.radButtonSave.Text = "Save";

            // 

            this.tableLayoutPanel2.ResumeLayout(false);

            this.tableLayoutPanel2.PerformLayout();

            ((System.ComponentModel.ISupportInitialize)(this.radBrowseEditorFile)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.radButtonSave)).EndInit();

        private Telerik.WinControls.UI.RadBrowseEditor radBrowseEditorFile;

        private Telerik.WinControls.UI.RadButton radButtonSave;

using ID2.Manager.Common;

using ID2.Manager.Data.Models;

using ID2.Manager.Controller.Controllers;

using Telerik.WinControls;

        string DocumentID = string.Empty;

        public OpenFileDialog ofd;

        public ImageView(string docID)

            this.DocumentID = docID;

            this.Initialize();

            this.radButtonSave.Click += RadButtonSave_Click;

        }

        private void Initialize()

        {

            ofd = this.radBrowseEditorFile.BrowseDialog as OpenFileDialog;

            ofd.Filter = "Image files (*.png)|*.png";

            ofd.Title = "Open an Image File";

            //string[] files = new string[] { };

            //foreach (string file in files)

            //{

            //    PictureBox pic = new PictureBox();

            //    pic.Image = Image.FromFile(file);

            //    pic.SizeMode = PictureBoxSizeMode.Zoom;

            //    pic.Width = 150;

            //    pic.Height = 150;

            //    pic.Margin = new Padding(5);

            //    flowLayoutPanel1.Controls.Add(pic);

            //    pic.Click += Pic_Click;

            //}

            this.GetFileList();

        }

        public void GetFileList()

        {

            var files = new FileController().GetFileList(this.DocumentID).ToList();

            foreach (Data.Models.FileInfo file in files)

                var arrayBinary = file.FileData.ToArray();

                using (MemoryStream ms = new MemoryStream(arrayBinary))

                {

                    PictureBox pic = new PictureBox();

                    pic.Image = Image.FromStream(ms);

                    pic.SizeMode = PictureBoxSizeMode.Zoom;

                    pic.Width = 150;

                    pic.Height = 150;

                    pic.Margin = new Padding(5);

                    flowLayoutPanel1.Controls.Add(pic);

                    pic.Click += Pic_Click;

                }

        private void RadButtonSave_Click(object sender, EventArgs e)

        {

            if (string.IsNullOrEmpty(ofd.FileName) && !File.Exists(ofd.FileName))

            {

                RadMessageBox.Show($"There is no Image File selected.", "Information", MessageBoxButtons.OK, RadMessageIcon.Info);

                return;

            }

            var file = new Data.Models.FileInfo();

            file.RefDocID = this.DocumentID;

            file.FileName = ofd.FileName;

            file.FilePath = ofd.FileName;

            file.FileType = ofd.FileName;

            using (var stream = new FileStream(ofd.FileName, FileMode.Open, FileAccess.Read))

            {

                using (var reader = new BinaryReader(stream))

                {

                    file.FileData = reader.ReadBytes((int)stream.Length);

                }

            }

            var files = new List<Data.Models.FileInfo>() { file };

            bool result = new FileController().SetUserInfo(files);

            if (result)

            {

                RadMessageBox.Show("Save is complete", Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Error);

            }

            else

            {

                RadMessageBox.Show("Save is not complete", Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Error);

            }

        }

                        if (e.Row.DataBoundItem is Documents dd)

                            using (var frm = new ImageView(dd.DocID))

                            {

                                frm.ShowDialog(this);

                            }