USP_APPUSERPASSWORDRESETREQUESTEXCEPTION_ADD

Parameters

Parameter	Parameter Type	Mode
@EMAILADDRESS	nvarchar(100)	IN
@REASONCODE	tinyint	IN
@MESSAGE	nvarchar(1000)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_APPUSERPASSWORDRESETREQUESTEXCEPTION_ADD(
    @EMAILADDRESS nvarchar(100),
    @REASONCODE tinyint = 0,
    @MESSAGE nvarchar(1000) = '',
    @CHANGEAGENTID uniqueidentifier = null
)
as
begin

    set nocount on;

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


    insert into dbo.APPUSERPASSWORDRESETREQUESTEXCEPTION 
    (
        EMAILADDRESS,
        REASONCODE,
        MESSAGE,
        ADDEDBYID,
        CHANGEDBYID,
        DATEADDED,
        DATECHANGED
    )
    values
    (
        @EMAILADDRESS,
        @REASONCODE,
        @MESSAGE,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        getdate(),
        getdate()
    );

end;