USP_MKTSPONSORSHIPRECORDSOURCE_EDITSAVE

Saves information for a sponsorship record source.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@QUERYVIEWCATALOGID	uniqueidentifier	IN
@SPONSORSHIPSYSTEMIDFIELD	nvarchar(255)	IN
@SPONSORIDFIELD	nvarchar(255)	IN
@ACTIONFIELD	nvarchar(255)	IN
@REASONFIELD	nvarchar(255)	IN
@GIFTSPONSORSHIPFIELD	nvarchar(255)	IN
@SPONSORSHIPOPPORTUNITYIDCHILDFIELD	nvarchar(255)	IN
@SPONSORSHIPOPPORTUNITYIDPROJECTFIELD	nvarchar(255)	IN
@SPONSORSHIPCHILDPROGRAMIDFIELD	nvarchar(255)	IN
@SPONSORSHIPPROJECTPROGRAMIDFIELD	nvarchar(255)	IN
@SPONSORSHIPLOCATIONIDFIELD	nvarchar(255)	IN

Definition

Copy



CREATE procedure dbo.[USP_MKTSPONSORSHIPRECORDSOURCE_EDITSAVE]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @QUERYVIEWCATALOGID uniqueidentifier,
  @SPONSORSHIPSYSTEMIDFIELD nvarchar(255),
  @SPONSORIDFIELD nvarchar(255),
  @ACTIONFIELD nvarchar(255),
  @REASONFIELD nvarchar(255),
  @GIFTSPONSORSHIPFIELD nvarchar(255),
  @SPONSORSHIPOPPORTUNITYIDCHILDFIELD nvarchar(255),
  @SPONSORSHIPOPPORTUNITYIDPROJECTFIELD nvarchar(255),
  @SPONSORSHIPCHILDPROGRAMIDFIELD nvarchar(255),
  @SPONSORSHIPPROJECTPROGRAMIDFIELD nvarchar(255),
  @SPONSORSHIPLOCATIONIDFIELD nvarchar(255)
)
as
  set nocount on;

  declare @CURRENTDATE datetime;

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

    set @CURRENTDATE = getdate();

    if exists (select 1 from dbo.[MKTSPONSORSHIPRECORDSOURCE] where [ID] = @ID)
      update dbo.[MKTSPONSORSHIPRECORDSOURCE] set
        [QUERYVIEWCATALOGID] = @QUERYVIEWCATALOGID,
        [SPONSORSHIPSYSTEMIDFIELD] = @SPONSORSHIPSYSTEMIDFIELD,
        [SPONSORIDFIELD] = @SPONSORIDFIELD,
        [ACTIONFIELD] =@ACTIONFIELD,
        [REASONFIELD]=  @REASONFIELD ,
        [GIFTSPONSORSHIPFIELD] = @GIFTSPONSORSHIPFIELD,
        [SPONSORSHIPOPPORTUNITYIDCHILDFIELD] = @SPONSORSHIPOPPORTUNITYIDCHILDFIELD,
        [SPONSORSHIPOPPORTUNITYIDPROJECTFIELD] = @SPONSORSHIPOPPORTUNITYIDPROJECTFIELD  ,
        [SPONSORSHIPCHILDPROGRAMIDFIELD]= @SPONSORSHIPCHILDPROGRAMIDFIELD,
        [SPONSORSHIPPROJECTPROGRAMIDFIELD]=  @SPONSORSHIPPROJECTPROGRAMIDFIELD,
        [SPONSORSHIPLOCATIONIDFIELD] = @SPONSORSHIPLOCATIONIDFIELD,
        [CHANGEDBYID] = @CHANGEAGENTID,
        [DATECHANGED] = @CURRENTDATE
      where [ID] = @ID;
    else
      insert into dbo.[MKTSPONSORSHIPRECORDSOURCE] (
        [ID],
        [QUERYVIEWCATALOGID],
        [SPONSORSHIPSYSTEMIDFIELD],
        [SPONSORIDFIELD],
        [ACTIONFIELD],
        [REASONFIELD],
        [GIFTSPONSORSHIPFIELD],
        [SPONSORSHIPOPPORTUNITYIDCHILDFIELD],
        [SPONSORSHIPOPPORTUNITYIDPROJECTFIELD],
        [SPONSORSHIPCHILDPROGRAMIDFIELD],
        [SPONSORSHIPPROJECTPROGRAMIDFIELD],
        [SPONSORSHIPLOCATIONIDFIELD],
        [ADDEDBYID],
        [DATEADDED],
        [CHANGEDBYID],
        [DATECHANGED]
      ) values (
        @ID,
        @QUERYVIEWCATALOGID,
        @SPONSORSHIPSYSTEMIDFIELD,
        @SPONSORIDFIELD,
        @ACTIONFIELD,
        @REASONFIELD ,
        @GIFTSPONSORSHIPFIELD,
        @SPONSORSHIPOPPORTUNITYIDCHILDFIELD,
        @SPONSORSHIPOPPORTUNITYIDPROJECTFIELD  ,
        @SPONSORSHIPCHILDPROGRAMIDFIELD,
        @SPONSORSHIPPROJECTPROGRAMIDFIELD,
        @SPONSORSHIPLOCATIONIDFIELD,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CHANGEAGENTID,
        @CURRENTDATE
      );
  end try

  begin catch
    exec dbo.[USP_RAISE_ERROR];
    return 1;
  end catch

  return 0;