CREATE_form.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace SOFTDEV_FINAL_PROJECT
{
    public partial class CREATE_form : Form
    {
        public CREATE_form()
        {
            InitializeComponent();

            // GENDER ComboBox

            comboBoxGender.Items.Add("Male");
            comboBoxGender.Items.Add("Female");
            comboBoxGender.Items.Add("LGBTQIA");
            comboBoxGender.Items.Add("Rather not say");

            // PROGRAM ComboBox

            comboBoxProgram.Items.Add("Computer Engineer");
            comboBoxProgram.Items.Add("Mechanical Engineer");
            comboBoxProgram.Items.Add("Electrical Engineer");
            comboBoxProgram.Items.Add("Civil Engineer");
            comboBoxProgram.Items.Add("Combat Engineer");
            comboBoxProgram.Items.Add("Information Technology");
            comboBoxProgram.Items.Add("Food Technology");
            comboBoxProgram.Items.Add("Education");
            comboBoxProgram.Items.Add("Tourism Management");
            comboBoxProgram.Items.Add("Hotel Management");
            comboBoxProgram.Items.Add("Political Science");
            comboBoxProgram.Items.Add("Computer Science");
        }



        private void CREATE_form_Load(object sender, EventArgs e)
        {







        }




        private void Create_button_Click(object sender, EventArgs e)
        {

            bool allowed = true;

            // Retrieve input data
            string firstname = textBoxFirstName.Text.Trim();
            string lastname = textBoxLastname.Text.Trim();
            string ageInput = textBoxAge.Text.Trim();
            string gender = comboBoxGender.SelectedItem?.ToString();
            string program = comboBoxProgram.SelectedItem?.ToString();
            string username = textbox_username.Text.Trim();
            string password = TextboxPassword.Text.Trim();

            // Validate Full Name
            if (string.IsNullOrWhiteSpace(firstname))
            {
                MessageBox.Show("Please enter your full name.", "Input Error");
                return;
            }
            if (string.IsNullOrWhiteSpace(lastname))
            {
                MessageBox.Show("Please enter your full name.", "Input Error");
                return;
            }



            if (comboBoxProgram.SelectedIndex == -1)
            {
                MessageBox.Show("Please select your program.", "Input Error");
                return;
            }

            /// must create a duplicate checker for this one

            if (string.IsNullOrWhiteSpace(username))
            {
                MessageBox.Show("Please enter your username.", "Input Error");
                return;
            }

            if (string.IsNullOrWhiteSpace(password))
            {
                MessageBox.Show("Please enter your password", "Input Error");
                return;
            }




            using (SqlConnection conn = new SqlConnection("Server=ASUS_2023;Database=Final_ProjectDB;Trusted_Connection=True;"))
            {

                conn.Open();

                // 1. Check if username already exists
                string usernameQuery = "SELECT COUNT(*) FROM Students WHERE Username = @Username;";
                using (SqlCommand checkUsername = new SqlCommand(usernameQuery, conn))
                {
                    checkUsername.Parameters.AddWithValue("@Username", username);
                    int usernameExists = (int)checkUsername.ExecuteScalar();

                    if (usernameExists > 0)
                    {
                        MessageBox.Show("Username is already taken.", "Duplicate Entry", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        allowed = false;
                        return;
                    }

                }

                // 2. Check if full name (first + last) already exists
                string nameQuery = "SELECT COUNT(*) FROM Students WHERE FirstName = @FirstName AND LastName = @LastName;";
                using (SqlCommand checkName = new SqlCommand(nameQuery, conn))
                {
                    checkName.Parameters.AddWithValue("@FirstName", firstname);
                    checkName.Parameters.AddWithValue("@LastName", lastname);
                    int nameExists = (int)checkName.ExecuteScalar();

                    if (nameExists > 0)
                    {
                        MessageBox.Show("A student with the same full name already exists.", "Duplicate Entry", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        allowed = false;
                        return;
                    }

                }

                // Continue with insert if no duplicate
            }





            // Validate Age (Numeric only)
            if (string.IsNullOrEmpty(ageInput))
            {
                MessageBox.Show("Please enter your age.", "Input Error");
                return;
            }

            if (!int.TryParse(ageInput, out int age))
            {
                MessageBox.Show("Please enter a valid numeric age.", "Input Error");
                return;
            }

            // Validate Gender selection
            if (comboBoxGender.SelectedIndex == -1)
            {
                MessageBox.Show("Please select a gender.", "Input Error");
                return;
            }



            // Age logic as requested - show age-related warning messages using MessageBox
            if (age >= 60)
            {
                if (age >= 150)
                {
                    MessageBox.Show($"{firstname}, INVALID", "Age Status");
                    allowed = false;
                    textBoxAge.Text = "";
                }
                else
                {
                    MessageBox.Show($"{firstname}, ARE YOU SURE???", "Age Status");
                    allowed = true;

                }
            }
            else if (age <= 0)
            {
                MessageBox.Show($"{firstname},", "Age Status");
                allowed = false;
                textBoxAge.Text = "";
            }
            else
            {

                if (age <= 17)
                {
                    DialogResult result = MessageBox.Show($"{firstname}, ARE YOU SURE??", "Age Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

                    if (result == DialogResult.Yes)
                    {
                        allowed = true;
                    }
                    else
                    {
                        allowed = false;
                        return; // Stop execution and let user edit
                    }
                }
                else
                {
                    allowed = true; // No confirmation needed for older users
                }

            }




            // saving mechanism

            if (allowed)
            {
                try
                {
                    string connectionString = "Server=ASUS_2023;Database=Final_ProjectDB;Trusted_Connection=True";

                    using (SqlConnection conn = new SqlConnection(connectionString))
                    {
                        conn.Open();



                        // Generating ID student
                        string getMaxIdQuery = "SELECT ISNULL(MAX(StudentID), 0) + 1 FROM Students";
                        int newStudentId;

                        using (SqlCommand getIdCmd = new SqlCommand(getMaxIdQuery, conn))
                        {
                            newStudentId = (int)getIdCmd.ExecuteScalar();
                        }



                        // INSERT into Students table (use manual StudentID)
                        string insertStudentQuery = @"INSERT INTO Students (StudentID, FirstName, LastName, Age, Gender, Program, Username, KeyPassword)
                              VALUES (@StudentID, @FirstName, @LastName, @Age, @Gender, @Program, @Username, @KeyPassword)";

                        using (SqlCommand cmd = new SqlCommand(insertStudentQuery, conn))
                        {
                            cmd.Parameters.AddWithValue("@StudentID", newStudentId); // Add this line
                            cmd.Parameters.AddWithValue("@FirstName", firstname);
                            cmd.Parameters.AddWithValue("@LastName", lastname);
                            cmd.Parameters.AddWithValue("@Age", int.Parse(ageInput));
                            cmd.Parameters.AddWithValue("@Gender", gender);
                            cmd.Parameters.AddWithValue("@Program", program);
                            cmd.Parameters.AddWithValue("@Username", username);
                            cmd.Parameters.AddWithValue("@KeyPassword", password);

                            cmd.ExecuteNonQuery(); // Execute insert into Students


                            // Get the newly inserted user's ID


                            // Now insert into Quizzes table with default values
                            string insertScoreQuery = @"INSERT INTO Quizzes (StudentID, numquiz, Leveling, Math1, Math2, InfoTech1, InfoTech2, Biology1, Physics1)
                                                VALUES (@StudentID, 1, 1, -1, -1, -1, -1, -1, -1)";

                            using (SqlCommand quizCmd = new SqlCommand(insertScoreQuery, conn))
                            {
                                quizCmd.Parameters.AddWithValue("@StudentID", newStudentId);
                                quizCmd.ExecuteNonQuery();
                            }



                            MessageBox.Show("User and quiz record created successfully!");

                            // RETURN TO BLANK

                            textBoxFirstName.Text = "";
                            textBoxLastname.Text = "";
                            textBoxAge.Text = "";
                            comboBoxGender.Text = "";
                            comboBoxProgram.Text = "";
                            textbox_username.Text = "";
                            TextboxPassword.Text = "";
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error: " + ex.Message);
                }
            }


        }



        private void Return_button_Click(object sender, EventArgs e)
        {
            // Redirect to Login Form
            LOGINFORM loginForm = new LOGINFORM();
            loginForm.Show();
            this.Close(); // Close the Profile Form

        }

        private void TextboxPassword_TextChanged(object sender, EventArgs e)
        {
            string password = TextboxPassword.Text;
            List<string> errors = new List<string>();

            if (password.Length < 8 || password.Length > 20)
            {
                errors.Add("• Password must be between 8 and 20 characters long.");
            }

            if (!password.Any(char.IsDigit))
            {
                errors.Add("• Password must contain at least one number.");
            }

            if (!password.Any(char.IsUpper))
            {
                errors.Add("• Password should include at least one uppercase letter.");
            }

            if (!password.Any(char.IsLower))
            {
                errors.Add("• Password should include at least one lowercase letter.");
            }



            if (errors.Count > 0)
            {
                labelPasswordError.Visible = true;
                labelPasswordError.Text = string.Join("\n", errors);
            }
            else
            {
                labelPasswordError.Visible = false;
            }

        }




        private void textbox_username_TextChanged(object sender, EventArgs e)
        {
            string username = textbox_username.Text;
            List<string> messages = new List<string>();

            if (username.Length < 5 || username.Length > 15)
            {
                messages.Add("• Username must be 5 to 15 characters long.");
            }

            if (!string.IsNullOrEmpty(username) && !char.IsLetter(username[0]))
            {
                messages.Add("• Username must start with a letter.");
            }

            if (!username.All(ch => char.IsLetterOrDigit(ch) || ch == '_'))
            {
                messages.Add("• Username can only contain letters, digits, and underscores.");
            }

            if (username.Contains(" "))
            {
                messages.Add("• Username should not contain spaces.");
            }

            if (messages.Count > 0)
            {
                usernamevalid.Visible = true;
                usernamevalid.Text = string.Join("\n", messages);
                usernamevalid.ForeColor = Color.Red;
            }
            else
            {
                usernamevalid.Visible = true;
                usernamevalid.Text = "✓ Username is valid";
                usernamevalid.ForeColor = Color.Green;
            }
        }







        private void passworderror_Click(object sender, EventArgs e)
        {

        }

        private void comboBoxProgram_SelectedIndexChanged(object sender, EventArgs e)
        {



        }


        private void textBoxAge_TextChanged(object sender, EventArgs e)
        {
            if (!int.TryParse(textBoxAge.Text, out int age))
            {
                textBoxAge.Text = "";
                return;
            }

            if (age > 100)
            {

                textBoxAge.Text = "";
                return;
            }
        }

        private void comboBoxGender_Leave(object sender, EventArgs e)
        {

            string[] allowedCourses = new string[]
   {
        "Computer Engineer", "Mechanical Engineer", "Electrical Engineer",
        "Civil Engineer", "Combat Engineer",
        "Information Technology (major in programming)",
        "Information Technology (major in Networking)",
        "Food Technology", "Education", "Tourism Management",
        "Hotel Management", "Political Science", "Computer Science"
   };

            // Check if user input matches any course
            if (!allowedCourses.Contains(comboBoxProgram.Text))
            {
                comboBoxProgram.Text = "";
            }



        }

        private void comboBoxProgram_Click(object sender, EventArgs e)
        {

        }

        private void comboBoxProgram_TextChanged(object sender, EventArgs e)
        {
            string[] allowedCourses = new string[]
   {
        "Computer Engineer", "Mechanical Engineer", "Electrical Engineer",
        "Civil Engineer", "Combat Engineer",
        "Information Technology (major in programming)",
        "Information Technology (major in Networking)",
        "Food Technology", "Education", "Tourism Management",
        "Hotel Management", "Political Science", "Computer Science"
   };

            // Check if user input matches any course
            if (!allowedCourses.Contains(comboBoxProgram.Text))
            {
                comboBoxProgram.Text = "";
            }
        }

        private void comboBoxGender_TextChanged(object sender, EventArgs e)
        {
            string[] allowedGenders = new string[]
    {
        "Male", "Female", "LGBTQIA", "Rather not say"
    };

            if (!allowedGenders.Contains(comboBoxGender.Text))
            {
                comboBoxGender.Text = "";
            }

        }

        private void textBoxFirstName_TextChanged(object sender, EventArgs e)
        {

        }
    }
}