USP_DATAFORMTEMPLATE_EDIT_FAFNFGCampaignLevel

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@NFGCAMPAIGNID	uniqueidentifier	IN
@CONTACTID	uniqueidentifier	IN
@SITES	xml	IN
@FAFFRIENDLYURL	nvarchar(200)	IN
@TOTALREVENUEGOAL	money	IN
@DONORSGOAL	int	IN
@PARTICIPANTSGOAL	int	IN
@GROUPSGOAL	int	IN
@COMMUNICATIONSGOAL	int	IN
@NOTMATCH	bit	IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_FAFNFGCampaignLevel (
      @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
      @CHANGEAGENTID uniqueidentifier = null,
      @NAME nvarchar(100),
    @NFGCAMPAIGNID uniqueidentifier,
    @CONTACTID uniqueidentifier,
    @SITES xml,
    @FAFFRIENDLYURL nvarchar(200),
    @TOTALREVENUEGOAL money,
    @DONORSGOAL int,
    @PARTICIPANTSGOAL int,
    @GROUPSGOAL int,
    @COMMUNICATIONSGOAL int,
    @NOTMATCH bit
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

  if exists(select top 1 * from dbo.UFN_FAFPROGRAM_GETSITES_FROMITEMLISTXML(@SITES) SS where SS.SITEID not in (select SITEID from dbo.UFN_FAFNATIONALFUNDRAISINGGROUP_GETSITES (@NFGCAMPAIGNID)))
    raiserror('NotMatchSite',13,1)


    begin try
        -- handle updating the data
        update dbo.FAFNFGCAMPAIGNLEVEL set
            NAME = @NAME,
          NFGCAMPAIGNID = @NFGCAMPAIGNID,
          CONTACTID = @CONTACTID,
      TOTALREVENUEGOAL = @TOTALREVENUEGOAL,
      DONORSGOAL = @DONORSGOAL,
      PARTICIPANTSGOAL = @PARTICIPANTSGOAL,
      GROUPSGOAL = @GROUPSGOAL,
      COMMUNICATIONSGOAL = @COMMUNICATIONSGOAL,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where ID = @ID

    exec dbo.USP_NFGLEVEL_GETSITES_UPDATEFROMXML @ID, @SITES, @CHANGEAGENTID;

    if @NOTMATCH = 1
      exec dbo.USP_NFGLEVEL_REMOVECHILDLEVELSITES @ID, @SITES;

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;