Main.cs

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

namespace Leaernify
{
    public partial class Main : UserControl
    {
        public Main()
        {
            InitializeComponent();
            loadDoesenCard();
        }
        SqlConnection con = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Learnify;Integrated Security=True;");
        SqlCommand cmd;

        public void loadDoesenCard()
        {
            flowLayoutPanel1.Controls.Clear();
            con.Open();
            string query = "SELECT * FROM pengajar";

            using (SqlCommand cmd = new SqlCommand(query, con))
            {
                using (SqlDataReader reader = cmd.ExecuteReader())
                {

                    while (reader.Read())
                    {
                        int id = reader.GetInt32(0);
                        string nama = reader.GetString(1);
                        string mataPelajaran = reader.GetString(2);
                        string status = reader.GetString(3);

                        if (status != null)
                        {

                            Panel dosenCard = CreateDosenCard(id, nama, mataPelajaran, status);
                            flowLayoutPanel1.Controls.Add(dosenCard);
                        }
                        else
                        {
                            Panel dosenCard = CreateDosenCard(id, "", "", status);
                            flowLayoutPanel1.Controls.Add(dosenCard);
                        }
                    }
                }

            }
        }

        private Panel CreateDosenCard(int id, string nama, string mataPelajaran, string status)
        {
            Panel card = new Panel
            {
                Size = new Size(250, 150),
                BorderStyle = BorderStyle.FixedSingle,
                BackColor = Color.White,
                Margin = new Padding(10),

            };

            Label lblNama = new Label
            {
                Font = new Font("Poppins", 12, FontStyle.Regular),
                Text = "Nama: " + nama,
                Location = new Point(10, 30),
                AutoSize = true
            };

            Label lblMataPelajaran = new Label
            {
                Font = new Font("Poppins", 10, FontStyle.Regular),
                Text = "Mata Pelajaran: " + mataPelajaran,
                AutoSize = true,
                Location = new Point(10, 60),
            };

            Button btnBooking = new Button
            {
                Font = new Font("Poppins", 7, FontStyle.Bold),
                Text = (status == "Booked") ? "Sudah Dipesan" : "Book",
                Location = new Point(10, 90),
                Enabled = (status != "Booked"),
                Tag = id,
                AutoSize = true,
                BackColor = (status == "Booked") ? Color.Gray : Color.FromArgb(96, 139, 193),
                ForeColor = Color.White,
                FlatStyle = FlatStyle.Flat
            };

            btnBooking.Click += BtnBooking_Click;

            card.Controls.Add(lblNama);
            card.Controls.Add(lblMataPelajaran);
            card.Controls.Add(btnBooking);

            return card;
        }

        private void BtnBooking_Click(object sender, EventArgs e)
        {
            Button btn = sender as Button;
            int pengajarID = (int)btn.Tag;
            int userID = userSession.id; // Ambil user_id dari session

            try
            {
                if (con.State == ConnectionState.Closed)
                {
                    con.Open();
                }

                // 🔹 Cek apakah pengajar masih available sebelum booking
                string checkQuery = "SELECT status FROM Pengajar WHERE id = @id";
                using (SqlCommand checkCmd = new SqlCommand(checkQuery, con))
                {
                    checkCmd.Parameters.AddWithValue("@id", pengajarID);
                    string status = checkCmd.ExecuteScalar()?.ToString();

                    if (status == "Booked")
                    {
                        MessageBox.Show("Pengajar sudah dibooking oleh orang lain!", "Gagal", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        return;
                    }
                }

                // 🔹 Masukkan data booking ke tabel Booking
                string insertQuery = "INSERT INTO Booking (user_id, pengajar_id, status) VALUES (@user_id, @pengajar_id, 'Booked')";
                using (SqlCommand insertCmd = new SqlCommand(insertQuery, con))
                {
                    insertCmd.Parameters.AddWithValue("@user_id", userID);
                    insertCmd.Parameters.AddWithValue("@pengajar_id", pengajarID);
                    insertCmd.ExecuteNonQuery();
                }

                MessageBox.Show("Berhasil melakukan booking!", "Sukses", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch (Exception ex)
            {
                MessageBox.Show("Terjadi kesalahan: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            finally
            {
                if (con.State == ConnectionState.Open)
                {
                    con.Close();
                }

                loadDoesenCard(); // 🔄 Refresh tampilan setelah booking
            }
        }



        private void flowLayoutPanel1_Paint(object sender, PaintEventArgs e)
        {

        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void panel1_Paint(object sender, PaintEventArgs e)
        {

        }
    }
}