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 varchar(250)
 DECLARE @Description varchar(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 [API_UpdateTransport] 
 @ID,
 @TransportName,
 @Description,
 @Prohibit,
 @CashPaymentAllowed,
 @WireTransferPaymentAllowed,
 @HideOnEshop,
 @BranchID

Notices

None.