USP_DATAFORMTEMPLATE_EDIT_DISCOUNTAVAILABILITY

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@ALLOWMONDAY	bit	IN	Monday
@ALLOWTUESDAY	bit	IN	Tuesday
@ALLOWWEDNESDAY	bit	IN	Wednesday
@ALLOWTHURSDAY	bit	IN	Thursday
@ALLOWFRIDAY	bit	IN	Friday
@ALLOWSATURDAY	bit	IN	Saturday
@ALLOWSUNDAY	bit	IN	Sunday
@ALLOWDISCOUNTDATEFROM	datetime	IN	From
@ALLOWDISCOUNTDATETO	datetime	IN	To
@ALLOWDISCOUNTTIMEFROM	UDT_HOURMINUTE	IN	From
@ALLOWDISCOUNTTIMETO	UDT_HOURMINUTE	IN	To
@DISCOUNTADVANCEDSALESID	uniqueidentifier	IN	Discount availability advanced sales method id
@ADVANCEDSALESACTIVE	bit	IN	Advanced Sales Active
@ADVANCEDSALESID	uniqueidentifier	IN	Advanced Sales ID
@ALLOWADVANCEDSALES	bit	IN	Advance sales
@DISCOUNTONLINESALESID	uniqueidentifier	IN	Discount availability online sales method id
@ONLINESALESACTIVE	bit	IN	Online Sales Active
@ONLINESALESID	uniqueidentifier	IN	Online Sales ID
@ALLOWONLINESALES	bit	IN	Online
@DISCOUNTWALKUPSALESID	uniqueidentifier	IN	Discount availability walk up sales method id
@WALKUPSALESACTIVE	bit	IN	Walk Up Sales Active
@WALKUPSALESID	uniqueidentifier	IN	Walk Up Sales ID
@ALLOWWALKUPSALES	bit	IN	Walk up

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DISCOUNTAVAILABILITY
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,                                                
    @ALLOWMONDAY bit,
    @ALLOWTUESDAY bit,
    @ALLOWWEDNESDAY bit,
    @ALLOWTHURSDAY bit,
    @ALLOWFRIDAY bit,
    @ALLOWSATURDAY bit,
    @ALLOWSUNDAY bit,
    @ALLOWDISCOUNTDATEFROM  datetime,
    @ALLOWDISCOUNTDATETO  datetime,
    @ALLOWDISCOUNTTIMEFROM  dbo.UDT_HOURMINUTE,
    @ALLOWDISCOUNTTIMETO  dbo.UDT_HOURMINUTE,
    @DISCOUNTADVANCEDSALESID uniqueidentifier,
    @ADVANCEDSALESACTIVE bit,
    @ADVANCEDSALESID uniqueidentifier,
    @ALLOWADVANCEDSALES bit,
    @DISCOUNTONLINESALESID uniqueidentifier,
    @ONLINESALESACTIVE bit,
    @ONLINESALESID uniqueidentifier,
    @ALLOWONLINESALES bit,
    @DISCOUNTWALKUPSALESID uniqueidentifier,
    @WALKUPSALESACTIVE bit,
    @WALKUPSALESID uniqueidentifier,
    @ALLOWWALKUPSALES bit                        
)
as
    set nocount on;

    declare @DISCOUNTGROUPSALESID uniqueidentifier;
    declare @GROUPSALESACTIVE bit;
    declare @GROUPSALESID uniqueidentifier;
    declare @GROUPSALESDESCRIPTION nvarchar(50);
    declare @ALLOWGROUPSALES bit;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_DISCOUNTAVAILABILITY
        @ID = @ID,
        @DISCOUNTGROUPSALESID = @DISCOUNTGROUPSALESID output,
        @GROUPSALESACTIVE = @GROUPSALESACTIVE output,
        @GROUPSALESID = @GROUPSALESID output,
        @GROUPSALESDESCRIPTION = @GROUPSALESDESCRIPTION output,
        @ALLOWGROUPSALES = @ALLOWGROUPSALES output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_DISCOUNTAVAILABILITY_2
        @ID,
        @CHANGEAGENTID,                                                
        @ALLOWMONDAY,
        @ALLOWTUESDAY, 
        @ALLOWWEDNESDAY,
        @ALLOWTHURSDAY,
        @ALLOWFRIDAY,
        @ALLOWSATURDAY,
        @ALLOWSUNDAY,
        @ALLOWDISCOUNTDATEFROM,
        @ALLOWDISCOUNTDATETO,
        @ALLOWDISCOUNTTIMEFROM,
        @ALLOWDISCOUNTTIMETO,
        @DISCOUNTADVANCEDSALESID,
        @ADVANCEDSALESACTIVE,
        @ADVANCEDSALESID,
        @ALLOWADVANCEDSALES,
        @DISCOUNTONLINESALESID,
        @ONLINESALESACTIVE,
        @ONLINESALESID,
        @ALLOWONLINESALES,
        @DISCOUNTWALKUPSALESID,
        @WALKUPSALESACTIVE,
        @WALKUPSALESID,
        @ALLOWWALKUPSALES,
        @DISCOUNTGROUPSALESID,
        @GROUPSALESACTIVE,
        @GROUPSALESID,
        @ALLOWGROUPSALES;

    return 0;