API UpdateProviderInformations

Z Podpora.nextis.cz
Přejít na: navigace, hledání

Description

Method allows You to update provider informations in system.

Exact name

API_UpdateProviderInformations

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@ID int Internal system id
@Name nvarchar(150) Provider 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
@Phone2 nvarchar(50) Phone 2
@Fax nvarchar(50) Fax
@MobilePhone nvarchar(50) Mobile phone
@Email nvarchar(70) Email
@Email2 nvarchar(70) Email 2
@Web nvarchar(150) Web address
@CompanyRegistrationNumber nvarchar(20) Company registration number
@VATNumber nvarchar(25) VAT Number
@VATNumber2 nvarchar(20) VAT Number 2
@IsVATPayer int Is VAT Payer
@FileMark nvarchar(50) File mark
@FileMark2 nvarchar(50) File mark 2
@FileMark3 nvarchar(50) File mark 3
@FileMark4 nvarchar(50) File mark 4

Return

0 : OK
100 : Item could not be updated

Example

 DECLARE @return_value int
 DECLARE @ID int 
 DECLARE @Name nvarchar(150)
 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 @Phone2 nvarchar(50)
 DECLARE @Fax nvarchar(50)
 DECLARE @MobilePhone nvarchar(50)
 DECLARE @Email nvarchar(70)
 DECLARE @Email2 nvarchar(70)
 DECLARE @Web nvarchar(150)
 DECLARE @CompanyRegistrationNumber nvarchar(20)
 DECLARE @VATNumber nvarchar(25)
 DECLARE @VATNumber2 nvarchar(20)
 DECLARE @IsVATPayer int
 DECLARE @FileMark nvarchar(50)
 DECLARE @FileMark2 nvarchar(50)
 DECLARE @FileMark3 nvarchar(50)
 DECLARE @FileMark4 nvarchar(50)
 
 SELECT @ID = [ID], 
       @Name = [Name],
       @Street = [Street],
       @City = [City],
       @ZIPCode = [ZIPCode],
       @Country = [Country],
       @Region = [Region],
       @State = [State],
       @StateID = [StateID],
       @Phone = [Phone],
       @Phone2 = [Phone2],
       @Fax = [Fax],
       @MobilePhone = [MobilePhone],
       @Email = [Email],
       @Email2 = [Email2],
       @Web = [Web],
       @CompanyRegistrationNumber = [CompanyRegistrationNumber],
       @VATNumber = [VATNumber],
       @VATNumber2 = [VATNumber2],
       @IsVATPayer = [IsVATPayer],
       @FileMark = [FileMark],
       @FileMark2 = [FileMark2],
       @FileMark3 = [FileMark3],
       @FileMark4 = [FileMark4]
 FROM   [API_GetProviderInformations] 
 WHERE  id = 3
 
 EXECUTE @return_value = [API_UpdateProviderInformations] 
  @ID, 
  @Name,
  @Street,
  @City,
  @ZIPCode,
  @Country,
  @Region,
  @State,
  @StateID,
  @Phone,
  @Phone2,
  @Fax,
  @MobilePhone,
  @Email,
  @Email2,
  @Web,
  @CompanyRegistrationNumber,
  @VATNumber,
  @VATNumber2,
  @IsVATPayer,
  @FileMark,
  @FileMark2,
  @FileMark3,
  @FileMark4

Notices

None.