USP_DATAFORMTEMPLATE_EDIT_EVENT_EXTENSION

Used for adding Event Extension

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@EVENTID	uniqueidentifier	IN	Event
@EVENTYEAR	UDT_YEAR	IN	Event year
@SUPPORTPHONE	nvarchar(100)	IN	Support phone
@SUPPORTURL	UDT_WEBADDRESS	IN	Support url
@LOOKUPEVENTID	nvarchar(100)	IN
@FACEBOOKURL	UDT_WEBADDRESS	IN	Facebook url
@MYSPACEURL	UDT_WEBADDRESS	IN	Myspaceurl
@EVENTURL	UDT_WEBADDRESS	IN	Event url
@EVENTTYPECODE	tinyint	IN
@LOCATIONDESCRIPTION	nvarchar(1000)	IN	Location description
@TWITTERID	nvarchar(100)	IN	Twitter ID
@TWITTERPASSWORD	nvarchar(100)	IN	Twitter Password
@FACEBOOKID	nvarchar(100)	IN	Facebook Login
@FACEBOOKPASSWORD	nvarchar(100)	IN	Facebook Password
@YOUTUBEID	nvarchar(100)	IN	YouTube Login
@YOUTUBEPASSWORD	nvarchar(100)	IN	YouTube Password

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EVENT_EXTENSION
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @EVENTID uniqueidentifier,
  @EVENTYEAR UDT_YEAR,
  @SUPPORTPHONE nvarchar(100),
  @SUPPORTURL UDT_WEBADDRESS,
  @LOOKUPEVENTID nvarchar(100),
  @FACEBOOKURL dbo.UDT_WEBADDRESS = '' ,
  @MYSPACEURL dbo.UDT_WEBADDRESS = '',
  @EVENTURL UDT_WEBADDRESS,
  @EVENTTYPECODE tinyint,
  --@EVENTSTATUS nvarchar(1),

  @LOCATIONDESCRIPTION nvarchar(1000), 
  --@EVENTGROUPFAFID uniqueidentifier,

  --@EVENTTEMPLATEID uniqueidentifier,

  @TWITTERID nvarchar(100),
  @TWITTERPASSWORD nvarchar(100),
  @FACEBOOKID nvarchar(100),
  @FACEBOOKPASSWORD nvarchar(100),    
  @YOUTUBEID nvarchar(100),
  @YOUTUBEPASSWORD nvarchar(100)

)
as

    set nocount on;

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    begin try

        -- Open the symmetric key for encryption

        exec dbo.USP_GET_KEY_ACCESS;

        -- handle updating the data

        update dbo.EVENTEXTENSION 
    set
        EVENTID = @EVENTID,
        EVENTYEAR = @EVENTYEAR,
        SUPPORTPHONE = @SUPPORTPHONE,
        SUPPORTURL = @SUPPORTURL,
        LOOKUPEVENTID = @LOOKUPEVENTID,
        FACEBOOKURL = @FACEBOOKURL,
        MYSPACEURL = @MYSPACEURL,
        EVENTURL = @EVENTURL,
        EVENTTYPECODE = @EVENTTYPECODE,
        --EVENTSTATUS = @EVENTSTATUS,

        LOCATIONDESCRIPTION = @LOCATIONDESCRIPTION,
        TWITTERID = @TWITTERID,
        TWITTERPASSWORD = EncryptByKey(Key_GUID('sym_BBInfinity'), @TWITTERPASSWORD),
        FACEBOOKID = @FACEBOOKID,
        FACEBOOKPASSWORD = EncryptByKey(Key_GUID('sym_BBInfinity'), @FACEBOOKPASSWORD),
        YOUTUBEID = @YOUTUBEID,
        YOUTUBEPASSWORD = EncryptByKey(Key_GUID('sym_BBInfinity'), @YOUTUBEPASSWORD),
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = getdate()

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

        close symmetric key sym_BBInfinity;

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;