API UpdateProductGroup

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

Description

Method allows You to update product group in system.

Exact name

API_UpdateProductGroup

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@ID int Internal system id API_GetProductGroups.ID
@ProductCode nvarchar(40) Product code
@TecDocCode nvarchar(35) TecDoc code
@TecDocBrandName nvarchar(80) TecDoc brand name
@TecDocBrandID int TecDoc brand ID
@GroupName nvarchar(100) Group name
@SubGoupName nvarchar(100) Sub goup name
@AssortmentName nvarchar(100) AssortmentName
@Name nvarchar(100) Name
@Name2 nvarchar(150) Name2
@IsNew bit Is new:

0 = Off,

1 = On

@PurchasePrice decimal(19,6) Purchase price
@RetailPrice decimal(19,6) Retail price
@IsArchiving int Is archiving
@SupplierID int Supplier ID API_GetCustomers.ID
@Prefix nvarchar(3) @Prefix
@SupplierProductCode nvarchar(40) Supplier product code
@ManufacturerSupplier nvarchar(50) Manufacturer supplier
@SupplierItemName nvarchar(300) Supplier item name
@BasicPrice decimal(19,6) Basic price
@SupplierRetailPrice decimal(19,6) Supplier retail price
@SupplierIsArchiving int Supplier is archiving
@Description nvarchar(250) Description
@EshopDescription nvarchar(500) Eshop description
@VATRate int ID of VAT rates from VAT rates list (see relation) API_GetVATRates.ID
@MinimumOrderablePieces decimal(18,2) Minimum orderable pieces
@UnitID int ID of unit from units list (see relation) API_GetUnits.ID
@IsSale bit Is sale:

0 = Off,

1 = On

@IsHiddenOnEshop bit Is hidden on eshop:

0 = Off,

1 = On

@InfoReturnOfGoods nvarchar(50) Info return of goods

Return

0 : OK
100 : Item could not be updated

Example

 DECLARE @return_value int
 DECLARE  @ID int
 DECLARE  @ProductCode nvarchar(40)
 DECLARE  @TecDocCode nvarchar(35)
 DECLARE  @TecDocBrandName nvarchar(80)
 DECLARE  @TecDocBrandID int
 DECLARE  @GroupName nvarchar(100)
 DECLARE  @SubGoupName nvarchar(100)
 DECLARE  @AssortmentName nvarchar(100)
 DECLARE  @Name nvarchar(100)
 DECLARE  @Name2 nvarchar(150)
 DECLARE  @IsNew bit
 DECLARE  @PurchasePrice decimal(19,6)
 DECLARE  @RetailPrice decimal(19,6)
 DECLARE  @IsArchiving int
 DECLARE  @SupplierID int
 DECLARE  @Prefix nvarchar(3)
 DECLARE  @SupplierProductCode nvarchar(40)
 DECLARE  @ManufacturerSupplier nvarchar(50)
 DECLARE  @SupplierItemName nvarchar(300)
 DECLARE  @BasicPrice decimal(19,6)
 DECLARE  @SupplierRetailPrice decimal(19,6)
 DECLARE  @SupplierIsArchiving int
 DECLARE  @Description nvarchar(250)
 DECLARE  @EshopDescription nvarchar(500)
 DECLARE  @VATRate int
 DECLARE  @MinimumOrderablePieces decimal(18,2)
 DECLARE  @UnitID int
 DECLARE  @IsSale bit
 DECLARE  @IsHiddenOnEshop bit
 DECLARE  @InfoReturnOfGoods nvarchar(50)

 
 
 SELECT @ID = [ID], 
       @ProductCode = [ProductCode],
       @TecDocCode = [TecDocCode],
       @TecDocBrandName = [TecDocBrandName],
       @TecDocBrandID = [TecDocBrandID],
       @GroupName = [GroupName],
       @SubGoupName = [SubGoupName],
       @AssortmentName = [AssortmentName],
       @Name = 'Name 2',
       @Name2 = [Name2],
       @IsNew = [IsNew],
       @PurchasePrice = [PurchasePrice],
       @RetailPrice = [RetailPrice],
       @Description = [Description],
       @EshopDescription = [EshopDescription],
       @VATRate = [VATRate],
       @MinimumOrderablePieces = [MinimumOrderablePieces],
       @UnitID = [UnitID],
       @IsArchiving = [IsArchiving],
       @IsSale = [IsSale],
       @IsHiddenOnEshop = [IsHiddenOnEshop]
 FROM   [API_GetProductGroups] 
 WHERE  id = 3


 SELECT @SupplierID = [SupplierID],
       @Prefix = [Prefix],
       @SupplierProductCode = [SupplierProductCode],
       @ManufacturerSupplier = [ManufacturerSupplier],
       @SupplierItemName = [SupplierItemName],
       @BasicPrice = [BasicPrice],
       @SupplierRetailPrice = [RetailPrice],
       @SupplierIsArchiving = [IsArchiving],
       @InfoReturnOfGoods = [InfoReturnOfGoods]
FROM [API_GetProducts]
WHERE GroupID = @ID and SupplierID = @SupplierID

 
 EXECUTE @return_value = [API_UpdateProductGroup] 
  @ID,
  @ProductCode,
  @TecDocCode,
  @TecDocBrandName,
  @TecDocBrandID,
  @GroupName,
  @SubGoupName,
  @AssortmentName,
  @Name,
  @Name2,
  @IsNew,
  @PurchasePrice,
  @RetailPrice,
  @IsArchiving,
  @SupplierID,
  @Prefix,
  @SupplierProductCode,
  @ManufacturerSupplier,
  @SupplierItemName,
  @BasicPrice,
  @SupplierRetailPrice,
  @SupplierIsArchiving,
  @Description,
  @EshopDescription,
  @VATRate,
  @MinimumOrderablePieces,
  @UnitID,
  @IsSale,
  @IsHiddenOnEshop,
  @InfoReturnOfGoods

Notices

None.