Changeset 15503 for branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/ResourcePermissionDao.cs
- Timestamp:
- 12/07/17 18:14:13 (7 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/ResourcePermissionDao.cs
r15500 r15503 43 43 } 44 44 45 public void DeleteByResourceIdAndGrantedUserId(Guid resourceId, IEnumerable<Guid> grantedUserId) { 46 string paramIds = string.Join(",", grantedUserId.Select(x => string.Format("'{0}'", x))); 47 if (!string.IsNullOrWhiteSpace(paramIds)) { 48 string query = string.Format(DeleteByGrantedUserQuery, resourceId, paramIds); 49 DataContext.ExecuteCommand(query); 50 } 51 } 52 45 53 #region Compiled queries 46 54 private static readonly Func<DataContext, Guid, IEnumerable<ResourcePermission>> GetByResourceIdQuery = … … 71 79 ;"; 72 80 81 private const string DeleteByGrantedUserQuery = @" 82 DELETE FROM [ResourcePermission] 83 WHERE ResourceId = '{0}' 84 AND GrantedUserId IN ({1}) 85 ;"; 73 86 #endregion 74 87 }
Note: See TracChangeset
for help on using the changeset viewer.