Jo0b related1

-- =============================================
-- Author:  Kamal Khanal
-- Create date: 2022-09-13
-- Description: Add data to InstituteBulkUser
-- =============================================
CREATE PROCEDURE usp_Institute_AddBulkUser
    @InstituteID INT = NULL,
    @UserID INT = NULL,
    @GradeID INT = NULL,
    @NoOfLearner INT = NULL,
    @NoOfInstructor INT = NULL,
    @UserPrefix NVARCHAR(50) = NULL,
    @DefaultPassword NVARCHAR(50) = NULL,
    @PasswordSalt NVARCHAR(100) = NULL,
    @PasswordHash NVARCHAR(100) = NULL,
    @UserName NVARCHAR(256),
    @Output INT OUTPUT
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE @InstituteBulkUserID INT;

    SELECT @Output = 0;

    INSERT INTO [dbo].[InstituteBulkUser]
    (
        [InstituteID],
        [UserID],
        [GradeID],
        [NoOfLearner],
        [NoOfInstructor],
        [UserPrefix],
        [DefaultPassword],
        [AddedBy]
    )
    VALUES
    (@InstituteID, @UserID, @GradeID, @NoOfLearner, @NoOfInstructor, @UserPrefix, @DefaultPassword, @UserName);

    SELECT @InstituteBulkUserID = SCOPE_IDENTITY();

    IF @@ROWCOUNT > 0
        SELECT @Output = 1;

    EXEC [dbo].[usp_Institute_CreateUsersJob] @InstituteBulkUserID,
                                              @InstituteID,
                                              @GradeID,
                                              @NoOfLearner,
                                              @NoOfInstructor,
                                              @UserPrefix,
                                              @PasswordSalt,
                                              @PasswordHash,
                                              @UserName;

    SELECT @Output AS [Output];

END;