USE [SDS_DevSchoolDistrict]
GO
/****** Object:  StoredProcedure [dbo].[UploadFileToEducatorStudentLearningPlanParentCommunication]    Script Date: 07/20/2011 18:10:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =================================================================================
-- Copyright:   School Data Solutions
-- =================================================================================
/*

        EXEC UploadApplicationUserFile
            @ApplicationUser = 'TestWithPerson',
            @ApplicationPassword = 'test',
            @PersonId = 1

        SELECT * FROM SdsProducts


*/
CREATE PROCEDURE [dbo].[UploadFileToEducatorStudentLearningPlanParentCommunication]
    @ApplicationUserFileLabel           [dbo].[Label],
    @ApplicationUserFileLocation        varchar(200),
    @ApplicationUserFilePath            [dbo].[FilePath],
    @ApplicationUserFileType            varchar(100),
    @ApplicationUserFileExtension           varchar(10),
    @ApplicationUserFileSize            bigint,
    @ApplicationUserFileDateUploaded    [date] = NULL,
    @ApplicationUserFilePurpose         [dbo].[Notes] = NULL,
    @ApplicationUserFileNotes           [dbo].[Notes] = NULL,
    @ApplicationUserId                  [dbo].[ApplicationUserId],
    @SdsProductId                       ElementReference = NULL,
    ----------------------------------------------------------------
    @StudentLearningPlanParentCommunicationId   int = NULL
AS
BEGIN

        DECLARE @ApplicationUserFileId_Output int


        EXEC    UploadApplicationUserFile
                @ApplicationUserFileLabel = @ApplicationUserFileLabel,
                @ApplicationUserFileLocation = @ApplicationUserFileLocation,
                @ApplicationUserFilePath = @ApplicationUserFilePath,
                @ApplicationUserFileExtension = @ApplicationUserFileExtension,
                @ApplicationUserFileType = @ApplicationUserFileType,
                @ApplicationUserFileSize = @ApplicationUserFileSize,
                @ApplicationUserFileDateUploaded = @ApplicationUserFileDateUploaded,
                --@ApplicationUserFilePurpose   = @ApplicationUserFilePurpose,
                @ApplicationUserFileNotes = @ApplicationUserFileNotes,
                @ApplicationUserId = @ApplicationUserId,
                @SdsProductId = @SdsProductId,
                @ApplicationUserFileId = @ApplicationUserFileId_Output





        -- =============================================================================
        -- If we've uploaded for Evaluations app
        -- =============================================================================
        IF(@StudentLearningPlanParentCommunicationId IS NOT NULL)
        BEGIN   -------------------------------------------------
                INSERT  StudentLearningPlanParentCommunications_ApplicationUserFiles
                (
                        StudentLearningPlanParentCommunicationId,
                        ApplicationUserFileId
                ) VALUES (
                        @StudentLearningPlanParentCommunicationId,
                        @ApplicationUserFileId_Output
                )
        END     -------------------------------------------------
        -- =============================================================================







END