USP_DATAFORMTEMPLATE_EDITSAVE_WPSOCIAL

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@FULLNAME	nvarchar(600)	IN
@GENDER	int	IN
@LOCATION	nvarchar(2048)	IN
@OCCUPATION	nvarchar(1024)	IN
@COMPANY	nvarchar(2048)	IN

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_WPSOCIAL (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
            @FULLNAME nvarchar(600),
            @GENDER int,
            @LOCATION nvarchar(2048),
            @OCCUPATION nvarchar(1024),
            @COMPANY nvarchar(2048)
            ) as begin

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

                        declare @CURRENTDATE datetime
                        set @CURRENTDATE = getdate()

            update dbo.WPSOCIAL set
              FULLNAME = @FULLNAME,
              GENDERCODE = @GENDER,
              LOCATION = @LOCATION,
              OCCUPATION = @OCCUPATION,
              COMPANY = @COMPANY,
              CHANGEDBYID = @CHANGEAGENTID,
              DATECHANGED = @CURRENTDATE
            where @ID = ID

            return 0;
          end