Practical DDD Step 1 - Refactoring to deeper insights

OnlineTickets.cs

using System;
using System.Data;
using System.Data.SqlClient;

namespace ddd_patterns
{
    public class OnlineTickets
    {
        private readonly string _connectionString;

        public OnlineTickets()
        {
            _connectionString = @"connection String";
        }


        public Guid AddTkt(Guid aId)
        {
            const string sql1 = @"SELECT get number of available tickets from db";

            using var connection = new SqlConnection(_connectionString);
            var command = new SqlCommand(sql1, connection);
            connection.Open();

            var reader = command.ExecuteReader();

            while (reader.Read())
            {
                var availableTickets = reader.GetInt32(0);

                if (availableTickets <= 0)
                {
                    throw new Exception("No Ticket available");
                }
            }

            reader.Close();
            var tId = Guid.NewGuid();
            const string sql2 = @"Insert into tickets... tId = @tId, aId = @aId";
            var command2 = new SqlCommand(sql2, connection);
            command2.Parameters.AddWithValue("@tId", tId);
            command2.Parameters.AddWithValue("@tad", aId);
            command2.ExecuteNonQuery();

            return tId;
        }

        public void DelTkt(Guid tId)
        {
            using var connection = new SqlConnection(_connectionString);

            const string sql = @"Delete FROM tickets WHERE tId = @tId";
            var command = new SqlCommand(sql, connection);
            command.Parameters.AddWithValue("@tId", tId);
            command.ExecuteNonQuery();
        }
    }
}