query to reserve a slot in csharp

main.cs
string connectionString = "YourConnectionString";
string query = "UPDATE Slots SET IsReserved = @IsReserved, ReservedBy = @ReservedBy WHERE SlotId = @SlotId";

using (SqlConnection connection = new SqlConnection(connectionString))
using (SqlCommand command = new SqlCommand(query, connection))
{
    command.Parameters.AddWithValue("@IsReserved", true);
    command.Parameters.AddWithValue("@ReservedBy", "YourName");
    command.Parameters.AddWithValue("@SlotId", 1); // Replace with the slot ID

    connection.Open();
    int result = command.ExecuteNonQuery();

    if (result > 0)
    {
        Console.WriteLine("Slot reserved successfully");
    }
    else
    {
        Console.WriteLine("Slot is already reserved");
    }
}
733 chars
23 lines