/// <summary> /// In the makeAreservation method we again use the cli helper to take in user input. /// It calls the MakeReservation method from the ReservationSqlDAL class and uses it in a list /// We created variables of type string in and dateTime to store the user input then we called the reservation class /// from the models folder and assigned the user input to the variables in the reservation class which are get; set; properties /// We then call the list in a if statement again and if count of items in list is > 0 we then print out the response with the /// reservation id confirming their reservation has been created. /// </summary> private void MakeAreservation() { string name = CLIHelper.GetString("Please enter the reservation name: "); int site_id = CLIHelper.GetInteger("Please enter the site number: "); DateTime startDate = CLIHelper.GetDateTime("Please enter the arrival date(YYYY/MM/DD): "); DateTime endDate = CLIHelper.GetDateTime("Please enter the departure date(YYYY/MM/DD): "); Reservation newRes = new Reservation() { Name = name, SiteID = site_id, FromDate = startDate, ToDate = endDate, CreateDate = DateTime.Now }; ReservationSqlDAL dal = new ReservationSqlDAL(DatabaseConnection); List <Reservation> confirm = dal.MakeReservation(newRes); if (confirm.Count > 0) { Console.WriteLine(); Console.WriteLine("The reservation has been made and the confirmation ID is: " + confirm[0].ReservationId); } else { Console.WriteLine("DID NOT MAKE RESERVATION"); } }
public void ReservationConfirmationForPark(string arrivalDate, string departureDate, int camp_id, int parkSelection) { SiteSqlDAL site = new SiteSqlDAL(databaseconnectionString); ReservationSqlDAL bookReservation = new ReservationSqlDAL(databaseconnectionString); Console.WriteLine(); Console.Write("Which campground should be reserved? (enter 0 to cancel) "); int campInput = CLI_Helper.GetInteger("==>"); if (campInput == 0) { return; } Console.WriteLine(); Console.Write("Which camp site should be reserved? (enter 0 to cancel) "); int siteInput = CLI_Helper.GetInteger("==>"); if (siteInput == 0) { return; } Console.WriteLine(); Console.Write("Under what name should the reservation be held? "); string inputName = Console.ReadLine(); bookReservation.MakeReservation(parkSelection, site.GetSiteID(siteInput, camp_id), inputName, arrivalDate, departureDate); string reservationID = bookReservation.GetReservationId(inputName); Thread.Sleep(2000); Console.WriteLine(); Console.WriteLine($"The reservation has been booked and the confirmation ID is: {reservationID}"); Console.ReadLine(); }
private void Reservation(int campgroundId) { DateTime arrivalInput = CLIHelper.GetDateTime("What is your desired arrival date?(MM/DD/YYYY)"); DateTime fromDate = Convert.ToDateTime(arrivalInput); DateTime departureInput = CLIHelper.GetDateTime("When would you like to leave?(MM/DD/YYYY)"); DateTime toDate = Convert.ToDateTime(departureInput); Console.WriteLine("Showing available sites "); SiteSqlDAL sal = new SiteSqlDAL(connectionString); List <Site> allCampSites = sal.CampsiteAvailability(campgroundId, fromDate, toDate); if (allCampSites.Count() <= 0) { Console.WriteLine("No available camp sites! Please make a new selection."); return; } else { foreach (Site s in allCampSites) { Console.WriteLine(); Console.WriteLine("SiteId " + s.SiteID); Console.WriteLine("Campground_Id " + s.CampgroundID); Console.WriteLine("SiteNumber " + s.SiteNumber); Console.WriteLine("MaxOccupancy " + s.MaxOccupancy); Console.WriteLine("Handicap Accessible " + s.Accessible); Console.WriteLine("MaxRvLength " + s.MaxRvLength); Console.WriteLine("Utilities are available " + s.Utilities); } ReservationSqlDAL ral = new ReservationSqlDAL(connectionString); campgroundPrice = (ral.CostOfCampground(campgroundId) * (toDate.DayOfYear - fromDate.DayOfYear)); Console.WriteLine("The total fee for these sites are: " + campgroundPrice.ToString("C")); Console.WriteLine(); int campSiteInput = CLIHelper.GetInteger("What Camp site are you booking for?"); Console.WriteLine(); string nameInput = CLIHelper.GetString("What name should the reservation be under?"); Console.WriteLine(); DateTime createDate = DateTime.Now; int wasReservationSuccessful = ral.MakeReservations(campSiteInput, nameInput, fromDate, toDate, createDate); if (wasReservationSuccessful > 0) { Console.WriteLine("Success!"); Console.WriteLine("Here is your conformation ID: " + wasReservationSuccessful); } else { Console.WriteLine("Sorry but that site is alreaday booked. Please try again."); } } }
public void AddReservationTest() { ReservationSqlDAL dal = new ReservationSqlDAL(ConnectionString); int initialCount = GetRowCount(); Reservation reservation = new Reservation(); reservation.ReservationId = 2; reservation.SiteId = 1; reservation.Name = "Art Vandelay Reservation"; reservation.StartDate = new DateTime(2018, 07, 01); reservation.EndDate = new DateTime(2018, 07, 10); reservation.CreateDate = DateTime.Now; DateTime[] dateRange = new DateTime[2] { reservation.StartDate, reservation.EndDate }; var reservations = dal.AddReservation(reservation.SiteId, reservation.Name, dateRange); int finalCount = GetRowCount(); Assert.AreEqual(initialCount + 1, finalCount); }
public void GetReservationIdTest() { ReservationSqlDAL reservationtests = new ReservationSqlDAL(dbconnectionString); string testResult = reservationtests.GetReservationId("TestReservation"); Assert.AreEqual($"TestReservation_{reservation_idx}", testResult); }
public void CostOfStayTests() { int fakePark; int fakeCampground; decimal fakeOutput = 2.00M; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("Insert into Park values ('Big Fake Park', 'FAKE EVERYWHERE', '1919-02-26', 0000, 0, 'THIS IS SO FAKE ITS FUNNY')", conn); cmd.ExecuteNonQuery(); cmd = new SqlCommand("select cast(scope_identity() as int);", conn); fakePark = Convert.ToInt32(cmd.ExecuteScalar()); string fakeParkString = $"Insert into Campground values ({fakePark}, 'FAKE CAMPGROUND', 1, 12, 2.00)"; SqlCommand cmd2 = new SqlCommand(fakeParkString, conn); cmd2.ExecuteNonQuery(); cmd = new SqlCommand("select cast(scope_identity() as int)", conn); fakeCampground = Convert.ToInt32(cmd.ExecuteScalar()); } ReservationSqlDAL ral = new ReservationSqlDAL(connectionString); decimal output = ral.CostOfCampground(fakeCampground); Assert.AreEqual(fakeOutput.ToString("C"), output.ToString("C")); }
public void BookReservation(Reservation r) { string name = CLIHelper.GetString("Please enter first and last name:"); int siteNumber = CLIHelper.GetInteger("Please enter the site number: "); int numberCampers = CLIHelper.GetInteger("Please enter the number of campers:"); int reservationID = 0; r.Name = name; r.SiteNumber = siteNumber; r.NumberCampers = numberCampers; ReservationSqlDAL dal = new ReservationSqlDAL(); try { reservationID = dal.BookReservation(r); } catch (Exception e) { Console.WriteLine(e.Message); } if (reservationID > 0) { Console.WriteLine($"Your reservation was successfully created. Reservation id: {reservationID}"); } else { Console.WriteLine("Request unsuccessful. Reservation NOT created."); } }
public void SearchForParkReservations(string park) { DateTime today = System.DateTime.Now; DateTime futureMonthDate = today.AddMonths(1); ReservationSqlDAL reservationSqlDAL = new ReservationSqlDAL(); List <Reservation> reservations = new List <Reservation>(); reservations = reservationSqlDAL.GetParkReversations(park, today, futureMonthDate); if (reservations.Count != 0) { Console.WriteLine($"\nAll Reservations for {park}:"); Console.WriteLine("ID".PadRight(4) + "Site ID".PadRight(9) + "Name".PadRight(32) + "From Date".PadRight(12) + "To Date"); foreach (Reservation reservation in reservations) { Console.WriteLine( reservation.ReservationId.ToString().PadRight(4) + reservation.SiteID.ToString().PadRight(9) + reservation.Name.ToString().PadRight(32) + reservation.FromDate.ToString("d").PadRight(12) + reservation.ToDate.Date.ToString("d") ); } Console.WriteLine("\nPress <Enter> to continue!"); Console.ReadLine(); } else { Console.WriteLine($"No Reservations for {park}"); } }
public void GetAvailableSites_AdjacentToNext_IsAvailable() { using (TransactionScope transaction = new TransactionScope()) { // Arrange ManualInitialize(); SiteSqlDAL testClass = new SiteSqlDAL(connectionString); DateTime testStartDate = new DateTime(2000, 6, 10).Date; DateTime testEndDate = new DateTime(2000, 6, 20).Date; DateTime conflictStartDate = new DateTime(2000, 6, 20).Date; DateTime conflictEndDate = new DateTime(2000, 6, 30).Date; ReservationSqlDAL rDal = new ReservationSqlDAL(connectionString); Reservation tempReservation = new Reservation(); tempReservation.Site_Id = siteId; tempReservation.Name = "TEMP RESERVATION"; tempReservation.From_Date = conflictStartDate; tempReservation.To_Date = conflictEndDate; rDal.AddReservation(tempReservation); // Act List <Site> availableSites = testClass.GetAvailableSites(testCamp, testStartDate, testEndDate); // Assert Assert.AreEqual(1, availableSites.Count); } }
public void MakeNewReservation(string name, int campsiteId, DateTime arrivalDate, DateTime departureDate) { ReservationSqlDAL reservationSqlDAl = new ReservationSqlDAL(); int reservationId = reservationSqlDAl.MakeReservation(name, campsiteId, arrivalDate, departureDate); Console.WriteLine("The reservation has been made and the confirmation id is {0}", reservationId); }
/// <summary> /// Select from available sites in selected campground /// </summary> /// <param name="campground"></param> /// <param name="arrival"></param> /// <param name="departure"></param> private void SiteSelectionMenu(Campground campground, DateTime arrival, DateTime departure) { Reservation reserve = new Reservation(); reserve.FromDate = arrival; reserve.ToDate = departure; bool quit = false; while (!quit) { SiteSqlDAL siteSqlDAL = new SiteSqlDAL(_connectionString); List <Site> resList = siteSqlDAL.GetAvailalableSitesInCampground(campground.CampgroundId, arrival, departure); TimeSpan interval = reserve.ToDate - reserve.FromDate; decimal cost = interval.Days * campground.DailyFee; if (resList.Count == 0) { Console.WriteLine("\nNo sites available for the dates provided."); } else { DisplayAvailableSites(resList, cost); reserve.SiteId = 0; int selection = CLIHelper.GetInteger("Which site should be reserved (enter 0 to cancel)?"); if (selection < 0) { Console.WriteLine(" Invalid selection. Please try again."); } //else if (selection == 0) //{ // quit = true; //} else if (selection > 0) { //var site = resList.Find(m => m.SiteId == selection); for (int i = 0; i < resList.Count; i++) { if (resList[i].SiteNumber == selection) { reserve.SiteId = resList[i].SiteId; } } if (reserve.SiteId == 0) { Console.WriteLine(" Invalid selection. Please try again."); } } Console.WriteLine("What name Should the reservation be made under?"); reserve.Name = Console.ReadLine(); ReservationSqlDAL reservationSqlDAL = new ReservationSqlDAL(_connectionString); reserve = reservationSqlDAL.AddReservation(reserve); Console.WriteLine($"The reservation has been made and the confirmation id is {reserve.ReservationId}"); quit = true; } } }
/// <summary> /// Displays available campsites within a campground based on the user's selection and options /// </summary> /// <param name="campId"></param> /// <param name="arriveDate"></param> /// <param name="departDate"></param> public void DisplayAvailableSites(int campId, DateTime arriveDate, DateTime departDate) { SiteSqlDAL siteDal = new SiteSqlDAL(DatabaseConnection); List <Site> sites = siteDal.GetCampgroundSites(campId, arriveDate, departDate); bool timeToExit = false; while (!timeToExit) { if (sites.Count == 0) { Console.WriteLine("There are no available sites on that date, try again."); Console.ReadKey(); Console.Clear(); Header(); timeToExit = true; //CampgroundReservation(_parks[campId]); } else { int numDays = (int)(departDate - arriveDate).TotalDays + 1; decimal totalCost = _campgrounds[campId - 1].CalculateCost(_campgrounds[campId - 1], numDays); Console.Clear(); Header(); Console.WriteLine("Results Matching Your Search Criteria"); Console.WriteLine(); Console.WriteLine($"{siteNo,6} | {maxOcc,9} | {access,9} | {rvLngth,9} | {utility,9} | {cost,9}"); for (int i = 0; i < sites.Count; i++) { Console.WriteLine($"{sites[i].SiteNumber,8} | {sites[i].MaxOccupancy,10} | {sites[i].Accessible,11} | {sites[i].MaxRvLength,13} | {sites[i].Utilities,9} | {totalCost.ToString("c"),9}"); } //iterates through the Sites List to display to user Console.WriteLine(); int siteId = CLIHelper.GetInteger("Which site would you like to reserve ? (enter 0 to cancel)"); if (siteId == 0) { Console.Clear(); Header(); timeToExit = true; } Console.WriteLine(); string resName = CLIHelper.GetString("What name should your reservation be called?"); ReservationSqlDAL sqlDal = new ReservationSqlDAL(DatabaseConnection); int resConfirmationId = sqlDal.BookReservation(siteId, arriveDate, departDate, resName); Console.WriteLine(); Console.WriteLine($"The reservation has been made and your confirmation number is {resConfirmationId}"); Console.WriteLine("Click any key to exit the program."); timeToExit = true; Console.ReadKey(); } } }
public void GetReservationsTest() { ReservationSqlDAL dal = new ReservationSqlDAL(ConnectionString); var reservations = dal.GetReservations(1, 1, 1); Assert.AreEqual(1, reservations.Count); }
//GET: Confirmation public ActionResult Confirmation(Reservation reservation) { ReservationSqlDAL reservationDAL = new ReservationSqlDAL(connectionString); int reservationId = reservationDAL.CreateReservation(reservation.SiteID, reservation.ReservationStart, reservation.ReservationEnd, reservation.ReservationName); return(View("Confirmation", reservationId)); }
public ParkSystem(string connectionString) { this.ConnectionString = connectionString; campgroundDAL = new CampgroundSqlDAL(ConnectionString); campsiteDAL = new SiteSqlDAL(ConnectionString); parkDAL = new ParkSqlDAL(ConnectionString); reservationDAL = new ReservationSqlDAL(ConnectionString); }
public void CreatedReservation() // test that the dictionary item exists { ReservationSqlDAL reservationSql = new ReservationSqlDAL(); Reservation newReservation = new Reservation(); //output = reservationSql.AddNewReservation(1, "Keet Bailey", DateTime[](2018, 6, 25, 3, 30, 54); //Assert.IsNotNull(output); }
// LEVEL: RESERVATION ///////////////////////////////////////// // // // private int ReserveCampsite_View(int chosenCampsite, DateTime startDate, DateTime endDate, string partyName) { int reservationID = 0; ReservationSqlDAL dal = new ReservationSqlDAL(DatabaseConnection); reservationID = dal.ReserveCampsite(chosenCampsite, startDate, endDate, partyName); return(reservationID); }
public Dictionary <int, Reservation> AddNewReservation(int siteSelection, string reservationName, DateTime[] reservationRange) { ReservationSqlDAL reservationSql = new ReservationSqlDAL(); Dictionary <int, Reservation> newReservation = new Dictionary <int, Reservation>(); newReservation = reservationSql.AddNewReservation(siteSelection, reservationName, reservationRange); return(newReservation); }
public void GetReservationTest() { ReservationSqlDAL dal = new ReservationSqlDAL(connectionString); List <Reservation> list = dal.GetReservation(); Assert.AreEqual(1, list.Count()); Assert.AreEqual("Natalie", list[0].name); }
public UserInterface(string connectionString) { this.spaceDAL = new SpaceSqlDAL(connectionString); this.venueDAL = new VenueSqlDAL(connectionString); this.categoryDAL = new CategorySqlDAL(connectionString); this.reservationDAL = new ReservationSqlDAL(connectionString); this.cityDAL = new CitySqlDAL(connectionString); }
// GET: Index public ActionResult Index(CampSearch campSearch) { ReservationSqlDAL reservationDAL = new ReservationSqlDAL(connectionString); Session["CampSearch"] = campSearch; List <CampSite> siteList = reservationDAL.FindReservation(campSearch); return(View("Index", siteList)); }
public void ReserveCampsite(int choice, string name, DateTime arrivalDate, DateTime departureDate) { ReservationSqlDAL reserveDAL = new ReservationSqlDAL(connectionString); int reservation_id = reserveDAL.InsertReservation(choice, name, arrivalDate, departureDate); Console.WriteLine("\nThe reservation has been made and the confirmation id is {" + reservation_id + "}"); Console.WriteLine("\nPress ENTER to exit..."); Console.ReadLine(); }
public ActionResult ParkScreen(ParkSearch parkSearch) { ReservationSqlDAL reservationDAL = new ReservationSqlDAL(connectionString); Session["ParkSearch"] = parkSearch; List <CampSite> siteList = reservationDAL.FindParkReservation(parkSearch); return(View("ParkScreen", siteList)); }
public void GetParkReservationsTest() { string parkName = "Acadia"; DateTime currentDate = DateTime.MinValue; DateTime futureMonthDate = DateTime.MinValue; ReservationSqlDAL reservationSqlDAL = new ReservationSqlDAL(); List <Reservation> result = reservationSqlDAL.GetParkReversations(parkName, currentDate, futureMonthDate); Assert.IsNotNull(result); }
public void AddNewReservation(Reservation reservation) { IReservationDAL reservationdal = new ReservationSqlDAL(DatabaseConnectionString.DatabaseString); (bool worked, int reservationId) = reservationdal.AddNewReservation(reservation); if (worked == true) { Console.WriteLine($"The reservation has been made and the confirmation id is {reservationId}"); } }
public void CreateReservationTest() { //Arrange ReservationSqlDAL reservationSqlDal = new ReservationSqlDAL(connectionString); //Act int reservation = reservationSqlDal.CreateReservation(3, today, today, "Test"); //Assert Assert.IsNotNull(reservation); Assert.AreEqual(reservation, reservationNumber + 1); }
public void MakeReservationTest() { int result; string name = "Alec2"; int campsiteId = 37; DateTime arrivalDate = DateTime.Parse("2019-07-04"); DateTime departureDate = DateTime.Parse("2019-07-24"); ReservationSqlDAL reservationSqlDAL = new ReservationSqlDAL(); result = reservationSqlDAL.MakeReservation(name, campsiteId, arrivalDate, departureDate); Assert.AreEqual(testInsert + 1, result); }
public void SearchForReservationTest() { string park = "Acadia"; string campground = "Blackwoods"; DateTime arrivalDate = DateTime.MinValue; DateTime departureDate = DateTime.MinValue; List <Campsite> test = new List <Campsite>(); ReservationSqlDAL reservationSqlDAL = new ReservationSqlDAL(); test = reservationSqlDAL.SearchForReservation(park, campground, arrivalDate, departureDate); Assert.IsNotNull(test); }
public void SearchForAvailableReservationTest() { ReservationSqlDAL myDAL = new ReservationSqlDAL(connectionString); List <Site> testReservationList = myDAL.SearchForAvailableReservation(siteID, startDate, endDate); Assert.AreEqual(testReservationList.Count, 0); List <Site> testReservationList2 = myDAL.SearchForAvailableReservation(siteID, Convert.ToDateTime("02/01/2019"), Convert.ToDateTime("02/02/2019")); Assert.AreEqual(testReservationList.Count, 1); }
private void GetCampsite() { selectingReservation = true; while (selectingReservation) { Console.WriteLine("Please enter the Campground ID to view the list of available campsites"); int input = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("\nWhat date would you like to begin your trip?(Please use format: mm/dd/yyyy)"); DateTime fromDate = Convert.ToDateTime(Console.ReadLine()); Console.WriteLine("\nWhat date would you like to end your trip?(Please use format: mm/dd/yyyy)"); DateTime toDate = Convert.ToDateTime(Console.ReadLine()); CampsiteSqlDAL dal = new CampsiteSqlDAL(DatabaseConnection); List <Campsite> campsites = dal.GetCampsite(input, fromDate, toDate); if (campsites.Count > 0) { campsites.ForEach(c => { Console.WriteLine(c); }); Console.WriteLine("\nPlease select the ID of the site you would like to reserve. If none, select '0'."); int reservationSelection = Convert.ToInt32(Console.ReadLine()); if (reservationSelection == 0) { return; } Console.WriteLine("\nWhat name would you like to place the reservation under?"); string reservationName = Console.ReadLine(); ReservationSqlDAL resDAL = new ReservationSqlDAL(DatabaseConnection); resDAL.MakeReservation(reservationSelection, fromDate, toDate, reservationName); Console.WriteLine("\nConfirmation Code: " + randomHex()); selectingReservation = false; } else { Console.WriteLine("\nNo site available.\n"); } } }