public int GetNewActivityCount(string dp)
{
var q = (from a in dbContext.Activities
let isNotMapped = (a.ProjectId ?? 0) == 0 && (a.MappedProjectId ?? 0) == 0 && (a.MappedTrustFundId ?? 0) == 0
let isMapped = a.ProjectId > 0 || a.MappedProjectId > 0 || a.MappedTrustFundId > 0
where a.OrgId == dp && a.AssignedOrgId == dp && isNotMapped
select 1).Count();
return q;
}
public int GetMappedActivityCount(string dp)