USP_GIFTAIDDISQUALIFICATION_BY_ATTRIBUTE_EDIT

Edit

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CODETABLEVALUE	uniqueidentifier	IN
@CURRENCYVALUE	money	IN
@CONSTITUENTID	uniqueidentifier	IN
@DATEVALUE	datetime	IN
@FUZZYDATEVALUE	UDT_FUZZYDATE	IN
@MEMOVALUE	nvarchar(max)	IN
@NUMBERVALUE	int	IN
@TEXTVALUE	nvarchar(255)	IN
@HOURMINUTEVALUE	UDT_HOURMINUTE	IN
@BOOLEANVALUE	tinyint	IN
@ATTRIBUTECATEGORYID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@DATATYPE	smallint	IN

Definition

Copy



            CREATE procedure [dbo].[USP_GIFTAIDDISQUALIFICATION_BY_ATTRIBUTE_EDIT]
      (
        @ID uniqueidentifier = null,
        @CODETABLEVALUE uniqueidentifier = null,
        @CURRENCYVALUE money = 0,
        @CONSTITUENTID uniqueidentifier = null,
        @DATEVALUE datetime = null,
        @FUZZYDATEVALUE dbo.UDT_FUZZYDATE = '00000000',
        @MEMOVALUE nvarchar(max) = '',
        @NUMBERVALUE int = 0,
        @TEXTVALUE nvarchar(255) = '',
        @HOURMINUTEVALUE dbo.UDT_HOURMINUTE = '',
        @BOOLEANVALUE tinyint = 0,
        @ATTRIBUTECATEGORYID uniqueidentifier = null,
        @CHANGEAGENTID uniqueidentifier = null,
        @DATATYPE smallint = 0
      )
      as
          set nocount off

          declare @CURRENTDATE datetime
          set @CURRENTDATE = getdate()

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

              update 
                  dbo.[GIFTAIDDISQUALIFIEDBYATTRIBUTE]
              set 
            ID = @ID,
            CODETABLEVALUE = @CODETABLEVALUE,
            CURRENCYVALUE = @CURRENCYVALUE,
            CONSTITUENTID = @CONSTITUENTID,
            DATEVALUE = @DATEVALUE,
            FUZZYDATEVALUE = @FUZZYDATEVALUE,
            MEMOVALUE = @MEMOVALUE,
            NUMBERVALUE = @NUMBERVALUE,
            TEXTVALUE = @TEXTVALUE,
            HOURMINUTEVALUE = @HOURMINUTEVALUE,
            BOOLEANVALUE = @BOOLEANVALUE,
            ATTRIBUTECATEGORYID = @ATTRIBUTECATEGORYID,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE,
            DATATYPE = @DATATYPE
              where 
                  ID = @ID                            
          end try

          begin catch
              exec dbo.USP_RAISE_ERROR
              return 1
          end catch

          return 0;