USP_DATAFORMTEMPLATE_EDIT_ACADEMICCATALOGDIVISION

The save procedure used by the edit dataform template "Academic Catalog Division Edit 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.
@USERID	nvarchar(50)	IN	ID
@NAME	nvarchar(150)	IN	Name
@DATEFROM	UDT_FUZZYDATE	IN	Date from
@HISTORY	xml	IN	Catalog history
@MAKEHISTORICAL	bit	IN	Move to catalog history

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ACADEMICCATALOGDIVISION
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @USERID nvarchar(50),
    @NAME nvarchar(150),
    @DATEFROM dbo.UDT_FUZZYDATE,
    @HISTORY xml,
    @MAKEHISTORICAL bit
)
as
    set nocount on;

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

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

    begin try
        if @MAKEHISTORICAL = 1
        begin
            declare @NEWID uniqueidentifier;
            set @NEWID = newID();

            declare @ACADEMICCATALOGCOLLEGEID uniqueidentifier;
            select
                @ACADEMICCATALOGCOLLEGEID = ACADEMICCATALOGCOLLEGEID
            from
                dbo.ACADEMICCATALOGDIVISION
            where
                ID = @ID;

            insert into dbo.ACADEMICCATALOGDIVISION
            (
                ID,
                ACADEMICCATALOGCOLLEGEID,
                USERID,
                NAME,
                CURRENTID,
                DATEFROM,
                ISHISTORICAL,
                ADDEDBYID, 
                CHANGEDBYID, 
                DATEADDED, 
                DATECHANGED
            )
            values
            (
                @NEWID,
                @ACADEMICCATALOGCOLLEGEID,
                @USERID,
                @NAME,
                null,
                @DATEFROM,
                0,
                @CHANGEAGENTID,
                @CHANGEAGENTID,
                @CURRENTDATE,
                @CURRENTDATE
            );

            declare @DATETO dbo.UDT_FUZZYDATE;
            declare @HISTORYDATEFROM dbo.UDT_FUZZYDATE;
            select
                @DATETO = HISTORY.DATETO,
                @HISTORYDATEFROM = HISTORY.DATEFROM
            from
                dbo.UFN_ACADEMICCATALOG_GETHISTORY_FROMITEMLISTXML(@HISTORY) as HISTORY;

            exec dbo.USP_ACADEMICCATALOG_MAKEHISTORICAL 4, @NEWID, @ID, @HISTORYDATEFROM, @DATETO, @CHANGEAGENTID;
        end
        else
        begin    
            update dbo.ACADEMICCATALOGDIVISION
            set
                USERID = @USERID,
                NAME = @NAME,
                DATEFROM = @DATEFROM,
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = @CURRENTDATE
            where
                ID = @ID;
        end

        -- update the history

        exec dbo.USP_ACADEMICCATALOG_GETHISTORY_UPDATEFROMXML 4, @HISTORY, @CHANGEAGENTID;
    end try

    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;