public void TestMakeReservationBySiteId()
        {
            //Arrange
            ReservationSqlDAO dao = new ReservationSqlDAO(connectionString);

            //Act
            Reservation reservation = dao.MakeReservationBySiteId(newSiteId, "Williams View", Convert.ToDateTime("01/24/1995"), Convert.ToDateTime("02/01/1995"));


            //Assert
            Assert.AreEqual(Convert.ToDateTime("02/01/1995"), reservation.EndDate);
            Assert.AreEqual("Williams View", reservation.Name);
        }