USP_DATAFORMTEMPLATE_EDIT_SOCIALNETWORK

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SOCIALNETWORK (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
  @PUBLISHCALLTEXT nvarchar(500), 
  @PUBLISHMESSAGETEXT nvarchar(500), 
  @MISSIONCALLTEXT nvarchar(500), 
  @MISSIONTEXT nvarchar(500), 
  @PUBLISHLOGO int,
  @ISEMPTY bit
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()
  set @ISEMPTY = 0

    begin try
        -- handle updating the data
        update dbo.FAFEVENTSOCIALNETWORKPROPERTY 
    set
        PUBLISHCALLTEXT = @PUBLISHCALLTEXT,
    PUBLISHMESSAGETEXT = @PUBLISHMESSAGETEXT,
    MISSIONCALLTEXT = @MISSIONCALLTEXT,
    MISSIONTEXT = @MISSIONTEXT,
    PUBLISHLOGO = @PUBLISHLOGO,
    ISEMPTY = @ISEMPTY,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE

        from dbo.FAFEVENTSOCIALNETWORKPROPERTY (NOLOCK)
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;