API UpdateTransport

Z Podpora.nextis.cz
Přejít na: navigace, hledání

Description

Method allows You to update transport in system.

Exact name

API_UpdateTransport

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@ID int Internal system id
@TransportName varchar(250) Transport name
@Description varchar(200) Description
@Prohibit int Prohibit
@CashPaymentAllowed int Cash payment allowed
@WireTransferPaymentAllowed int Wire transfer payment allowed
@HideOnEshop bit Hide on eshop
@BranchID int ID of branch from branch list (see relation) API_GetBranches.ID


Example

 DECLARE @ID int
 DECLARE @TransportName
 DECLARE @Description
 DECLARE @Prohibit
 DECLARE @CashPaymentAllowed
 DECLARE @WireTransferPaymentAllowed
 DECLARE @HideOnEshop
 DECLARE @BranchID
 
 SELECT @ID = [ID],
        @TransportName = 'Transport 2',
        @Description = [Description],
        @Prohibit = [Prohibit],
        @CashPaymentAllowed = [CashPaymentAllowed],
        @WireTransferPaymentAllowed = [WireTransferPaymentAllowed],
        @HideOnEshop = [HideOnEshop],
        @BranchID = [BranchID]
 FROM   [API_GetTransports] 
 WHERE  ID = 3
 
 EXECUTE [API_UpdateTransport] 
 @ID,
 @TransportName,
 @Description,
 @Prohibit,
 @CashPaymentAllowed,
 @WireTransferPaymentAllowed,
 @HideOnEshop,
 @BranchID

Notices

None.