USP_MKTSPONSORSHIPRECORDSOURCE_EDITSAVE_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@QUERYVIEWCATALOGID	uniqueidentifier	IN
@CHILDIDFIELD	nvarchar(255)	IN
@CHILDPROGRAMIDFIELD	nvarchar(255)	IN
@ISGIFTFIELD	nvarchar(255)	IN
@LASTACTIONFIELD	nvarchar(255)	IN
@LASTACTIONREASONIDFIELD	nvarchar(255)	IN
@LOCATIONIDFIELD	nvarchar(255)	IN
@PROJECTIDFIELD	nvarchar(255)	IN
@PROJECTPROGRAMIDFIELD	nvarchar(255)	IN
@SPONSORIDFIELD	nvarchar(255)	IN
@SYSTEMIDFIELD	nvarchar(255)	IN

Definition

Copy



create procedure dbo.[USP_MKTSPONSORSHIPRECORDSOURCE_EDITSAVE_2]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @QUERYVIEWCATALOGID uniqueidentifier,
  @CHILDIDFIELD nvarchar(255),
  @CHILDPROGRAMIDFIELD nvarchar(255),
  @ISGIFTFIELD nvarchar(255),
  @LASTACTIONFIELD nvarchar(255),
  @LASTACTIONREASONIDFIELD nvarchar(255),
  @LOCATIONIDFIELD nvarchar(255),
  @PROJECTIDFIELD nvarchar(255),
  @PROJECTPROGRAMIDFIELD nvarchar(255),
  @SPONSORIDFIELD nvarchar(255),
  @SYSTEMIDFIELD 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] = @SYSTEMIDFIELD,
        [SPONSORIDFIELD] = @SPONSORIDFIELD,
        [ACTIONFIELD] = @LASTACTIONFIELD,
        [REASONFIELD] = @LASTACTIONREASONIDFIELD ,
        [GIFTSPONSORSHIPFIELD] = @ISGIFTFIELD,
        [SPONSORSHIPOPPORTUNITYIDCHILDFIELD] = @CHILDIDFIELD,
        [SPONSORSHIPOPPORTUNITYIDPROJECTFIELD] = @PROJECTIDFIELD,
        [SPONSORSHIPCHILDPROGRAMIDFIELD] = @CHILDPROGRAMIDFIELD,
        [SPONSORSHIPPROJECTPROGRAMIDFIELD] = @PROJECTPROGRAMIDFIELD,
        [SPONSORSHIPLOCATIONIDFIELD] = @LOCATIONIDFIELD,
        [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,
        @SYSTEMIDFIELD,
        @SPONSORIDFIELD,
        @LASTACTIONFIELD,
        @LASTACTIONREASONIDFIELD,
        @ISGIFTFIELD,
        @CHILDIDFIELD,
        @PROJECTIDFIELD,
        @CHILDPROGRAMIDFIELD,
        @PROJECTPROGRAMIDFIELD,
        @LOCATIONIDFIELD,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CHANGEAGENTID,
        @CURRENTDATE
      );
  end try

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

  return 0;