USP_CUSTOMFORMENTRY_ADDUPDATE

Parameters

Parameter	Parameter Type	Mode
@ID	int	IN
@EntryID	uniqueidentifier	IN
@FormGuid	uniqueidentifier	IN
@ClientUserID	int	IN
@EntryData	xml	IN
@EntryAlias	nvarchar(100)	IN
@EntryState	int	IN
@Printed	bit	IN
@ClientSitesID	int	IN
@PaymentReviewed	tinyint	IN

Definition

Copy



        create procedure dbo.USP_CUSTOMFORMENTRY_ADDUPDATE
        @ID                 int,            
        @EntryID         uniqueidentifier,
        @FormGuid         uniqueidentifier,
        @ClientUserID     int,
        @EntryData         xml,
        @EntryAlias         nvarchar(100),
        @EntryState      int, 
        @Printed         bit,
        @ClientSitesID     int,
        @PaymentReviewed tinyint
        as
        begin transaction
          update dbo.CustomFormEntry
          set
            [EntryID] = @EntryID,
            [FormGuid] = @FormGuid,
            [ClientUserID] = @ClientUserID,
            [EntryData] = @EntryData,
            [EntryAlias] = @EntryAlias,
            [EntryState] = @EntryState, 
            [Printed] = @Printed,
            [ClientSitesID] = @ClientSitesID,
            [PaymentReviewed] = @PaymentReviewed
          where [EntryID] = @EntryID or [ID] = @ID

          if @@rowcount = 0
          begin
              insert into dbo.CustomFormEntry
              (
                [EntryID],
                [FormGuid],
                [ClientUserID],
                [EntryData],
                [EntryAlias],
                [EntryState],
                [Printed],
                [ClientSitesID],
                [PaymentReviewed]
              )
              values
              (
                @EntryID,
                @FormGuid,
                @ClientUserID,
                @EntryData,
                @EntryAlias,
                @EntryState,
                @Printed,
                @ClientSitesID,
                @PaymentReviewed
              )
          end
        commit transaction