USP_DATAFORMTEMPLATE_EDITLOAD_SALESORDERALERTCONFIGURATION_BYAPPUSER

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SALESORDERALERTCONFIGURATION_BYAPPUSER(
    @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
    @ALERTONDAILYADMISSION bit = null output,
    @ALERTONSCHEDULEDPROGRAM bit = null output,
    @ALERTONSPECIALEVENT bit = null output,
    @ALERTONDONATION bit = null output,
    @ALERTONMEMBERSHIP bit = null output
)
as
    set nocount on;

    --If there are no settings, it just means this user hasn't configured their settings. Don't error
    set @DATALOADED = 1
    set @TSLONG = 0

    select
        @TSLONG = SALESORDERALERTCONFIGURATION.TSLONG,
        @EMAILADDRESS = SALESORDERALERTEMAILADDRESS.EMAILADDRESS,
        @ALERTONDONATION = SALESORDERALERTCONFIGURATION.ALERTONDONATION,
        @ALERTONSCHEDULEDPROGRAM = SALESORDERALERTCONFIGURATION.ALERTONSCHEDULEDPROGRAM,
        @ALERTONDAILYADMISSION = SALESORDERALERTCONFIGURATION.ALERTONDAILYADMISSION,
        @ALERTONMEMBERSHIP = SALESORDERALERTCONFIGURATION.ALERTONMEMBERSHIP,
        @ALERTONSPECIALEVENT = SALESORDERALERTCONFIGURATION.ALERTONSPECIALEVENT
    from dbo.SALESORDERALERTEMAILADDRESS
    inner join dbo.SALESORDERALERTEMAILSUBSCRIPTION on
        SALESORDERALERTEMAILADDRESS.ID = SALESORDERALERTEMAILSUBSCRIPTION.SALESORDERALERTEMAILADDRESSID
    inner join dbo.SALESORDERALERTCONFIGURATION on
        SALESORDERALERTEMAILSUBSCRIPTION.SALESORDERALERTCONFIGURATIONID = SALESORDERALERTCONFIGURATION.ID
    where SALESORDERALERTEMAILADDRESS.APPUSERID = @CURRENTAPPUSERID

    if isnull(@EMAILADDRESS,'') = ''
    begin
        select @EMAILADDRESS = EMAILADDRESS
        from dbo.APPUSER
        where ID = @CURRENTAPPUSERID
    end

    return 0;