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 ProjectController : BaseController

    {

        public IEnumerable<ProjectInfo> GetAllProjectList()

        {

            using (ProjectRepository rep = new ProjectRepository(this._MSSQLCONNSTR))

            {

                var id2Project = new ID2Controller().GetID2ProjectList();

                var allProject = rep.GetAllProjectList();

                return from mg in allProject

                       join id2 in id2Project on mg.Code equals id2.Name into gj

                       from prjs in gj.DefaultIfEmpty()

                       select new ProjectInfo()

                       {

                           ProjectID = mg.ProjectID,

                           Code = mg.Code,

                           Name = mg.Name,

                           Description = mg.Description,

                           ID2Path = prjs?.Path ?? null,

                           GroupID = mg.GroupID,

                           GroupName = mg.GroupName,

                           Level = mg.Level,

                           ID2Info = prjs ?? new ID2ProjectInfo(),

                       };

            }

        }

        public ProjectInfo GetProjectInfo(string ProjectID)

        {

            using (ProjectRepository rep = new ProjectRepository(this._MSSQLCONNSTR))

            {

                var id2Project = new ID2Controller().GetID2ProjectList();

                var project = rep.GetProjectInfo(ProjectID);

                var id2 = id2Project.Where(x => x.Name.Equals(project.Code)).FirstOrDefault();

                project.ID2Path = id2?.Path ?? null;

                project.ID2Info = id2 ?? new ID2ProjectInfo();

                return rep.GetProjectInfo(ProjectID);

            }

        }

        public bool SetProjectData(ProjectInfo projectInfo, List<ID2ProjectInfo> id2ProjectList)

        {

            using (ProjectRepository rep = new ProjectRepository(this._MSSQLCONNSTR))

            {

                return rep.SetProjectData(projectInfo, id2ProjectList);

            }

        }

        public bool SetProjectGroupData(ProjectInfo projectInfo)

        {

            using (ProjectRepository rep = new ProjectRepository(this._MSSQLCONNSTR))

            {

                return rep.SetProjectGroupData(projectInfo);

            }

        }

    }

}