Changeset 15628 for branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/AssignedProjectResourceDao.cs

Timestamp:

01/17/18 15:24:44 (6 years ago)

Author:

jzenisek

Message:

#2839

• updated TaskDao towards independency of the formerly used Task-Resource assignment entity
• updated several permission/assignment handling service methods for client
• added AssignedJobResource DTO

File:

• branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/AssignedProjectResourceDao.cs (modified) (4 diffs)

branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/AssignedProjectResourceDao.cs

@@ -107 +107 @@
         WHERE ProjectId IN ({0})
     ";
+    // tested
     private const string CheckProjectGrantedForResourcesQueryString = @"
     WITH rtree AS
@@ -125 +126 @@
       FROM rtree, [AssignedProjectResource] apr
       WHERE rtree.ParentResourceId = apr.ResourceId
-      AND apr.ProjectId = {0}
+      AND apr.ProjectId = '{0}'
       UNION
       SELECT apr.ResourceId
       FROM [AssignedProjectResource] apr
-      WHERE apr.ProjectId = {0}
+      WHERE apr.ProjectId = '{0}'
     )
     ";
@@ -146 +147 @@
       WHERE rtree.ParentResourceId = apr.ResourceId
       AND rtree.ResourceId = res.ResourceId
-      AND apr.ProjectId = {0}
+      AND apr.ProjectId = '{0}'
       UNION
       SELECT res.*
       FROM [AssignedProjectResource] apr, [Resource] res
       WHERE apr.ResourceId = res.ResourceId
-      AND apr.ProjectId = {0}
+      AND apr.ProjectId = '{0}'
     ";
     private const string GetAllGrantedResourceIdsByProjectIdQueryString = @"
@@ -166 +167 @@
     FROM rtree, [AssignedProjectResource] apr
     WHERE rtree.ParentResourceId = apr.ResourceId
-    AND apr.ProjectId = {0}
+    AND apr.ProjectId = '{0}'
     UNION
     SELECT apr.ResourceId
     FROM [AssignedProjectResource] apr
-    WHERE apr.ProjectId = {0}
+    WHERE apr.ProjectId = '{0}'
     ";
     private const string GetAllGrantedResourceIdsOfOwnedParentProjectsQueryString = @"