USP_DATAFORMTEMPLATE_EDITLOAD_EXCHANGECONTACTSYNC

The load procedure used by the edit dataform template "Exchange Contact Synchronization Process Edit 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.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(250)	INOUT	Description
@APPUSERIDSETREGISTERID	uniqueidentifier	INOUT	Selection
@CONSTITUENTIDSETREGISTERID	uniqueidentifier	INOUT	Selection
@EXCHANGECONTACTCATEGORYCODEID	uniqueidentifier	INOUT	Category
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@APPUSERRECORDTYPEID	uniqueidentifier	INOUT
@CONSTITUENTRECORDTYPEID	uniqueidentifier	INOUT
@APPLYTOCODE	tinyint	INOUT	Apply to
@LIMITTOASSIGNEDCONSTITUENTS	bit	INOUT	Create contacts based on prospect planned step or planned interaction ownership
@SPECIFICAPPUSERID	uniqueidentifier	INOUT	User
@PAGEDEFINITIONCATALOGID	uniqueidentifier	INOUT	Add link to

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EXCHANGECONTACTSYNC
                        (
                            @ID uniqueidentifier,
                            @DATALOADED bit = 0 output,
                            @NAME nvarchar(100) = null output,
                            @DESCRIPTION nvarchar(250) = null output,
                            @APPUSERIDSETREGISTERID uniqueidentifier = null output,
                            @CONSTITUENTIDSETREGISTERID uniqueidentifier = null output,
                            @EXCHANGECONTACTCATEGORYCODEID uniqueidentifier = null output,
                            @TSLONG bigint = 0 output,
                            @APPUSERRECORDTYPEID uniqueidentifier = null output,
                            @CONSTITUENTRECORDTYPEID uniqueidentifier = null output,
                            @APPLYTOCODE tinyint = null output,
                            @LIMITTOASSIGNEDCONSTITUENTS bit = null output,
                            @SPECIFICAPPUSERID uniqueidentifier = null output,
                            @PAGEDEFINITIONCATALOGID uniqueidentifier = null output
                        )
                        as
                        begin
                            set nocount on;                                                        

                            begin try
                                select
                                    @NAME = EXCHANGECONTACTSYNC.NAME,
                                    @DESCRIPTION = EXCHANGECONTACTSYNC.DESCRIPTION,
                                    @APPUSERIDSETREGISTERID = EXCHANGECONTACTSYNC.APPUSERIDSETREGISTERID,
                                    @CONSTITUENTIDSETREGISTERID = EXCHANGECONTACTSYNC.CONSTITUENTIDSETREGISTERID,
                                    @EXCHANGECONTACTCATEGORYCODEID = EXCHANGECONTACTSYNC.EXCHANGECONTACTCATEGORYCODEID,
                                    @TSLONG = EXCHANGECONTACTSYNC.TSLONG, 
                                    @DATALOADED = 1,
                                    @APPUSERRECORDTYPEID = dbo.UFN_RECORDTYPE_GETIDBYNAME('Application User'),
                                    @CONSTITUENTRECORDTYPEID = dbo.UFN_RECORDTYPE_GETIDBYNAME('Constituent'),
                                    @APPLYTOCODE = APPLYTOCODE,
                                    @LIMITTOASSIGNEDCONSTITUENTS = LIMITTOASSIGNEDCONSTITUENTS,
                                    @SPECIFICAPPUSERID = SPECIFICAPPUSERID,
                                    @PAGEDEFINITIONCATALOGID = PAGEDEFINITIONCATALOGID
                                from
                                    dbo.EXCHANGECONTACTSYNC
                                where
                                    EXCHANGECONTACTSYNC.ID = @ID;        
                            end try
                            begin catch
                                exec dbo.USP_RAISE_ERROR;    
                                return 1;
                            end catch 

                            return 0;
                        end