API UpdateWorkshop

Description

Method allows You to update workshop in system.

Exact name

API_UpdateWorkshop

Type

Standard executable stored procedure.

Specification

Parameter	Data type	Value range	Description	Relation
@ID	int		Internal system id
@Name	nvarchar(250)		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
@PhoneNumber	nvarchar(50)		Phone number
@Fax	nvarchar(50)		Fax
@MobilePhone	nvarchar(50)		MobilePhone
@Email	nvarchar(70)		Email
@Web	nvarchar(120)		Web

Return

0 : OK
100 : Item could not be updated

Example

 DECLARE @return_value int
 DECLARE @ID int 
 DECLARE @Name nvarchar(250)
 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 @PhoneNumber nvarchar(50)
 DECLARE @Fax nvarchar(50)
 DECLARE @MobilePhone nvarchar(50)
 DECLARE @Email nvarchar(70)
 DECLARE @Web nvarchar(150)
 
 SELECT @ID = [ID], 
       @Name = 'Name 2',
       @Street = [Street],
       @City = [City],
       @ZIPCode = [ZIPCode],
       @Country = [Country],
       @Region = [Region],
       @State = [State],
       @StateID = [StateID],
       @PhoneNumber = [PhoneNumber],
       @Fax = [Fax],
       @MobilePhone = [MobilePhone],
       @Email = [Email],
       @Web = [Web]
 FROM   [API_GetWorkshops] 
 WHERE  id = 1
 
 EXECUTE @return_value = [API_UpdateWorkshop] 
  @ID, 
  @Name,
  @Street,
  @City,
  @ZIPCode,
  @Country,
  @Region,
  @State,
  @StateID,
  @PhoneNumber,
  @Fax,
  @MobilePhone,
  @Email,
  @Web

Notices

None.