ServiceIntegration.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 DB_Project
{
    public partial class ServiceIntegrationForm : Form
    {
        // Connection string for SQL Server database
        private string connectionString = @"Data Source=ABDULSABOOR190\SQLEXPRESS;Initial Catalog=sabbbb;Integrated Security=True;Encrypt=False";

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

        private void SetupForm()
        {
            // Initialize the combo box with default selection
            if (cmbType.Items.Count > 0)
                cmbType.SelectedIndex = 0;
        }

        // 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(45, 62, 80);
                    btn.ForeColor = Color.White;
                }
            }

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

        // Event handler for combo box selection change
        private void cmbType_SelectedIndexChanged(object sender, EventArgs e)
        {
            // Show hotel-specific fields only when "Hotel" is selected
            if (cmbType.SelectedItem != null && cmbType.SelectedItem.ToString() == "Hotel")
            {
                groupBox3.Visible = true;
            }
            else
            {
                groupBox3.Visible = false;
            }
        }

        // Method to validate user inputs
        private bool ValidateInputs()
        {
            if (string.IsNullOrWhiteSpace(txtProviderName.Text))
            {
                MessageBox.Show("Please enter a provider name.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }

            if (cmbType.SelectedItem == null)
            {
                MessageBox.Show("Please select a provider type.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }

            if (string.IsNullOrWhiteSpace(txtLocation.Text))
            {
                MessageBox.Show("Please enter a location.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }

            if (string.IsNullOrWhiteSpace(txtServiceName.Text))
            {
                MessageBox.Show("Please enter a service name.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }

            if (numPricePerUnit.Value <= 0)
            {
                MessageBox.Show("Price per unit must be greater than zero.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }

            if (numTotalUnits.Value <= 0)
            {
                MessageBox.Show("Total units must be greater than zero.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }

            // Hotel-specific validation
            if (cmbType.SelectedItem.ToString() == "Hotel" && string.IsNullOrWhiteSpace(txtAddress.Text))
            {
                MessageBox.Show("Please enter a hotel address.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }

            return true;
        }

        // Method to insert a new service provider
        private int InsertServiceProvider()
        {
            int providerId = -1;
            string type = cmbType.SelectedItem.ToString().ToLower();

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

                    // First, create a new user entry
                    string insertUserQuery = @"
                    INSERT INTO AppUser (email, password_hash, registration_status, role, is_active)
                    VALUES (@Email, 'dummyHash', 'approved', 'service_provider', 1);
                    SELECT SCOPE_IDENTITY();";

                    SqlCommand cmdUser = new SqlCommand(insertUserQuery, connection);
                    cmdUser.Parameters.AddWithValue("@Email", $"{txtProviderName.Text.Replace(" ", "")}@travelexplorer.com");

                    // Get the new user ID
                    int userId = Convert.ToInt32(cmdUser.ExecuteScalar());

                    // Now insert into ServiceProviderProfile
                    string insertProviderQuery = @"
                    INSERT INTO ServiceProviderProfile (user_id, provider_name, type, location, contact_info, is_verified)
                    VALUES (@UserId, @ProviderName, @Type, @Location, 'contact', 1);";

                    SqlCommand cmdProvider = new SqlCommand(insertProviderQuery, connection);
                    cmdProvider.Parameters.AddWithValue("@UserId", userId);
                    cmdProvider.Parameters.AddWithValue("@ProviderName", txtProviderName.Text);
                    cmdProvider.Parameters.AddWithValue("@Type", type);
                    cmdProvider.Parameters.AddWithValue("@Location", txtLocation.Text);
                    cmdProvider.ExecuteNonQuery();

                    // If it's a hotel, add hotel details
                    if (type == "hotel")
                    {
                        // Build amenities string
                        List<string> amenities = new List<string>();
                        if (chkPool.Checked) amenities.Add("Pool");
                        if (chkWifi.Checked) amenities.Add("WiFi");
                        if (chkBreakfast.Checked) amenities.Add("Breakfast");
                        if (chkParking.Checked) amenities.Add("Parking");
                        string amenitiesStr = string.Join(", ", amenities);

                        string insertHotelQuery = @"
                        INSERT INTO Hotel (provider_id, name, address, star_rating, amenities, total_rooms, description)
                        VALUES (@ProviderId, @Name, @Address, 3, @Amenities, 10, 'Standard hotel description');";

                        SqlCommand cmdHotel = new SqlCommand(insertHotelQuery, connection);
                        cmdHotel.Parameters.AddWithValue("@ProviderId", userId);
                        cmdHotel.Parameters.AddWithValue("@Name", txtProviderName.Text);
                        cmdHotel.Parameters.AddWithValue("@Address", txtAddress.Text);
                        cmdHotel.Parameters.AddWithValue("@Amenities", amenitiesStr);
                        cmdHotel.ExecuteNonQuery();
                    }

                    providerId = userId;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show($"Database error: {ex.Message}", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }

            return providerId;
        }

        // Method to insert a new service
        private void InsertService(int providerId)
        {
            try
            {
                using (SqlConnection connection = new SqlConnection(connectionString))
                {
                    connection.Open();

                    string insertServiceQuery = @"
                    INSERT INTO Service (provider_id, name, type, price_per_unit, total_units, location, description, status)
                    VALUES (@ProviderId, @Name, @Type, @PricePerUnit, @TotalUnits, @Location, 'Service description', 'available');";

                    SqlCommand cmd = new SqlCommand(insertServiceQuery, connection);
                    cmd.Parameters.AddWithValue("@ProviderId", providerId);
                    cmd.Parameters.AddWithValue("@Name", txtServiceName.Text);
                    cmd.Parameters.AddWithValue("@Type", cmbType.SelectedItem.ToString().ToLower());
                    cmd.Parameters.AddWithValue("@PricePerUnit", numPricePerUnit.Value);
                    cmd.Parameters.AddWithValue("@TotalUnits", numTotalUnits.Value);
                    cmd.Parameters.AddWithValue("@Location", txtLocation.Text);

                    cmd.ExecuteNonQuery();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show($"Database error: {ex.Message}", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        // Event handler for the Save button
        private void btnSave_Click(object sender, EventArgs e)
        {
            if (!ValidateInputs())
                return;

            try
            {
                // Begin transaction by inserting provider first
                int providerId = InsertServiceProvider();

                if (providerId > 0)
                {
                    // Then insert the service
                    InsertService(providerId);

                    MessageBox.Show("Service information saved successfully!", "Success",
                        MessageBoxButtons.OK, MessageBoxIcon.Information);

                    // Clear form fields after successful save
                    ClearFields();
                }
                else
                {
                    MessageBox.Show("Failed to create service provider.", "Error",
                        MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show($"An error occurred: {ex.Message}", "Error",
                    MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        // Clear all form fields
        private void ClearFields()
        {
            txtProviderName.Clear();
            txtLocation.Clear();
            txtServiceName.Clear();
            numPricePerUnit.Value = 0;
            numTotalUnits.Value = 0;
            txtAddress.Clear();
            chkPool.Checked = false;
            chkWifi.Checked = false;
            chkBreakfast.Checked = false;
            chkParking.Checked = false;

            if (cmbType.Items.Count > 0)
                cmbType.SelectedIndex = 0;
        }

        // Event handler for the Cancel button
        private void btnCancel_Click(object sender, EventArgs e)
        {
            // Close the form
            this.Close();
        }

        // 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)
        {
            BookingManagementForm abc = new BookingManagementForm();
            abc.Show();
        }

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

        #region Event handlers for UI elements - empty implementations

        private void panelTopBar_Paint(object sender, PaintEventArgs e) { }
        private void lblTravelExplorer_Click(object sender, EventArgs e) { }
        private void panelSidebar_Paint(object sender, PaintEventArgs e) { }
        private void groupBox1_Enter(object sender, EventArgs e) { }
        private void txtLocation_TextChanged(object sender, EventArgs e) { }
        private void txtProviderName_TextChanged(object sender, EventArgs e) { }
        private void label4_Click(object sender, EventArgs e) { }
        private void label3_Click(object sender, EventArgs e) { }
        private void label2_Click(object sender, EventArgs e) { }
        private void groupBox2_Enter(object sender, EventArgs e) { }
        private void numTotalUnits_ValueChanged(object sender, EventArgs e) { }
        private void numPricePerUnit_ValueChanged(object sender, EventArgs e) { }
        private void txtServiceName_TextChanged(object sender, EventArgs e) { }
        private void label7_Click(object sender, EventArgs e) { }
        private void label6_Click(object sender, EventArgs e) { }
        private void label5_Click(object sender, EventArgs e) { }
        private void groupBox3_Enter(object sender, EventArgs e) { }
        private void chkParking_CheckedChanged(object sender, EventArgs e) { }
        private void chkBreakfast_CheckedChanged(object sender, EventArgs e) { }
        private void chkWifi_CheckedChanged(object sender, EventArgs e) { }
        private void chkPool_CheckedChanged(object sender, EventArgs e) { }
        private void txtAddress_TextChanged(object sender, EventArgs e) { }
        private void label8_Click(object sender, EventArgs e) { }
        private void btnRegistration_Click(object sender, EventArgs e) { }
        private void btnSearchBooking_Click(object sender, EventArgs e) { }
        private void btnDashboard_Click(object sender, EventArgs e) { }
        private void btnDigitalTravelPass_Click(object sender, EventArgs e) { }
        private void btnReview_Click(object sender, EventArgs e) { }
        private void btnProfile_Click(object sender, EventArgs e) { }
        private void btnServiceIntegration_Click(object sender, EventArgs e) { }

        #endregion
    }
}