USP_DATAFORMTEMPLATE_EDITSAVE_WPBIOGRAPHICAL

The save procedure used by the edit dataform template "WealthPoint Biographical 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.
@SOURCE	nvarchar(100)	IN	Source
@FULLNAME	nvarchar(100)	IN	Name
@LINE1	nvarchar(4000)	IN	Address
@CITY	nvarchar(4000)	IN	City
@STATE	nvarchar(4000)	IN	State
@ZIP	nvarchar(50)	IN	ZIP
@A2LINE1	nvarchar(4000)	IN	Address
@A2CITY	nvarchar(4000)	IN	City
@A2STATE	nvarchar(4000)	IN	State
@A2ZIP	nvarchar(50)	IN	ZIP
@GENDERCODE	nvarchar(6)	IN	Gender
@BIRTHDATE	datetime	IN	Birth date
@CNOTES	nvarchar(1024)	IN	Notes
@BIRTHPLACE	nvarchar(120)	IN	Birthplace
@DECEASEDDATE	UDT_FUZZYDATE	IN	Deceased date
@OCCUPATION	nvarchar(4000)	IN	Occupation
@EDUCATION	nvarchar(max)	IN	Education
@FAMILY	nvarchar(max)	IN	Family
@POSITIONSHELD	nvarchar(max)	IN	Positions held
@CERTIFICATIONS	nvarchar(max)	IN	Certifications
@CAREER	nvarchar(max)	IN	Career
@AWARDS	nvarchar(max)	IN	Awards
@MEMBERSHIPS	nvarchar(max)	IN	Memberships
@RESEARCHINTERESTS	nvarchar(max)	IN	Avocations/ Research/ Interests
@POLITICALRELIGIOUSAFFILIATIONS	nvarchar(max)	IN	Political/Religious affiliations
@CIVICMILITARYSERVICE	nvarchar(max)	IN	Civic/Military service
@THOUGHTSONLIFE	nvarchar(max)	IN	Thoughts on life
@LAW	nvarchar(max)	IN	Law
@PERSONAL	nvarchar(max)	IN	Personal

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_WPBIOGRAPHICAL (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @SOURCE nvarchar(100),
                        @FULLNAME nvarchar(100),
                        @LINE1 nvarchar(4000),
                        @CITY nvarchar(4000),
                        @STATE nvarchar(4000),
                        @ZIP nvarchar(50),
                        @A2LINE1 nvarchar(4000),
                        @A2CITY nvarchar(4000),
                        @A2STATE nvarchar(4000),
                        @A2ZIP nvarchar(50),
                        @GENDERCODE nvarchar(6),
                        @BIRTHDATE datetime,
                        @CNOTES nvarchar(1024),
                        @BIRTHPLACE nvarchar(120),
                        @DECEASEDDATE dbo.UDT_FUZZYDATE,
                        @OCCUPATION nvarchar(4000),
                        @EDUCATION nvarchar(max),
                        @FAMILY nvarchar(max),
                        @POSITIONSHELD nvarchar(max),
                        @CERTIFICATIONS nvarchar(max),
                        @CAREER nvarchar(max),
                        @AWARDS nvarchar(max),
                        @MEMBERSHIPS nvarchar(max),
                        @RESEARCHINTERESTS nvarchar(max),
                        @POLITICALRELIGIOUSAFFILIATIONS nvarchar(max),
                        @CIVICMILITARYSERVICE nvarchar(max),
                        @THOUGHTSONLIFE nvarchar(max),
                        @LAW nvarchar(max),
                        @PERSONAL nvarchar(max)
                    ) as begin

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

                        update dbo.WPBIOGRAPHICAL set
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = getdate(),
                            SOURCE = @SOURCE,
                            FULLNAME = @FULLNAME,
                            LINE1 = @LINE1,
                            CITY = @CITY,
                            STATE = @STATE,
                            ZIP = @ZIP,
                            A2LINE1 = @A2LINE1,
                            A2CITY = @A2CITY,
                            A2STATE = @A2STATE,
                            A2ZIP = @A2ZIP,
                            GENDERCODE = @GENDERCODE,
                            BIRTHDATE = @BIRTHDATE,
                            CNOTES = @CNOTES,
                            BIRTHPLACE = @BIRTHPLACE,
                            DECEASEDDATE = @DECEASEDDATE,
                            OCCUPATION = @OCCUPATION,
                            EDUCATION = @EDUCATION,
                            FAMILY = @FAMILY,
                            POSITIONSHELD = @POSITIONSHELD,
                            CERTIFICATIONS = @CERTIFICATIONS,
                            CAREER = @CAREER,
                            AWARDS = @AWARDS,
                            MEMBERSHIPS = @MEMBERSHIPS,
                            RESEARCHINTERESTS = @RESEARCHINTERESTS,
                            POLITICALRELIGIOUSAFFILIATIONS = @POLITICALRELIGIOUSAFFILIATIONS,
                            CIVICMILITARYSERVICE = @CIVICMILITARYSERVICE,
                            THOUGHTSONLIFE = @THOUGHTSONLIFE,
                            LAW = @LAW,
                            PERSONAL = @PERSONAL
                        where
                            ID=@ID;

                        if    (select
                                count(WEALTHSOURCE.SOURCE)
                            from
                                dbo.WEALTHSOURCE
                            where
                                WEALTHSOURCE.SOURCE = @SOURCE
                            ) = 0
                            begin
                                insert into dbo.WEALTHSOURCE (
                                    [SOURCE],
                                    [ISBUILTIN],
                                    [ADDEDBYID],
                                    [CHANGEDBYID]
                                )values(
                                    @SOURCE,
                                    0,
                                    @CHANGEAGENTID,
                                    @CHANGEAGENTID
                                );
                            end    

                        declare @WEALTHID uniqueidentifier;
                        select @WEALTHID=WEALTHID from dbo.WPBIOGRAPHICAL where ID=@ID;

                        exec dbo.USP_WEALTHPOINT_UPDATEWEALTHSUMMARY_BIOGRAPHICAL @WEALTHID, @CHANGEAGENTID;

                        return 0;

                    end;