API UpdateTransport

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.