USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP

The save procedure used by the edit dataform template "NetCommunity Default Code Map Edit Form".

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.
@BUSINESSPHONECODEID	uniqueidentifier	IN	Business phone
@FAXPHONECODEID	uniqueidentifier	IN	Fax phone
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Spouse relationship
@PRIMARYBUSINESSRELATIONSHIPTYPECODEID	uniqueidentifier	IN	Primary business relationship
@PRIMARYBUSINESSRECIPROCALTYPECODEID	uniqueidentifier	IN	Primary business reciprocal
@BUSINESSADDRESSTYPECODEID	uniqueidentifier	IN	Business address type
@MGCONDITIONTYPECODEID	uniqueidentifier	IN	Matching gift condition type
@REVENUENOTETYPECODEID	uniqueidentifier	IN	Donation user-entered note type
@CONSTITUENTLINKPAGEID	uniqueidentifier	IN	Constituent link page

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @BUSINESSPHONECODEID uniqueidentifier,
                    @FAXPHONECODEID uniqueidentifier,
                    @RELATIONSHIPTYPECODEID uniqueidentifier,
                    @PRIMARYBUSINESSRELATIONSHIPTYPECODEID uniqueidentifier,
                    @PRIMARYBUSINESSRECIPROCALTYPECODEID uniqueidentifier,
                    @BUSINESSADDRESSTYPECODEID uniqueidentifier,
                    @MGCONDITIONTYPECODEID uniqueidentifier,
                    @REVENUENOTETYPECODEID uniqueidentifier,
                    @CONSTITUENTLINKPAGEID uniqueidentifier
                )
                as
                    set nocount on;

                    declare @CURRENTDATE datetime;

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

                    set @CURRENTDATE = getdate();

                    begin try
                        if not exists (select ID from dbo.NETCOMMUNITYDEFAULTCODEMAP where ID=@ID)
                            insert into dbo.NETCOMMUNITYDEFAULTCODEMAP
                            (
                                ID,
                                BUSINESSPHONECODEID,
                                FAXPHONECODEID,
                                RELATIONSHIPTYPECODEID,
                                PRIMARYBUSINESSRELATIONSHIPTYPECODEID,
                                PRIMARYBUSINESSRECIPROCALTYPECODEID,
                                BUSINESSADDRESSTYPECODEID,
                                MGCONDITIONTYPECODEID,
                                REVENUENOTETYPECODEID,
                                CONSTITUENTLINKPAGEID,
                                ADDEDBYID,
                                CHANGEDBYID,
                                DATEADDED,
                                DATECHANGED
                            )
                            values
                            (
                                @ID,
                                @BUSINESSPHONECODEID,
                                @FAXPHONECODEID,
                                @RELATIONSHIPTYPECODEID,
                                @PRIMARYBUSINESSRELATIONSHIPTYPECODEID,
                                @PRIMARYBUSINESSRECIPROCALTYPECODEID,
                                @BUSINESSADDRESSTYPECODEID,
                                @MGCONDITIONTYPECODEID,
                                @REVENUENOTETYPECODEID,
                                @CONSTITUENTLINKPAGEID,
                                @CHANGEAGENTID,
                                @CHANGEAGENTID,
                                @CURRENTDATE,
                                @CURRENTDATE
                            );
                        else
                            update 
                                dbo.[NETCOMMUNITYDEFAULTCODEMAP]
                            set
                                [BUSINESSPHONECODEID] = @BUSINESSPHONECODEID,
                                [FAXPHONECODEID] = @FAXPHONECODEID,
                                [RELATIONSHIPTYPECODEID] = @RELATIONSHIPTYPECODEID,
                                [PRIMARYBUSINESSRELATIONSHIPTYPECODEID] = @PRIMARYBUSINESSRELATIONSHIPTYPECODEID,
                                [PRIMARYBUSINESSRECIPROCALTYPECODEID] = @PRIMARYBUSINESSRECIPROCALTYPECODEID,
                                [BUSINESSADDRESSTYPECODEID] = @BUSINESSADDRESSTYPECODEID,
                                [MGCONDITIONTYPECODEID] = @MGCONDITIONTYPECODEID,
                                [REVENUENOTETYPECODEID] = @REVENUENOTETYPECODEID,
                                [CONSTITUENTLINKPAGEID] = @CONSTITUENTLINKPAGEID,
                                [DATECHANGED] = @CURRENTDATE,
                                [CHANGEDBYID] = @CHANGEAGENTID
                            where 
                                [NETCOMMUNITYDEFAULTCODEMAP].ID = @ID;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;