29 lines
968 B
Plaintext
29 lines
968 B
Plaintext
|
ALTER PROCEDURE [dbo].[sp_GroupsDelete]
|
||
|
|
@Id INT,
|
||
|
|
@errorNumber INT OUTPUT,
|
||
|
|
@errorMessage NVARCHAR (255) OUTPUT
|
||
|
|
AS
|
||
|
|
BEGIN
|
||
|
|
SET NOCOUNT ON;
|
||
|
|
SET @errorNumber=0
|
||
|
|
SET @errorMessage=''
|
||
|
|
|
||
|
|
/*Delete any channel settings*/
|
||
|
|
DELETE A FROM [dbo].GroupChannelSettings AS A INNER JOIN [dbo].Channels AS B on A.ChannelId=B.Id WHERE B.GroupId=@Id;
|
||
|
|
/*Delete any level triggers*/
|
||
|
|
DELETE A FROM [dbo].LevelTriggers AS A INNER JOIN [dbo].Channels AS B on A.ChannelId=B.Id WHERE B.GroupId=@Id;
|
||
|
|
/*Delete any channels from this group*/
|
||
|
|
DELETE FROM [dbo].Channels WHERE [GroupId] = @Id
|
||
|
|
/*Delete assignment of this group to any tests*/
|
||
|
|
DELETE FROM [dbo].TestSetupGroups WHERE [GroupId]=@Id
|
||
|
|
/*Delete hardware assignments*/
|
||
|
|
DELETE FROM [dbo].GroupHardware WHERE [GroupId]=@Id
|
||
|
|
/*delete group*/
|
||
|
|
DELETE FROM [dbo].Groups WHERE [Id]=@Id
|
||
|
|
|
||
|
|
if(@@error != 0)
|
||
|
|
begin
|
||
|
|
set @errorNumber = error_number()
|
||
|
|
set @errorMessage = error_message()
|
||
|
|
end
|
||
|
|
END
|