USP_SOCIALMEDIASERVICE_DELETE

CREATE procedure dbo.USP_SOCIALMEDIASERVICE_DELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as
    set nocount on;

    begin try

        declare @ISSYSTEM bit = 0;
        select @ISSYSTEM = ISSYSTEM from dbo.SOCIALMEDIASERVICE where @ID = ID;

        if (@ISSYSTEM = 1)
        begin
            raiserror('BBERR_SOCIALMEDIASERVICE_DELETE_SYSTEMRECORD', 13, 1);
        end

        declare @ACCOUNTEXISTS bit = 0;
        select @ACCOUNTEXISTS = 1 from dbo.SOCIALMEDIAACCOUNT where SOCIALMEDIASERVICEID = @ID;

        if (@ACCOUNTEXISTS = 1)
        begin
            raiserror('BBERR_SOCIALMEDIASERVICE_DELETE_ACCOUNTEXISTS', 13, 1);
        end

        declare @BATCHACCOUNTEXISTS bit = 0;
        select @BATCHACCOUNTEXISTS = 1 from dbo.BATCHCONSTITUENTSOCIALMEDIAACCOUNT where SOCIALMEDIASERVICEID = @ID;

        if (@BATCHACCOUNTEXISTS = 1)
        begin
            raiserror('BBERR_SOCIALMEDIASERVICE_DELETE_BATCHACCOUNTEXISTS', 13, 1);
        end

        select @BATCHACCOUNTEXISTS = 1 from dbo.BATCHCONSTITUENTUPDATESOCIALMEDIAACCOUNT where SOCIALMEDIASERVICEID = @ID;

        if (@BATCHACCOUNTEXISTS = 1)
        begin
            raiserror('BBERR_SOCIALMEDIASERVICE_DELETE_BATCHACCOUNTEXISTS', 13, 1);
        end

        exec dbo.USP_SOCIALMEDIASERVICE_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;