USP_DATAFORMTEMPLATE_EDIT_CMSUSER_SOCIALPROFILE

The save procedure used by the edit dataform template "CMS User Social Profile Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	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.
@POINTS	int	IN	Points
@LASTLOGINDATE	datetime	IN	Last login date

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CMSUSER_SOCIALPROFILE (
    @ID int,
    @CHANGEAGENTID uniqueidentifier = null,
    @POINTS int,
    @LASTLOGINDATE datetime
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        -- handle updating the data


        declare @SOCIALID uniqueidentifier = null
        select @SOCIALID = ID from dbo.CMSUSERSOCIALPROFILE where CMSUSERID = @ID

        if @SOCIALID is null
        begin
            insert into dbo.CMSUSERSOCIALPROFILE (CMSUSERID, POINTS, LASTLOGINDATE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
            values (@ID, isnull(@POINTS,0), @LASTLOGINDATE, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
        end
        else
        begin
            if @POINTS is not null
                update dbo.CMSUSERSOCIALPROFILE set POINTS = @POINTS where ID = @SOCIALID

            if @LASTLOGINDATE is not null
                update dbo.CMSUSERSOCIALPROFILE set LASTLOGINDATE = @LASTLOGINDATE where ID = @SOCIALID 
        end


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

return 0;