API CreateBranch - Historie editací

Chrzaszcz v 20. 9. 2017, 13:53

2017-09-20T13:53:13Z

2017-07-25T12:10:25Z

2017-07-25T07:14:34Z

2017-07-24T16:25:08Z

2017-07-24T16:20:09Z

2017-07-24T16:19:15Z

2017-07-24T16:17:54Z

2017-07-24T16:16:22Z

2017-07-24T16:16:08Z

2017-07-24T16:15:02Z

@@ Řádka 100: / Řádka 100: @@
+|
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
-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'
+DECLARE @return_value int
 </syntaxhighlight>
 ==== Notices ====
 None.

@@ Řádka 19: / Řádka 19: @@
 |int
+|
-|Workshop ID
+|ID of workshop from workshop list (see relation)
 |API_GetWorkshops.ID
 |-
@@ Řádka 32: / Řádka 31: @@
 |nvarchar(200)
+|
+|Street
+|
 |-
@@ Řádka 38: / Řádka 37: @@
 |nvarchar(120)
+|
+|City
+|
 |-
@@ Řádka 44: / Řádka 43: @@
 |nvarchar(15)
+|
+|ZIPCode
+|
 |-
@@ Řádka 50: / Řádka 49: @@
 |nvarchar(70)
+|
+|Country
+|
 |-
@@ Řádka 56: / Řádka 55: @@
 |nvarchar(70)
+|
+|Region
+|
 |-
@@ Řádka 62: / Řádka 61: @@
 |nvarchar(80)
+|
+|State
+|
 |-

@@ Řádka 26: / Řádka 26: @@
 |nvarchar(100)
+|
-|Workshop name
+|Branch name
+|
 |-

@@ Řádka 68: / Řádka 68: @@
 |int
+|
-|ID of country
+|ID of country from country list (see relation)
 |API_GetCountry.ID
 |-

@@ Řádka 1: / Řádka 1: @@
 ==== Description ====
-Provides functionality to manage branches within your company. Minimum count of branches is 1 and maximum is not specified (there's no limitation).
+Method allows You to create new branch in system.
 ==== Exact name ====
@@ Řádka 6: / Řádka 6: @@
 ==== Type ====
-Standard executable stored procedure
+Standard executable stored procedure.
 ==== Specification ====

← Starší verze		Verze z 24. 7. 2017, 16:16
Řádka 1:		Řádka 1:
		+	==== Exact name ====
		+
	==== <code>API_CreateBranch</code> ====		==== <code>API_CreateBranch</code> ====
		+
		+	==== Type ====
		+	Standard executable stored procedure

	==== Specification ====		==== Specification ====

@@ Řá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
+==== 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>