API CreateBranch: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(Založena nová stránka s textem „API_CreateBranch @WorkshopID int - API_GetWorkshops.ID @Name nvarchar(100) @Street nvarchar(200) @City nvarchar(120) @ZIPCode nvarchar(15) @Country…“)
 
Řádka 1: Řádka 1:
−
API_CreateBranch
+
==== <code>API_CreateBranch</code> ====
  
−
@WorkshopID int - API_GetWorkshops.ID
+
==== Specification ====
−
@Name nvarchar(100)
+
{| class="wikitable"
−
@Street nvarchar(200)
+
!Parameter
−
@City nvarchar(120)
+
!Data type
−
@ZIPCode nvarchar(15)
+
!Value range
−
@Country nvarchar(70)
+
!Description
−
@Region nvarchar(70)
+
!Relation
−
@State nvarchar(80)
+
|-
−
@StateID int - API_GetCountry.ID
+
|@WorkshopID
−
@Phone nvarchar(50)
+
|int
−
@Fax nvarchar(50)
+
|
−
@MobilePhone nvarchar(50)
+
|Workshop ID
−
@Email nvarchar(70)
+
(could be equal to ID in Your internal system)
−
@Web nvarchar(120)
+
|API_GetWorkshops.ID
 +
|-
 +
|@Name  
 +
|nvarchar(100)
 +
|
 +
|Workshop name
 +
|
 +
|-
 +
|@Street  
 +
|nvarchar(200)
 +
|
 +
|
 +
|
 +
|-
 +
|@City  
 +
|nvarchar(120)
 +
|
 +
|
 +
|
 +
|-
 +
|@ZIPCode  
 +
|nvarchar(15)
 +
|
 +
|
 +
|
 +
|-
 +
|@Country  
 +
|nvarchar(70)
 +
|
 +
|
 +
|
 +
|-
 +
|@Region  
 +
|nvarchar(70)
 +
|
 +
|
 +
|
 +
|-
 +
|@State  
 +
|nvarchar(80)
 +
|
 +
|
 +
|
 +
|-
 +
|@StateID
 +
|int
 +
|
 +
|ID of country
 +
|API_GetCountry.ID
 +
|-
 +
|@Phone  
 +
|nvarchar(50)
 +
|
 +
|Phone
 +
|
 +
|-
 +
|@Fax
 +
|nvarchar(50)
 +
|
 +
|Fax
 +
|
 +
|-
 +
|@MobilePhone
 +
|nvarchar(50)
 +
|
 +
|Mobile phone
 +
|
 +
|-
 +
|@Email
 +
|nvarchar(70)
 +
|
 +
|Email
 +
|
 +
|-
 +
|@Web
 +
|nvarchar(120)
 +
|
 +
|Web address
 +
|
 +
|}
  
−
 
+
==== Example ====
−
Example:
+
<syntaxhighlight lang="sql">
−
EXEC [API_CreateBranch]  
+
EXEC [API_CreateBranch] @WorkshopID = 1 ,@Name = 'Name' ,@Street = 'Street' ,@City = 'City' ,@ZIPCode = 'ZIPCode' ,@Country = 'Country' ,@Region = 'Region' ,@State ='Česká republika' ,@StateID = 15797 ,@Phone = '+420 556 621 300' ,@Fax = '+420 596 790 789' ,@MobilePhone = '+420 556 621 301' ,@Email = 'info@nextis.cz' ,@Web = 'www.nextis.cz'
−
  @WorkshopID = 1
+
</syntaxhighlight>
−
  ,@Name = 'Name'
 
−
  ,@Street = 'Street'
 
−
  ,@City = 'City'
 
−
  ,@ZIPCode = 'ZIPCode'
 
−
  ,@Country = 'Country'
 
−
  ,@Region = 'Region'
 
−
  ,@State ='Česká republika'
 
−
  ,@StateID = 15797
 
−
  ,@Phone = '+420 556 621 300'
 
−
  ,@Fax = '+420 596 790 789'
 
−
  ,@MobilePhone = '+420 556 621 301'
 
−
  ,@Email = 'info@nextis.cz'
 
−
  ,@Web = 'www.nextis.cz'
 

Verze z 24. 7. 2017, 18:15

API_CreateBranch

Specification

Parameter Data type Value range Description Relation
@WorkshopID int Workshop ID

(could be equal to ID in Your internal system)

API_GetWorkshops.ID
@Name nvarchar(100) Workshop name
@Street nvarchar(200)
@City nvarchar(120)
@ZIPCode nvarchar(15)
@Country nvarchar(70)
@Region nvarchar(70)
@State nvarchar(80)
@StateID int ID of country API_GetCountry.ID
@Phone nvarchar(50) Phone
@Fax nvarchar(50) Fax
@MobilePhone nvarchar(50) Mobile phone
@Email nvarchar(70) Email
@Web nvarchar(120) Web address

Example

EXEC [API_CreateBranch] @WorkshopID = 1 ,@Name = 'Name' ,@Street = 'Street' ,@City = 'City' ,@ZIPCode = 'ZIPCode' ,@Country = 'Country' ,@Region = 'Region' ,@State ='Česká republika' ,@StateID = 15797 ,@Phone = '+420 556 621 300' ,@Fax = '+420 596 790 789' ,@MobilePhone = '+420 556 621 301' ,@Email = 'info@nextis.cz' ,@Web = 'www.nextis.cz'
Citováno z „https://podpora.nextis.cz/index.php?title=API_CreateBranch&oldid=216“