HYTOS

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)

        {

            try

            {

                string query = $@"

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

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

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        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;

        }

    }

}