AIMS_BD_IATI.DAL.AimsDAL.GetAIMSProjectsInIATIFormat C# (CSharp) Метод

        public List<iatiactivity> GetAIMSProjectsInIATIFormat(string dp)
        {

            var projects = (from project in dbContext.tblProjectInfoes
                            join fundSource in dbContext.tblFundSources on project.FundSourceId equals fundSource.Id
                            let isIATIactivity = project.IatiIdentifier != null || project.IatiIdentifier.Length > 0 || project.DPProjectNo != null || project.DPProjectNo.Length > 0
                            where fundSource.IATICode == dp
                            && isIATIactivity
                            select project);

            List<iatiactivity> iatiactivities = new List<iatiactivity>();

            foreach (var project in projects)
            {
                var iatiActivityObj = ConvertAimsToIati(project);

                iatiactivities.Add(iatiActivityObj);
            }

            return iatiactivities;
        }