API CreateBranch: Porovnání verzí

Z Podpora.nextis.cz
Skočit na navigaci Skočit na vyhledávání

Chrzaszcz (diskuse | příspěvky)

2 uživatelské skupiny
542 editací
VizuálníWikitext
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…“
 
Bez shrnutí editace
 
(Není zobrazeno 9 mezilehlých verzí od 2 dalších uživatelů.)
Řádek 1: Řádek 1:
API_CreateBranch
==== Description ====
Method allows You to create new branch in system.


@WorkshopID int - API_GetWorkshops.ID
==== Exact name ====
@Name nvarchar(100)
<code>API_CreateBranch</code>
@Street nvarchar(200)
@City nvarchar(120)
@ZIPCode nvarchar(15)
@Country nvarchar(70)
@Region nvarchar(70)
@State nvarchar(80)
@StateID int - API_GetCountry.ID
@Phone nvarchar(50)
@Fax nvarchar(50)
@MobilePhone nvarchar(50)
@Email nvarchar(70)
@Web nvarchar(120)


==== Type ====
Standard executable stored procedure.


Example:
==== Specification ====
  EXEC [API_CreateBranch]  
{| class="wikitable"
  @WorkshopID = 1
!Parameter
  ,@Name = 'Name'
!Data type
  ,@Street = 'Street'
!Value range
  ,@City = 'City'
!Description
  ,@ZIPCode = 'ZIPCode'
!Relation
  ,@Country = 'Country'
|-
  ,@Region = 'Region'
|@WorkshopID
  ,@State ='Česká republika'
|int
  ,@StateID = 15797
|
  ,@Phone = '+420 556 621 300'
|ID of workshop from workshop list (see relation)
  ,@Fax = '+420 596 790 789'
|API_GetWorkshops.ID
  ,@MobilePhone = '+420 556 621 301'
|-
  ,@Email = 'info@nextis.cz'
|@Name
  ,@Web = 'www.nextis.cz'
|nvarchar(100)
|
|Branch name
|
|-
|@Street
|nvarchar(200)
|
|Street
|
|-
|@City
|nvarchar(120)
|
|City
|
|-
|@ZIPCode
|nvarchar(15)
|
|ZIPCode
|
|-
|@Country
|nvarchar(70)
|
|Country
|
|-
|@Region
|nvarchar(70)
|
|Region
|
|-
|@State
|nvarchar(80)
|
|State
|
|-
|@StateID
|int
|
|ID of country from country list (see relation)
|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
|
|}
 
==== Return ====
0 : OK
  100 : Item could not be created
 
==== Example ====
<syntaxhighlight lang="sql">
DECLARE @return_value int
EXEC @return_value = [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'
</syntaxhighlight>
 
==== Notices ====
None.

Aktuální verze z 20. 9. 2017, 13:53

Description

Method allows You to create new branch in system.

Exact name

API_CreateBranch

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@WorkshopID int ID of workshop from workshop list (see relation) API_GetWorkshops.ID
@Name nvarchar(100) Branch name
@Street nvarchar(200) Street
@City nvarchar(120) City
@ZIPCode nvarchar(15) ZIPCode
@Country nvarchar(70) Country
@Region nvarchar(70) Region
@State nvarchar(80) State
@StateID int ID of country from country list (see relation) 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

Return

0 : OK
100 : Item could not be created

Example

DECLARE @return_value int
EXEC @return_value = [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'

Notices

None.

Citováno z „https://podpora.nextis.cz/index.php?title=API_CreateBranch&oldid=955“