API UpdateProviderInformations - Historie editací

Chrzaszcz v 9. 11. 2018, 14:50

2018-11-09T14:50:05Z

Chrzaszcz v 20. 9. 2017, 13:51

2017-09-20T13:51:40Z

Chrzaszcz v 2. 8. 2017, 14:46

2017-08-02T14:46:03Z

Chrzaszcz v 2. 8. 2017, 14:44

2017-08-02T14:44:59Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update provider informations in system. ==== Exact name ==== `API_UpdateProviderInformations` ====…“

2017-08-02T14:43:16Z

Založena nová stránka s textem „==== Description ==== Method allows You to update provider informations in system. ==== Exact name ==== <code>API_UpdateProviderInformations</code> ====…“

Nová stránka

==== 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.

@@ Řádka 125: / Řádka 125: @@
 |-
 |@VATNumber2
-|char(20)
+|nvarchar(20)
+|
 |VAT Number 2
@@ Řádka 187: / Řádka 187: @@
   DECLARE @CompanyRegistrationNumber nvarchar(20)
   DECLARE @VATNumber nvarchar(25)
-  DECLARE @VATNumber2 char(20)
+  DECLARE @VATNumber2 nvarchar(20)
   DECLARE @IsVATPayer int
   DECLARE @FileMark nvarchar(50)

@@ Řádka 161: / Řádka 161: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
   DECLARE @ID int
   DECLARE @Name nvarchar(150)
@@ Řádka 216: / Řádka 221: @@
   WHERE  id = 3
-  EXECUTE [API_UpdateProviderInformations]
+  EXECUTE @return_value = [API_UpdateProviderInformations]
    @ID,
    @Name,

@@ Řádka 22: / Řádka 22: @@
+|
 |-
-|Name
+|@Name
 |nvarchar(150)
+|
@@ Řádka 28: / Řádka 28: @@
+|
 |-
-|Street
+|@Street
 |nvarchar(200)
+|
@@ Řádka 34: / Řádka 34: @@
+|
 |-
-|City
+|@City
 |nvarchar(120)
+|
@@ Řádka 40: / Řádka 40: @@
+|
 |-
-|ZIPCode
+|@ZIPCode
 |nvarchar(15)
+|
@@ Řádka 46: / Řádka 46: @@
+|
 |-
-|Country
+|@Country
 |nvarchar(70)
+|
@@ Řádka 52: / Řádka 52: @@
+|
 |-
-|Region
+|@Region
 |nvarchar(70)
+|
@@ Řádka 58: / Řádka 58: @@
+|
 |-
-|State
+|@State
 |nvarchar(80)
+|
@@ Řádka 64: / Řádka 64: @@
+|
 |-
-|StateID
+|@StateID
 |int
+|
@@ Řádka 70: / Řádka 70: @@
 |API_GetCountry.ID
 |-
-|Phone
+|@Phone
 |nvarchar(50)
+|
@@ Řádka 76: / Řádka 76: @@
+|
 |-
-|Phone2
+|@Phone2
 |nvarchar(50)
+|
@@ Řádka 82: / Řádka 82: @@
+|
 |-
-|Fax
+|@Fax
 |nvarchar(50)
+|
@@ Řádka 88: / Řádka 88: @@
+|
 |-
-|MobilePhone
+|@MobilePhone
 |nvarchar(50)
+|
@@ Řádka 94: / Řádka 94: @@
+|
 |-
-|Email
+|@Email
 |nvarchar(70)
+|
@@ Řádka 100: / Řádka 100: @@
+|
 |-
-|Email2
+|@Email2
 |nvarchar(70)
+|
@@ Řádka 106: / Řádka 106: @@
+|
 |-
-|Web
+|@Web
 |nvarchar(150)
+|
@@ Řádka 112: / Řádka 112: @@
+|
 |-
-|CompanyRegistrationNumber
+|@CompanyRegistrationNumber
 |nvarchar(20)
+|
@@ Řádka 118: / Řádka 118: @@
+|
 |-
-|VATNumber
+|@VATNumber
 |nvarchar(25)
+|
@@ Řádka 124: / Řádka 124: @@
+|
 |-
-|VATNumber2
+|@VATNumber2
 |char(20)
+|
@@ Řádka 130: / Řádka 130: @@
+|
 |-
-|IsVATPayer
+|@IsVATPayer
 |int
+|
@@ Řádka 136: / Řádka 136: @@
+|
 |-
-|FileMark
+|@FileMark
 |nvarchar(50)
+|
@@ Řádka 142: / Řádka 142: @@
+|
 |-
-|FileMark2
+|@FileMark2
 |nvarchar(50)
+|
@@ Řádka 148: / Řádka 148: @@
+|
 |-
-|FileMark3
+|@FileMark3
 |nvarchar(50)
+|
@@ Řádka 154: / Řádka 154: @@
+|
 |-
-|FileMark4
+|@FileMark4
 |nvarchar(50)
+|