AIMS_BD_IATI.DAL.AimsDbIatiDAL.GetNotMappedAimsProjects C# (CSharp) Method

        private List<iatiactivity> GetNotMappedAimsProjects(string dp)
        {
            var mappedProjectIds = (from a in dbContext.Activities
                                    let isMapped = a.ProjectId > 0 || a.MappedProjectId > 0 || a.MappedTrustFundId > 0
                                    where a.AssignedOrgId == dp && isMapped && a.IsIgnore != true
                                    select (a.ProjectId > 0 ? a.ProjectId :
                                    a.MappedProjectId > 0 ? a.MappedProjectId :
                                    a.MappedTrustFundId)).ToList();


            var aimsActivities = new AimsDAL().GetNotMappedAIMSProjectsInIATIFormat(dp, mappedProjectIds);
            return aimsActivities;
        }