USP_DATAFORMTEMPLATE_EDIT_EVENT_LABEL

Used for saving customized labels for an event
Parameters

Parameter	Parameter Type	Mode
@EVENTID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@PARTICIPANT	nvarchar(200)	IN
@DONOR	nvarchar(200)	IN
@INDIVIDUAL	nvarchar(200)	IN
@FAMILY	nvarchar(200)	IN
@HEADOFHOUSEHOLD	nvarchar(200)	IN
@TEAM	nvarchar(200)	IN
@TEAMMEMBER	nvarchar(200)	IN
@TEAMCAPTAIN	nvarchar(200)	IN
@TEAMCOCAPTAIN	nvarchar(200)	IN
@COMPANY	nvarchar(200)	IN
@GROUPTEAM	nvarchar(200)	IN
@GROUPTEAMLEADER	nvarchar(200)	IN
@GROUPCOCAPTAIN	nvarchar(200)	IN
@SPONSOR	nvarchar(200)	IN
@VOLUNTEER	nvarchar(200)	IN
@FITNESSCOACH	nvarchar(200)	IN
@FUNDRAISINGCOACH	nvarchar(200)	IN
@HOUSEHOLDMEMBER	nvarchar(200)	IN
@PARTICIPANTS	nvarchar(200)	IN
@DONORS	nvarchar(200)	IN
@INDIVIDUALS	nvarchar(200)	IN
@FAMILIES	nvarchar(200)	IN
@HEADSOFHOUSEHOLDS	nvarchar(200)	IN
@TEAMS	nvarchar(200)	IN
@TEAMMEMBERS	nvarchar(200)	IN
@TEAMCAPTAINS	nvarchar(200)	IN
@TEAMCOCAPTAINS	nvarchar(200)	IN
@COMPANIES	nvarchar(200)	IN
@GROUPTEAMS	nvarchar(200)	IN
@GROUPTEAMLEADERS	nvarchar(200)	IN
@GROUPCOCAPTAINS	nvarchar(200)	IN
@SPONSORS	nvarchar(200)	IN
@VOLUNTEERS	nvarchar(200)	IN
@FITNESSCOACHES	nvarchar(200)	IN
@FUNDRAISINGCOACHES	nvarchar(200)	IN
@HOUSEHOLDMEMBERS	nvarchar(200)	IN
Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EVENT_LABEL
(
  @EVENTID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @PARTICIPANT nvarchar(200) = null,
  @DONOR nvarchar(200) = null,
  @INDIVIDUAL nvarchar(200) = null,
  @FAMILY nvarchar(200) = null,
  @HEADOFHOUSEHOLD nvarchar(200) = null,
  @TEAM nvarchar(200) = null,
  @TEAMMEMBER nvarchar(200) = null,
  @TEAMCAPTAIN nvarchar(200) = null,
  @TEAMCOCAPTAIN nvarchar(200) = null,
  @COMPANY nvarchar(200) = null,
  @GROUPTEAM nvarchar(200) = null,
  @GROUPTEAMLEADER nvarchar(200) = null,
  @GROUPCOCAPTAIN nvarchar(200) = null,
  @SPONSOR nvarchar(200) = null,
  @VOLUNTEER nvarchar(200) = null,
  @FITNESSCOACH nvarchar(200) = null,
  @FUNDRAISINGCOACH nvarchar(200) = null,
  @HOUSEHOLDMEMBER nvarchar(200) = null,

  @PARTICIPANTS nvarchar(200) = null,
  @DONORS nvarchar(200) = null,
  @INDIVIDUALS nvarchar(200) = null,
  @FAMILIES nvarchar(200) = null,
  @HEADSOFHOUSEHOLDS nvarchar(200) = null,
  @TEAMS nvarchar(200) = null,
  @TEAMMEMBERS nvarchar(200) = null,
  @TEAMCAPTAINS nvarchar(200) = null,
  @TEAMCOCAPTAINS nvarchar(200) = null,
  @COMPANIES nvarchar(200) = null,
  @GROUPTEAMS nvarchar(200) = null,
  @GROUPTEAMLEADERS nvarchar(200) = null,
  @GROUPCOCAPTAINS nvarchar(200) = null,
  @SPONSORS nvarchar(200) = null,
  @VOLUNTEERS nvarchar(200) = null,
  @FITNESSCOACHES nvarchar(200) = null,
  @FUNDRAISINGCOACHES nvarchar(200) = null,
  @HOUSEHOLDMEMBERS nvarchar(200) = null    
)
as

    set nocount on;

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

  declare @CURRENTDATE datetime    
  set @CURRENTDATE = getdate()    

    begin try

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Participant' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Participant', @PARTICIPANT, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @PARTICIPANT WHERE LABELNAME= 'Participant' AND EVENTID= @EVENTID

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Donor' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Donor', @DONOR, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @DONOR WHERE LABELNAME= 'Donor' AND EVENTID= @EVENTID

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Individual' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Individual', @INDIVIDUAL, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @INDIVIDUAL WHERE LABELNAME= 'Individual' AND EVENTID= @EVENTID

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Family' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Family', @FAMILY, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @FAMILY WHERE LABELNAME= 'Family' AND EVENTID= @EVENTID

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Head of Household' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Head of Household', @HEADOFHOUSEHOLD, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @HEADOFHOUSEHOLD WHERE LABELNAME= 'Head of Household' AND EVENTID= @EVENTID

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Team' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Team', @TEAM, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @TEAM WHERE LABELNAME= 'Team' AND EVENTID= @EVENTID

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Team Member' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Team Member', @TEAMMEMBER, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @TEAMMEMBER WHERE LABELNAME= 'Team Member' AND EVENTID= @EVENTID

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Team Captain' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Team Captain', @TEAMCAPTAIN, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @TEAMCAPTAIN WHERE LABELNAME= 'Team Captain' AND EVENTID= @EVENTID

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Team Co-Captain' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Team Co-Captain', @TEAMCOCAPTAIN, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @TEAMCOCAPTAIN WHERE LABELNAME= 'Team Co-Captain' AND EVENTID= @EVENTID

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Company' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Company', @COMPANY, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @COMPANY WHERE LABELNAME= 'Company' AND EVENTID= @EVENTID

IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Group Team' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Group Team', @GROUPTEAM, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @GROUPTEAM WHERE LABELNAME= 'Group Team' AND EVENTID= @EVENTID

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Group Team Leader' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Group Team Leader', @GROUPTEAMLEADER, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @GROUPTEAMLEADER WHERE LABELNAME= 'Group Team Leader' AND EVENTID= @EVENTID

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Group Co-Captain' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Group Co-Captain', @GROUPCOCAPTAIN, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @GROUPCOCAPTAIN WHERE LABELNAME= 'Group Co-Captain' AND EVENTID= @EVENTID

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Sponsor' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Sponsor', @SPONSOR, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @SPONSOR WHERE LABELNAME= 'Sponsor' AND EVENTID= @EVENTID

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Volunteer' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Volunteer', @VOLUNTEER, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @VOLUNTEER WHERE LABELNAME= 'Volunteer' AND EVENTID= @EVENTID

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Fitness Coach' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Fitness Coach', @FITNESSCOACH, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @FITNESSCOACH WHERE LABELNAME= 'Fitness Coach' AND EVENTID= @EVENTID

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Fundraising Coach' AND EVENTID= @EVENTID)    
  insert into dbo.EVENTLABEL    
   (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Fundraising Coach', @FUNDRAISINGCOACH, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @FUNDRAISINGCOACH WHERE LABELNAME= 'Fundraising Coach' AND EVENTID= @EVENTID

 IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Household Member' AND EVENTID= @EVENTID)    
   insert into dbo.EVENTLABEL    
     (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
  values    
   (newid(), @EVENTID, 'Household Member', @HOUSEHOLDMEMBER, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
 ELSE
    UPDATE dbo.EVENTLABEL SET LABELVALUE = @HOUSEHOLDMEMBER WHERE LABELNAME= 'Household Member' AND EVENTID= @EVENTID

    IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Participants' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Participants', @PARTICIPANTS, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @PARTICIPANTS WHERE LABELNAME= 'Participants' AND EVENTID= @EVENTID

     IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Donors' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Donors', @DONORS, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @DONORS WHERE LABELNAME= 'Donors' AND EVENTID= @EVENTID

     IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Individuals' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Individuals', @INDIVIDUALS, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @INDIVIDUALS WHERE LABELNAME= 'Individuals' AND EVENTID= @EVENTID

     IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Families' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Families', @FAMILIES, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @FAMILIES WHERE LABELNAME= 'Families' AND EVENTID= @EVENTID

     IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Heads of Households' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Heads of Households', @HEADSOFHOUSEHOLDS, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @HEADSOFHOUSEHOLDS WHERE LABELNAME= 'Heads of Households' AND EVENTID= @EVENTID

     IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Teams' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Teams', @TEAMS, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @TEAMS WHERE LABELNAME= 'Teams' AND EVENTID= @EVENTID

     IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Team Members' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Team Members', @TEAMMEMBERS, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @TEAMMEMBERS WHERE LABELNAME= 'Team Members' AND EVENTID= @EVENTID

     IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Team Captains' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Team Captains', @TEAMCAPTAINS, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @TEAMCAPTAINS WHERE LABELNAME= 'Team Captains' AND EVENTID= @EVENTID

     IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Team Co-Captains' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Team Co-Captains', @TEAMCOCAPTAIN, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @TEAMCOCAPTAINS WHERE LABELNAME= 'Team Co-Captains' AND EVENTID= @EVENTID

     IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Companies' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Companies', @COMPANIES, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @COMPANIES WHERE LABELNAME= 'Companies' AND EVENTID= @EVENTID

    IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Group Teams' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Group Teams', @GROUPTEAMS, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @GROUPTEAMS WHERE LABELNAME= 'Group Teams' AND EVENTID= @EVENTID

     IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Group Team Leaders' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Group Team Leaders', @GROUPTEAMLEADERS, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @GROUPTEAMLEADERS WHERE LABELNAME= 'Group Team Leaders' AND EVENTID= @EVENTID

     IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Group Co-Captains' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Group Co-Captains', @GROUPCOCAPTAINS, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @GROUPCOCAPTAINS WHERE LABELNAME= 'Group Co-Captains' AND EVENTID= @EVENTID

     IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Sponsors' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Sponsors', @SPONSORS, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @SPONSORS WHERE LABELNAME= 'Sponsors' AND EVENTID= @EVENTID

     IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Volunteers' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Volunteers', @VOLUNTEER, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @VOLUNTEERS WHERE LABELNAME= 'Volunteers' AND EVENTID= @EVENTID

     IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Fitness Coaches' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Fitness Coaches', @FITNESSCOACHES, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @FITNESSCOACHES WHERE LABELNAME= 'Fitness Coaches' AND EVENTID= @EVENTID

     IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Fundraising Coaches' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Fundraising Coaches', @FUNDRAISINGCOACHES, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @FUNDRAISINGCOACHES WHERE LABELNAME= 'Fundraising Coaches' AND EVENTID= @EVENTID

     IF NOT EXISTS (SELECT * FROM dbo.EVENTLABEL (NOLOCK) WHERE LABELNAME= 'Household Members' AND EVENTID= @EVENTID)    
      insert into dbo.EVENTLABEL    
       (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      values    
       (newid(), @EVENTID, 'Household Members', @HOUSEHOLDMEMBERS, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
     ELSE
        UPDATE dbo.EVENTLABEL SET LABELVALUE = @HOUSEHOLDMEMBERS WHERE LABELNAME= 'Household Members' AND EVENTID= @EVENTID

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

return 0;