USP_DATALIST_SALESORDERONLINEDELIVERYMETHOD

List of possible Delivery Methods
Parameters

Parameter	Parameter Type	Mode	Description
@SALESORDERID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@GETALL	bit	IN	Get All
Definition

Copy


                CREATE procedure dbo.USP_DATALIST_SALESORDERONLINEDELIVERYMETHOD
                (
                    @SALESORDERID uniqueidentifier,
                    @GETALL bit
                )
                as
                    set nocount on;

                    declare @SALESMETHODCODE tinyint = (select SALESMETHODTYPECODE from dbo.SALESORDER where ID = @SALESORDERID);
                    declare @DEFAULTDELIVERYMETHODID uniqueidentifier = dbo.UFN_SALESMETHODDELIVERYMETHOD_GETDEFAULTDELIVERYMETHODID(@SALESMETHODCODE);

                    if @GETALL = 1
                    begin
                        select
                            [ID],
                            [NAME],
                            [NAMEREQUIRED],
                            [ADDRESSREQUIRED],
                            [BLOCKDELIVERY],
                            [BLOCKTIMEVALUE],
                            [BLOCKTIMEUNITCODE],
                            [ISACTIVE],                        
                            [PHONEREQUIRED],
                            [EMAILREQUIRED],
                            [PRINTCODE],
                            [BLOCKTIMEUNIT],
                            [PRINT],
                            case when @DEFAULTDELIVERYMETHODID = ID then 1 else 0 end as [ISSALESMETHODDEFAULT]
                        from dbo.DELIVERYMETHOD 
                        where dbo.UFN_DELIVERYMETHOD_VALIDFORORDER(DELIVERYMETHOD.ID, @SALESORDERID) = 1
                    end
                    else
                        begin
                        declare @DELIVERYMETHODID uniqueidentifier
                        select @DELIVERYMETHODID = DELIVERYMETHODID 
                        from dbo.SALESORDER
                        where ID = @SALESORDERID

                        select
                            [ID],
                            [NAME],
                            [NAMEREQUIRED],
                            [ADDRESSREQUIRED],
                            [BLOCKDELIVERY],
                            [BLOCKTIMEVALUE],
                            [BLOCKTIMEUNITCODE],
                            [ISACTIVE],                        
                            [PHONEREQUIRED],
                            [EMAILREQUIRED],
                            [PRINTCODE],
                            [BLOCKTIMEUNIT],
                            [PRINT],
                            case when @DEFAULTDELIVERYMETHODID = ID then 1 else 0 end as [ISSALESMETHODDEFAULT]
                        from dbo.DELIVERYMETHOD 
                        where [ID] = @DELIVERYMETHODID
                        end