USP_DATAFORMTEMPLATE_VIEW_ONLINEDELIVERYMETHODINFORMATION

Parameters

Parameter	Parameter Type	Mode
@DATALOADED	bit	INOUT
@HASDELIVERYMETHOD	bit	INOUT
@HASUNRESTRICTEDDELIVERY	bit	INOUT
@CURRENTDATETIMEWITHOFFSET	datetimeoffset	INOUT
@EARLIESTVALIDEVENTTIMEWITHOFFSET	datetimeoffset	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ONLINEDELIVERYMETHODINFORMATION
(
    @DATALOADED bit = 0 output,
    @HASDELIVERYMETHOD bit = null output,
    @HASUNRESTRICTEDDELIVERY bit = null output,
    @CURRENTDATETIMEWITHOFFSET datetimeoffset(3) = null output,
    @EARLIESTVALIDEVENTTIMEWITHOFFSET datetimeoffset(3) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    -- Online sales method
    declare @SALESMETHODID uniqueidentifier;
    set @SALESMETHODID = dbo.UFN_SALESMETHOD_GETIDFROMTYPECODE(2);

    select 
        @DATALOADED = 1,
        @HASDELIVERYMETHOD = [HASDELIVERYMETHOD],
        @HASUNRESTRICTEDDELIVERY = [HASUNRESTRICTEDDELIVERY], 
        @CURRENTDATETIMEWITHOFFSET = sysdatetimeoffset(),
        @EARLIESTVALIDEVENTTIMEWITHOFFSET = [EARLIESTVALIDEVENTDATETIMEWITHOFFSET]
    from dbo.UFN_DELIVERYMETHOD_INFO_BYSALESMETHODID(@SALESMETHODID);

    return 0;