USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIPCONFIGURATION_2

The save procedure used by the edit dataform template "Relationship Configuration 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.
@RELATIONSHIP	nvarchar(200)	IN	Relationship
@GENDERCODE	tinyint	IN	Gender
@APPLIESTOINDIVIDUALS	bit	IN	Individuals
@APPLIESTOORGANIZATIONS	bit	IN	Organizations
@APPLIESTOGROUPS	bit	IN	Groups/Households
@APPLIESTOSTUDENTS	bit	IN	Students
@RELATESTOINDIVIDUALS	bit	IN	Individuals
@RELATESTOORGANIZATIONS	bit	IN	Organizations
@RELATESTOGROUPS	bit	IN	Groups/Households
@RELATESTOSTUDENTS	bit	IN	Students
@ISEMPLOYEERELATIONSHIP	bit	IN	Is employee relationship type
@ISPEERRELATIONSHIPTYPE	bit	IN	Is corporate peer relationship type

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIPCONFIGURATION_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @RELATIONSHIP nvarchar(200),
    @GENDERCODE tinyint,
    @APPLIESTOINDIVIDUALS bit,
    @APPLIESTOORGANIZATIONS bit,
    @APPLIESTOGROUPS bit,
    @APPLIESTOSTUDENTS bit,
    @RELATESTOINDIVIDUALS bit,
    @RELATESTOORGANIZATIONS bit,
    @RELATESTOGROUPS bit,
    @RELATESTOSTUDENTS bit,
    @ISEMPLOYEERELATIONSHIP bit,
    @ISPEERRELATIONSHIPTYPE bit
)
as
    set nocount on;

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

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

    begin try
        --Update code table entry

        update dbo.RELATIONSHIPTYPECODE set
            DESCRIPTION = @RELATIONSHIP,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where ID = @ID

        --Update configuration

        if exists(select ID from dbo.RELATIONSHIPCONFIGURATION where ID = @ID)
            update dbo.RELATIONSHIPCONFIGURATION set
                GENDERCODE = @GENDERCODE,
                APPLIESTOINDIVIDUALS = @APPLIESTOINDIVIDUALS,
                APPLIESTOORGANIZATIONS = @APPLIESTOORGANIZATIONS,
                APPLIESTOGROUPS = @APPLIESTOGROUPS,
                APPLIESTOSTUDENTS = @APPLIESTOSTUDENTS,
                RELATESTOINDIVIDUALS = @RELATESTOINDIVIDUALS,
                RELATESTOORGANIZATIONS = @RELATESTOORGANIZATIONS,
                RELATESTOGROUPS = @RELATESTOGROUPS,
                RELATESTOSTUDENTS = @RELATESTOSTUDENTS,
                ISPEERRELATIONSHIPTYPE = @ISPEERRELATIONSHIPTYPE,
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = @CURRENTDATE
            where ID = @ID

        else
            insert into dbo.RELATIONSHIPCONFIGURATION
            (
                ID,
                GENDERCODE,
                APPLIESTOINDIVIDUALS,
                APPLIESTOORGANIZATIONS,
                APPLIESTOGROUPS,
                APPLIESTOSTUDENTS,
                RELATESTOINDIVIDUALS,
                RELATESTOORGANIZATIONS,
                RELATESTOGROUPS,
                RELATESTOSTUDENTS,
                ISPEERRELATIONSHIPTYPE,
                ADDEDBYID,
                CHANGEDBYID,
                DATEADDED,
                DATECHANGED
            )
            values
            (
                @ID,
                @GENDERCODE,
                @APPLIESTOINDIVIDUALS,
                @APPLIESTOORGANIZATIONS,
                @APPLIESTOGROUPS,
                @APPLIESTOSTUDENTS,
                @RELATESTOINDIVIDUALS,
                @RELATESTOORGANIZATIONS,
                @RELATESTOGROUPS,
                @RELATESTOSTUDENTS,
                @ISPEERRELATIONSHIPTYPE,
                @CHANGEAGENTID,
                @CHANGEAGENTID,
                @CURRENTDATE,
                @CURRENTDATE
            )



    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;