public void MakeReservationTest() { // Arrange ReservationSqlDAO reserve = new ReservationSqlDAO(connectionString); var date1 = new DateTime(2008, 10, 10); // Act reserve.MakeReservation(date1, date1, "bob", 1); //Assert Assert.AreEqual(false, false); }
public void TestMakeReservation() { //Arrange ReservationSqlDAO dao = new ReservationSqlDAO(connectionString); //Act Reservation reservation = dao.MakeReservation(10, newCampgroundId, "Fries Island", Convert.ToDateTime("01/05/2020"), Convert.ToDateTime("03/05/2020")); //Assert Assert.AreEqual("Fries Island", reservation.Name); Assert.AreEqual(Convert.ToDateTime("01/05/2020"), reservation.StartDate); }
public void MakeReservation_Test() { IReservationDAO dao = new ReservationSqlDAO(connectionString); int beforeCount = GetCount("reservation"); Site site = new Site(); site.SiteID = this.siteId; int id = dao.MakeReservation(site, Convert.ToDateTime("2019-06-20"), Convert.ToDateTime("2019-06-29"), "Eisenberg"); int afterCount = GetCount("reservation"); Assert.AreEqual(beforeCount + 1, afterCount); Assert.AreNotEqual(0, id); }
public void MakeReservation() { int reservationId = 0; Reservation newReservation = new Reservation { SiteId = 1, FromDate = Convert.ToDateTime("2019-05-10"), ToDate = Convert.ToDateTime("2019-05-15"), Name = "Fake Reservation" }; reservationId = dao.MakeReservation(newReservation); Assert.AreNotEqual(0, reservationId); }
public void MakeReservation() { //Arrange ReservationSqlDAO dao = new ReservationSqlDAO(connectionString); Reservation reservation = new Reservation(); reservation.FromDate = new DateTime(2019, 5, 11); reservation.ToDate = new DateTime(2019, 5, 13); reservation.Name = "Glenn"; reservation.SiteId = newSiteId; //Act int actualResult = dao.MakeReservation(reservation); //Assert Assert.AreEqual(newReservationId + 1, actualResult); }
public void MakeReservationReturnsCorrectIDTest() { DateTime Arrival = new DateTime(2019, 07, 20); DateTime Departure = new DateTime(2019, 07, 23); string createTime = DateTime.Now.ToString(); Reservation TestReservation = new Reservation(); TestReservation.SiteId = SiteId; TestReservation.ReservationName = "Jane Doe"; TestReservation.Arrival = Arrival; TestReservation.Departure = Departure; TestReservation.CreateDate = createTime; dao = new ReservationSqlDAO(ConnectionString); int idNumber = dao.MakeReservation(TestReservation); Assert.AreEqual((ReservationId + 1), idNumber); }
public void TestViewAllUpcomingReservations() { //Arrange ReservationSqlDAO dao = new ReservationSqlDAO(connectionString); Reservation reservation = dao.MakeReservation(10, newCampgroundId, "Fries Island", Convert.ToDateTime("02/29/2020"), Convert.ToDateTime("03/01/2020")); //Act IList <Reservation> reservations = dao.ViewAllUpcomingReservations(DateTime.Now, Convert.ToDateTime("03/01/2020")); //int i = 0; //for (; i < reservations.Count; i++) //{ // if (reservations[i].ReservationId == newReservationId) // { // break; // } //} //Assert Assert.AreEqual(Convert.ToDateTime("03/01/2020"), reservations[reservations.Count - 1].EndDate); }
public void MakeReservationTests() { // Arrange ReservationSqlDAO dao = new ReservationSqlDAO(connectionString); Reservation r1 = new Reservation(); r1.SiteId = newsite_id; r1.Name = "Test Family"; r1.FromDate = DateTime.Parse("2021-06-15"); r1.ToDate = DateTime.Parse("2021-06-30"); r1.CreateDate = DateTime.Now; //@site_id, 'Asimov Family', '2020-06-15','2020-06-30', '2020-05-01' //Act int reservation_id = dao.MakeReservation(r1); //Assert // At least 1 Campground Assert.IsTrue(reservation_id > 0); }
public void MakeReservationTest() { // Arrange int resId1; int resId2; int resIdReturn2; int resIdReturn1; Reservation reservation = new Reservation { Name = "Und R. Doge", From_Date = DateTime.Now.AddDays(40), To_Date = DateTime.Now.AddDays(45) }; Reservation reservation2 = new Reservation { Name = "Jeeyai Jhoe", From_Date = DateTime.Now.AddDays(45), To_Date = DateTime.Now.AddDays(52) }; using (SqlConnection connection = new SqlConnection(ConnectionString)) { SqlCommand command = new SqlCommand( @"SELECT s.site_id FROM site s JOIN campground c ON s.campground_id = c.campground_id WHERE s.site_number = 4 AND c.name = 'The Back Yard'", connection); SqlCommand command2 = new SqlCommand( @"SELECT s.site_id FROM site s JOIN campground c ON s.campground_id = c.campground_id WHERE s.site_number = 2 AND c.name = 'The Front Yard'", connection); SqlCommand command3 = new SqlCommand( "SELECT park_id FROM park WHERE name = 'Casa de Jesse'", connection); connection.Open(); reservation.Site_Id = Convert.ToInt32(command.ExecuteScalar()); reservation2.Site_Id = Convert.ToInt32(command2.ExecuteScalar()); parkId = Convert.ToInt32(command3.ExecuteScalar()); } // Act resId1 = dao.MakeReservation(parkId, reservation); resId2 = dao.MakeReservation(parkId, reservation2); using (SqlConnection connection = new SqlConnection(ConnectionString)) { SqlCommand command = new SqlCommand( "SELECT reservation_id FROM reservation WHERE name = 'Und R. Doge'", connection); SqlCommand command2 = new SqlCommand( "SELECT reservation_id FROM reservation WHERE name = 'Jeeyai Jhoe'", connection); connection.Open(); resIdReturn1 = Convert.ToInt32(command.ExecuteScalar()); resIdReturn2 = Convert.ToInt32(command2.ExecuteScalar()); } // Assert Assert.AreEqual(4, GetRowCount("reservation")); Assert.AreEqual(resIdReturn1, resId1); Assert.AreEqual(resIdReturn2, resId2); }