= UC0009 Prototype Implementation - Register a New User =

'''Initiating actor:''' Faculty Administrator

'''Other actors:''' None

The administrator creates a new user account by entering personal details, selecting a role from the available user types, and setting an initial password. The system validates email uniqueness, hashes the password with bcrypt, and inserts the new user.

== Scenario ==

 1. The administrator selects ''Register a New User'' from the main menu. The system queries available roles:
{{{
SELECT type_id, type_name, description FROM user_types ORDER BY type_id;
}}}

The system displays the role selection menu:
{{{
=== Register a New User ===

  Available roles:
  1. Student - Students can view resource availability and access permitted resources
  2. Teaching Staff - Faculty members who can reserve resources for lectures, labs, and research
  3. Administrator - System administrators who manage resources and approve reservations
  0. Cancel / Go back
}}}

 2. The administrator selects ''Teaching Staff'' and enters the new user's details.
{{{
  Select role: 2
  First name: Petar
  Last name: Jovanov
  Email: petar.jovanov@finki.ukim.mk
}}}

 3. The system checks that the email is not already registered.
{{{
SELECT COUNT(*) FROM users WHERE email = 'petar.jovanov@finki.ukim.mk';
}}}

 4. The email is available. The administrator sets the initial password.
{{{
  Initial password: ********
  Confirm password: ********
}}}

 5. The system hashes the password with bcrypt and inserts the new user account:
{{{
INSERT INTO users (first_name, last_name, email, password, type_id)
VALUES ('Petar', 'Jovanov', 'petar.jovanov@finki.ukim.mk', '$2b$12$...hashed...', 2)
RETURNING user_id, first_name, last_name, email;
}}}

The system confirms the account was created:
{{{
  User created successfully!
  User ID:  13
  Name:     Petar Jovanov
  Email:    petar.jovanov@finki.ukim.mk
  Role:     Teaching Staff
}}}

== Alternative: Email Already Exists ==

 3a. If the email is already registered, the system displays an error.
{{{
  ERROR: A user with email 'elena.stojanova@finki.ukim.mk' already exists.
}}}