DELETE FROM [dbo].[GrantedPermissions] WHERE (([PermissionId] = @Original_PermissionId) AND ([PermissionOwnerId] = @Original_PermissionOwnerId) AND ([EntityId] = @Original_EntityId)) INSERT INTO [dbo].[GrantedPermissions] ([PermissionId], [PermissionOwnerId], [EntityId]) VALUES (@PermissionId, @PermissionOwnerId, @EntityId); SELECT PermissionId, PermissionOwnerId, EntityId FROM GrantedPermissions WHERE (EntityId = @EntityId) AND (PermissionId = @PermissionId) AND (PermissionOwnerId = @PermissionOwnerId) SELECT * FROM dbo.GrantedPermissions UPDATE [dbo].[GrantedPermissions] SET [PermissionId] = @PermissionId, [PermissionOwnerId] = @PermissionOwnerId, [EntityId] = @EntityId WHERE (([PermissionId] = @Original_PermissionId) AND ([PermissionOwnerId] = @Original_PermissionOwnerId) AND ([EntityId] = @Original_EntityId)); SELECT PermissionId, PermissionOwnerId, EntityId FROM GrantedPermissions WHERE (EntityId = @EntityId) AND (PermissionId = @PermissionId) AND (PermissionOwnerId = @PermissionOwnerId) SELECT * FROM dbo.GrantedPermissions WHERE EntityId = @EntityId SELECT * FROM dbo.GrantedPermissions WHERE PermissionId = @PermissionId SELECT * FROM dbo.GrantedPermissions WHERE PermissionOwnerId = @PermissionOwnerId SELECT * FROM dbo.GrantedPermissions WHERE PermissionId = @PermissionId AND PermissionOwnerId = @PermissionOwnerId AND EntityId = @EntityId DELETE FROM [dbo].[UserGroup] WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId)) INSERT INTO [dbo].[UserGroup] ([PermissionOwnerId]) VALUES (@PermissionOwnerId); SELECT PermissionOwnerId FROM UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId) SELECT * 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 * FROM UserGroup WHERE EXISTS (SELECT * FROM PermissionOwner_UserGroup WHERE PermissionOwner_UserGroup.PermissionOwnerId = @PermissionOwnerId AND PermissionOwner_UserGroup.UserGroupId = UserGroup.PermissionOwnerId) DELETE FROM [HLUser] WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId)) INSERT INTO [HLUser] ([PermissionOwnerId], [Password], [Login], [MailAddress]) VALUES (@PermissionOwnerId, @Password, @Login, @MailAddress); SELECT PermissionOwnerId, Password, Login, MailAddress FROM HLUser WHERE (PermissionOwnerId = @PermissionOwnerId) SELECT * FROM HLUser UPDATE [HLUser] SET [PermissionOwnerId] = @PermissionOwnerId, [Password] = @Password, [Login] = @Login, [MailAddress] = @MailAddress WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId)); SELECT PermissionOwnerId, Password, Login, MailAddress FROM HLUser WHERE (PermissionOwnerId = @PermissionOwnerId) SELECT * FROM HLUser WHERE PermissionOwnerId = @Id SELECT * FROM HLUser WHERE Login = @Login DELETE FROM [Permission] WHERE (([PermissionId] = @Original_PermissionId)) INSERT INTO [Permission] ([PermissionId], [Name], [Description], [Plugin]) VALUES (@PermissionId, @Name, @Description, @Plugin); SELECT PermissionId, Name, Description, Plugin FROM Permission WHERE (PermissionId = @PermissionId) SELECT * FROM Permission UPDATE [Permission] SET [PermissionId] = @PermissionId, [Name] = @Name, [Description] = @Description, [Plugin] = @Plugin WHERE (([PermissionId] = @Original_PermissionId)); SELECT PermissionId, Name, Description, Plugin FROM Permission WHERE (PermissionId = @PermissionId) SELECT Description, Name, PermissionId, Plugin FROM Permission WHERE (PermissionId = @Id) DELETE FROM [PermissionOwner] WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId)) INSERT INTO [PermissionOwner] ([PermissionOwnerId], [Name]) VALUES (@PermissionOwnerId, @Name); SELECT PermissionOwnerId, Name FROM PermissionOwner WHERE (PermissionOwnerId = @PermissionOwnerId) SELECT * FROM PermissionOwner UPDATE [PermissionOwner] SET [PermissionOwnerId] = @PermissionOwnerId, [Name] = @Name WHERE (([PermissionOwnerId] = @Original_PermissionOwnerId)); SELECT PermissionOwnerId, Name FROM PermissionOwner WHERE (PermissionOwnerId = @PermissionOwnerId) SELECT Name, PermissionOwnerId FROM PermissionOwner WHERE (PermissionOwnerId = @Id) SELECT Name, PermissionOwnerId FROM PermissionOwner WHERE (Name = @Name) DELETE FROM [dbo].[PermissionOwner_UserGroup] WHERE (([UserGroupId] = @Original_UserGroupId) AND ([PermissionOwnerId] = @Original_PermissionOwnerId)) INSERT INTO [dbo].[PermissionOwner_UserGroup] ([UserGroupId], [PermissionOwnerId]) VALUES (@UserGroupId, @PermissionOwnerId); SELECT UserGroupId, PermissionOwnerId FROM PermissionOwner_UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId) AND (UserGroupId = @UserGroupId) SELECT * FROM dbo.PermissionOwner_UserGroup UPDATE [dbo].[PermissionOwner_UserGroup] SET [UserGroupId] = @UserGroupId, [PermissionOwnerId] = @PermissionOwnerId WHERE (([UserGroupId] = @Original_UserGroupId) AND ([PermissionOwnerId] = @Original_PermissionOwnerId)); SELECT UserGroupId, PermissionOwnerId FROM PermissionOwner_UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId) AND (UserGroupId = @UserGroupId) SELECT PermissionOwnerId, UserGroupId FROM PermissionOwner_UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId) SELECT PermissionOwnerId, UserGroupId FROM PermissionOwner_UserGroup WHERE (PermissionOwnerId = @PermissionOwnerId) AND (UserGroupId = @UserGroupId) SELECT PermissionOwnerId, UserGroupId FROM PermissionOwner_UserGroup WHERE (UserGroupId = @UserGroupId)