API UpdateBranch: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 27: | Řádka 27: | ||
| | | | ||
|Workshops ID | |Workshops ID | ||
| − | ( | + | ID of workshops from workshops list (see relation) |
|API_GetWorkshops.ID | |API_GetWorkshops.ID | ||
|- | |- | ||
Verze z 25. 7. 2017, 08:12
Description
Method allows You to update branch in system.
Exact name
API_UpdateBranch
Type
Standard executable stored procedure.
Specification
| Parameter | Data type | Value range | Description | Relation |
|---|---|---|---|---|
| @ID | int | Branches ID
(could be equal to ID in Your internal system) |
API_GetBranches.ID | |
| @WorkshopID | int | Workshops ID
ID of workshops from workshops list (see relation) |
API_GetWorkshops.ID | |
| @Name | nvarchar(100) | Branch name | ||
| @Street | nvarchar(200) | Street | ||
| @City | nvarchar(120) | City | ||
| @ZIPCode | nvarchar(15) | ZIP Code | ||
| @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 | ||
| nvarchar(70) | ||||
| @Web | nvarchar(120) | Web address |
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
Notices
None.
