USP_DATAFORMTEMPLATE_EDIT_FAFEVENTBATCHROW

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@SEQUENCE	int	IN
@COPYFROMEVENTID	uniqueidentifier	IN
@EVENTPROGRAMID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@STARTDATE	date	IN
@STARTTIME	UDT_HOURMINUTE	IN
@ENDDATE	date	IN
@ENDTIME	UDT_HOURMINUTE	IN
@REPORTYEAR	UDT_YEAR	IN
@EVENTLOCATIONID	uniqueidentifier	IN
@EVENTLOCATIONNAME	nvarchar(100)	IN
@EVENTLOCATIONCONTACTID	uniqueidentifier	IN
@EVENTLOCATIONCONTACTFIRSTNAME	nvarchar(50)	IN
@EVENTLOCATIONCONTACTLASTNAME	nvarchar(100)	IN
@EVENTLOCATIONCONTACTEMAILADDRESS	UDT_EMAILADDRESS	IN
@PREVIOUSYEAREVENTID	uniqueidentifier	IN
@EVENTTYPECODE	tinyint	IN
@EVENTCATEGORYCODEID	uniqueidentifier	IN
@SITEID	uniqueidentifier	IN
@DEFAULTCONSTITUENTSITEID	uniqueidentifier	IN
@LOOKUPEVENTID	nvarchar(100)	IN
@SUPPORTPHONE	nvarchar(100)	IN
@SUPPORTURL	UDT_WEBADDRESS	IN
@EVENTSUPPORTEMAIL	UDT_EMAILADDRESS	IN
@APPEALID	uniqueidentifier	IN
@DESIGNATIONID	uniqueidentifier	IN
@EVENTURL	nvarchar(200)	IN
@TOTALREVENUEGOAL	money	IN
@REGISTRATIONSREVENUEGOAL	money	IN
@PARTICIPANTSREVENUEGOAL	money	IN
@HOUSEHOLDSREVENUEGOAL	money	IN
@TEAMSREVENUEGOAL	money	IN
@COMPANIESREVENUEGOAL	money	IN
@SPONSORSREVENUEGOAL	money	IN
@DONORSRECRUITMENTGOAL	int	IN
@PARTICIPANTSRECRUITMENTGOAL	int	IN
@HOUSEHOLDSRECRUITMENTGOAL	int	IN
@TEAMSRECRUITMENTGOAL	int	IN
@COMPANIESRECRUITMENTGOAL	int	IN
@SPONSORSRECRUITMENTGOAL	int	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_FAFEVENTBATCHROW (
  @ID uniqueidentifier,
  @SEQUENCE int,
  @COPYFROMEVENTID uniqueidentifier,
  @EVENTPROGRAMID uniqueidentifier,
  @NAME nvarchar(100),
  @DESCRIPTION nvarchar(255),
  @STARTDATE date,
  @STARTTIME UDT_HOURMINUTE,
  @ENDDATE date,
  @ENDTIME UDT_HOURMINUTE,
  @REPORTYEAR UDT_YEAR,
  @EVENTLOCATIONID uniqueidentifier,
  @EVENTLOCATIONNAME nvarchar(100),
  @EVENTLOCATIONCONTACTID uniqueidentifier,
  @EVENTLOCATIONCONTACTFIRSTNAME nvarchar(50),
  @EVENTLOCATIONCONTACTLASTNAME nvarchar(100),
  @EVENTLOCATIONCONTACTEMAILADDRESS UDT_EMAILADDRESS,
  @PREVIOUSYEAREVENTID uniqueidentifier,
  @EVENTTYPECODE tinyint,
  @EVENTCATEGORYCODEID uniqueidentifier,
  @SITEID uniqueidentifier,
  @DEFAULTCONSTITUENTSITEID uniqueidentifier,
  @LOOKUPEVENTID nvarchar(100),
  @SUPPORTPHONE nvarchar(100),
  @SUPPORTURL UDT_WEBADDRESS,
  @EVENTSUPPORTEMAIL UDT_EMAILADDRESS,
  @APPEALID uniqueidentifier,
  @DESIGNATIONID uniqueidentifier,
  @EVENTURL nvarchar(200),
  @TOTALREVENUEGOAL money,
  @REGISTRATIONSREVENUEGOAL money,
  @PARTICIPANTSREVENUEGOAL money,
  @HOUSEHOLDSREVENUEGOAL money,
  @TEAMSREVENUEGOAL money,
  @COMPANIESREVENUEGOAL money,
  @SPONSORSREVENUEGOAL money,
  @DONORSRECRUITMENTGOAL int,
  @PARTICIPANTSRECRUITMENTGOAL int,
  @HOUSEHOLDSRECRUITMENTGOAL int,
  @TEAMSRECRUITMENTGOAL int,
  @COMPANIESRECRUITMENTGOAL int,
  @SPONSORSRECRUITMENTGOAL int,
  @CHANGEAGENTID uniqueidentifier
)
as

  set nocount on;

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

  declare @CURRENTDATE datetime
  set @CURRENTDATE = getdate()

