USP_DATAFORMTEMPLATE_EDIT_FUNDRAISINGCOACHES

The save procedure used by the edit dataform template "EventFundraisingCoaches Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@EVENTID	uniqueidentifier	IN	Event
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@FUNDRAISINGCOACHESACTIVATEINDIVIDUAL	bit	IN	Individual participants
@FUNDRAISINGCOACHESACTIVATEHOUSEHOLDS	bit	IN	Households
@FUNDRAISINGCOACHESACTIVATETEAMS	bit	IN	Teams
@FUNDRAISINGCOACHESACTIVATECOMPANIES	bit	IN	Companies
@FCGROUPASSIGNMENTSLIMIT	smallint	IN
@FCGROUPSASSIGNMENTCODE	tinyint	IN	Fundraising coach group assign code

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_FUNDRAISINGCOACHES (
    @ID uniqueidentifier,
  @EVENTID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @FUNDRAISINGCOACHESACTIVATEINDIVIDUAL bit,
  @FUNDRAISINGCOACHESACTIVATEHOUSEHOLDS bit,
  @FUNDRAISINGCOACHESACTIVATETEAMS bit,
  @FUNDRAISINGCOACHESACTIVATECOMPANIES bit,
    @FCGROUPASSIGNMENTSLIMIT smallint,
    @FCGROUPSASSIGNMENTCODE tinyint
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    IF (@FUNDRAISINGCOACHESACTIVATEINDIVIDUAL = 1 or @FUNDRAISINGCOACHESACTIVATEHOUSEHOLDS = 1 or @FUNDRAISINGCOACHESACTIVATETEAMS = 1 or @FUNDRAISINGCOACHESACTIVATECOMPANIES = 1)AND @FCGROUPASSIGNMENTSLIMIT <= 0
BEGIN
  raiserror('FCGROUPASSIGNMENTSLIMITISNOTVALID',13,2);
  return 1
END

   IF (@FUNDRAISINGCOACHESACTIVATEINDIVIDUAL = 1 or @FUNDRAISINGCOACHESACTIVATEHOUSEHOLDS = 1 or @FUNDRAISINGCOACHESACTIVATETEAMS = 1 or @FUNDRAISINGCOACHESACTIVATECOMPANIES = 1)AND @FCGROUPSASSIGNMENTCODE = 2
BEGIN
  raiserror('FCGROUPSASSIGNMENTCODEISNOTVALID',13,2);
  return 1
END

    begin try
        -- handle updating the data

        update dbo.EVENTATTRIBUTES set
      EVENTID = @EVENTID,
       FUNDRAISINGCOACHESACTIVATEINDIVIDUAL = @FUNDRAISINGCOACHESACTIVATEINDIVIDUAL,
       FUNDRAISINGCOACHESACTIVATEHOUSEHOLDS = @FUNDRAISINGCOACHESACTIVATEHOUSEHOLDS,
       FUNDRAISINGCOACHESACTIVATETEAMS = @FUNDRAISINGCOACHESACTIVATETEAMS,
       FUNDRAISINGCOACHESACTIVATECOMPANIES = @FUNDRAISINGCOACHESACTIVATECOMPANIES,
       FCGROUPASSIGNMENTSLIMIT = @FCGROUPASSIGNMENTSLIMIT,
             FCGROUPSASSIGNMENTCODE = coalesce(@FCGROUPSASSIGNMENTCODE, 0),       
            CHANGEDBYID = @CHANGEAGENTID,  
        DATECHANGED = getdate()

         from dbo.EVENTATTRIBUTES EA(NOLOCK)
         left join dbo.EVENT E (NOLOCK)ON EA.EVENTID = E.ID
         where E.ID = @ID

     exec USP_DATAFORMTEMPLATE_EDIT_EVENT_FAF_CONFIG @CHANGEAGENTID = @CHANGEAGENTID, @EVENTID = @ID , @FUNDRAISINGCOACHISSET = 1;



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

return 0;