USP_DATAFORMTEMPLATE_EDIT_MERCHANDISEPRODUCT

The save procedure used by the edit dataform template "Merchandise Item Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@PICTURE	varbinary	IN	Image
@PICTURETHUMBNAIL	varbinary	IN	Image thumbnail
@NAME	nvarchar(50)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@MERCHANDISEDEPARTMENTID	uniqueidentifier	IN	Department
@MERCHANDISEDEPARTMENTCATEGORYID	uniqueidentifier	IN	Category
@VENDORID	uniqueidentifier	IN	Vendor
@ISDISCOUNTABLE	bit	IN	Discounts allowed
@ONHANDQUANTITY	int	IN	Quantity
@ISACTIVE	bit	IN	Active
@PICTURECHANGED	bit	IN	Picture changed

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MERCHANDISEPRODUCT (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @PICTURE varbinary(max),
                    @PICTURETHUMBNAIL varbinary(max),
                    @NAME nvarchar(50),
                    @DESCRIPTION nvarchar(255),
                    @MERCHANDISEDEPARTMENTID uniqueidentifier,
                    @MERCHANDISEDEPARTMENTCATEGORYID uniqueidentifier,
                    @VENDORID uniqueidentifier,
                    @ISDISCOUNTABLE bit,
                    @ONHANDQUANTITY integer,
                    @ISACTIVE bit,
                    @PICTURECHANGED bit
                )
                as

                    set nocount on;
          declare @TAXID uniqueidentifier
          exec USP_DATAFORMTEMPLATE_EDITLOAD_MERCHANDISEPRODUCT
                @ID,
                @TAXID = @TAXID output

          exec USP_DATAFORMTEMPLATE_EDIT_MERCHANDISEPRODUCT_2
                @ID,
                @CHANGEAGENTID,
                @PICTURE,
                @PICTURETHUMBNAIL,
                @NAME,
                @DESCRIPTION,
                @MERCHANDISEDEPARTMENTID,
                @MERCHANDISEDEPARTMENTCATEGORYID,
                @VENDORID,
                @ISDISCOUNTABLE,
                @ONHANDQUANTITY,
                @ISACTIVE,
                @PICTURECHANGED,
                @TAXID

                return 0;