USP_SALESORDER_ADDMEMBERSHIPPROMO

Adds a given membership promotion to the given sales order

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@SALESORDERID	uniqueidentifier	IN
@MEMBERSHIPPROMOID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTDATE	datetime	IN
@PROMOCODE	nvarchar(50)	IN

Definition

Copy



CREATE procedure dbo.USP_SALESORDER_ADDMEMBERSHIPPROMO
(
    @ID uniqueidentifier = null,
    @SALESORDERID uniqueidentifier,
    @MEMBERSHIPPROMOID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CURRENTDATE datetime = null,
    @PROMOCODE nvarchar(50) = ''
)
as
begin
    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    if @CURRENTDATE is null
        set @CURRENTDATE = getdate()

    insert into dbo.SALESORDERMEMBERSHIPPROMO
        (ID, SALESORDERID, MEMBERSHIPPROMOID, PROMOTIONALCODE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    values
        (newid(), @SALESORDERID, @MEMBERSHIPPROMOID, @PROMOCODE, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

    exec dbo.USP_SALESORDER_UPDATEMEMBERSHIPPROMOS @SALESORDERID, @CHANGEAGENTID
end