public void testAddShowing()
        {
            ShowingsClass.addShowing(2, "2017-06-20 11:00", 5, 2, 1);
            dataSet = ShowingsClass.getShowingByShowingId(2);

            string actualShowingDate             = dataSet.Tables[0].Rows[0]["Date"].ToString();
            double actualShowingUpperCirclePrice = double.Parse(dataSet.Tables[0].Rows[0]["UpperCirclePrice"].ToString());
            double actualShowingDressCirclePrice = double.Parse(dataSet.Tables[0].Rows[0]["DressCirclePrice"].ToString());
            double actualShowingStallPrice       = double.Parse(dataSet.Tables[0].Rows[0]["StallsPrice"].ToString());

            string expectedShowingDate             = "2017-06-20 11:00";
            double expectedShowingUpperCirclePrice = 5;
            double expectedShowingDressCirclePrice = 2;
            double expectedShowingStallPrice       = 1;

            Assert.AreEqual(expectedShowingDate, actualShowingDate);
            Assert.AreEqual(expectedShowingUpperCirclePrice, actualShowingUpperCirclePrice);
            Assert.AreEqual(expectedShowingDressCirclePrice, actualShowingDressCirclePrice);
            Assert.AreEqual(expectedShowingStallPrice, actualShowingStallPrice);
        }