---

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

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

        public Guest()
        {
            InitializeComponent();
        }

        private void buttonLoad_Click(object sender, EventArgs e)
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();

                SqlDataAdapter da = new SqlDataAdapter(
                    "SELECT * FROM Rooms WHERE IsOccupied=0", conn);

                DataTable dt = new DataTable();
                da.Fill(dt);

                dataGridView1.DataSource = dt;
            }
        }

        private void buttonBook_Click(object sender, EventArgs e)
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();

                string query = @"INSERT INTO Bookings (ClientId, RoomId, DateFrom, DateTo)
                                 VALUES (1, @room, @from, @to)";

                SqlCommand cmd = new SqlCommand(query, conn);
                cmd.Parameters.AddWithValue("@room", textBoxRoomId.Text);
                cmd.Parameters.AddWithValue("@from", dateFrom.Value);
                cmd.Parameters.AddWithValue("@to", dateTo.Value);

                cmd.ExecuteNonQuery();

                MessageBox.Show("Забронировано");
            }
        }
    }
}