API UpdateProductGroup

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	varchar(150)		Name2
@IsNew	bit		Is new
@PurchasePrice	decimal(19,6)		Purchase price
@RetailPrice	decimal(19,6)		Retail price
@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
@Description	varchar(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

Example

 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 varchar(150)
 DECLARE  @IsNew bit
 DECLARE  @PurchasePrice decimal(19,6)
 DECLARE  @RetailPrice decimal(19,6)
 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  @Description varchar(250)
 DECLARE  @EshopDescription nvarchar(500)
 DECLARE  @VATRate int
 DECLARE  @MinimumOrderablePieces decimal(18,2)
 DECLARE  @UnitID int

 
 
 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]
 FROM   [API_GetProductGroups] 
 WHERE  id = 3


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

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

Notices

None.