USP_DATAFORMTEMPLATE_EDIT_MARRIAGEADDITIONALRELATIONSHIP

The save procedure used by the edit dataform template "Marriage Additional Relationship Edit Data 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.
@SPOUSERELATIONSHIPTYPECODEID	uniqueidentifier	IN	If one spouse has a
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN	They become the
@MARRIAGEADDITIONALRELATIONSHIPASSOCIATIONS	xml	IN	For existing relationships on the other spouse

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MARRIAGEADDITIONALRELATIONSHIP
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @SPOUSERELATIONSHIPTYPECODEID uniqueidentifier,
  @RELATIONSHIPTYPECODEID uniqueidentifier,
  @MARRIAGEADDITIONALRELATIONSHIPASSOCIATIONS xml
)
as

  set nocount on;

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

  declare @CURRENTDATE datetime
  set @CURRENTDATE = getdate()

  begin try
    update dbo.MARRIAGEADDITIONALRELATIONSHIP set
      SPOUSERELATIONSHIPTYPECODEID = @SPOUSERELATIONSHIPTYPECODEID,
      RELATIONSHIPTYPECODEID = @RELATIONSHIPTYPECODEID,
      CHANGEDBYID = @CHANGEAGENTID,
      DATECHANGED = @CURRENTDATE
    where ID = @ID;

    exec dbo.USP_MARRIAGEADDITIONALRELATIONSHIP_GETASSOCIATIONS_UPDATEFROMXML @ID, @MARRIAGEADDITIONALRELATIONSHIPASSOCIATIONS, @CHANGEAGENTID, @CURRENTDATE;    
  end try
  begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
  end catch

return 0;