Chrzaszcz v 9. 11. 2018, 13:27

2018-11-09T13:27:25Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update payment in system. ==== Exact name ==== `API_UpdatePayment` ==== Type ==== Standard executab…“

2018-04-30T13:39:12Z

Založena nová stránka s textem „==== Description ==== Method allows You to update payment in system. ==== Exact name ==== <code>API_UpdatePayment</code> ==== Type ==== Standard executab…“

Nová stránka

==== Description ====
Method allows You to update payment in system.

==== Exact name ====
<code>API_UpdatePayment</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|API_GetPayments.ID
|-
|@DocumentID
|int
|
|ID of invoices from invoices list (see relation)
|API_GetInvoices.ID
|-
|@CurrencyID
|int
|
|ID of currency from currency list (see relation)
|API_GetCurrency.ID
|-
|@CurrencyIDInCurrency
|int
|
|ID of currency from currency list (see relation)
|API_GetCurrency.ID
|-
|@ExchangeRate
|decimal(18,6)
|
|Exchange rate
|
|-
|@Price
|decimal(19,4)
|
|Price
|
|-
|@PriceInCurrency
|decimal(18,4)
|
|Price in currency
|
|-
|@Note
|varchar(150)
|
|Note
|
|-
|@Purpose
|varchar(150)
|
|Purpose
|
|}

==== Return ====
0 : OK
100 : Item could not be updated

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @return_value int
DECLARE @ID int
DECLARE @CurrencyID int
DECLARE @CurrencyIDInCurrency int
DECLARE @ExchangeRate decimal(18, 6)
DECLARE @Price decimal(19, 4)
DECLARE @PriceInCurrency decimal(18, 4)
DECLARE @Note varchar(150)
DECLARE @Purpose varchar(150)

SELECT @ID = [ID],
@CurrencyID = [CurrencyID]
@CurrencyIDInCurrency = [CurrencyIDInCurrency]
@ExchangeRate = [ExchangeRate]
@Price = 0
@PriceInCurrency = 0
@Note = ''
@Purpose = ''
FROM [API_GetPayments]
WHERE DocumentID = 1

EXECUTE @return_value = [API_UpdatePayment]
@ID,
@CurrencyID
@CurrencyIDInCurrency
@ExchangeRate
@Price
@PriceInCurrency
@Note
@Purpose

</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 59: / Řádka 59: @@
 |-
 |@Note
-|varchar(150)
+|nvarchar(150)
+|
 |Note
@@ Řádka 65: / Řádka 65: @@
 |-
 |@Purpose
-|varchar(150)
+|nvarchar(150)
+|
 |Purpose
@@ Řádka 85: / Řádka 85: @@
   DECLARE @Price decimal(19, 4)
   DECLARE @PriceInCurrency decimal(18, 4)
-  DECLARE @Note  varchar(150)
+  DECLARE @Note  nvarchar(150)
-  DECLARE @Purpose varchar(150)
+  DECLARE @Purpose nvarchar(150)

API UpdatePayment - Historie editací

Chrzaszcz v 9. 11. 2018, 13:27

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update payment in system. ==== Exact name ==== API_UpdatePayment ==== Type ==== Standard executab…“

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update payment in system. ==== Exact name ==== `API_UpdatePayment` ==== Type ==== Standard executab…“