Changeset 15628 for branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/ProjectPermissionDao.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/ProjectPermissionDao.cs (modified) (2 diffs)

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

@@ -74 +74 @@
     private const string DeleteByProjectIdAndGrantedUserIdsQueryString = @"
       DELETE FROM [ProjectPermission]
-      WHERE ProjectId = '{0}'
+      WHERE ProjectId = {0}
       AND GrantedUserId IN ({1});
     ";
@@ -85 +85 @@
       SELECT COUNT(pp.ProjectId)
       FROM [ProjectPermission] pp
-      WHERE pp.ProjectId = {0}
+      WHERE pp.ProjectId = '{0}'
       AND pp.GrantedUserId IN ({1})
     ";