Zobrazení zdroje stránky API UpdateProviderInformations

==== Description ====
Method allows You to update provider informations in system.

==== Exact name ====
<code>API_UpdateProviderInformations</code>

==== Type ====
Standard executable stored procedure.

==== Specification ====
{| class="wikitable"
!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
|char(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
|
|}


==== Example ====
<syntaxhighlight lang="sql">
 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 char(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 [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

</syntaxhighlight>

==== Notices ====
None.