//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 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 CreateReservationTest() { ReservationSqlDAL reservationDAL = new ReservationSqlDAL(connectionString); int reservationId = reservationDAL.CreateReservation(1, "TestName", new DateTime(1990, 08, 28), new DateTime(1990, 09, 14)); using (SqlConnection conn = new SqlConnection(connectionString)) { //SqlCommand command; conn.Open(); //command = new SqlCommand("INSERT INTO reservation VALUES (1, TestName, '08/28/1990', '09/14/1990', GETDATE(); SELECT CAST (SCOPE_IDENTITY() AS int)", conn); SqlCommand command = new SqlCommand("SELECT * FROM reservation WHERE name = 'TestName'; SELECT CAST(SCOPE_IDENTITY() AS int)", conn); reservationIdColumn = (int)command.ExecuteScalar(); } Assert.AreEqual(reservationId, reservationIdColumn); // Assert.IsTrue(true); }
// method that inserts a reservation // private List <Site> MakeReservation(Campground campground, DateTime arrival, DateTime departure) { // opens a connection to provide a list of sites for current campground // SiteSqlDAL dal = new SiteSqlDAL(connectionString); List <Site> sites = dal.GetAvailableSites(campground, arrival, departure); // customer chooses which site they'd like to make a reservation for OR cancels // int customerSelection = CLIHelper.GetInteger("Which site should be reserved (enter 0 to cancel)?"); // customer chose to return to main menu (probably choked on total cost of trip) // if (customerSelection == 0) { Console.Clear(); ParksInterface mainmenu = new ParksInterface(); mainmenu.RunCLI(); } else if (customerSelection > sites.Count) { Console.WriteLine("That site does not exist, returning to main menu!"); Thread.Sleep(milliseconds); Console.Clear(); ParksInterface mainmenu = new ParksInterface(); mainmenu.RunCLI(); } // customer opted to make a reservation // // returns a list of all current resos, then gives customer confirmation number using last reservation_id (newest created) // else { string reservationName = CLIHelper.GetString("What name should the reservation be made under?"); int selectedSite = customerSelection - 1; DateTime now = DateTime.Now; ReservationSqlDAL resodal = new ReservationSqlDAL(connectionString); List <Reservation> result = resodal.CreateReservation(sites[selectedSite].site_id, reservationName, arrival, departure, now); Console.WriteLine($"The reservation has been made and the confirmation id is {result[result.Count - 1].reservation_id.ToString()}"); } return(sites); }
private int BookReservation(Reservation reservation) { ReservationSqlDAL reservationDal = new ReservationSqlDAL(connectionString); return(reservationDal.CreateReservation(reservation)); }
public void CampGroundChoices(List <Campground> campgrounds) { Console.WriteLine("Select a campground to check for availability. Please select a number"); for (int i = 0; i < campgrounds.Count; i++) { Console.WriteLine((i + 1).ToString().PadRight(10) + campgrounds[i].Name); } int parsedUserInput = 0; while (parsedUserInput <= 0 || parsedUserInput > campgrounds.Count) { string userInput = Console.ReadLine(); Int32.TryParse(userInput, out parsedUserInput); if (parsedUserInput <= 0 || parsedUserInput > campgrounds.Count) { Console.WriteLine("Please enter a valid number"); } } Campground userCampground = campgrounds[parsedUserInput - 1]; Console.WriteLine("You Selected campground " + userCampground.Name); Console.WriteLine(); DateTime startDate = DateTime.MinValue; while (startDate < DateTime.Today) { Console.WriteLine("Please enter a valid start date (MM/DD/YYYY)"); Console.WriteLine(); string userStartDate = Console.ReadLine(); DateTime.TryParse(userStartDate, out startDate); } Console.WriteLine("Your start date is " + startDate.ToShortDateString()); Console.WriteLine(); DateTime endDate = DateTime.MinValue; while (endDate < startDate) { Console.WriteLine("Please enter a valid end date (MM/DD/YYYY)"); Console.WriteLine(); string userEndDate = Console.ReadLine(); DateTime.TryParse(userEndDate, out endDate); } Console.WriteLine("Your end date is " + endDate.ToShortDateString()); Console.WriteLine(); IReservationDAL dal = new ReservationSqlDAL(databaseConnection); List <int> numberOfSites = dal.GetTotalSites(userCampground.CampgroundId); List <Reservation> allReservations = dal.GetAllReservations(); List <int> openSites = dal.IsReservationOpen(startDate, endDate, allReservations, numberOfSites); bool isOpen = dal.IsCampgroundOpen(userCampground, startDate, endDate); if (isOpen) { IReservationDAL reservation = new ReservationSqlDAL(databaseConnection); ISiteDAL siteDAL = new SiteSqlDAL(databaseConnection); List <Site> availableSites = siteDAL.GetAvailableSites(userCampground.CampgroundId); Console.WriteLine("Available Camp Sites:"); foreach (Site camp in availableSites) { if (numberOfSites.Contains(camp.SiteId)) { Console.WriteLine("Site ID: " + camp.SiteId); Console.WriteLine("Site #" + camp.SiteNumber); Console.WriteLine(" Max Occupancy: " + camp.MaxOccupancy); Console.WriteLine(" Handicap Accessible: " + camp.yesOrNo(camp.Accessible)); Console.WriteLine(" Max RV Length: " + camp.RvLength.ToString()); Console.WriteLine(" Utilities Available: " + camp.yesOrNo(camp.HasUtilities)); Console.WriteLine(" Total Fee: " + (userCampground.DailyFee * Convert.ToInt32((endDate.Subtract(startDate)).TotalDays)).ToString("C2")); Console.WriteLine(); } else if (numberOfSites.Count == 0) { Console.WriteLine("Sorry, no camp sites are available during that time."); } } } else { Console.WriteLine("The campground is not open during that period"); } bool userInputId = false; while (userInputId == false) { Console.WriteLine("Please enter the Site ID for your desired site:"); string response = Console.ReadLine(); int userSite = 0; if (int.TryParse(response, out int result)) { userSite = int.Parse(response); } if (numberOfSites.Contains(userSite)) { userReservation.SiteId = userSite; userInputId = true; } else { Console.WriteLine("That was not a valid site number"); } } Console.WriteLine("What name would you like to book this reservation under? "); string userName = Console.ReadLine(); userReservation.Name = userName; userReservation.From_Date = startDate; userReservation.To_Date = endDate; userReservation.Create_Date = DateTime.Now; bool reservationSuccess = dal.CreateReservation(userReservation); if (reservationSuccess) { IReservationDAL dalUpdated = new ReservationSqlDAL(databaseConnection); List <Reservation> updatedReservations = dalUpdated.GetAllReservations(); Console.WriteLine("Your reservation has been successfully booked!"); Console.WriteLine("Your confirmation id is " + (updatedReservations.Count)); } }