//GET: ParkSearch public ActionResult ParkSearch(int id) { ParkSearchSqlDAL parkSearchDAL = new ParkSearchSqlDAL(connectionString); ParkSearch parkSearch = parkSearchDAL.RetrieveInfo(id); return(View("ParkSearch", parkSearch)); }
public ParkSearch RetrieveInfo(int id) { try { ParkSearch p = new ParkSearch(); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand cmd = new SqlCommand(SQL_PopulateSiteInfo, connection); cmd.Parameters.AddWithValue("@park_id", id); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { p.ParkId = id; p.ParkName = Convert.ToString(reader["name"]); } return(p); } } catch (SqlException ex) { throw; } }
public IActionResult Detail(string id, ParkSearch ps) { HttpContext.Session.SetString("tempChoice", ps.TempChoice); ps.park = parkDAO.GetParkById(id); ps.WeatherList = parkDAO.GetWeatherByPark(id); return(RedirectToAction("Detail")); }
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 RetrieveInfoTest() { //Arrange ParkSearchSqlDAL parkSeachSqlDal = new ParkSearchSqlDAL(connectionString); //Act ParkSearch parksearch = parkSeachSqlDal.RetrieveInfo(1); //Assert Assert.IsNotNull(parksearch); Assert.AreEqual(nameOfPark, parksearch.ParkName); }
public IActionResult Detail(string id) { Park park = parkDAO.GetParkById(id); ParkSearch ps = new ParkSearch(); ps.park = park; ps.WeatherList = parkDAO.GetWeatherByPark(id); ps.TempChoice = HttpContext.Session.GetString("tempChoice") ?? "F"; return(View(ps)); }
public void CampgroundController_ParkSearchAction_RedirectToParkScreenView() { //Arrange CampgroundController controller = new CampgroundController(); ParkSearch model = new ParkSearch(); //Act RedirectToRouteResult result = controller.ParkSearch(model) as RedirectToRouteResult; //Assert Assert.IsNotNull(result); Assert.AreEqual("ParkScreen", result.RouteValues["action"]); }
public IActionResult Detail(string id, ParkSearch ps, User user) { if (user.Id > 0) { //user.TempPref = HttpContext.Session.GetString("tempChoice") ?? "F"; ps.TempChoice = user.TempPref; userDAO.UpdateUser(user); } HttpContext.Session.SetString("tempChoice", ps.TempChoice); ps.park = parkDAO.GetParkById(id); ps.WeatherList = parkDAO.GetWeatherByPark(id); return(RedirectToAction("Detail")); }
public void ReservationController_ParkScreenAction_ReturnParkScreenView() { // Arrange ReservationController controller = new ReservationController(); DateTime arrive = Convert.ToDateTime("07/04/2017"); DateTime depart = Convert.ToDateTime("07/05/2017"); ParkSearch parkSearch = new ParkSearch() { ArrivalDate = arrive, DepartureDate = depart, MaxOccupancy = 0, ParkId = 1, IsAccessible = false, RVLength = 0, NeedUtilities = false }; // Mock Session Object Mock <HttpSessionStateBase> mockSession = new Mock <HttpSessionStateBase>(); // Mock Http Context Request for Controller // because Session doesn't exist unless MVC actually receives a "request" Mock <HttpContextBase> mockContext = new Mock <HttpContextBase>(); // When the Controller calls this.Session it will get a mock session mockContext.Setup(c => c.Session).Returns(mockSession.Object); // Assign the context property on the controller to our mock context which uses our mock session controller.ControllerContext = new ControllerContext(mockContext.Object, new RouteData(), controller); // Act ViewResult result = controller.ParkScreen(parkSearch) as ViewResult; // Assert Assert.IsNotNull(result); Assert.AreEqual("ParkScreen", result.ViewName); }
public ActionResult ParkSubmit(int id) { //Session will always be filled but If/Else statement is there for testing purposes ParkSearch existingParkSearch = new ParkSearch(); if (Session["ParkSearch"] != null) { existingParkSearch = Session["ParkSearch"] as ParkSearch; } else { existingParkSearch = new ParkSearch() { ArrivalDate = DateTime.Today, DepartureDate = DateTime.Today }; } Reservation reservation = new Reservation(id, existingParkSearch.ArrivalDate, existingParkSearch.DepartureDate); return(View("ParkSubmit", reservation)); }
public void FindParkReservationTest() { //Arrange ReservationSqlDAL reservationSqlDal = new ReservationSqlDAL(connectionString); ParkSearch ps = new ParkSearch() { ParkId = 1, ArrivalDate = DateTime.Today, DepartureDate = DateTime.Today, MaxOccupancy = 4, IsAccessible = false, RVLength = 0, NeedUtilities = false }; //Act List <CampSite> campSites = reservationSqlDal.FindParkReservation(ps); //Assert Assert.IsNotNull(campSites); Assert.AreEqual(numberOfCampsites, campSites.Count); }
public IActionResult Detail(string id, User user) { Park park = parkDAO.GetParkById(id); ParkSearch ps = new ParkSearch(); ps.park = park; ps.WeatherList = parkDAO.GetWeatherByPark(id); if (user.Id > 0) { user.TempPref = HttpContext.Session.GetString("tempChoice") ?? "F"; ps.TempChoice = user.TempPref; //userDAO.UpdateUser(user); } else { ps.TempChoice = HttpContext.Session.GetString("tempChoice") ?? "F"; } //ps.TempChoice = HttpContext.Session.GetString("tempChoice") ?? "F"; return(View(ps)); }
public ActionResult ParkSearch(ParkSearch parkSearch) { return(RedirectToAction("ParkScreen", "Reservation", parkSearch)); }
public List <CampSite> FindParkReservation(ParkSearch parkSearch) { try { int accessible = 0; int utilities = 0; List <CampSite> availableSites = new List <CampSite>(); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); if (parkSearch.IsAccessible == false) { accessible = 0; } else { accessible = 1; } if (parkSearch.NeedUtilities == false) { utilities = 0; } else { utilities = 1; } SqlCommand cmd = new SqlCommand(SQL_ParkReservationSearch, connection); cmd.Parameters.AddWithValue("@park_id", parkSearch.ParkId); cmd.Parameters.AddWithValue("@from_date", parkSearch.ArrivalDate); cmd.Parameters.AddWithValue("@to_date", parkSearch.DepartureDate); cmd.Parameters.AddWithValue("@max_occupancy", parkSearch.MaxOccupancy); cmd.Parameters.AddWithValue("@accessible", accessible); cmd.Parameters.AddWithValue("@max_rv_length", parkSearch.RVLength); cmd.Parameters.AddWithValue("@utilities", utilities); cmd.Parameters.AddWithValue("@open_from_mm", parkSearch.ArrivalDate.Month); cmd.Parameters.AddWithValue("@open_to_mm", parkSearch.ArrivalDate.Month); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if (parkSearch.ArrivalDate < DateTime.Today || parkSearch.DepartureDate < parkSearch.ArrivalDate) { availableSites = null; break; } CampSite site = new CampSite(); bool isAccessible = Convert.ToBoolean(reader["accessible"]); string YesOrNO = site.BoolToString(isAccessible); bool hasUtilities = Convert.ToBoolean(reader["utilities"]); string YON = site.BoolToString(hasUtilities); site.Campground = Convert.ToString(reader["name"]); site.SiteId = Convert.ToInt32(reader["site_id"]); site.SiteNumber = Convert.ToInt32(reader["site_number"]); site.MaxOccupancy = Convert.ToInt32(reader["max_occupancy"]); site.Accessible = YesOrNO; site.MaxRvLength = Convert.ToInt32(reader["max_rv_length"]); site.Utilities = YON; site.Cost = Convert.ToDouble(reader["daily_fee"]); availableSites.Add(site); } } return(availableSites); } catch (SqlException e) { throw; } }