USP_WPSOCIALMEDIASERVICE_ADD

create procedure dbo.USP_WPSOCIALMEDIASERVICE_ADD
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
  @NAME nvarchar(100),
  @ISACTIVE bit,
  @ICON varbinary(max)
)
as
begin

set nocount on;

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

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

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

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

end