Changeset 15552 for branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/ProjectDao.cs
- Timestamp:
- 12/20/17 11:27:33 (6 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/ProjectDao.cs
r15540 r15552 31 31 public override Project GetById(Guid id) { 32 32 return GetByIdQuery(DataContext, id); 33 } 34 35 public IEnumerable<Project> GetGrantedProjectsForUser(IEnumerable<Guid> userAndGroupIds) { 36 return GetGrantedProjectsForUserQuery(DataContext, userAndGroupIds); 33 37 } 34 38 … … 63 67 where project.ProjectId == projectId 64 68 select project).SingleOrDefault()); 69 private static readonly Func<DataContext, IEnumerable<Guid>, IEnumerable<Project>> GetGrantedProjectsForUserQuery = 70 CompiledQuery.Compile((DataContext db, IEnumerable<Guid> userAndGroupIds) => 71 (from project in db.GetTable<Project>() 72 join projectPermission in db.GetTable<ProjectPermission>() 73 on project.ProjectId equals projectPermission.ProjectId 74 where userAndGroupIds.Contains(projectPermission.GrantedUserId) 75 select project).Distinct()); 65 76 #endregion 66 77 67 #region String queries78 #region String queries 68 79 private const string GetChildProjectsByIdQuery = @" 69 80 WITH ptree AS
Note: See TracChangeset
for help on using the changeset viewer.