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()

        {

            try

            {

                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,

                               Team = mg.Team,

                               Level = mg.Level,

                               ID2Info = prjs ?? new ID2ProjectInfo(),

                           };

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        public ProjectInfo GetProjectInfo(string ProjectID)

        {

            try

            {

                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);

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

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

        {

            try

            {

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

                {

                    return rep.SetProjectData(projectInfo, id2ProjectList);

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        public bool SetProjectGroupData(ProjectInfo projectInfo)

        {

            try

            {

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

                {

                    return rep.SetProjectGroupData(projectInfo);

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

    }

}