spAddUpdate_ClientSSO

Parameters

Parameter	Parameter Type	Mode
@ID	int	INOUT
@Description	nvarchar(256)	IN
@SharedKey	nvarchar(256)	IN
@UserNameParameter	nvarchar(50)	IN
@TimeParameter	nvarchar(50)	IN
@MD5Parameter	nvarchar(50)	IN
@ClientSiteID	int	IN
@Delta	int	IN
@IncludeIP	bit	IN
@RequireSsl	bit	IN

Definition

Copy



CREATE procedure dbo.spAddUpdate_ClientSSO
    @ID int out,
    @Description nvarchar(256),
    @SharedKey nvarchar(256),
    @UserNameParameter nvarchar(50),
    @TimeParameter nvarchar(50),
    @MD5Parameter nvarchar(50),
    @ClientSiteID int, 
    @Delta int,
    @IncludeIP bit,
    @RequireSsl bit
    as

    set nocount on;

    begin try
        exec dbo.USP_GET_KEY_ACCESS            

        if (ltrim(rtrim(@SharedKey)) <> '')
        begin 
        set @SharedKey = EncryptByKey(Key_GUID('sym_BBInfinity'),  @SharedKey)
        end        
        close symmetric key sym_BBInfinity;

        end try        
        begin catch
            close symmetric key sym_BBInfinity;
            exec dbo.USP_RAISE_ERROR;
        end catch


    if exists(select ID from dbo.ClientSSO where ID = @ID) begin
        update dbo.ClientSSO set
            Description = @Description,
            SharedKey = @SharedKey,
            UserNameParameter = @UserNameParameter,
            TimeParameter = @TimeParameter,
            MD5Parameter = @MD5Parameter,
            ClientSiteID = @ClientSiteID,
            Delta = @Delta,
            IncludeIP = @IncludeIP,
            RequireSsl = @RequireSsl
        where
            ID = @ID;
    end else begin
        insert into dbo.ClientSSO (
            Description,
            SharedKey,
            UserNameParameter,
            TimeParameter,
            MD5Parameter,
            ClientSiteID,
            Delta,
            IncludeIP,
            RequireSsl
        ) values (
            @Description,
            @SharedKey,
            @UserNameParameter,
            @TimeParameter,
            @MD5Parameter,
            @ClientSiteID,
            @Delta,
            @IncludeIP,
            @RequireSsl
        );
        set @ID = @@identity;
    end