fnSitePollResultAlreadySubmitted

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@CurrentUsersID	int	IN
@SitePollsID	int	IN
@MachineIP	nvarchar(50)	IN

Definition

Copy



    CREATE FUNCTION fnSitePollResultAlreadySubmitted(
    @CurrentUsersID      int,
    @SitePollsID      int,
    @MachineIP          nvarchar(50)
)
RETURNS bit
AS
BEGIN

    DECLARE @SitePollResultAlreadySubmitted bit
    SELECT @SitePollResultAlreadySubmitted=0

    DECLARE @RecordCount int

    if (@CurrentUsersID > 0) begin

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

    end
    else begin

        if (Len(@MachineIP) > 0) begin

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

    if @RecordCount > 0 begin
        SELECT @SitePollResultAlreadySubmitted=1
    end

    RETURN @SitePollResultAlreadySubmitted

END