API UpdateBranch - Historie editací

Chrzaszcz v 20. 9. 2017, 13:54

2017-09-20T13:54:10Z

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

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

	==== Example ====		==== Example ====
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
			DECLARE @return_value int
	DECLARE @ID INT		DECLARE @ID INT
	DECLARE @WorkshopID INT		DECLARE @WorkshopID INT
Řádek 145:		Řádek 149:
	WHERE id = 3		WHERE id = 3

	EXECUTE [Api_updatebranch]		EXECUTE @return_value = [Api_updatebranch]
	@ID,		@ID,
	@WorkshopID,		@WorkshopID,

2017-08-07T13:43:05Z

2017-08-01T13:20:16Z

← Starší verze		Verze z 1. 8. 2017, 13:20
Řádek 19:		Řádek 19:
	\|int		\|int
	\|		\|
	\|~~Branches ID~~		\|Internal system id
	~~(could be equal to ID in Your internal~~ system)
	\|API_GetBranches.ID		\|API_GetBranches.ID
	\|-		\|-

2017-07-25T07:12:52Z

← Starší verze		Verze z 25. 7. 2017, 07:12
Řádek 27:		Řádek 27:
	\|		\|
	\|Workshops ID		\|Workshops ID
	(~~could be equal to ID in Your internal system~~)		ID of workshops from workshops list (see relation)
	\|API_GetWorkshops.ID		\|API_GetWorkshops.ID
	\|-		\|-

2017-07-25T07:07:33Z

@@ Řádek 1: / Řádek 1: @@
-'''API_UpdateBranch'''
+==== Description ====
- @ID int - API_GetBranches.ID
+Method allows You to update branch in system.
-''Example:''
+==== Type ====
   DECLARE @ID INT
   DECLARE @WorkshopID INT
@@ Řádek 68: / Řádek 163: @@
    @Email,
    @Web

2017-07-24T13:14:03Z

← Starší verze		Verze z 24. 7. 2017, 13:14
Řádek 1:		Řádek 1:
	'''API_UpdateBranch'''		'''API_UpdateBranch'''
			@ID int - API_GetBranches.ID
			@WorkshopID int - API_GetWorkshops.ID
			@Name nvarchar(100)
			@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)


	''Example:''		''Example:''
			DECLARE @ID INT
			DECLARE @WorkshopID INT
			DECLARE @Name NVARCHAR(100)
			DECLARE @Street NVARCHAR(200)
			DECLARE @City NVARCHAR(120)
			DECLARE @ZIPCode NVARCHAR(15)
			DECLARE @Country NVARCHAR(70)
			DECLARE @Region NVARCHAR(70)
			DECLARE @State NVARCHAR(80)
			DECLARE @StateID INT
			DECLARE @Phone NVARCHAR(50)
			DECLARE @Fax NVARCHAR(50)
			DECLARE @MobilePhone NVARCHAR(50)
			DECLARE @Email NVARCHAR(70)
			DECLARE @Web NVARCHAR(120)

			SELECT @ID = id,
			@WorkshopID = [workshopid],
			@Name = 'Name2',
			@Street = [street],
			@City = [city],
			@ZIPCode = [zipcode],
			@Country = [country],
			@Region = [region],
			@State = [state],
			@StateID = [stateid],
			@Phone = [phone],
			@Fax = [fax],
			@MobilePhone = [mobilephone],
			@Email = [email],
			@Web = [web]
			FROM [api_getbranches]
			WHERE id = 3

			EXECUTE [Api_updatebranch]
			@ID,
			@WorkshopID,
			@Name,
			@Street,
			@City,
			@ZIPCode,
			@Country,
			@Region,
			@State,
			@StateID,
			@Phone,
			@Fax,
			@MobilePhone,
			@Email,
			@Web

2017-07-24T13:01:05Z

Založena nová stránka s textem „'''API_UpdateBranch''' ''Example:''“

Nová stránka

'''API_UpdateBranch'''

''Example:''