USE [SDS_DevSchoolDistrict]
GO

-- =================================================================================
-- Copyright:   School Data Solutions
-- =================================================================================
CREATE PROCEDURE [dbo].[SetStudentLearningCommitment]
    @StudentLearningPlanId                      int,
    @StudentLearningPlanCommitmentId    int,
    @StudentLearningPlanCommitmentApplies   bit
AS
BEGIN

    -- =============================================================================
    --
    -- =============================================================================
    IF(@StudentLearningPlanCommitmentApplies = 1)
    BEGIN
            INSERT  StudentLearningPlans_Commitments
            (
                    StudentLearningPlanId,
                    StudentLearningPlanCommitmentId
            )
            VALUES
            (
                    @StudentLearningPlanId,
                    @StudentLearningPlanCommitmentId
            )
    END
    ELSE
    BEGIN
            DELETE  StudentLearningPlans_Commitments
            WHERE   StudentLearningPlanId = @StudentLearningPlanId
              AND   StudentLearningPlanCommitmentId = @StudentLearningPlanCommitmentId
    END
    -- =============================================================================

END
GO






-- =================================================================================
-- Copyright:   School Data Solutions
-- =================================================================================
CREATE PROCEDURE [dbo].[SetStudentLearningPlanQualifyingCondition]
    @StudentLearningPlanId                      int,
    @StudentLearningPlanQualifyingConditionId   int,
    @StudentLearningPlanQualifyingConditionApplies  bit
AS
BEGIN

    -- =============================================================================
    --
    -- =============================================================================
    IF(@StudentLearningPlanQualifyingConditionApplies = 1)
    BEGIN
            INSERT  StudentLearningPlans_QualifyingConditions
            (
                    StudentLearningPlanId,
                    StudentLearningPlanQualifyingConditionId
            )
            VALUES
            (
                    @StudentLearningPlanId,
                    @StudentLearningPlanQualifyingConditionId
            )
    END
    ELSE
    BEGIN
            DELETE  StudentLearningPlans_QualifyingConditions
            WHERE   StudentLearningPlanId = @StudentLearningPlanId
              AND   StudentLearningPlanQualifyingConditionId = @StudentLearningPlanQualifyingConditionId
    END
    -- =============================================================================

END