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
int
nvarchar(40)
nvarchar(35)
nvarchar(80)
int
nvarchar(100)
nvarchar(100)
nvarchar(100)
nvarchar(100)
varchar(150)
bit
decimal(19,6)
decimal(19,6)
int
nvarchar(3)
nvarchar(40)
nvarchar(50)
nvarchar(300)
decimal(19,6)
decimal(19,6)
varchar(250)
nvarchar(500)
int
decimal(18,2)
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.