spSubmitSitePollResults

Parameters

Parameter	Parameter Type	Mode
@SitePollID	int	IN
@CurrentUsersID	int	IN
@SitePollAnswersID	int	IN
@MachineIP	nvarchar(50)	IN
Definition

Copy


CREATE   PROCEDURE dbo.spSubmitSitePollResults (
        @SitePollID        int,
        @CurrentUsersID        int,
        @SitePollAnswersID  int,
        @MachineIP            nvarchar(50)
    )
    AS

    BEGIN

    DECLARE @RecordCount int

    if (@CurrentUsersID > 0) begin

        SELECT @RecordCount = COUNT(*) 
        FROM SitePollResults spr
            INNER JOIN SitePollAnswers spa1
            ON spa1.ID = spr.SitePollAnswersID
        WHERE spr.ClientUsersID = @CurrentUsersID
            and spa1.SitePollsID = @SitePollID

    end
    else begin

        if (Len(@MachineIP) > 0) begin

            SELECT @RecordCount = COUNT(*) 
            FROM SitePollResults spr
                INNER JOIN SitePollAnswers spa1
                    ON spa1.ID = spr.SitePollAnswersID
            WHERE spr.MachineIP = @MachineIP
                    and spr.ClientUsersID = 0
            and spa1.SitePollsID = @SitePollID

        end

    end

    if @RecordCount = 0 begin

        INSERT INTO SitePollResults (
            SitePollAnswersID,
            ClientUsersID,
            MachineIP, 
            DateAdded)
        VALUES ( 
            @SitePollAnswersID,
             @CurrentUsersID,
            @MachineIP,
             getutcdate()
            )

        if @@ERROR = 0 begin
            UPDATE SitePolls SET SitePolls.LastActivityDate = getutcdate() 
            WHERE SitePolls.ID = @SitePollID
        end
    end

END