HYTOS

using ID2.Manager.Dapper.Repository;

using ID2.Manager.Data.Models;

using Newtonsoft.Json;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ID2.Manager.Controller.Controllers

{

    public class MarkusInfoController : BaseController

    {

        //public IEnumerable<MarkupText> GetMarkupData(IEnumerable<string> ProjectNoList, IEnumerable<string> DocumentNoList)

        //{

        //    IEnumerable<MarkupText> result = null;

        //    using (MarkusRepository rep = new MarkusRepository(this._MARKUSCONNSTR))

        //    {

        //        result = rep.GetMarkupText(ProjectNoList, DocumentNoList);

        //    }

        //    return result;

        //}

        public bool SetProperties(IEnumerable<string> ProjectNoList)

        {

            bool result = false;

            try

            {

                using (MarkusRepository rep = new MarkusRepository(this._MARKUSCONNSTR))

                {

                    foreach (var ProjectNo in ProjectNoList)

                    {

                        rep.InsertProperties(ProjectNo);

                    }

                    result = true;

                }

            }

            catch (Exception)

            {

                throw;

            }

            return result;

        }

        public int GetConvertDoc(string ProjectNo, string DOCUMENT_ID)

        {

            int result = -1;

            try

            {

                using (MarkusRepository rep = new MarkusRepository(this._MARKUSCONNSTR))

                {

                    result = rep.GetConvertDoc(ProjectNo, DOCUMENT_ID);

                }

            }

            catch (Exception)

            {

                throw;

            }

            return result;

        }

        public bool SetMarkusInfo(List<Documents> docList)

        {

            bool result = false;

            using (MarkusRepository rep = new MarkusRepository(this._MARKUSCONNSTR))

            {

                foreach (var item in docList)

                {

                    try

                    {

                        result = rep.Insert(item.RefProjectCode, item.DocumentNo);

                        if (!result)

                        {

                            throw new Exception($"Insert Item Error.");

                        }

                    }

                    catch (Exception ex)

                    {

                        result = false;

                        this.Exception = new Exception($"{JsonConvert.SerializeObject(item)}",ex);

                        break;

                    }

                }

            }

            return result;

        }

        public bool SetMembers(IEnumerable<UserInfo> users)

        {

            bool result = false;

            try

            {

                using (MarkusRepository rep = new MarkusRepository(this._MARKUSCONNSTR))

                {

                    foreach (var user in users)

                    {

                        rep.InsertOrUpdateUsers(new Dapper.Entities.MEMBER

                        {

                            ID = user.ID,

                            NAME = user.Name,

                            DEPARTMENT = "SAMSUNG ELEC",

                            POSITION = user.Role,

                            EMAIL_ADDRESS = user.ID,

                            PASSWORD = "",

                            COMPANY = "SAMSUNG ELEC",

                            CREATE_DATETIME = DateTime.Now,

                            MODIFIED_DATETIME = DateTime.Now,

                            ISLICENSE = 1

                        });

                    }

                    result = true;

                }

            }

            catch (Exception)

            {

                throw;

            }

            return result;

        }

    }

}