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_GetBranches.ID
@ID	int
@ProductCode	nvarchar(40)
@TecDocCode	nvarchar(35)
@TecDocBrandName	nvarchar(80)
@TecDocBrandID	int
@GroupName	nvarchar(100)
@SubGoupName	nvarchar(100)
@AssortmentName	nvarchar(100)
@Name	nvarchar(100)
@Name2	varchar(150)
@IsNew	bit
@PurchasePrice	decimal(19,6)
@RetailPrice	decimal(19,6)
@SupplierID	int
@Prefix	nvarchar(3)
@SupplierProductCode	nvarchar(40)
@ManufacturerSupplier	nvarchar(50)
@SupplierItemName	nvarchar(300)
@BasicPrice	decimal(19,6)
@SupplierRetailPrice	decimal(19,6)
@Description	varchar(250)
@EshopDescription	nvarchar(500)
@VATRate	int
@MinimumOrderablePieces	decimal(18,2)
@UnitID	int

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.