USP_DATAFORMTEMPLATE_EDIT_MARRIAGERELATIONSHIP

The save procedure used by the edit dataform template "Marriage 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.
@SPOUSEGENDERCODE	tinyint	IN	A new spouse with gender
@SPOUSERELATIONSHIPTYPECODEID	uniqueidentifier	IN	Becomes the
@MARRIAGERELATIONSHIPASSOCIATIONS	xml	IN	For existing relationships on one spouse

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MARRIAGERELATIONSHIP (
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @SPOUSEGENDERCODE tinyint,
  @SPOUSERELATIONSHIPTYPECODEID uniqueidentifier,
  @MARRIAGERELATIONSHIPASSOCIATIONS 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.MARRIAGERELATIONSHIP set
      SPOUSEGENDERCODE = @SPOUSEGENDERCODE,
      SPOUSERELATIONSHIPTYPECODEID = @SPOUSERELATIONSHIPTYPECODEID,
      CHANGEDBYID = @CHANGEAGENTID,
      DATECHANGED = @CURRENTDATE
    where ID = @ID;

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

return 0;