API CreateBranch - Historie editací

Chrzaszcz v 20. 9. 2017, 13:53

2017-09-20T13:53:13Z

← Starší verze		Verze z 20. 9. 2017, 13:53
Řádek 100:		Řádek 100:
	\|		\|
	\|}		\|}

			==== Return ====
			0 : OK
			100 : Item could not be created

	==== Example ====		==== Example ====
	<syntaxhighlight lang="sql">		<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
			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>		</syntaxhighlight>

	==== Notices ====		==== Notices ====
	None.		None.

2017-07-25T12:10:25Z

← Starší verze		Verze z 25. 7. 2017, 12:10
Řádek 19:		Řádek 19:
	\|int		\|int
	\|		\|
	\|~~Workshop~~ ID		\|ID of workshop from workshop list (see relation)
	(~~could be equal to ID in Your internal system~~)
	\|API_GetWorkshops.ID		\|API_GetWorkshops.ID
	\|-		\|-
Řádek 32:		Řádek 31:
	\|nvarchar(200)		\|nvarchar(200)
	\|		\|
	\|		\|Street
	\|		\|
	\|-		\|-
Řádek 38:		Řádek 37:
	\|nvarchar(120)		\|nvarchar(120)
	\|		\|
	\|		\|City
	\|		\|
	\|-		\|-
Řádek 44:		Řádek 43:
	\|nvarchar(15)		\|nvarchar(15)
	\|		\|
	\|		\|ZIPCode
	\|		\|
	\|-		\|-
Řádek 50:		Řádek 49:
	\|nvarchar(70)		\|nvarchar(70)
	\|		\|
	\|		\|Country
	\|		\|
	\|-		\|-
Řádek 56:		Řádek 55:
	\|nvarchar(70)		\|nvarchar(70)
	\|		\|
	\|		\|Region
	\|		\|
	\|-		\|-
Řádek 62:		Řádek 61:
	\|nvarchar(80)		\|nvarchar(80)
	\|		\|
	\|		\|State
	\|		\|
	\|-		\|-

2017-07-25T07:14:34Z

2017-07-24T16:25:08Z

2017-07-24T16:20:09Z

← Starší verze		Verze z 24. 7. 2017, 16:20
Řádek 68:		Řádek 68:
	\|int		\|int
	\|		\|
	\|ID of country		\|ID of country from country list (see relation)
	\|API_GetCountry.ID		\|API_GetCountry.ID
	\|-		\|-

2017-07-24T16:19:15Z

← Starší verze		Verze z 24. 7. 2017, 16:19
Řádek 1:		Řádek 1:
	==== Description ====		==== 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 ====		==== Exact name ====
Řádek 6:		Řádek 6:

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

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

2017-07-24T16:17:54Z

@@ Řádek 1: / Řádek 1: @@
 ==== Exact name ====
 <code>API_CreateBranch</code>
@@ Řádek 103: / Řádek 106: @@
 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'
 </syntaxhighlight>

2017-07-24T16:16:22Z

2017-07-24T16:16:08Z

← Starší verze		Verze z 24. 7. 2017, 16:16
Řádek 1:		Řádek 1:
			==== Exact name ====

	==== <code>API_CreateBranch</code> ====		==== <code>API_CreateBranch</code> ====

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

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

2017-07-24T16:15:02Z

@@ Řádek 1: / Řádek 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>