UFN_AMPROIMPORT_VALIDATEACCOUNTSYSTEMSITES

Validates the sites on an account system with an auction.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTAUCTIONID	uniqueidentifier	IN
@PDACCOUNTSYSTEMID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_AMPROIMPORT_VALIDATEACCOUNTSYSTEMSITES
            (
                @EVENTAUCTIONID uniqueidentifier,
                @PDACCOUNTSYSTEMID uniqueidentifier
            )
            returns bit
            as
            begin
                declare @EVENTSITECOUNT int = 0;
                declare @ACCOUNTSYSTEMSITECOUNT int = 0;
                declare @ISDEFAULTACCOUNTSYSTEM bit = 0;

                select @EVENTSITECOUNT = count(*) from dbo.EVENTSITE where EVENTID = @EVENTAUCTIONID;
                select @ACCOUNTSYSTEMSITECOUNT = count(*) from dbo.PDACCOUNTSYSTEMSITE where PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID;
                select @ISDEFAULTACCOUNTSYSTEM = ISDEFAULT from dbo.PDACCOUNTSYSTEM where ID = @PDACCOUNTSYSTEMID

                if @EVENTSITECOUNT = 0 and (@ACCOUNTSYSTEMSITECOUNT = 0 or @ISDEFAULTACCOUNTSYSTEM = 1)
                    return 1;
                else
                begin
                    if exists    (    select EVENTSITE.SITEID 
                                    from dbo.EVENTSITE 
                                    inner join dbo.PDACCOUNTSYSTEMSITE on PDACCOUNTSYSTEMSITE.SITEID = EVENTSITE.SITEID 
                                        and PDACCOUNTSYSTEMSITE.PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID
                                    where EVENTSITE.EVENTID = @EVENTAUCTIONID 
                                )
                        return 1;
                end

                return 0;
            end