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 nvarchar(250) Transport name
@Description nvarchar(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

Return

0 : OK
100 : Item could not be updated

Example

 DECLARE @return_value int
 DECLARE @ID int
 DECLARE @TransportName nvarchar(250)
 DECLARE @Description nvarchar(200)
 DECLARE @Prohibit int
 DECLARE @CashPaymentAllowed int
 DECLARE @WireTransferPaymentAllowed int
 DECLARE @HideOnEshop bit
 DECLARE @BranchID int
 
 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 @return_value = [API_UpdateTransport] 
 @ID,
 @TransportName,
 @Description,
 @Prohibit,
 @CashPaymentAllowed,
 @WireTransferPaymentAllowed,
 @HideOnEshop,
 @BranchID

Notices

None.