USP_DATAFORMTEMPLATE_ADD_DISCOUNTAVAILABILITY_PRELOAD

The load procedure used by the edit dataform template "Discount Availability Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DISCOUNTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@NEWRECORD	bit	INOUT	Add a new availability
@WALKUPSALESID	uniqueidentifier	INOUT	Walk Up Sales ID
@WALKUPSALESACTIVE	bit	INOUT	Walk Up Sales Active
@WALKUPDESCRIPTION	nvarchar(50)	INOUT	Walk Up Sales Description
@ADVANCEDSALESID	uniqueidentifier	INOUT	Advanced Sales ID
@ADVANCEDSALESACTIVE	bit	INOUT	Advanced Sales Active
@ADVANCEDDESCRIPTION	nvarchar(50)	INOUT	Advanced Sales Description
@ONLINESALESID	uniqueidentifier	INOUT	Online Sales ID
@ONLINESALESACTIVE	bit	INOUT	Online Sales Active
@ONLINEDESCRIPTION	nvarchar(50)	INOUT	Online Sales Description
@GROUPSALESID	uniqueidentifier	INOUT
@GROUPSALESACTIVE	bit	INOUT
@GROUPSALESDESCRIPTION	nvarchar(50)	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_DISCOUNTAVAILABILITY_PRELOAD
(
    @DISCOUNTID uniqueidentifier,
    @NEWRECORD bit = null output,
    @WALKUPSALESID uniqueidentifier = null output,
    @WALKUPSALESACTIVE bit = null output,
    @WALKUPDESCRIPTION nvarchar(50) = null output,
    @ADVANCEDSALESID uniqueidentifier = null output,
    @ADVANCEDSALESACTIVE bit = null output,
    @ADVANCEDDESCRIPTION nvarchar(50) = null output,
    @ONLINESALESID uniqueidentifier = null output,
    @ONLINESALESACTIVE bit = null output,
    @ONLINEDESCRIPTION nvarchar(50) = null output,
    @GROUPSALESID uniqueidentifier = null output,
    @GROUPSALESACTIVE bit = null output,
    @GROUPSALESDESCRIPTION nvarchar(50) = null output
)
as

    set @NEWRECORD = 1;

    select @WALKUPSALESID = ID, @WALKUPSALESACTIVE = ISACTIVE, @WALKUPDESCRIPTION = [TYPE] from dbo.SALESMETHOD where TYPECODE = 0;                        
    select @ADVANCEDSALESID = ID, @ADVANCEDSALESACTIVE = ISACTIVE, @ADVANCEDDESCRIPTION = [TYPE] from dbo.SALESMETHOD where TYPECODE = 1;                        
    select @ONLINESALESID = ID, @ONLINESALESACTIVE = ISACTIVE, @ONLINEDESCRIPTION = [TYPE] from dbo.SALESMETHOD where TYPECODE = 2;        
    select @GROUPSALESID = ID, @GROUPSALESACTIVE = ISACTIVE, @GROUPSALESDESCRIPTION = [TYPE] from dbo.SALESMETHOD where TYPECODE = 3;