USP_DATAFORMTEMPLATE_ADD_WORKSTATIONCASHDRAWEROPEN

The save procedure used by the add dataform template "Workstation Cash Drawer Open Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@WORKSTATIONID	uniqueidentifier	IN	Workstation
@WORKSTATIONCASHDRAWEROPENREASONCODEID	uniqueidentifier	IN	Reason
@COMMENTS	nvarchar(255)	IN	Comment
@WORKSTATIONMACHINENAME	nvarchar(255)	IN	Workstation name

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_WORKSTATIONCASHDRAWEROPEN
(
    @ID uniqueidentifier = null output,    
    @CHANGEAGENTID uniqueidentifier = null,
    @CURRENTAPPUSERID uniqueidentifier = null,
    @WORKSTATIONID uniqueidentifier = null,
    @WORKSTATIONCASHDRAWEROPENREASONCODEID uniqueidentifier = null,
    @COMMENTS nvarchar(255) = '',
    @WORKSTATIONMACHINENAME nvarchar(255) = ''
)
as

set nocount on;

if @ID is null
    set @ID = newid()

if @CHANGEAGENTID is null  
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

begin try
    -- handle inserting the data


    if @WORKSTATIONID is null
        select @WORKSTATIONID = ID from dbo.WORKSTATION where MACHINENAME = @WORKSTATIONMACHINENAME        

    insert into dbo.WORKSTATIONCASHDRAWEROPEN
        (ID, WORKSTATIONID, APPUSERID, WORKSTATIONCASHDRAWEROPENREASONCODEID, COMMENTS, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    values
        (@ID, @WORKSTATIONID, @CURRENTAPPUSERID, @WORKSTATIONCASHDRAWEROPENREASONCODEID, @COMMENTS, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0