DELETE FROM [dbo].[Resource] WHERE (([ResourceId] = @Original_ResourceId) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name))) INSERT INTO [dbo].[Resource] ([Name]) VALUES (@Name); SELECT ResourceId, Name FROM Resource WHERE (ResourceId = SCOPE_IDENTITY()) SELECT ResourceId, Name FROM dbo.Resource UPDATE [dbo].[Resource] SET [Name] = @Name WHERE (([ResourceId] = @Original_ResourceId) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name))); SELECT ResourceId, Name FROM Resource WHERE (ResourceId = @ResourceId) SELECT Resource.* FROM Resource INNER JOIN Client ON Resource.ResourceId = Client.ResourceId WHERE Client.Status <> 'offline' SELECT * FROM dbo.Resource WHERE ResourceId = @ID SELECT * FROM dbo.Resource WHERE Name = @Name DELETE FROM [dbo].[Client] WHERE (([ResourceId] = @Original_ResourceId) AND ((@IsNull_GUID = 1 AND [GUID] IS NULL) OR ([GUID] = @Original_GUID)) AND ((@IsNull_CPUSpeed = 1 AND [CPUSpeed] IS NULL) OR ([CPUSpeed] = @Original_CPUSpeed)) AND ((@IsNull_Memory = 1 AND [Memory] IS NULL) OR ([Memory] = @Original_Memory)) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_ClientConfigId = 1 AND [ClientConfigId] IS NULL) OR ([ClientConfigId] = @Original_ClientConfigId)) AND ((@IsNull_NumberOfCores = 1 AND [NumberOfCores] IS NULL) OR ([NumberOfCores] = @Original_NumberOfCores))) INSERT INTO [dbo].[Client] ([ResourceId], [GUID], [CPUSpeed], [Memory], [Login], [Status], [ClientConfigId], [NumberOfCores]) VALUES (@ResourceId, @GUID, @CPUSpeed, @Memory, @Login, @Status, @ClientConfigId, @NumberOfCores); SELECT ResourceId, GUID, CPUSpeed, Memory, Login, Status, ClientConfigId, NumberOfCores FROM Client WHERE (ResourceId = @ResourceId) SELECT ResourceId, GUID, CPUSpeed, Memory, Login, Status, ClientConfigId, NumberOfCores FROM dbo.Client UPDATE [dbo].[Client] SET [ResourceId] = @ResourceId, [GUID] = @GUID, [CPUSpeed] = @CPUSpeed, [Memory] = @Memory, [Login] = @Login, [Status] = @Status, [ClientConfigId] = @ClientConfigId, [NumberOfCores] = @NumberOfCores WHERE (([ResourceId] = @Original_ResourceId) AND ((@IsNull_GUID = 1 AND [GUID] IS NULL) OR ([GUID] = @Original_GUID)) AND ((@IsNull_CPUSpeed = 1 AND [CPUSpeed] IS NULL) OR ([CPUSpeed] = @Original_CPUSpeed)) AND ((@IsNull_Memory = 1 AND [Memory] IS NULL) OR ([Memory] = @Original_Memory)) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_ClientConfigId = 1 AND [ClientConfigId] IS NULL) OR ([ClientConfigId] = @Original_ClientConfigId)) AND ((@IsNull_NumberOfCores = 1 AND [NumberOfCores] IS NULL) OR ([NumberOfCores] = @Original_NumberOfCores))); SELECT ResourceId, GUID, CPUSpeed, Memory, Login, Status, ClientConfigId, NumberOfCores FROM Client WHERE (ResourceId = @ResourceId) SELECT * FROM dbo.Client WHERE Status <> 'offline' SELECT * FROM dbo.Client WHERE GUID = @ID SELECT * FROM dbo.Client WHERE ResourceId = @Id DELETE FROM [dbo].[HiveUser] WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password))) INSERT INTO [dbo].[HiveUser] ([PermissionOwnerId], [Password]) VALUES (@PermissionOwnerId, @Password); SELECT PermissionOwnerId, Password FROM HiveUser WHERE (PermissionOwnerId = @PermissionOwnerId) SELECT PermissionOwnerId, Password FROM dbo.HiveUser UPDATE [dbo].[HiveUser] SET [PermissionOwnerId] = @PermissionOwnerId, [Password] = @Password WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password))); SELECT PermissionOwnerId, Password FROM HiveUser WHERE (PermissionOwnerId = @PermissionOwnerId) SELECT * FROM dbo.HiveUser WHERE PermissionOwnerId = @Id SELECT HiveUser.PermissionOwnerId, HiveUser.Password FROM HiveUser INNER JOIN PermissionOwner ON HiveUser.PermissionOwnerId = PermissionOwner.PermissionOwnerId WHERE (PermissionOwner.Name = @Name) DELETE FROM [dbo].[PermissionOwner] WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name))) INSERT INTO [dbo].[PermissionOwner] ([Name]) VALUES (@Name); SELECT PermissionOwnerId, Name FROM PermissionOwner WHERE (PermissionOwnerId = SCOPE_IDENTITY()) SELECT PermissionOwnerId, Name FROM dbo.PermissionOwner UPDATE [dbo].[PermissionOwner] SET [Name] = @Name WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name))); SELECT PermissionOwnerId, Name FROM PermissionOwner WHERE (PermissionOwnerId = @PermissionOwnerId) SELECT * FROM dbo.PermissionOwner WHERE PermissionOwnerId = @Id SELECT * FROM dbo.PermissionOwner WHERE Name = @Name DELETE FROM [dbo].[UserGroup] WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId)) INSERT INTO [dbo].[UserGroup] ([PermissionOwnerId]) VALUES (@PermissionOwnerId); SELECT PermissionOwnerId FROM UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId) SELECT PermissionOwnerId FROM dbo.UserGroup UPDATE [dbo].[UserGroup] SET [PermissionOwnerId] = @PermissionOwnerId WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId)); SELECT PermissionOwnerId FROM UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId) SELECT * FROM dbo.UserGroup WHERE PermissionOwnerId = @Id SELECT UserGroup.* FROM UserGroup INNER JOIN PermissionOwner ON UserGroup.PermissionOwnerId = PermissionOwner.PermissionOwnerId WHERE (PermissionOwner.Name = @Name) DELETE FROM [dbo].[PermissionOwner_UserGroup] WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId) AND ([UserGroupId] = @Original_UserGroupId)) INSERT INTO [dbo].[PermissionOwner_UserGroup] ([PermissionOwnerId], [UserGroupId]) VALUES (@PermissionOwnerId, @UserGroupId); SELECT PermissionOwnerId, UserGroupId FROM PermissionOwner_UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId) AND (UserGroupId = @UserGroupId) SELECT PermissionOwnerId, UserGroupId FROM dbo.PermissionOwner_UserGroup UPDATE [dbo].[PermissionOwner_UserGroup] SET [PermissionOwnerId] = @PermissionOwnerId, [UserGroupId] = @UserGroupId WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId) AND ([UserGroupId] = @Original_UserGroupId)); SELECT PermissionOwnerId, UserGroupId FROM PermissionOwner_UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId) AND (UserGroupId = @UserGroupId) SELECT * FROM dbo.PermissionOwner_UserGroup WHERE PermissionOwnerId = @Id SELECT * FROM dbo.PermissionOwner_UserGroup WHERE PermissionOwnerId = @PermissionOwnerId AND UserGroupId = @UserGroupId SELECT * FROM dbo.PermissionOwner_UserGroup WHERE UserGroupId = @UserGroupId DELETE FROM [dbo].[ClientGroup] WHERE (([ResourceId] = @Original_ResourceId)) INSERT INTO [dbo].[ClientGroup] ([ResourceId]) VALUES (@ResourceId); SELECT ResourceId FROM ClientGroup WHERE (ResourceId = @ResourceId) SELECT ResourceId FROM dbo.ClientGroup UPDATE [dbo].[ClientGroup] SET [ResourceId] = @ResourceId WHERE (([ResourceId] = @Original_ResourceId)); SELECT ResourceId FROM ClientGroup WHERE (ResourceId = @ResourceId) SELECT * FROM dbo.ClientGroup WHERE ResourceId = @Id DELETE FROM [dbo].[Job] WHERE (([JobId] = @Original_JobId) AND ((@IsNull_ParentJobId = 1 AND [ParentJobId] IS NULL) OR ([ParentJobId] = @Original_ParentJobId)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_PermissionOwnerId = 1 AND [PermissionOwnerId] IS NULL) OR ([PermissionOwnerId] = @Original_PermissionOwnerId)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId))) INSERT INTO [dbo].[Job] ([ParentJobId], [Status], [PermissionOwnerId], [ResourceId]) VALUES (@ParentJobId, @Status, @PermissionOwnerId, @ResourceId); SELECT JobId, ParentJobId, Status, PermissionOwnerId, ResourceId FROM Job WHERE (JobId = SCOPE_IDENTITY()) SELECT JobId, ParentJobId, Status, PermissionOwnerId, ResourceId FROM dbo.Job UPDATE [dbo].[Job] SET [ParentJobId] = @ParentJobId, [Status] = @Status, [PermissionOwnerId] = @PermissionOwnerId, [ResourceId] = @ResourceId WHERE (([JobId] = @Original_JobId) AND ((@IsNull_ParentJobId = 1 AND [ParentJobId] IS NULL) OR ([ParentJobId] = @Original_ParentJobId)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_PermissionOwnerId = 1 AND [PermissionOwnerId] IS NULL) OR ([PermissionOwnerId] = @Original_PermissionOwnerId)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId))); SELECT JobId, ParentJobId, Status, PermissionOwnerId, ResourceId FROM Job WHERE (JobId = @JobId) SELECT * FROM dbo.Job WHERE Status <> 'offline' SELECT * FROM dbo.Job WHERE ResourceId = @ResourceId SELECT * FROM dbo.Job WHERE JobId = @Id SELECT * FROM dbo.Job WHERE Status = @State SELECT * FROM dbo.Job WHERE ParentJobId = @Id SELECT * FROM dbo.Job WHERE PermissionOwnerId = @PermissionOwnerId DELETE FROM [dbo].[ClientGroup_Resource] WHERE (([ClientGroupId] = @Original_ClientGroupId) AND ([ResourceId] = @Original_ResourceId)) INSERT INTO [dbo].[ClientGroup_Resource] ([ClientGroupId], [ResourceId]) VALUES (@ClientGroupId, @ResourceId); SELECT ClientGroupId, ResourceId FROM ClientGroup_Resource WHERE (ClientGroupId = @ClientGroupId) AND (ResourceId = @ResourceId) SELECT ClientGroupId, ResourceId FROM dbo.ClientGroup_Resource UPDATE [dbo].[ClientGroup_Resource] SET [ClientGroupId] = @ClientGroupId, [ResourceId] = @ResourceId WHERE (([ClientGroupId] = @Original_ClientGroupId) AND ([ResourceId] = @Original_ResourceId)); SELECT ClientGroupId, ResourceId FROM ClientGroup_Resource WHERE (ClientGroupId = @ClientGroupId) AND (ResourceId = @ResourceId) SELECT * FROM dbo.ClientGroup_Resource WHERE ClientGroupId = @Id SELECT * FROM dbo.ClientGroup_Resource WHERE ClientGroupId = @ClientGroupId AND ResourceId = @ResourceId SELECT * FROM dbo.ClientGroup_Resource WHERE ResourceId = @Id DELETE FROM [dbo].[JobResult] WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsNull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull_JobResult = 1 AND [JobResult] IS NULL) OR ([JobResult] = @Original_JobResult)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId))) INSERT INTO [dbo].[JobResult] ([JobId], [JobResult], [ResourceId]) VALUES (@JobId, @JobResult, @ResourceId); SELECT JobResultId, JobId, JobResult, ResourceId FROM JobResult WHERE (JobResultId = SCOPE_IDENTITY()) SELECT JobResultId, JobId, JobResult, ResourceId FROM dbo.JobResult UPDATE [dbo].[JobResult] SET [JobId] = @JobId, [JobResult] = @JobResult, [ResourceId] = @ResourceId WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsNull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull_JobResult = 1 AND [JobResult] IS NULL) OR ([JobResult] = @Original_JobResult)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId))); SELECT JobResultId, JobId, JobResult, ResourceId FROM JobResult WHERE (JobResultId = @JobResultId) SELECT * FROM dbo.JobResult WHERE JobResultId = @Id SELECT * FROM dbo.JobResult WHERE JobId = @JobId