begin
if @EVENTURL is not null
  set @EVENTURL = ltrim(rtrim(@EVENTURL))
  if len(@EVENTURL) =1
    raiserror('EVENTURLLENGTH',13,1)
  else if patindex('%[^0-9a-zA-Z_-]%',@EVENTURL) <> 0 and len(@EVENTURL) > 1
    raiserror('EVENTURLVALID',13,1)
end

  begin try
    -- handle updating the data
    update dbo.FAFEVENTBATCH set
      SEQUENCE = @SEQUENCE,
      COPYFROMEVENTID = @COPYFROMEVENTID,
      EVENTPROGRAMID = @EVENTPROGRAMID,
      NAME = @NAME,
      DESCRIPTION = @DESCRIPTION,
      STARTDATE = @STARTDATE,
      STARTTIME = @STARTTIME,
      ENDDATE = @ENDDATE,
      ENDTIME = @ENDTIME,
      REPORTYEAR = @REPORTYEAR,
      EVENTLOCATIONID = @EVENTLOCATIONID,
      EVENTLOCATIONNAME = @EVENTLOCATIONNAME,
      EVENTLOCATIONCONTACTID = @EVENTLOCATIONCONTACTID,
      EVENTLOCATIONCONTACTLASTNAME = @EVENTLOCATIONCONTACTLASTNAME,
      EVENTLOCATIONCONTACTFIRSTNAME = @EVENTLOCATIONCONTACTFIRSTNAME,
      EVENTLOCATIONCONTACTEMAILADDRESS = @EVENTLOCATIONCONTACTEMAILADDRESS,
      PREVIOUSYEAREVENTID = @PREVIOUSYEAREVENTID,
      EVENTTYPECODE = @EVENTTYPECODE,
      EVENTCATEGORYCODEID = @EVENTCATEGORYCODEID,
      SITEID = @SITEID,
      DEFAULTCONSTITUENTSITEID = @DEFAULTCONSTITUENTSITEID,
      LOOKUPEVENTID = @LOOKUPEVENTID,
      SUPPORTPHONE = @SUPPORTPHONE,
      SUPPORTURL = @SUPPORTURL,
      EVENTSUPPORTEMAIL = @EVENTSUPPORTEMAIL,
      APPEALID = @APPEALID,
      DESIGNATIONID = @DESIGNATIONID,
      EVENTURL = @EVENTURL,
      TOTALREVENUEGOAL = @TOTALREVENUEGOAL,
      REGISTRATIONSREVENUEGOAL = @REGISTRATIONSREVENUEGOAL,
      PARTICIPANTSREVENUEGOAL = @PARTICIPANTSREVENUEGOAL,
      HOUSEHOLDSREVENUEGOAL = @HOUSEHOLDSREVENUEGOAL,
      TEAMSREVENUEGOAL = @TEAMSREVENUEGOAL,
      COMPANIESREVENUEGOAL = @COMPANIESREVENUEGOAL,
      SPONSORSREVENUEGOAL = @SPONSORSREVENUEGOAL,
      DONORSRECRUITMENTGOAL = @DONORSRECRUITMENTGOAL,
      PARTICIPANTSRECRUITMENTGOAL = @PARTICIPANTSRECRUITMENTGOAL,
      HOUSEHOLDSRECRUITMENTGOAL = @HOUSEHOLDSRECRUITMENTGOAL,
      TEAMSRECRUITMENTGOAL = @TEAMSRECRUITMENTGOAL,
      COMPANIESRECRUITMENTGOAL = @COMPANIESRECRUITMENTGOAL,
      SPONSORSRECRUITMENTGOAL = @SPONSORSRECRUITMENTGOAL,
      CHANGEDBYID = @CHANGEAGENTID,
      DATECHANGED = @CURRENTDATE
    where ID = @ID
  end try
  begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
  end catch

return 0;