static internal List <Project> GetProjects()
{
string projectList = UserProjectSecurity.GetUserProjectList();
string filter = $"ProjectObjectId IN ({projectList}) " +
$"AND Status <> 'X' AND ExtData NOT LIKE '%isTemplate%'";
return(BaseObject.GetList <Project>(filter, "ItemPosition, Name"));
}
static internal FixedList <ProjectItem> GetAllActivities()
{
string projectList = UserProjectSecurity.GetUserProjectList();
string sql = $"SELECT * FROM PMProjectObjects " +
$"WHERE BaseProjectId IN ({projectList}) AND ProjectObjectTypeId <> 1203 AND Status <> 'X' AND " +
$"BaseProjectId NOT IN (SELECT ProjectObjectId FROM PMProjectObjects WHERE Status = 'X' OR ExtData LIKE '%isTemplate%')";
var op = DataOperation.Parse(sql);
return(DataReader.GetList <ProjectItem>(op).ToFixedList());
}
