BookingManagementForm.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.Windows.Forms;

namespace DB_Project
{
    public partial class BookingManagementForm : Form
    {
        private readonly string connectionString = @"Data Source=ABDULSABOOR190\SQLEXPRESS;Initial Catalog=sabbbb;Integrated Security=True;Encrypt=False";

        public BookingManagementForm()
        {
            InitializeComponent();
            SetupForm();
        }

        private void SetupForm()
        {
            // Set active button appearance
            HighlightActiveButton(button2); // Highlight the booking management button
        }

        // Helper method to highlight the active sidebar button
        private void HighlightActiveButton(Button activeButton)
        {
            // Reset all buttons
            foreach (Control c in panelSidebar.Controls)
            {
                if (c is Button btn)
                {
                    btn.BackColor = Color.FromArgb(52, 73, 94);
                    btn.ForeColor = Color.White;
                }
            }

            // Highlight active button
            activeButton.BackColor = Color.FromArgb(41, 128, 185);
            activeButton.ForeColor = Color.White;
        }

        private void BookingManagementForm_Load(object sender, EventArgs e)
        {
            // Clear existing columns that were created in designer
            dgvBookings.Columns.Clear();

            // Configure DataGridView columns programmatically
            ConfigureDataGridView();

            // Load data from database
            LoadBookings();
        }

        private void ConfigureDataGridView()
        {
            // Add ID column
            DataGridViewTextBoxColumn bookingIdColumn = new DataGridViewTextBoxColumn
            {
                Name = "BookingId",
                HeaderText = "Booking ID",
                Width = 80,
                ReadOnly = true
            };
            dgvBookings.Columns.Add(bookingIdColumn);

            // Add Customer Name column
            DataGridViewTextBoxColumn customerNameColumn = new DataGridViewTextBoxColumn
            {
                Name = "CustomerName",
                HeaderText = "Customer Name",
                Width = 150,
                ReadOnly = true
            };
            dgvBookings.Columns.Add(customerNameColumn);

            // Add Service/Trip Name column
            DataGridViewTextBoxColumn serviceNameColumn = new DataGridViewTextBoxColumn
            {
                Name = "ServiceName",
                HeaderText = "Service/Trip Name",
                Width = 150,
                ReadOnly = true
            };
            dgvBookings.Columns.Add(serviceNameColumn);

            // Add Booking Date column
            DataGridViewTextBoxColumn bookingDateColumn = new DataGridViewTextBoxColumn
            {
                Name = "BookingDate",
                HeaderText = "Booking Date",
                Width = 110,
                ReadOnly = true,
                DefaultCellStyle = new DataGridViewCellStyle { Format = "dd/MM/yyyy" }
            };
            dgvBookings.Columns.Add(bookingDateColumn);

            // Add Participants column
            DataGridViewTextBoxColumn participantsColumn = new DataGridViewTextBoxColumn
            {
                Name = "Participants",
                HeaderText = "Participants",
                Width = 90,
                ReadOnly = true
            };
            dgvBookings.Columns.Add(participantsColumn);

            // Add Amount column
            DataGridViewTextBoxColumn amountColumn = new DataGridViewTextBoxColumn
            {
                Name = "Amount",
                HeaderText = "Amount",
                Width = 100,
                ReadOnly = true,
                DefaultCellStyle = new DataGridViewCellStyle { Format = "C2" }
            };
            dgvBookings.Columns.Add(amountColumn);

            // Add Status ComboBox column
            DataGridViewComboBoxColumn statusColumn = new DataGridViewComboBoxColumn
            {
                Name = "Status",
                HeaderText = "Status",
                Width = 95
            };
            statusColumn.Items.AddRange(new object[] { "pending", "confirmed", "canceled" });
            dgvBookings.Columns.Add(statusColumn);
        }

