API UpdateVATRate: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(Založena nová stránka s textem „==== Description ==== Method allows You to update branch in system. ==== Exact name ==== <code>API_UpdateBranch</code> ==== Type ==== Standard executable…“)
 
Řádka 20: Řádka 20:
 
|
 
|
 
|Internal system id
 
|Internal system id
|API_GetBranches.ID
+
|
 
|-
 
|-
 
|@WorkshopID  
 
|@WorkshopID  
Řádka 27: Řádka 27:
 
|Workshops ID  
 
|Workshops ID  
 
ID of workshops from workshops list (see relation)
 
ID of workshops from workshops list (see relation)
|API_GetWorkshops.ID
+
|
 +
|@Name
 +
|nvarchar(50)
 +
|
 +
|Name
 +
|
 +
|-
 +
|@Value
 +
|decimal(18,2)
 +
|
 +
|Value
 +
|
 
|-
 
|-
|@Name
+
|@IsActive
|nvarchar(100)
+
|int
 
|
 
|
|Branch name
+
|Is active
 
|
 
|
 
|}
 
|}

Verze z 2. 8. 2017, 07:55

Description

Method allows You to update branch in system.

Exact name

API_UpdateBranch

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@ID int Internal system id
@WorkshopID int Workshops ID

ID of workshops from workshops list (see relation)

@Name nvarchar(50) Name
@Value decimal(18,2) Value
@IsActive int Is active


Example

 DECLARE @ID INT 
 DECLARE @WorkshopID INT 
 
 SELECT @ID = id, 
       @WorkshopID = [workshopid], 
       @Name = 'Name2', 

 FROM   [api_getbranches] 
 WHERE  id = 3
 
 EXECUTE [Api_updatebranch] 
  @ID, 
  @WorkshopID,

Notices

None.