USP_SPONSORSHIPOPPORTUNITY_EDITLOAD_PROJECT

The load procedure used by the edit dataform template "Sponsorship Opportunity Project Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@SPONSORSHIPOPPORTUNITYGROUPID	uniqueidentifier	INOUT	Project group
@SPONSORSHIPLOCATIONID	uniqueidentifier	INOUT	Location
@PROJECTNAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@GOAL	money	INOUT	Amount
@SPONSORGOAL	int	INOUT	Sponsors
@DESIGNATIONID	uniqueidentifier	INOUT	Designation
@SPROPPPROJECTCATEGORYCODE	uniqueidentifier	INOUT	Category
@ISSPONSORED	bit	INOUT
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID

Definition

Copy


CREATE procedure dbo.USP_SPONSORSHIPOPPORTUNITY_EDITLOAD_PROJECT
  (
    @ID uniqueidentifier ,
    @DATALOADED bit = 0 output,  
    @TSLONG bigint = 0 output,
    @SPONSORSHIPOPPORTUNITYGROUPID uniqueidentifier =null output,
    @SPONSORSHIPLOCATIONID uniqueidentifier = null output,
    @PROJECTNAME nvarchar(100) = null output,
    @DESCRIPTION nvarchar(255) = null output,
    @GOAL money=null output,
    @SPONSORGOAL int=null output,
  @DESIGNATIONID uniqueidentifier = null output,
  @SPROPPPROJECTCATEGORYCODE uniqueidentifier = null output,
  @ISSPONSORED bit=null output,
  @BASECURRENCYID uniqueidentifier = null output
  )
as
  set nocount on;
  set @DATALOADED = 0;    
  set @TSLONG = 0;

    select
        @DATALOADED = 1,    
        @TSLONG = SP.TSLONG,
        @SPONSORSHIPLOCATIONID = SO.SPONSORSHIPLOCATIONID,
        @PROJECTNAME = SP.NAME,
        @DESCRIPTION = SP.DESCRIPTION,
        @GOAL = SP.GOAL,
        @SPONSORGOAL = SP.SPONSORGOAL,
        @SPONSORSHIPOPPORTUNITYGROUPID = SO.SPONSORSHIPOPPORTUNITYGROUPID,
    @DESIGNATIONID = SP.DESIGNATIONID,
    @SPROPPPROJECTCATEGORYCODE = SP.SPROPPPROJECTCATEGORYCODEID,
    @ISSPONSORED = case SL.SPONSORCOUNT when 0 then 0 else 1 end,
    @BASECURRENCYID = BASECURRENCYID
    from dbo.SPONSORSHIPOPPORTUNITYPROJECT SP
    inner join dbo.SPONSORSHIPOPPORTUNITY SO on SP.ID=SO.ID
  inner join dbo.SPONSORSHIPOPPORTUNITYLOCK SL on SL.ID = SO.ID
    where SP.ID = @ID;

  return 0;