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
I@D	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.