USP_DATAFORMTEMPLATE_EDIT_SALESORDERITEMFACILITY_OVERRIDE
The save procedure used by the edit dataform template "Sales Order Item Facility Override 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. |
| @PRICE | money | IN | Cost |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SALESORDERITEMFACILITY_OVERRIDE
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@PRICE money
)
as
set nocount on;
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()
begin try
--if @PRICE <> 0.0
begin
-- handle updating the data
update dbo.SALESORDERITEM set
FLATRATEPRICE = @PRICE,
CHANGEDBYID = @CHANGEAGENTID,
DATECHANGED = @CURRENTDATE
where
ID = @ID
declare @ORDERID uniqueidentifier
select
@ORDERID = SALESORDERID
from dbo.SALESORDERITEM
where
SALESORDERITEM.ID = @ID
-- recalculate taxes
exec dbo.USP_SALESORDER_CALCULATETAXES @ORDERID, @CHANGEAGENTID;
end
--else
-- exec dbo.USP_SALESORDERITEM_DELETE @ID, @CHANGEAGENTID;
end try
begin catch
exec dbo.USP_RAISE_ERROR
return 1
end catch
return 0;