USP_RECORDOPERATION_MODELSCORESGLOBALDELETE

CREATE procedure dbo.USP_RECORDOPERATION_MODELSCORESGLOBALDELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin

  --Modeling and Propensity is set back to default value. Guids need to be updated here, in the prompt, and in the ModelScoresPropensityAndRatings.SimpleList.vb.

    if(@ID = '10000000-0000-0000-0000-000000000000')  
        update dbo.MODELINGANDPROPENSITY set ANNUALGIFTLIKELIHOOD = -1
        where ANNUALGIFTLIKELIHOOD <>-1;  
    else if(@ID = '20000000-0000-0000-0000-000000000000')  
        update dbo.MODELINGANDPROPENSITY set ANNUITYLIKELIHOOD = -1
        where ANNUITYLIKELIHOOD <> -1;  
    else if(@ID = '30000000-0000-0000-0000-000000000000')  
        update dbo.MODELINGANDPROPENSITY set BEQUESTLIKELIHOOD = -1
        where BEQUESTLIKELIHOOD <> -1;  
    else if(@ID = '40000000-0000-0000-0000-000000000000')  
        update dbo.MODELINGANDPROPENSITY set CRTLIKELIHOOD = -1
        where CRTLIKELIHOOD <> -1;  
    else if(@ID = '50000000-0000-0000-0000-000000000000')  
        update dbo.MODELINGANDPROPENSITY set MAJORGIVINGLIKELIHOOD = -1
        where MAJORGIVINGLIKELIHOOD <> -1;  
    else if(@ID = '60000000-0000-0000-0000-000000000000')  
        update dbo.MODELINGANDPROPENSITY set MEMBERSHIPLIKELIHOOD = -1
        where MEMBERSHIPLIKELIHOOD <> -1;  
    else if(@ID = '70000000-0000-0000-0000-000000000000')  
        update dbo.MODELINGANDPROPENSITY set ONLINEGIVINGLIKELIHOOD = -1
        where ONLINEGIVINGLIKELIHOOD <> -1;  
     else if(@ID = '80000000-0000-0000-0000-000000000000')  
        update dbo.MODELINGANDPROPENSITY set PATIENTRESPONSELIKELIHOOD = -1
        where PATIENTRESPONSELIKELIHOOD <> -1;  
     else if(@ID = '90000000-0000-0000-0000-000000000000')  
        update dbo.MODELINGANDPROPENSITY set PLANNEDGIFTLIKELIHOOD = -1
        where PLANNEDGIFTLIKELIHOOD <> -1;  
     else if(@ID = 'A0000000-0000-0000-0000-000000000000')  
        update dbo.MODELINGANDPROPENSITY set SUGGESTEDMEMBERSHIPLEVELID = null
        where SUGGESTEDMEMBERSHIPLEVELID is not null;  
     else if(@ID = 'B0000000-0000-0000-0000-000000000000')  
        update dbo.MODELINGANDPROPENSITY set NCOAMOVEDINDICATOR = 0
        where NCOAMOVEDINDICATOR <> 0;  
     else if(@ID = 'C0000000-0000-0000-0000-000000000000')  
        update dbo.MODELINGANDPROPENSITY set WEALTHESTIMATORRATINGID = null
        where WEALTHESTIMATORRATINGID is not null;  
     else if(@ID = 'D0000000-0000-0000-0000-000000000000')  
        update dbo.MODELINGANDPROPENSITY set TARGETGIFTRANGEID = null
        where TARGETGIFTRANGEID is not null;  
  --Attributes require a dynamic delete using the guid to find their specific table.  

 else  
 begin  
    declare @ATTRIBUTEID nvarchar(32) = REPLACE(CAST(@ID as nvarchar(36)), '-', '');  
    declare @ATTRIBUTECLEARSQL nvarchar(200) = REPLACE('truncate table dbo.ATTRIBUTE{0}', '{0}', @ATTRIBUTEID);  
    execute sp_executesql @ATTRIBUTECLEARSQL;  
  end
    return 0;

end