---

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

namespace WindowsFormsApp6
{
    public partial class Admin : Form
    {
        string connStr = @"Data Source=(LocalDB)\MSSQLLocalDB;
        AttachDbFilename=|DataDirectory|\HotelDB.mdf;
        Integrated Security=True";

        public Admin()
        {
            InitializeComponent();
        }

        // Загрузка таблицы
        private void buttonLoad_Click(object sender, EventArgs e)
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();

                SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Rooms", conn);
                DataTable dt = new DataTable();
                da.Fill(dt);

                dataGridView1.DataSource = dt;
            }
        }

        // Добавить номер
        private void buttonAdd_Click(object sender, EventArgs e)
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();

                string query = @"INSERT INTO Rooms (RoomNumber, Type, Price, IsOccupied)
                                 VALUES (@num, @type, @price, 0)";

                SqlCommand cmd = new SqlCommand(query, conn);
                cmd.Parameters.AddWithValue("@num", textBoxNumber.Text);
                cmd.Parameters.AddWithValue("@type", textBoxType.Text);
                cmd.Parameters.AddWithValue("@price", textBoxPrice.Text);

                cmd.ExecuteNonQuery();

                MessageBox.Show("Добавлено");
            }
        }

        // Удалить номер
        private void buttonDelete_Click(object sender, EventArgs e)
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();

                string query = "DELETE FROM Rooms WHERE Id=@id";

                SqlCommand cmd = new SqlCommand(query, conn);
                cmd.Parameters.AddWithValue("@id", textBoxId.Text);

                cmd.ExecuteNonQuery();

                MessageBox.Show("Удалено");
            }
        }

        // Сделать занятым
        private void buttonSetBusy_Click(object sender, EventArgs e)
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();

                string query = "UPDATE Rooms SET IsOccupied = 1 WHERE Id=@id";

                SqlCommand cmd = new SqlCommand(query, conn);
                cmd.Parameters.AddWithValue("@id", textBoxId.Text);

                cmd.ExecuteNonQuery();

                MessageBox.Show("Номер занят");
            }
        }

        // Сделать свободным
        private void buttonSetFree_Click(object sender, EventArgs e)
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();

                string query = "UPDATE Rooms SET IsOccupied = 0 WHERE Id=@id";

                SqlCommand cmd = new SqlCommand(query, conn);
                cmd.Parameters.AddWithValue("@id", textBoxId.Text);

                cmd.ExecuteNonQuery();

                MessageBox.Show("Номер свободен");
            }
        }
    }
}