USP_DATAFORMTEMPLATE_VIEW_EVENTSOCIALNETWORK

The load procedure used by the view dataform template "Event Social Network View Form "

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@EVENTID	uniqueidentifier	INOUT	Event
@TWITTERID	nvarchar(100)	INOUT	User name
@TWITTERPASSWORD	nvarchar(100)	INOUT	Password
@TWITTERURL	UDT_WEBADDRESS	INOUT	URL
@FACEBOOKID	nvarchar(100)	INOUT	User name
@FACEBOOKPASSWORD	nvarchar(100)	INOUT	Password
@FACEBOOKURL	UDT_WEBADDRESS	INOUT	URL
@YOUTUBEID	nvarchar(100)	INOUT	User name
@YOUTUBEPASSWORD	nvarchar(100)	INOUT	Password
@YOUTUBEURL	UDT_WEBADDRESS	INOUT	URL
@MYSPACEID	nvarchar(100)	INOUT	User name
@MYSPACEPASSWORD	nvarchar(100)	INOUT	Password
@MYSPACEURL	UDT_WEBADDRESS	INOUT	URL

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EVENTSOCIALNETWORK
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @EVENTID uniqueidentifier = null output,
      @TWITTERID nvarchar(100) = null output,
    @TWITTERPASSWORD nvarchar(100) = null output,
    @TWITTERURL dbo.UDT_WEBADDRESS = null output,
    @FACEBOOKID nvarchar(100) = null output,
    @FACEBOOKPASSWORD nvarchar(100) = null output,
    @FACEBOOKURL dbo.UDT_WEBADDRESS = null output,
    @YOUTUBEID nvarchar(100) = null output,
    @YOUTUBEPASSWORD nvarchar(100) = null output,
    @YOUTUBEURL dbo.UDT_WEBADDRESS = null output,
    @MYSPACEID nvarchar(100) = null output,
    @MYSPACEPASSWORD nvarchar(100) = null output,
    @MYSPACEURL dbo.UDT_WEBADDRESS = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 0;

    -- populate the output parameters, which correspond to fields on the form.  Note that
    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system
    -- will display a "no data loaded" message.

    -- Open the symmetric key for decryption
    exec dbo.USP_GET_KEY_ACCESS;

    select @DATALOADED = 1,
       @EVENTID= EVENTID,
       @TWITTERID = TWITTERID,       
     @TWITTERPASSWORD = coalesce(convert(nvarchar(100), DecryptByKey(TWITTERPASSWORD)),''),
       @TWITTERURL = TWITTERURL, 
       @FACEBOOKID = FACEBOOKID,
       @FACEBOOKPASSWORD = coalesce(convert(nvarchar(100), DecryptByKey(FACEBOOKPASSWORD)),''),
       @FACEBOOKURL = FACEBOOKURL, 
       @YOUTUBEID = YOUTUBEID,
       @YOUTUBEPASSWORD = coalesce(convert(nvarchar(100), DecryptByKey(YOUTUBEPASSWORD)),''),
       @YOUTUBEURL = YOUTUBEURL,
       @MYSPACEID = MYSPACEID,
       @MYSPACEPASSWORD = coalesce(convert(nvarchar(100), DecryptByKey(MYSPACEPASSWORD)),''),
       @MYSPACEURL = MYSPACEURL 

    from dbo.EVENT E (NOLOCK)
    left join dbo.EVENTEXTENSION EX (NOLOCK) ON EX.EVENTID = E.ID
    where E.ID = @ID

    close symmetric key sym_BBInfinity;                    

    return 0;