USP_DATAFORMTEMPLATE_ADD_SOCIALMEDIASERVICE

CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SOCIALMEDIASERVICE (
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100) = '',
    @ICON varbinary(max) = null
)
as
    set nocount on;

    declare @CURRENTDATE datetime;

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

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

    set @CURRENTDATE = getdate();

    begin try

        insert into dbo.SOCIALMEDIASERVICE
        (
            ID,
            NAME,
            ISACTIVE,
            ISSYSTEM,
            ISSOCIALNETWORK,
            ICON,
            ADDEDBYID,
            CHANGEDBYID,
            DATEADDED,
            DATECHANGED
        )
        values
        (
            @ID,
            @NAME,
            1,
            0,
            0,
            @ICON,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            @CURRENTDATE,
            @CURRENTDATE
        );

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

    return 0;