spDelete_UserImport

Parameters

Parameter	Parameter Type	Mode	Description
@PKID	int	IN
@CurrentUsersID	int	IN

Definition

Copy



    CREATE PROCEDURE [dbo].[spDelete_UserImport](
        @PKID int,
        @CurrentUsersID INT
    )
    AS
    DECLARE @Status INT
    DECLARE @EmailID INT

    SELECT @Status=COALESCE([Status], 0) FROM  [dbo].[UserImport] WHERE id=@PKID
    IF (@Status<=1)  BEGIN   --Nothing has been processed, if there is an email created then we need to whack it
            SELECT @EmailID=COALESCE([EmailID], 0) FROM  [dbo].[UserImport] WHERE id=@PKID
            DELETE FROM [dbo].[UserImport] WHERE id=@PKID
            if (@EmailID>0) BEGIN
                exec [dbo].[spDelete_Email] @EmailID, @CurrentUsersID
            END
        END
    ELSE
        UPDATE [dbo].[UserImport] set [deleted] = 1 WHERE id=@PKID