USP_ADDUPDATE_CONSENTTRANSACTIONSTATUS

create procedure dbo.USP_ADDUPDATE_CONSENTTRANSACTIONSTATUS
(
@TRANSACTIONID int,
@TRANSACTIONGUIDID uniqueidentifier,
@CONSENTUPDATE bit,
@CONSENT xml = null
)
as

begin
    begin
    declare @CHANGEAGENTID UNIQUEIDENTIFIER;
   exec dbo.Usp_changeagent_getorcreatechangeagent @CHANGEAGENTID OUTPUT;

   declare @DATE datetime
   set @DATE = Getdate()

   If exists(select 1 from CONSENTTRANSACTIONSTATUS where TRANSACTIONGUIDID = @TRANSACTIONGUIDID)
      update CONSENTTRANSACTIONSTATUS
        set CONSENTUPDATE = @CONSENTUPDATE,
            [CHANGEDBYID] = @CHANGEAGENTID,
            [DATECHANGED] = @DATE
            where TRANSACTIONID = @TRANSACTIONID and TRANSACTIONGUIDID = @TRANSACTIONGUIDID
   else
    insert into CONSENTTRANSACTIONSTATUS (
            [TRANSACTIONID],
          [TRANSACTIONGUIDID],
            [CONSENTUPDATE],
            [ADDEDBYID],
                [CHANGEDBYID],
                [DATEADDED],
                [DATECHANGED],
          [CONSENT]
            )
      values 
      (
                @TRANSACTIONID,
          @TRANSACTIONGUIDID,
                @CONSENTUPDATE ,
                @CHANGEAGENTID,
                @CHANGEAGENTID,
                @DATE,
                @DATE,
          @CONSENT
            )

end
end