API UpdateVATRate - Historie editací

Chrzaszcz v 22. 9. 2017, 08:45

2017-09-22T08:45:40Z

Chrzaszcz v 2. 8. 2017, 07:33

2017-08-02T07:33:26Z

Chrzaszcz v 2. 8. 2017, 07:09

2017-08-02T07:09:13Z

Chrzaszcz v 2. 8. 2017, 06:56

2017-08-02T06:56:06Z

Chrzaszcz v 2. 8. 2017, 06:55

2017-08-02T06:55:10Z

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

2017-08-02T06:52:57Z

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

Nová stránka

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

==== Exact name ====
<code>API_UpdateBranch</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|API_GetBranches.ID
|-
|@WorkshopID
|int
|
|Workshops ID
ID of workshops from workshops list (see relation)
|API_GetWorkshops.ID
|-
|@Name
|nvarchar(100)
|
|Branch name
|
|}

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @ID INT
DECLARE @WorkshopID INT

SELECT @ID = id,
@WorkshopID = [workshopid],
@Name = 'Name2',

FROM [api_getbranches]
WHERE id = 3

EXECUTE [Api_updatebranch]
@ID,
@WorkshopID,

</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 41: / Řádka 41: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
 DECLARE @ID int
 DECLARE @Name nvarchar(50)
@@ Řádka 56: / Řádka 60: @@
   WHERE  id = 10
-  EXECUTE [API_UpdateVATRate]
+  EXECUTE @return_value = [API_UpdateVATRate]
    @ID,
    @Name,

@@ Řádka 49: / Řádka 49: @@
 DECLARE @IsActive int
-  SELECT @ID = ID
+  SELECT @ID = [ID]
-         @Name = Name
+         @Name = [Name]
          @Value = 15
-         @IsActive = IsActive
+         @IsActive = [IsActive]
   FROM   [API_GetVATRates]
   WHERE  id = 10

@@ Řádka 28: / Řádka 28: @@
 ID of workshops from workshops list (see relation)
+|
 |@Name
 |nvarchar(50)

@@ Řádka 1: / Řádka 1: @@
 ==== Description ====
-Method allows You to update branch in system.
+Method allows You to update VAT rate in system.
 ==== Exact name ====
-<code>API_UpdateBranch</code>
+<code>API_UpdateVATRate</code>
 ==== Type ====
@@ Řádka 20: / Řádka 20: @@
+|
 |Internal system id
+|
 |-
@@ Řádka 51: / Řádka 44: @@
 ==== Example ====
 <syntaxhighlight lang="sql">
- DECLARE @ID INT
+DECLARE @ID int
- DECLARE @WorkshopID INT
+DECLARE @Name nvarchar(50)
-  SELECT @ID = id,
+  SELECT @ID = ID
-       @WorkshopID = [workshopid],
+        @Name = Name
-       @Name = 'Name2',
+        @Value = 15
+        @IsActive = IsActive
-  FROM   [api_getbranches]
+  FROM   [API_GetVATRates]
-  WHERE  id = 3
+  WHERE  id = 10
-  EXECUTE [Api_updatebranch]
+  EXECUTE [API_UpdateVATRate]
    @ID,
-   @WorkshopID,
+   @Name,
 </syntaxhighlight>

@@ Řádka 20: / Řádka 20: @@
+|
 |Internal system id
-|API_GetBranches.ID
 |-
 |@WorkshopID
@@ Řádka 27: / Řádka 27: @@
 |Workshops ID
 ID of workshops from workshops list (see relation)
-|API_GetWorkshops.ID
 |-
-|@Name
+|@IsActive
-|nvarchar(100)
+|int
+|
-|Branch name
+|Is active
+|
 |}