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

        public iatiactivityContainer GetMappedActivities(string dp)
        {
            var q = (from a in dbContext.Activities
                     let isMapped = a.ProjectId > 0 || a.MappedProjectId > 0
                     where a.OrgId == dp && a.AssignedOrgId == dp && isMapped && a.IsIgnore != true
                     orderby a.IatiIdentifier
                     select new ActivityModel
                     {
                         IatiActivity = a.IatiActivity,
                         OrgId = a.OrgId,
                         ProjectId = a.ProjectId,
                         MappedProjectId = a.MappedProjectId,
                         MappedTrustFundId = a.MappedTrustFundId,
                         IsInclude = a.IsInclude
                     }).ToList();

            var iatiActivities = ParseXMLAndResolve(q);
            foreach (var activity in iatiActivities)
            {
                LoadChildActivities(activity);
            }

            var aimsActivities = GetMappedAimsProjects(dp);

            return new iatiactivityContainer
            {
                iatiActivities = iatiActivities,
                AimsProjects = aimsActivities
            };
        }