USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_1_1

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

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 type
@SPOUSEREMOVEDRELATIONSHIPTYPECODEID	uniqueidentifier	IN	Removed spouse relationship type
@PRIMARYBUSINESSRELATIONSHIPTYPECODEID	uniqueidentifier	IN	Organization relationship type
@PRIMARYBUSINESSRECIPROCALTYPECODEID	uniqueidentifier	IN	Individual relationship type
@PRIMARYADDRESSTYPECODEID	uniqueidentifier	IN	Primary address type
@BUSINESSADDRESSTYPECODEID	uniqueidentifier	IN	Business address type
@ORGANIZATIONPRIMARYADDRESSTYPECODEID	uniqueidentifier	IN	Organization primary address type
@MGCONDITIONTYPECODEID	uniqueidentifier	IN	Matching gift condition type
@REVENUENOTETYPECODEID	uniqueidentifier	IN	Donation note type
@CONSTITUENTLINKPAGEID	uniqueidentifier	IN	NetCommunity link page
@CONTACTTYPECODEID	uniqueidentifier	IN	Contact relationship type
@CHANNELCODEID	uniqueidentifier	IN	Channel
@MGALIASTYPECODEID	uniqueidentifier	IN	Matchfinder Online alias type

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_1_1
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @BUSINESSPHONECODEID uniqueidentifier,
                    @FAXPHONECODEID uniqueidentifier,
                    @RELATIONSHIPTYPECODEID uniqueidentifier,
                    @SPOUSEREMOVEDRELATIONSHIPTYPECODEID uniqueidentifier,
                    @PRIMARYBUSINESSRELATIONSHIPTYPECODEID uniqueidentifier,
                    @PRIMARYBUSINESSRECIPROCALTYPECODEID uniqueidentifier,
                    @PRIMARYADDRESSTYPECODEID uniqueidentifier,
                    @BUSINESSADDRESSTYPECODEID uniqueidentifier,
                    @ORGANIZATIONPRIMARYADDRESSTYPECODEID uniqueidentifier,
                    @MGCONDITIONTYPECODEID uniqueidentifier,
                    @REVENUENOTETYPECODEID uniqueidentifier,
                    @CONSTITUENTLINKPAGEID uniqueidentifier,
                    @CONTACTTYPECODEID uniqueidentifier,
                    @CHANNELCODEID uniqueidentifier,
                    @MGALIASTYPECODEID 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,
                                SPOUSEREMOVEDRELATIONSHIPTYPECODEID,
                                PRIMARYBUSINESSRELATIONSHIPTYPECODEID,
                                PRIMARYBUSINESSRECIPROCALTYPECODEID,
                                PRIMARYADDRESSTYPECODEID,
                                BUSINESSADDRESSTYPECODEID,
                                ORGANIZATIONPRIMARYADDRESSTYPECODEID,
                                MGCONDITIONTYPECODEID,
                                REVENUENOTETYPECODEID,
                                CONSTITUENTLINKPAGEID,
                                CONTACTTYPECODEID,
                                CHANNELCODEID,
                                MGALIASTYPECODEID,
                                ADDEDBYID,
                                CHANGEDBYID,
                                DATEADDED,
                                DATECHANGED
                            )
                            values
                            (
                                @ID,
                                @BUSINESSPHONECODEID,
                                @FAXPHONECODEID,
                                @RELATIONSHIPTYPECODEID,
                                @SPOUSEREMOVEDRELATIONSHIPTYPECODEID,
                                @PRIMARYBUSINESSRELATIONSHIPTYPECODEID,
                                @PRIMARYBUSINESSRECIPROCALTYPECODEID,
                                @PRIMARYADDRESSTYPECODEID,
                                @BUSINESSADDRESSTYPECODEID,
                                @ORGANIZATIONPRIMARYADDRESSTYPECODEID,
                                @MGCONDITIONTYPECODEID,
                                @REVENUENOTETYPECODEID,
                                @CONSTITUENTLINKPAGEID,
                                @CONTACTTYPECODEID,
                                @CHANNELCODEID,
                                @MGALIASTYPECODEID,
                                @CHANGEAGENTID,
                                @CHANGEAGENTID,
                                @CURRENTDATE,
                                @CURRENTDATE
                            );
                        else
                            update 
                                dbo.[NETCOMMUNITYDEFAULTCODEMAP]
                            set
                                [BUSINESSPHONECODEID] = @BUSINESSPHONECODEID,
                                [FAXPHONECODEID] = @FAXPHONECODEID,
                                [RELATIONSHIPTYPECODEID] = @RELATIONSHIPTYPECODEID,
                                [SPOUSEREMOVEDRELATIONSHIPTYPECODEID] = @SPOUSEREMOVEDRELATIONSHIPTYPECODEID,
                                [PRIMARYBUSINESSRELATIONSHIPTYPECODEID] = @PRIMARYBUSINESSRELATIONSHIPTYPECODEID,
                                [PRIMARYBUSINESSRECIPROCALTYPECODEID] = @PRIMARYBUSINESSRECIPROCALTYPECODEID,
                                [PRIMARYADDRESSTYPECODEID] = @PRIMARYADDRESSTYPECODEID,
                                [BUSINESSADDRESSTYPECODEID] = @BUSINESSADDRESSTYPECODEID,
                                [ORGANIZATIONPRIMARYADDRESSTYPECODEID] = @ORGANIZATIONPRIMARYADDRESSTYPECODEID,
                                [MGCONDITIONTYPECODEID] = @MGCONDITIONTYPECODEID,
                                [REVENUENOTETYPECODEID] = @REVENUENOTETYPECODEID,
                                [CONSTITUENTLINKPAGEID] = @CONSTITUENTLINKPAGEID,
                                [CONTACTTYPECODEID] = @CONTACTTYPECODEID,
                                [CHANNELCODEID] = @CHANNELCODEID,
                                [MGALIASTYPECODEID] = @MGALIASTYPECODEID,
                                [DATECHANGED] = @CURRENTDATE,
                                [CHANGEDBYID] = @CHANGEAGENTID
                            where 
                                [NETCOMMUNITYDEFAULTCODEMAP].ID = @ID;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                      return 1;
                    end catch

                    return 0;