EA7_spDeleteUserLink

CREATE PROCEDURE dbo.EA7_spDeleteUserLink(@LinkId integer) AS 
BEGIN
    declare @ClientUsersID int;
    select @ClientUsersID = ClientUsersID
    from dbo.BackOfficeSystemUsers
    where ID = @LinkId;

    exec dbo.spBreakBackOfficeSystemUsersLink @PKID=@ClientUsersID, @CurrentUsersID = 0, @BackOfficeSystemID = 1;

    /* 10.07.2010  This used to do the following, which was deleting the record from BackOfficeSystemPeople as well as
       BackOfficeSystemUsers. However, the BreakLink button on the Users page uses spBreakBackOfficeSystemUsersLink,
       which only deletes from BackOfficeSystemUsers. We are going to call that also. If we need to delete
       from both tables, then spBreakBackOfficeSystemUsersLink should be updated.
    DECLARE @PeopleId    integer
    SET @PeopleId = (SELECT BackofficePeopleID FROM dbo.BackOfficeSystemUsers WHERE ID = @LinkId)
    DELETE FROM dbo.BackOfficeSystemUsers WHERE ID = @LinkId
    DELETE FROM dbo.BackOfficeSystemPeople WHERE ID = @PeopleId
    */
END