USP_DATAFORMTEMPLATE_ADD_PROSPECTASSIGNMENTPROCESS

The save procedure used by the add dataform template "Prospect Assignment Process Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@PROCESSTYPECODE	tinyint	IN	Process type
@PROSPECTSELECTIONID	uniqueidentifier	IN	Prospect selection
@SOURCEMANAGERID	uniqueidentifier	IN	Prospects assigned to
@DESTINATIONMANAGERID	uniqueidentifier	IN	Assign to
@INCLUDEPROSPECTMANAGERS	bit	IN	Transfer prospect manager assignments
@INCLUDEPRIMARYMANAGERS	bit	IN	Transfer primary manager assignments
@INCLUDESECONDARYMANAGERS	bit	IN	Transfer secondary manager assignments
@INCLUDESECONDARYSOLICITORS	bit	IN	Transfer secondary solicitor assignments
@INCLUDESTEPSANDINTERACTIONS	bit	IN	Transfer plan steps and interactions

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PROSPECTASSIGNMENTPROCESS
                    (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @CURRENTAPPUSERID uniqueidentifier = null,
                        @NAME nvarchar(100),
                        @DESCRIPTION nvarchar(255) = null,
                        @PROCESSTYPECODE tinyint,
                        @PROSPECTSELECTIONID uniqueidentifier = null,
                        @SOURCEMANAGERID uniqueidentifier = null,
                        @DESTINATIONMANAGERID uniqueidentifier = null,
                        @INCLUDEPROSPECTMANAGERS bit = null,
                        @INCLUDEPRIMARYMANAGERS bit = null,
                        @INCLUDESECONDARYMANAGERS bit = null,
                        @INCLUDESECONDARYSOLICITORS bit = null,
                        @INCLUDESTEPSANDINTERACTIONS bit = null
                    )
                    as

                    set nocount on;

                    if @ID is null
                        set @ID = newid()

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

                    declare @CURRENTDATE datetime = getdate()

                    begin try
                        insert into dbo.PROSPECTASSIGNMENTPROCESS
                        (
                            ID,
                            NAME,
                            DESCRIPTION,
                            PROCESSTYPECODE,
                            PROSPECTSELECTIONID,
                            SOURCEMANAGERID,
                            DESTINATIONMANAGERID,
                            INCLUDEPROSPECTMANAGERS,
                            INCLUDEPRIMARYMANAGERS,
                            INCLUDESECONDARYMANAGERS,
                            INCLUDESECONDARYSOLICITORS,
                            INCLUDESTEPSANDINTERACTIONS,
                            ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED
                        )
                        values
                        (
                            @ID,
                            @NAME, 
                            @DESCRIPTION, 
                            @PROCESSTYPECODE, 
                            @PROSPECTSELECTIONID,
                            @SOURCEMANAGERID,
                            @DESTINATIONMANAGERID,
                            @INCLUDEPROSPECTMANAGERS,
                            @INCLUDEPRIMARYMANAGERS,
                            @INCLUDESECONDARYMANAGERS,
                            @INCLUDESECONDARYSOLICITORS,
                            @INCLUDESTEPSANDINTERACTIONS,
                            @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE
                        )

                        exec dbo.USP_BUSINESSPROCESSINSTANCE_ADD 
                            @CHANGEAGENTID = @CHANGEAGENTID, 
                            @BUSINESSPROCESSCATALOGID = '49B35224-EED4-499A-9F8D-AF1E40D01BD1',
                            @BUSINESSPROCESSPARAMETERSETID = @ID, 
                            @OWNERID = @CURRENTAPPUSERID;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1
                    end catch

                    return 0