USP_DATAFORMTEMPLATE_EDIT_EVENTGOAL

The save procedure used by the edit dataform template "EventGoal 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.
@EVENTID	uniqueidentifier	IN	Event
@REVENUETOTAL	money	IN	Total
@REVENUEMONTHLY	money	IN	Monthly
@REVENUEWEEKLY	money	IN	Weekly
@REVENUEDAILY	money	IN	Daily
@REVENUESPONSOR	money	IN	Sponsors
@REVENUECOMPANY	money	IN	Companies
@REVENUETEAM	money	IN	Teams
@REVENUEINDIVIDUAL	money	IN	Individual participants
@RECRUITMENTSPONSOR	int	IN	Sponsors
@RECRUITMENTCOMPANY	int	IN	Companies
@RECRUITMENTTEAM	int	IN	Teams
@RECRUITMENTINDIVIDUAL	int	IN	Individual participants
@COMMUNICATIONTOTAL	int	IN	Total
@COMMUNICATIONMONTHLY	int	IN	Monthly
@COMMUNICATIONWEEKLY	int	IN	Weekly
@COMMUNICATIONDAILY	int	IN	Daily
@COMMUNICATIONSPONSOR	int	IN	Sponsors
@COMMUNICATIONCOMPANY	int	IN	Companies
@COMMUNICATIONTEAM	int	IN	Teams
@COMMUNICATIONINDIVIDUAL	int	IN	Individual participants
@ISACTIVE	bit	IN	ISACTIVE
@RECRUITMENTFUNDRAISINGCOACHES	int	IN	Fundraising coaches
@RECRUITMENTFITNESSCOACHES	int	IN	Fitness coaches
@RECRUITMENTDONOR	int	IN	Donors
@REVENUERETENTION	decimal(7, 2)	IN	Percentage of total revenue to retain
@REVENUESPONSORRETENTION	decimal(7, 2)	IN	Percentage of sponsor revenue to retain
@REVENUECOMPANYRETENTION	decimal(7, 2)	IN	Percentage of company revenue to retain
@REVENUETEAMRETENTION	decimal(7, 2)	IN	Percentage of team revenue to retain
@REVENUEINDIVIDUALRETENTION	decimal(7, 2)	IN	Percentage of individual participant revenue to retain
@RECRUITMENTFUNDRAISINGCOACHRETENTION	decimal(7, 2)	IN	Percentage of fundraising coaches to retain
@RECRUITMENTFITNESSCOACHRETENTION	decimal(7, 2)	IN	Percentage of fitness coaches to retain
@RECRUITMENTSPONSORRETENTION	decimal(7, 2)	IN	Percentage of sponsors to retain
@RECRUITMENTCOMPANYRETENTION	decimal(7, 2)	IN	Percentage of companies to retain
@RECRUITMENTDONORRETENTION	decimal(7, 2)	IN	Percentage of donors to retain
@RECRUITMENTTEAMRETENTION	decimal(7, 2)	IN	Percentage of teams to retain
@RECRUITMENTINDIVIDUALRETENTION	decimal(7, 2)	IN	Percentage of individual participants to retain
@REVENUEHOUSEHOLD	money	IN	Households
@RECRUITMENTHOUSEHOLD	int	IN	Households
@COMMUNICATIONHOUSEHOLD	int	IN	Households
@REVENUEHOUSEHOLDRETENTION	decimal(7, 2)	IN	Percentage of households revenue to retain
@RECRUITMENTHOUSEHOLDRETENTION	decimal(7, 2)	IN	Percentage of households to retain
@REVENUEREGISTRATION	money	IN	Registration
@REVENUEREGISTRATIONRETENTION	decimal(7, 2)	IN	Percentage of registration revenue to retain
@PRIORYEAREVENTID	uniqueidentifier	IN	Prior year event id

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EVENTGOAL
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @EVENTID uniqueidentifier,
    @REVENUETOTAL money,
    @REVENUEMONTHLY money,
    @REVENUEWEEKLY money,
    @REVENUEDAILY money,
    @REVENUESPONSOR money,
    @REVENUECOMPANY money,
    @REVENUETEAM money,
    @REVENUEINDIVIDUAL money,
   -- @RECRUITMENTTOTAL int,
   -- @RECRUITMENTMONTHLY int,
  --  @RECRUITMENTWEEKLY int,
   -- @RECRUITMENTDAILY int,
    @RECRUITMENTSPONSOR int,
    @RECRUITMENTCOMPANY int,
    @RECRUITMENTTEAM int,
    @RECRUITMENTINDIVIDUAL int,
    @COMMUNICATIONTOTAL int,
    @COMMUNICATIONMONTHLY int,
    @COMMUNICATIONWEEKLY int,
    @COMMUNICATIONDAILY int,
    @COMMUNICATIONSPONSOR int,
    @COMMUNICATIONCOMPANY int,
    @COMMUNICATIONTEAM int,
    @COMMUNICATIONINDIVIDUAL int,
    @ISACTIVE bit,

    --@MINIMIMUMFUNDRAISINGGOAL money,
