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