USP_DATAFORMTEMPLATE_EDIT_ADUEXPORT

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@LOGINNAME	nvarchar(50)	IN
@PASSWORD	nvarchar(50)	IN
@OUTPUTPATH	nvarchar(1024)	IN
Definition

Copy


                    create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ADUEXPORT
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @NAME nvarchar(100),
                        @DESCRIPTION nvarchar(255),
                        @LOGINNAME nvarchar(50),
                        @PASSWORD nvarchar(50),
                        @OUTPUTPATH nvarchar(1024)
                    )
                    as
                    set nocount on;

                    declare @DATE datetime;
                    set @DATE = getdate();

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

                    begin try
                        exec dbo.USP_GET_KEY_ACCESS;

                        update dbo.ADUEXPORTPROCESS
                            set NAME = @NAME,
                                DESCRIPTION = @DESCRIPTION,
                                LOGINNAME = EncryptByKey(Key_GUID('sym_BBInfinity'), @LOGINNAME),
                                PASSWORD = EncryptByKey(Key_GUID('sym_BBInfinity'), @PASSWORD),
                                OUTPUTPATH = @OUTPUTPATH,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @DATE
                        where ID = @ID;

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

                        close symmetric key sym_BBInfinity;

                        return 1;
                    end catch

                    return 0;