        private void LoadBookings()
        {
            dgvBookings.Rows.Clear();

            try
            {
                using (SqlConnection connection = new SqlConnection(connectionString))
                {
                    connection.Open();

                    // Get a list of all bookings with traveler info and trip info
                    string query = @"
                        SELECT b.booking_id, CONCAT(tp.first_name, ' ', tp.last_name) AS customer_name, 
                               t.title AS trip_name, b.booking_date, b.participants, b.total_amount, b.status
                        FROM Booking b
                        INNER JOIN TravelerProfile tp ON b.traveler_id = tp.user_id
                        INNER JOIN Trip t ON b.trip_id = t.trip_id
                        ORDER BY b.booking_date DESC";

                    using (SqlCommand command = new SqlCommand(query, connection))
                    {
                        using (SqlDataReader reader = command.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                int rowIndex = dgvBookings.Rows.Add();
                                DataGridViewRow row = dgvBookings.Rows[rowIndex];

                                // Populate each cell in the row
                                row.Cells["BookingId"].Value = reader["booking_id"].ToString();
                                row.Cells["CustomerName"].Value = reader["customer_name"].ToString();
                                row.Cells["ServiceName"].Value = reader["trip_name"].ToString();
                                row.Cells["BookingDate"].Value = Convert.ToDateTime(reader["booking_date"]);
                                row.Cells["Participants"].Value = reader["participants"].ToString();
                                row.Cells["Amount"].Value = Convert.ToDecimal(reader["total_amount"]);
                                row.Cells["Status"].Value = reader["status"].ToString();
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show($"Error loading bookings: {ex.Message}", "Database Error",
                    MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        private void btnUpdateStatus_Click(object sender, EventArgs e)
        {
            if (dgvBookings.SelectedRows.Count == 0 && dgvBookings.CurrentRow == null)
            {
                MessageBox.Show("Please select a booking to update.", "No Selection",
                    MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }

            try
            {
                int rowIndex = dgvBookings.CurrentRow.Index;
                string bookingId = dgvBookings.Rows[rowIndex].Cells["BookingId"].Value.ToString();

                // Create and show the booking edit form
                using (BookingEditForm editForm = new BookingEditForm(bookingId, connectionString))
                {
                    if (editForm.ShowDialog() == DialogResult.OK)
                    {
                        // If user clicked OK in the edit form, refresh the bookings
                        LoadBookings();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show($"Error opening booking editor: {ex.Message}", "Error",
                    MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        // Form class for editing booking details
        private class BookingEditForm : Form
        {
            private readonly string connectionString;
            private readonly string bookingId;
            private TextBox txtCustomerName;
            private TextBox txtServiceName;
            private DateTimePicker dtpBookingDate;
            private NumericUpDown nudParticipants;
            private NumericUpDown nudAmount;
            private ComboBox cboStatus;
            private TextBox txtSpecialRequests;
            private Button btnSave;
            private Button btnCancel;
            private int travelerId;
            private int tripId;

            public BookingEditForm(string bookingId, string connectionString)
            {
                this.bookingId = bookingId;
                this.connectionString = connectionString;
                InitializeEditComponents();
                LoadBookingDetails();
            }

            private void InitializeEditComponents()
            {
                // Form properties
                this.Text = "Edit Booking";
                this.Size = new Size(500, 450);
                this.FormBorderStyle = FormBorderStyle.FixedDialog;
                this.MaximizeBox = false;
                this.MinimizeBox = false;
                this.StartPosition = FormStartPosition.CenterParent;
                this.BackColor = Color.FromArgb(236, 240, 241);

                // Create panel for the form fields
                Panel panel = new Panel
                {
                    Dock = DockStyle.Fill,
                    Padding = new Padding(20)
                };
                this.Controls.Add(panel);

                // Customer Name
                Label lblCustomerName = new Label
                {
                    Text = "Customer Name:",
                    Location = new Point(20, 20),
                    AutoSize = true,
                    Font = new Font("Segoe UI", 9F)
                };
                panel.Controls.Add(lblCustomerName);

                txtCustomerName = new TextBox
                {
                    Location = new Point(150, 20),
                    Size = new Size(300, 25),
                    Font = new Font("Segoe UI", 9F),
                    ReadOnly = true // Can't edit customer name directly (would need to select from users)
                };
                panel.Controls.Add(txtCustomerName);

                // Service/Trip Name
                Label lblServiceName = new Label
                {
                    Text = "Service/Trip Name:",
                    Location = new Point(20, 60),
                    AutoSize = true,
                    Font = new Font("Segoe UI", 9F)
                };
                panel.Controls.Add(lblServiceName);

                txtServiceName = new TextBox
                {
                    Location = new Point(150, 60),
                    Size = new Size(300, 25),
                    Font = new Font("Segoe UI", 9F),
                    ReadOnly = true // Can't edit trip name directly (would need to select from trips)
                };
                panel.Controls.Add(txtServiceName);

                // Booking Date
                Label lblBookingDate = new Label
                {
                    Text = "Booking Date:",
                    Location = new Point(20, 100),
                    AutoSize = true,
                    Font = new Font("Segoe UI", 9F)
                };
                panel.Controls.Add(lblBookingDate);

                dtpBookingDate = new DateTimePicker
                {
                    Location = new Point(150, 100),
                    Size = new Size(300, 25),
                    Format = DateTimePickerFormat.Short,
                    Font = new Font("Segoe UI", 9F)
                };
                panel.Controls.Add(dtpBookingDate);

                // Participants
                Label lblParticipants = new Label
                {
                    Text = "Participants:",
                    Location = new Point(20, 140),
                    AutoSize = true,
                    Font = new Font("Segoe UI", 9F)
                };
                panel.Controls.Add(lblParticipants);

                nudParticipants = new NumericUpDown
                {
                    Location = new Point(150, 140),
                    Size = new Size(100, 25),
                    Minimum = 1,
                    Maximum = 20,
                    Value = 1,
                    Font = new Font("Segoe UI", 9F)
                };
                panel.Controls.Add(nudParticipants);

                // Amount
                Label lblAmount = new Label
                {
                    Text = "Total Amount:",
                    Location = new Point(20, 180),
                    AutoSize = true,
                    Font = new Font("Segoe UI", 9F)
                };
                panel.Controls.Add(lblAmount);

                nudAmount = new NumericUpDown
                {
                    Location = new Point(150, 180),
                    Size = new Size(150, 25),
                    Minimum = 0,
                    Maximum = 1000000,
                    DecimalPlaces = 2,
                    Increment = 100,
                    ThousandsSeparator = true,
                    Font = new Font("Segoe UI", 9F)
                };
                panel.Controls.Add(nudAmount);

                // Status
                Label lblStatus = new Label
                {
                    Text = "Status:",
                    Location = new Point(20, 220),
                    AutoSize = true,
                    Font = new Font("Segoe UI", 9F)
                };
                panel.Controls.Add(lblStatus);

                cboStatus = new ComboBox
                {
                    Location = new Point(150, 220),
                    Size = new Size(150, 25),
                    DropDownStyle = ComboBoxStyle.DropDownList,
                    Font = new Font("Segoe UI", 9F)
                };
                cboStatus.Items.AddRange(new object[] { "pending", "confirmed", "canceled" });
                panel.Controls.Add(cboStatus);

                // Special Requests
                Label lblSpecialRequests = new Label
                {
                    Text = "Special Requests:",
                    Location = new Point(20, 260),
                    AutoSize = true,
                    Font = new Font("Segoe UI", 9F)
                };
                panel.Controls.Add(lblSpecialRequests);

                txtSpecialRequests = new TextBox
                {
                    Location = new Point(150, 260),
                    Size = new Size(300, 80),
                    Multiline = true,
                    Font = new Font("Segoe UI", 9F)
                };
                panel.Controls.Add(txtSpecialRequests);

                // Save button
                btnSave = new Button
                {
                    Text = "Save Changes",
                    Location = new Point(150, 350),
                    Size = new Size(140, 40),
                    BackColor = Color.FromArgb(41, 128, 185),
                    ForeColor = Color.White,
                    FlatStyle = FlatStyle.Flat,
                    Font = new Font("Segoe UI", 9F)
                };
                btnSave.Click += BtnSave_Click;
                panel.Controls.Add(btnSave);

                // Cancel button
                btnCancel = new Button
                {
                    Text = "Cancel",
                    Location = new Point(310, 350),
                    Size = new Size(140, 40),
                    BackColor = Color.FromArgb(231, 76, 60),
                    ForeColor = Color.White,
                    FlatStyle = FlatStyle.Flat,
                    Font = new Font("Segoe UI", 9F)
                };
                btnCancel.Click += (s, e) => this.DialogResult = DialogResult.Cancel;
                panel.Controls.Add(btnCancel);
            }

            private void LoadBookingDetails()
            {
                try
                {
                    using (SqlConnection connection = new SqlConnection(connectionString))
                    {
                        connection.Open();

                        // Get the booking details including traveler and trip information
                        string query = @"
                            SELECT b.*, 
                                   CONCAT(tp.first_name, ' ', tp.last_name) AS customer_name,
                                   t.title AS trip_name
                            FROM Booking b
                            INNER JOIN TravelerProfile tp ON b.traveler_id = tp.user_id
                            INNER JOIN Trip t ON b.trip_id = t.trip_id
                            WHERE b.booking_id = @BookingId";

                        using (SqlCommand command = new SqlCommand(query, connection))
                        {
                            command.Parameters.AddWithValue("@BookingId", bookingId);

                            using (SqlDataReader reader = command.ExecuteReader())
                            {
                                if (reader.Read())
                                {
                                    // Store IDs for saving
                                    travelerId = Convert.ToInt32(reader["traveler_id"]);
                                    tripId = Convert.ToInt32(reader["trip_id"]);

                                    // Populate form fields
                                    txtCustomerName.Text = reader["customer_name"].ToString();
                                    txtServiceName.Text = reader["trip_name"].ToString();

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

                                    if (reader["participants"] != DBNull.Value)
                                    {
                                        nudParticipants.Value = Convert.ToInt32(reader["participants"]);
                                    }

                                    if (reader["total_amount"] != DBNull.Value)
                                    {
                                        nudAmount.Value = Convert.ToDecimal(reader["total_amount"]);
                                    }

                                    string status = reader["status"].ToString();
                                    cboStatus.SelectedItem = string.IsNullOrEmpty(status) ? "pending" : status;

                                    txtSpecialRequests.Text = reader["special_requests"]?.ToString() ?? "";
                                }
                                else
                                {
                                    MessageBox.Show("Booking not found!", "Error",
                                        MessageBoxButtons.OK, MessageBoxIcon.Error);
                                    this.Close();
                                }
                            }
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show($"Error loading booking details: {ex.Message}", "Database Error",
                        MessageBoxButtons.OK, MessageBoxIcon.Error);
                    this.Close();
                }
            }

            private void BtnSave_Click(object sender, EventArgs e)
            {
                try
                {
                    using (SqlConnection connection = new SqlConnection(connectionString))
                    {
                        connection.Open();

                        // Update the booking record
                        string updateQuery = @"
                            UPDATE Booking 
                            SET booking_date = @BookingDate,
                                participants = @Participants,
                                total_amount = @TotalAmount,
                                status = @Status,
                                special_requests = @SpecialRequests
                            WHERE booking_id = @BookingId";

                        using (SqlCommand command = new SqlCommand(updateQuery, connection))
                        {
                            command.Parameters.AddWithValue("@BookingId", bookingId);
                            command.Parameters.AddWithValue("@BookingDate", dtpBookingDate.Value);
                            command.Parameters.AddWithValue("@Participants", (int)nudParticipants.Value);
                            command.Parameters.AddWithValue("@TotalAmount", nudAmount.Value);
                            command.Parameters.AddWithValue("@Status", cboStatus.SelectedItem.ToString());

                            if (string.IsNullOrWhiteSpace(txtSpecialRequests.Text))
                                command.Parameters.AddWithValue("@SpecialRequests", DBNull.Value);
                            else
                                command.Parameters.AddWithValue("@SpecialRequests", txtSpecialRequests.Text);

                            int rowsAffected = command.ExecuteNonQuery();

                            if (rowsAffected > 0)
                            {
                                MessageBox.Show("Booking updated successfully!", "Success",
                                    MessageBoxButtons.OK, MessageBoxIcon.Information);
                                this.DialogResult = DialogResult.OK;
                            }
                            else
                            {
                                MessageBox.Show("No changes were made. The booking may have been deleted.",
                                    "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                            }
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show($"Error updating booking: {ex.Message}", "Database Error",
                        MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }

        private void btnRefresh_Click(object sender, EventArgs e)
        {
            LoadBookings();
        }

        private void dgvBookings_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            // Ensure we're clicking on the Status column and not the header
            if (e.ColumnIndex == dgvBookings.Columns["Status"].Index && e.RowIndex >= 0)
            {
                dgvBookings.BeginEdit(true);
                ((ComboBox)dgvBookings.EditingControl).DroppedDown = true;
            }
        }

        // Navigation button handlers
        private void btnRegistration_Click_1(object sender, EventArgs e)
        {
            ServiceIntegrationForm abc = new ServiceIntegrationForm();
            abc.Show();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            ServiceListingForm abc = new ServiceListingForm();
            abc.Show();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            // We're already on this form, but we could refresh it
            LoadBookings();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            PerformanceReportForm abc = new PerformanceReportForm();
            abc.Show();
        }

        private void panelSidebar_Paint(object sender, PaintEventArgs e)
        {
            // This is an empty event handler
        }
    }
}