Form2.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace H1
{
    public partial class Form2 : Form
    {
        private string connectionString = @"Data Source=ABDULSABOOR190\SQLEXPRESS;Initial Catalog=sabbbb;Integrated Security=True;Encrypt=False";
        private int currentUserId; // Will be set from login

        public Form2(int userId) // Modified constructor to accept user ID
        {
            InitializeComponent();
            currentUserId = userId;

            // Set up event handlers
            button1.Click += SaveProfile_Click;
            button2.Click += CancelChanges_Click;

            // Load the profile when form opens
            this.Load += Form2_Load;
        }

        private void Form2_Load(object sender, EventArgs e)
        {
            LoadUserProfile();
        }

        private void LoadUserProfile()
        {
            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    // Load basic profile info
                    string profileQuery = @"
                        SELECT tp.first_name, tp.last_name, tp.phone, tp.date_of_birth, u.email
                        FROM TravelerProfile tp
                        JOIN AppUser u ON tp.user_id = u.user_id
                        WHERE tp.user_id = @userId";

                    SqlCommand profileCmd = new SqlCommand(profileQuery, conn);
                    profileCmd.Parameters.AddWithValue("@userId", currentUserId);

                    using (SqlDataReader reader = profileCmd.ExecuteReader())
                    {
                        if (reader.Read())
                        {
                            txtFirstName.Text = reader["first_name"].ToString();
                            txtLastName.Text = reader["last_name"].ToString();
                            txtPhone.Text = reader["phone"].ToString();
                            lblEmail.Text = reader["email"].ToString();

                            if (reader["date_of_birth"] != DBNull.Value)
                            {
                                dtpDOB.Value = Convert.ToDateTime(reader["date_of_birth"]);
                            }
                        }
                    }

                    // Load preferences
                    clbPrefs.Items.Clear(); // Clear existing items
                    clbPrefs.Items.Add("Adventure");
                    clbPrefs.Items.Add("Beach");
                    clbPrefs.Items.Add("Cultural");

                    string prefsQuery = @"
                        SELECT preference_value 
                        FROM TravelerPreference 
                        WHERE user_id = @userId AND preference_type = 'travel'";

                    SqlCommand prefsCmd = new SqlCommand(prefsQuery, conn);
                    prefsCmd.Parameters.AddWithValue("@userId", currentUserId);

                    using (SqlDataReader reader = prefsCmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            string pref = reader["preference_value"].ToString();
                            for (int i = 0; i < clbPrefs.Items.Count; i++)
                            {
                                if (clbPrefs.Items[i].ToString() == pref)
                                {
                                    clbPrefs.SetItemChecked(i, true);
                                    break;
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error loading profile: " + ex.Message,
                    "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        private void SaveProfile_Click(object sender, EventArgs e)
        {
            if (!ValidateInputs())
                return;

            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();
                    SqlTransaction transaction = conn.BeginTransaction();

                    try
                    {
                        // Update TravelerProfile
                        string updateProfileQuery = @"
                            UPDATE TravelerProfile 
                            SET first_name = @firstName,
                                last_name = @lastName,
                                phone = @phone,
                                date_of_birth = @dob
                            WHERE user_id = @userId";

                        SqlCommand profileCmd = new SqlCommand(updateProfileQuery, conn, transaction);
                        profileCmd.Parameters.AddWithValue("@firstName", txtFirstName.Text.Trim());
                        profileCmd.Parameters.AddWithValue("@lastName", txtLastName.Text.Trim());
                        profileCmd.Parameters.AddWithValue("@phone", txtPhone.Text.Trim());
                        profileCmd.Parameters.AddWithValue("@dob", dtpDOB.Value.Date);
                        profileCmd.Parameters.AddWithValue("@userId", currentUserId);

                        profileCmd.ExecuteNonQuery();

                        // Update preferences - first delete existing ones
                        string deletePrefsQuery = "DELETE FROM TravelerPreference WHERE user_id = @userId AND preference_type = 'travel'";
                        SqlCommand deletePrefsCmd = new SqlCommand(deletePrefsQuery, conn, transaction);
                        deletePrefsCmd.Parameters.AddWithValue("@userId", currentUserId);
                        deletePrefsCmd.ExecuteNonQuery();

                        // Insert new preferences
                        string insertPrefQuery = @"
                            INSERT INTO TravelerPreference (user_id, preference_type, preference_value)
                            VALUES (@userId, 'travel', @prefValue)";

                        foreach (string item in clbPrefs.CheckedItems)
                        {
                            SqlCommand insertPrefCmd = new SqlCommand(insertPrefQuery, conn, transaction);
                            insertPrefCmd.Parameters.AddWithValue("@userId", currentUserId);
                            insertPrefCmd.Parameters.AddWithValue("@prefValue", item);
                            insertPrefCmd.ExecuteNonQuery();
                        }

                        transaction.Commit();
                        MessageBox.Show("Profile updated successfully!",
                            "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    catch (Exception ex)
                    {
                        transaction.Rollback();
                        throw; // Re-throw to be caught by outer catch
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error saving profile: " + ex.Message,
                    "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        private void CancelChanges_Click(object sender, EventArgs e)
        {
            LoadUserProfile(); // Reload original data
        }

        private bool ValidateInputs()
        {
            if (string.IsNullOrWhiteSpace(txtFirstName.Text))
            {
                MessageBox.Show("First name is required",
                    "Validation", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }

            if (string.IsNullOrWhiteSpace(txtLastName.Text))
            {
                MessageBox.Show("Last name is required",
                    "Validation", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }

            if (string.IsNullOrWhiteSpace(txtPhone.Text))
            {
                MessageBox.Show("Phone number is required",
                    "Validation", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }

            return true;
        }

        private void mainPanel_Paint(object sender, PaintEventArgs e)
        {
            // Empty implementation
        }
    }
}