public void Setup()
{
transaction = new TransactionScope();
parkSqlDao = new ParkSqlDAO(ConnectionString);
campgroundSqlDao = new CampgroundSqlDAO(ConnectionString);
siteSqlDAO = new SiteSqlDAO(ConnectionString);
reservationSqlDAO = new ReservationSqlDAO(ConnectionString);
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
SqlCommand cmdPark = new SqlCommand($"select count(*) from park where name = '{name}'", connection);
SqlCommand cmdCampground = new SqlCommand($"select count(*) from campground where park_id in (select park_id from park where name = '{name}')", connection);
SqlCommand cmdSite = new SqlCommand($"select count(*) from site where campground_id in (select campground_id from campground where name = '{nameCampground}')", connection);
if (Convert.ToInt32(cmdPark.ExecuteScalar()) == 0)
{
cmdPark = new SqlCommand($"insert into park values('{name}', '{location}', '{establish_date}', {area}, {visitors}, '{discription}')", connection);
cmdPark.ExecuteNonQuery();
}
if (Convert.ToInt32(cmdCampground.ExecuteScalar()) == 0)
{
cmdCampground = new SqlCommand($" insert into campground (park_id, name, open_from_mm, open_to_mm, daily_fee) values((select park_id from park where name = '{name}'), '{nameCampground}', {open_from_mm}, {open_to_mm}, {daily_fee})", connection);
cmdCampground.ExecuteNonQuery();
}
if (Convert.ToInt32(cmdSite.ExecuteScalar()) == 0)
{
cmdSite = new SqlCommand($" insert into site (campground_id, site_number, max_occupancy, accessible, max_rv_length, utilities) values((select campground_id from campground where name = '{nameCampground}'), 13, 6, 0, 0, 1)", connection);
cmdSite.ExecuteNonQuery();
}
}
}
public void BookReservationsTest()
{
//initialize reservation
Reservation alpha = new Reservation();
//gets connections
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
//opens connection
connection.Open();
//Arrange
//querystring = the query we want to put into the SQL databse to get the values for the reservation
string queryString = $"SELECT * FROM reservation WHERE reservation_id = {BlackLodgeReservationId}";
//takes query string and makes it into a command that can be used in SQL
SqlCommand command = new SqlCommand(queryString, connection);
//gets the data returend by the query
SqlDataReader reader = command.ExecuteReader();
//the reader reads row by row, in this case only reading the one row
while (reader.Read())
{
alpha = new Reservation(reader);
}
}
ReservationSqlDAO beta = new ReservationSqlDAO(ConnectionString);
//Act
int testRes = beta.BookReservation(alpha);
//Assert
Assert.IsTrue(testRes != 0);
}
private void DisplayInfoForReservation(Campground campground, string arrivalDate, string departureDate)
{
int count = 1;
IList <Site> topFiveSiteList = siteDAO.GetTop5SitesInCampground(campground, arrivalDate, departureDate);
foreach (Site campsite in topFiveSiteList)
{
string Accessible = ReturnYesORNoForBool(campsite.Accessible);
string Utilities = ReturnYesORNoForBool(campsite.Utilities);
Console.WriteLine("");
Console.Write($"{count}){campsite.Site_Number}".PadRight(10));
Console.Write($"\t {campsite.Max_Occupancy}".PadRight(10));
Console.Write($"\t {Accessible}".PadRight(10));
Console.Write($"\t {campsite.Max_RV_Length}".PadRight(10));
Console.Write($"\t {Utilities}".PadRight(10));
Console.Write($"\t {campground.Daily_Fee:C}".PadRight(10));
Console.WriteLine("");
count++;
}
int siteNumber = GetInteger("Which site should be reserved (enter 0 to cancel)?");
string name = GetString("What name should the reservation be made under?");
Site site = topFiveSiteList.ElementAt(siteNumber - 1);
ReservationSqlDAO ReservationDAO = new ReservationSqlDAO(ConnectionString);
int reservationId = ReservationDAO.CreateNewReservation(site, name, arrivalDate, departureDate);
Console.WriteLine($"The reservation has been made and the confirmation id is {reservationId}");
Pause("");
ViewParksMenu menu = new ViewParksMenu();
menu.Run();
}
public void GetReservation_ShouldReturnCorrectInformation_AndConvertReservationToReaderWorks()
{
ReservationSqlDAO dao = new ReservationSqlDAO(ConnectionString);
Reservation reservation = dao.GetReservation(this.ReservationId);
Assert.AreEqual("Flintstone", reservation.Name);
}
public void CreateReservationTest()
{
// Arrange
IReservationDAO dao = new ReservationSqlDAO(connection);
// Act
Reservation r = new Reservation()
{
SiteID = 2,
Name = "Ryan Family Reservation",
FromDate = DateTime.Now,
ToDate = DateTime.Now,
CreateDate = DateTime.Now
};
Reservation r2 = new Reservation()
{
SiteID = 3,
Name = "Bauer Family Reservation",
FromDate = DateTime.Now,
ToDate = DateTime.Now,
CreateDate = DateTime.Now
};
int thisOneIs45 = dao.CreateReservation(r);
int thisOneIs46 = dao.CreateReservation(r2);
// Assert
Assert.AreEqual(45, thisOneIs45);
Assert.AreEqual(46, thisOneIs46);
Assert.AreEqual(46, dao.GetAllReservations().Count);
}
public override void Setup()
{
base.Setup();
daoR = new ReservationSqlDAO(ConnectionString);
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
string reservationSearch = @"
SET IDENTITY_INSERT Park ON
INSERT INTO Park (park_id, name, location, establish_date, area, visitors, description)
VALUES (1, 'Franklin', 'Ohio', '2010-01-01', 120, 120, 'Cool place')
SET IDENTITY_INSERT PARK OFF
SET IDENTITY_INSERT campground ON INSERT INTO campground (campground_id, park_id, name, open_from_mm, open_to_mm, daily_fee)
VALUES (144, 1, 'BlackWoods', 1, 12, 35.00)
SET IDENTITY_INSERT campground OFF
SET IDENTITY_INSERT site ON INSERT INTO site (site_id, campground_id, site_number, max_occupancy, accessible, max_rv_length, utilities)
VALUES (96, 144, 12, 6, 0, 0, 0)
SET IDENTITY_INSERT site OFF
INSERT INTO reservation(site_id, name, from_date, to_date, create_date)
VALUES((SELECT site_id FROM site WHERE site_number = 12), 'Hobo Family Reservation', '2019-01-01', '2019-12-31', '2010-01-01'); SELECT SCOPE_IDENTITY()";
SqlCommand command = connection.CreateCommand();
command.CommandText = reservationSearch;
connection.Open();
newReservationId = Convert.ToInt32(command.ExecuteScalar());
}
}
public void GetAllReservationsTest()
{
ReservationSqlDAO res = new ReservationSqlDAO();
IList <Reservation> actualResult = res.GetAllReservations();
Assert.IsTrue(actualResult.Count > 0);
}
/// <summary>
/// Constructor adds items to the top-level menu. You will likely have parameters passed in
/// here...
/// </summary>
public MainMenu(ParkSqlDAO park, CampgroundSqlDAO campground, SiteSqlDAO site, ReservationSqlDAO reservation) : base("Main Menu")
{
this.parkDao = park;
this.campgroundDao = campground;
this.siteDao = site;
this.reservationDao = reservation;
parks = this.parkDao.GetParks();
}
public void PlaceReservation_Should_Return_ReservationId()
{
ReservationSqlDAO dao = new ReservationSqlDAO(base.ConnectionString);
int newReservationId = dao.PlaceReservation("doesn't matter", base.CampsiteId, DateTime.Now, DateTime.Now);
Assert.AreEqual(base.NewReservationId + 1, newReservationId);
}
public void UpcomingReservationHappyPathTest()
{
ReservationSqlDAO dao = new ReservationSqlDAO(ConnectionString);
IList <Reservation> reservations = dao.UpcomingReservations(ParkId);
Assert.AreEqual(2, reservations.Count);
}
/// <summary>
/// Constructor adds items to the top-level menu
/// </summary>
public CampgroundMenu(Park park, CampgroundSqlDAO campgroundDao, SiteSqlDAO siteDao, ReservationSqlDAO reservationDao) :
base("Park Menu")
{
this.campgroundDao = campgroundDao;
this.siteDao = siteDao;
this.reservationDao = reservationDao;
this.park = park;
}
public void GetAllReservations_ReturnsCorrectNumberOfResrevations()
{
ReservationSqlDAO dao = new ReservationSqlDAO(connectionString);
IList <Reservation> reservationList = dao.GetAllReservationInformation();
Assert.AreEqual(2, reservationList.Count);
}
/// <summary>
/// Constructor adds items to the top-level menu
/// </summary>
public SiteMenu(Park park, Campground campground, SiteSqlDAO siteDao, ReservationSqlDAO reservationDao, string arrivalDate, string departureDate) :
base("Park Menu")
{
this.siteDao = siteDao;
this.reservationDao = reservationDao;
this.campground = campground;
this.arrivalDate = arrivalDate;
this.departureDate = departureDate;
this.park = park;
}
public void GetAllReservations_ShouldReturn1()
{
//Arrange
ReservationSqlDAO dao = new ReservationSqlDAO(ConnectionString);
//Act
IList <Reservation> output = dao.GetAllReservations(this.SiteId);
//Assert
Assert.AreEqual(1, output.Count);
}
public void ViewReservationsTest1()
{
//arrange
ReservationSqlDAO dao = new ReservationSqlDAO(connectionString);
//act
IList <Reservation> listOfReservations = dao.ViewReservations();
//assert
Assert.AreEqual(30, listOfReservations.Count);
}
public void GetReservationBySitesTest()
{
//Arrange
ReservationSqlDAO reservationSqlDAO = new ReservationSqlDAO(connectionString);
//Act
IList <Reservations> reservations = reservationSqlDAO.GetReservationBySites(testCampsiteId);
//Assert
Assert.IsTrue(reservations.Count > 0);
}
public void AvailablityTest()
{
// Arrange
ReservationSqlDAO reserve = new ReservationSqlDAO(connectionString);
var date1 = new DateTime(2008, 10, 10);
// Act
reserve.IsAvailable(date1, date1, 1);
//Assert
Assert.AreEqual(true, true);
}
public void GetAvailableSites_Test_Should_Return_List()
{
//Arrange
ReservationSqlDAO dao = new ReservationSqlDAO(this.connectionString);
//Act
List <Site> list = dao.GetAvailableSites(start, end, this.BlackwoodsID);
//Assert
Assert.AreEqual(5, list.Count);
}
public void SearchReservationsTest()
{
DateTime fromDate = DateTime.Parse("2020-08-10");
DateTime toDate = DateTime.Parse("2020-08-11");
ReservationSqlDAO reservationSql = new ReservationSqlDAO(connectionString);
IList <Reservation> reservations = new List <Reservation>();
reservations = reservationSql.SearchReservations("1", fromDate, toDate);
Assert.IsTrue(reservations.Count > 0);
}
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 AvailableSitesTests()
{
// Arrange
ReservationSqlDAO dao = new ReservationSqlDAO(connectionString);
// Act
int actual = dao.BookReservation("Joe Schmo", lastSiteId, new DateTime(2020, 04, 05), new DateTime(2020, 04, 07));
// Assert
Assert.AreEqual(Confirmation + 1, actual);
}
public void CreateReservation_Should_ReturnNewReservationId()
{
// Arrange
ReservationSqlDAO dao = new ReservationSqlDAO(ConnectionString);
// Act
int returnedId = dao.CreateReservation(SiteId, "Test Name", DateTime.Now.AddDays(1), DateTime.Now.AddDays(3));
// Assert
Assert.AreEqual(ReservationId + 1, returnedId);
}
public void GetReservationsShouldReturnAllReservations()
{
//Arrange
ReservationSqlDAO dao = new ReservationSqlDAO(ConnectionString);
//Act
//Assert
}
public void GetReservationsWithin30DaysSelectedPark()
{
//ARRANGE
ReservationSqlDAO dao = new ReservationSqlDAO(ConnectionString);
//ACT
List <Reservation> result = (List <Reservation>)dao.GetReservationsWithin30DaysSelectedPark(ParkId.ToString());
//ASSERT
Assert.AreEqual(2, result.Count);
}
public void IsAvailableTest2()
{
// Arrange
ReservationSqlDAO reserve = new ReservationSqlDAO(connectionString);
var date1 = new DateTime(2019, 10, 10);
// Act
reserve.IsAvailable(date1, date1, 1);
//Assert
Assert.AreEqual(false, false);
}
public void TestCreateReservation()
{
ReservationSqlDAO dao = new ReservationSqlDAO(connectionString);
DateTime fromDate = Convert.ToDateTime("06/18/2020");
DateTime toDate = Convert.ToDateTime("06/19/2020");
int reservation = dao.BookReservation(site_id, "Bob", fromDate, toDate);
Assert.IsNotNull(reservation);
}
public void GetReservationByIDTest()
{
// Arrange
IReservationDAO dao = new ReservationSqlDAO(connection);
// Act
Reservation r = dao.GetReservationByID(4);
// Assert
Assert.AreEqual("Bauer Family Reservation", r.Name);
Assert.IsNull(dao.GetReservationByID(50));
}
public void IsInSeasonTest()
{
//arrange
ReservationSqlDAO dao = new ReservationSqlDAO(connectionString);
//act
DateTime startDate = new DateTime(2019, 10, 19);
DateTime endDate = new DateTime(2019, 10, 21);
bool isInSeason = dao.IsInSeason(1, startDate, endDate);
//assert
Assert.IsTrue(isInSeason);
}
public void CreateReservationTest()
{
//arrange
ReservationSqlDAO dao = new ReservationSqlDAO(connectionString);
//act
DateTime startDate = new DateTime(2019, 10, 19);
DateTime endDate = new DateTime(2019, 10, 21);
int reservationId = dao.CreateReservation(1, "Voldemort", startDate, endDate);
//assert
Assert.AreEqual(47, reservationId);
}
public void GetAllReservationsTest()
{
// Arrange
IList <Reservation> reservations;
IReservationDAO dao = new ReservationSqlDAO(connection);
// Act
reservations = dao.GetAllReservations();
// Assert
Assert.AreEqual(44, reservations.Count);
}
