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);
}
