spApproveContent

Parameters

Parameter	Parameter Type	Mode
@Approved	bit	IN
@ClientUsersID	int	IN
@ContentGuid	uniqueidentifier	IN

Definition

Copy


                CREATE PROCEDURE dbo.spApproveContent
    (
        @Approved bit,
        @ClientUsersID int,
        @ContentGuid uniqueidentifier
    )
AS
    declare @IsApproved bit

    SELECT @IsApproved = Approved FROM SiteContent WHERE Guid=@ContentGuid

    if (@IsApproved<>@Approved) begin
        UPDATE
            SiteContent
        SET
            Approved = @Approved
        WHERE
            Guid = @ContentGuid

        if @Approved=0
            exec dbo.spAuditThis @ClientUsersID, 6, @ContentGuid, 1
        else
            exec dbo.spAuditThis @ClientUsersID, 5, @ContentGuid, 1
    end