private static void NewOne()
        {
            BasketDal dal = new BasketDal(ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString);

            BasketDTO m = new BasketDTO
            {
                // BasketID = 2,
                Title    = "Mizery",
                UserID   = 1,
                BookID   = 1,
                StatusID = 2,
                Author   = "King",
                Price    = 150,
                Amount   = 1,
                Date     = DateTime.Now
            };

            m = dal.CreateBasket(m);
            Console.WriteLine($"New basket ID: {m.Title}");

            foreach (var basket in dal.GetAllBaskets())
            {
                Console.WriteLine($"{basket.BasketID}\t{basket.Title}\t{basket.Price}");
            }

            Console.WriteLine($"Deleting basket ID: {m.BasketID}");
            dal.DeleteBasket(m.BasketID);
            foreach (var basket in dal.GetAllBaskets())
            {
                Console.WriteLine($"{basket.BasketID}\t{basket.Title}\t{basket.Price}");
            }
        }
        public void GetAllTest()
        {
            BasketDal dal    = new BasketDal(ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString);
            var       result = dal.CreateBasket(new BasketDTO
            {
                Title    = "Test for all baskets",
                UserID   = 1,
                BookID   = 1,
                StatusID = 1,
                Author   = "Test one",
                Price    = 100,
                Amount   = 1,
                Date     = DateTime.Now
            });
            var movies = dal.GetAllBaskets();

            Assert.AreEqual(1, movies.Count(x => x.Title == "get all baskets"));
        }