USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPTRANSFERPROCESS

The save procedure used by the edit dataform template "Sponsorship Transfer Process Edit 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.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@SPONSORSHIPPROGRAMID	uniqueidentifier	IN	Program
@SPONSORSHIPLOCATIONID	uniqueidentifier	IN	Location
@SPROPPAGERANGEID	uniqueidentifier	IN	Age range
@GENDERCODE	int	IN	Gender
@ISHIVPOSITIVECODE	int	IN	HIV positive
@HASCONDITIONCODE	int	IN	Disability/Illness
@ISORPHANEDCODE	int	IN	Orphaned
@SPROPPPROJECTCATEGORYCODEID	uniqueidentifier	IN	Category
@SPONSORPREFERENCECODE	int	IN	Preferences option
@SPONSORSHIPREASONID	uniqueidentifier	IN	Reason
@MATCHINGRULECODE	int	IN	Matching rule
@TRANSFERTYPECODE	int	IN	Transfer type
@CREATESOURCESPONSORSHIPSIDSET	bit	IN	Create selection of successfully transferred source sponsorships
@SOURCESELECTIONNAME	nvarchar(100)	IN	Selection name
@OVERWRITESOURCESELECTION	bit	IN	Overwrite existing selection
@CREATETARGETSPONSORSHIPSIDSET	bit	IN	Create selection of successfully transferred target sponsorships
@TARGETSELECTIONNAME	nvarchar(100)	IN	Selection name
@OVERWRITETARGETSELECTION	bit	IN	Overwrite existing selection
@CREATEUNSUCCESSFULSPONSORSHIPSIDSET	bit	IN	Create selection of sponsorships not successfully transferred
@UNSUCCESSFULSELECTIONNAME	nvarchar(100)	IN	Selection name
@OVERWRITEUNSUCCESSFULSELECTION	bit	IN	Overwrite existing selection

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPTRANSFERPROCESS
         (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @NAME nvarchar(100),
            @DESCRIPTION nvarchar(255),
            @IDSETREGISTERID uniqueidentifier,
          @SPONSORSHIPPROGRAMID uniqueidentifier,
          @SPONSORSHIPLOCATIONID uniqueidentifier,          
          @SPROPPAGERANGEID uniqueidentifier,
          @GENDERCODE int,
          @ISHIVPOSITIVECODE int,
          @HASCONDITIONCODE int,
          @ISORPHANEDCODE int,
          @SPROPPPROJECTCATEGORYCODEID uniqueidentifier ,
          @SPONSORPREFERENCECODE int,
          @SPONSORSHIPREASONID uniqueidentifier,
          @MATCHINGRULECODE int,
          @TRANSFERTYPECODE int,
            @CREATESOURCESPONSORSHIPSIDSET bit,
                  @SOURCESELECTIONNAME nvarchar(100), 
                  @OVERWRITESOURCESELECTION bit,
            @CREATETARGETSPONSORSHIPSIDSET bit,
                  @TARGETSELECTIONNAME nvarchar(100), 
                  @OVERWRITETARGETSELECTION bit,
            @CREATEUNSUCCESSFULSPONSORSHIPSIDSET bit,
                  @UNSUCCESSFULSELECTIONNAME nvarchar(100), 
                  @OVERWRITEUNSUCCESSFULSELECTION bit)
        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.SPONSORSHIPTRANSFERPROCESS set
                  NAME = @NAME,
                  DESCRIPTION = @DESCRIPTION,
                  IDSETREGISTERID = @IDSETREGISTERID,
            SPONSORSHIPPROGRAMID = @SPONSORSHIPPROGRAMID,
            SPONSORSHIPLOCATIONID = @SPONSORSHIPLOCATIONID,          
            SPROPPAGERANGEID = @SPROPPAGERANGEID,
            GENDERCODE= isnull(@GENDERCODE,0),
            ISHIVPOSITIVECODE= isnull(@ISHIVPOSITIVECODE,0),
            HASCONDITIONCODE= isnull(@HASCONDITIONCODE,0),
            ISORPHANEDCODE= isnull(@ISORPHANEDCODE,0),
            SPROPPPROJECTCATEGORYCODEID = @SPROPPPROJECTCATEGORYCODEID,
            SPONSORPREFERENCECODE = @SPONSORPREFERENCECODE,
            SPONSORSHIPREASONID = @SPONSORSHIPREASONID,
            MATCHINGRULECODE = @MATCHINGRULECODE,
            TRANSFERTYPECODE = @TRANSFERTYPECODE,
              CREATESOURCESPONSORSHIPSIDSET = @CREATESOURCESPONSORSHIPSIDSET,
                    SOURCESELECTIONNAME = @SOURCESELECTIONNAME, 
                    OVERWRITESOURCESELECTION = @OVERWRITESOURCESELECTION,
              CREATETARGETSPONSORSHIPSIDSET = @CREATETARGETSPONSORSHIPSIDSET,
                    TARGETSELECTIONNAME = @TARGETSELECTIONNAME, 
                    OVERWRITETARGETSELECTION = @OVERWRITETARGETSELECTION,
              CREATEUNSUCCESSFULSPONSORSHIPSIDSET = @CREATEUNSUCCESSFULSPONSORSHIPSIDSET,
                    UNSUCCESSFULSELECTIONNAME = @UNSUCCESSFULSELECTIONNAME, 
                    OVERWRITEUNSUCCESSFULSELECTION = @OVERWRITEUNSUCCESSFULSELECTION,                
                  CHANGEDBYID = @CHANGEAGENTID,
                  DATECHANGED = @CURRENTDATE
              where 
                  ID = @ID
          end try
          begin catch
              exec dbo.USP_RAISE_ERROR
              return 1
          end catch

        return 0;