USP_DATAFORMTEMPLATE_EDIT_EDUCATIONALCONFIGURATION
The save procedure used by the edit dataform template "Educational Configuration Edit Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @USEACADEMICCATALOG | bit | IN | Use academic catalog |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EDUCATIONALCONFIGURATION (
@CHANGEAGENTID uniqueidentifier = null,
@USEACADEMICCATALOG bit
) as
set nocount on;
declare @CURRENTDATE datetime;
set @CURRENTDATE = getdate();
declare @EDUCATIONALCONFIGURATIONID uniqueidentifier;
select top 1
@EDUCATIONALCONFIGURATIONID = EDUCATIONALCONFIGURATION.ID
from
dbo.EDUCATIONALCONFIGURATION;
if @EDUCATIONALCONFIGURATIONID is not null begin
update
dbo.EDUCATIONALCONFIGURATION
set
USEACADEMICCATALOG = @USEACADEMICCATALOG,
CHANGEDBYID = @CHANGEAGENTID,
DATECHANGED = @CURRENTDATE
where
ID = @EDUCATIONALCONFIGURATIONID;
end
else begin
insert into dbo.EDUCATIONALCONFIGURATION (
USEACADEMICCATALOG,
ADDEDBYID,
CHANGEDBYID,
DATEADDED,
DATECHANGED
)
values (
@USEACADEMICCATALOG,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CURRENTDATE,
@CURRENTDATE
);
end
return 0;