API UpdateBranch - Historie editací

Chrzaszcz v 20. 9. 2017, 13:54

2017-09-20T13:54:10Z

2017-08-07T13:43:05Z

2017-08-01T13:20:16Z

2017-07-25T07:12:52Z

2017-07-25T07:07:33Z

2017-07-24T13:14:03Z

2017-07-24T13:01:05Z

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

Nová stránka

'''API_UpdateBranch'''

''Example:''

@@ Řádka 108: / Řádka 108: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
   DECLARE @ID INT
   DECLARE @WorkshopID INT
@@ Řádka 145: / Řádka 149: @@
   WHERE  id = 3
-  EXECUTE [Api_updatebranch]
+  EXECUTE @return_value = [Api_updatebranch]
    @ID,
    @WorkshopID,

@@ Řádka 106: / Řádka 106: @@
 |Web address
+|
 |}

@@ Řádka 19: / Řádka 19: @@
 |int
+|
-|Branches ID
+|Internal system id
 |API_GetBranches.ID
 |-

@@ Řádka 27: / Řádka 27: @@
+|
 |Workshops ID
-(could be equal to ID in Your internal system)
+ID of workshops from workshops list (see relation)
 |API_GetWorkshops.ID
 |-

@@ Řádka 1: / Řádka 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
@@ Řádka 68: / Řádka 163: @@
    @Email,
    @Web

← Starší verze		Verze z 24. 7. 2017, 13:14
Řádka 1:		Řádka 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