--    @MINIMIMUMPARTICIPANTGOAL int,
--    @MINIMUMFUNDRAISEGOALPERMEMBER    money,
--    @MINIMIMUMTEAMMEMBERGOAL int,
--    @MINIMIMUMDONORGOAL    int,
--    @MINIMIMUMNEWMEMBERGOAL    int,
    --@MINIMIMUMNEWDONORGOAL int,

    @RECRUITMENTFUNDRAISINGCOACHES int,
    @RECRUITMENTFITNESSCOACHES int,
    @RECRUITMENTDONOR int,
    @REVENUERETENTION decimal(7,2),
    @REVENUESPONSORRETENTION decimal(7,2),
    @REVENUECOMPANYRETENTION decimal(7,2),
    @REVENUETEAMRETENTION decimal(7,2),
    @REVENUEINDIVIDUALRETENTION decimal(7,2),
    @RECRUITMENTFUNDRAISINGCOACHRETENTION decimal(7,2),
    @RECRUITMENTFITNESSCOACHRETENTION decimal(7,2),
    @RECRUITMENTSPONSORRETENTION decimal(7,2),
    @RECRUITMENTCOMPANYRETENTION decimal(7,2),
    @RECRUITMENTDONORRETENTION decimal(7,2),
    @RECRUITMENTTEAMRETENTION decimal(7,2),
    @RECRUITMENTINDIVIDUALRETENTION decimal(7,2),
       @REVENUEHOUSEHOLD money ,
    @RECRUITMENTHOUSEHOLD int ,
    @COMMUNICATIONHOUSEHOLD int ,
    @REVENUEHOUSEHOLDRETENTION decimal(7,2) ,
    @RECRUITMENTHOUSEHOLDRETENTION decimal(7,2),
    @REVENUEREGISTRATION money,
    @REVENUEREGISTRATIONRETENTION decimal(7,2), 
     @PRIORYEAREVENTID uniqueidentifier

)
as

    set nocount on;

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

    begin try
        -- handle updating the data
        update dbo.EVENTGOAL set
            EVENTID = @EVENTID,
            REVENUETOTAL = @REVENUETOTAL,
            REVENUEMONTHLY = @REVENUEMONTHLY,
            REVENUEWEEKLY = @REVENUEWEEKLY,
            REVENUEDAILY = @REVENUEDAILY,
            REVENUESPONSOR = @REVENUESPONSOR, 
            REVENUECOMPANY = @REVENUECOMPANY, 
            REVENUETEAM = @REVENUETEAM,
            REVENUEINDIVIDUAL = @REVENUEINDIVIDUAL,
          --  RECRUITMENTTOTAL = @RECRUITMENTTOTAL,
          --  RECRUITMENTMONTHLY = @RECRUITMENTMONTHLY,
          --  RECRUITMENTWEEKLY = @RECRUITMENTWEEKLY,
          --  RECRUITMENTDAILY = @RECRUITMENTDAILY,
            RECRUITMENTSPONSOR = @RECRUITMENTSPONSOR, 
            RECRUITMENTCOMPANY = @RECRUITMENTCOMPANY, 
            RECRUITMENTTEAM = @RECRUITMENTTEAM,
            RECRUITMENTINDIVIDUAL = @RECRUITMENTINDIVIDUAL,
            COMMUNICATIONTOTAL = @COMMUNICATIONTOTAL,
            COMMUNICATIONMONTHLY = @COMMUNICATIONMONTHLY,
            COMMUNICATIONWEEKLY = @COMMUNICATIONWEEKLY,
            COMMUNICATIONDAILY = @COMMUNICATIONDAILY,
            COMMUNICATIONSPONSOR = @COMMUNICATIONSPONSOR, 
            COMMUNICATIONCOMPANY = @COMMUNICATIONCOMPANY, 
            COMMUNICATIONTEAM = @COMMUNICATIONTEAM,
            COMMUNICATIONINDIVIDUAL = @COMMUNICATIONINDIVIDUAL,
            EVENTGOAL.ISACTIVE= @ISACTIVE,

        --    MINIMIMUMFUNDRAISINGGOAL= @MINIMIMUMFUNDRAISINGGOAL,
        --    MINIMIMUMPARTICIPANTGOAL= @MINIMIMUMPARTICIPANTGOAL,
        --    MINIMUMFUNDRAISEGOALPERMEMBER= @MINIMUMFUNDRAISEGOALPERMEMBER,
        --    MINIMIMUMTEAMMEMBERGOAL= @MINIMIMUMTEAMMEMBERGOAL,
        --    MINIMIMUMDONORGOAL= @MINIMIMUMDONORGOAL,
        --    MINIMIMUMNEWMEMBERGOAL= @MINIMIMUMNEWMEMBERGOAL,
        --    MINIMIMUMNEWDONORGOAL= @MINIMIMUMNEWDONORGOAL,

            RECRUITMENTFUNDRAISINGCOACHES = @RECRUITMENTFUNDRAISINGCOACHES,
            RECRUITMENTFITNESSCOACHES = @RECRUITMENTFITNESSCOACHES,
            RECRUITMENTDONOR= @RECRUITMENTDONOR,
            REVENUERETENTION= @REVENUERETENTION/100,
            REVENUESPONSORRETENTION= @REVENUESPONSORRETENTION/100,
            REVENUECOMPANYRETENTION= @REVENUECOMPANYRETENTION/100,
            REVENUETEAMRETENTION= @REVENUETEAMRETENTION/100,
            REVENUEINDIVIDUALRETENTION= @REVENUEINDIVIDUALRETENTION/100,
            RECRUITMENTFUNDRAISINGCOACHRETENTION= @RECRUITMENTFUNDRAISINGCOACHRETENTION/100,
            RECRUITMENTFITNESSCOACHRETENTION= @RECRUITMENTFITNESSCOACHRETENTION/100,
            RECRUITMENTSPONSORRETENTION= @RECRUITMENTSPONSORRETENTION/100,
            RECRUITMENTCOMPANYRETENTION= @RECRUITMENTCOMPANYRETENTION/100,
            RECRUITMENTDONORRETENTION= @RECRUITMENTDONORRETENTION/100,
            RECRUITMENTTEAMRETENTION= @RECRUITMENTTEAMRETENTION/100,
            RECRUITMENTINDIVIDUALRETENTION= @RECRUITMENTINDIVIDUALRETENTION/100,
            REVENUEHOUSEHOLD = @REVENUEHOUSEHOLD,
            RECRUITMENTHOUSEHOLD = @RECRUITMENTHOUSEHOLD,
            COMMUNICATIONHOUSEHOLD= @COMMUNICATIONHOUSEHOLD,
            REVENUEHOUSEHOLDRETENTION = @REVENUEHOUSEHOLDRETENTION/100,
            RECRUITMENTHOUSEHOLDRETENTION = @RECRUITMENTHOUSEHOLDRETENTION/100 ,
            REVENUEREGISTRATION = @REVENUEREGISTRATION,
            REVENUEREGISTRATIONRETENTION = @REVENUEREGISTRATIONRETENTION/100, 

            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate()

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

    EXEC USP_DATAFORMTEMPLATE_EDIT_EVENT_FAF_CONFIG @EVENTID = @EVENTID, @GOALISSET = 1, @CHANGEAGENTID = @CHANGEAGENTID

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

return 0;