public IActionResult SaveTrip(SavedTrip savedtrip, int trip_id, int savedtrip_id) { int?userID = HttpContext.Session.GetInt32("ID"); if (userID == null) { return(RedirectToAction("Index")); } Trip thisTrip = _context.Trips.SingleOrDefault(a => a.TripID == trip_id); ViewBag.thisTrip = thisTrip; SavedTrip thisSavedTrip = _context.SavedTrips.SingleOrDefault(s => s.SavedTripID == savedtrip_id); ViewBag.thisSavedTrip = thisSavedTrip; SavedTrip newSavedTrip = new SavedTrip { SavedTripName = savedtrip.SavedTripName, UserID = (int)userID, User = savedtrip.User, TripID = (int)trip_id, Trip = thisTrip }; _context.Add(newSavedTrip); _context.SaveChanges(); return(RedirectToAction("MyTrips")); }
public void GetterSetterTestSavedTrip() { SavedTrip savedtrip = new SavedTrip { UserID = 50, CityName = "Hubba", VacationName = "lubba", AnswerCode = "loop", InUSA = false, LikesHot = false, Price = 2, HasChildren = true, LikesOutdoor = true, }; Assert.Equal(50, savedtrip.UserID); Assert.Equal("Hubba", savedtrip.CityName); Assert.Equal("lubba", savedtrip.VacationName); Assert.Equal("loop", savedtrip.AnswerCode); Assert.False(savedtrip.InUSA); Assert.False(savedtrip.LikesHot); Assert.Equal(2, savedtrip.Price); Assert.True(savedtrip.HasChildren); Assert.True(savedtrip.LikesOutdoor); }
public IActionResult MyTrips(SavedTrip savedTrip, int trip_id) { int?userID = HttpContext.Session.GetInt32("ID"); if (userID == null) { return(RedirectToAction("Index")); } List <Trip> myTrips = _context.Trips.Where(u => u.UserID == userID).ToList(); ViewBag.myTrips = myTrips; List <Comment> tripComments = _context.Comments.Where(a => a.TripID == trip_id).ToList(); ViewBag.tripComments = tripComments; List <SavedTrip> savedTrips = _context.SavedTrips.ToList(); // Trip thisTrip = _context.Trips.Include(c=>c.CountryID == country_id).ThenInclude(u=>u.UserID == user_id).ToList(); // ViewBag // ViewBag.User = _context.Users.Where (u => u.UserID == user_id).FirstOrDefault (); // Trip myTrip = _context.Trips.Where(c=>c.CountryID == country_id).Include(u=>u.UserID == user_id).FirstOrDefault(); return(View("MyTrips")); }
public async Task <IActionResult> Details(string AnswerCode, string CityName, string VacationName, int UserID) { SavedTrip trip = new SavedTrip { AnswerCode = AnswerCode, CityName = CityName, VacationName = VacationName, UserID = UserID, InUSA = (AnswerCode[0] == '1' ? true : false), LikesHot = (AnswerCode[2] == '1' ? true : false), HasChildren = (AnswerCode[6] == '1' ? true : false), LikesOutdoor = (AnswerCode[8] == '1' ? true : false) }; PopularTrip popTrip = new PopularTrip { AnswerCode = AnswerCode, CityName = CityName, VacationName = VacationName, Popularity = 0, InUSA = (AnswerCode[0] == '1' ? true : false), LikesHot = (AnswerCode[2] == '1' ? true : false), HasChildren = (AnswerCode[6] == '1' ? true : false), LikesOutdoor = (AnswerCode[8] == '1' ? true : false) }; switch (AnswerCode[4]) { case '1': trip.Price = 1; popTrip.Price = 1; break; case '2': trip.Price = 2; popTrip.Price = 2; break; case '3': trip.Price = 3; popTrip.Price = 3; break; } await _trips.SaveAsPopularTrip(popTrip); try { await _trips.SaveTrip(trip); } catch (Exception) { return(Ok("You already saved a vacation just like that! Try again.")); } return(RedirectToAction("MyVacations", UserID)); }
/// <summary> /// Saves a trip as a SavedTrip to it's respective table. /// </summary> /// <param name="SavedTrip">Takes in the new SavedTrip to save.</param> public async Task SaveTrip(SavedTrip savedTrip) { try { await _context.AddAsync(savedTrip); await _context.SaveChangesAsync(); } catch (Exception e) { throw e; } }
/// <summary> /// Updates a SavedTrip. /// </summary> /// <param name="trip">Takes in the SavedTrip to be updated.</param> public async Task UpdateTrip(SavedTrip trip) { _context.Update(trip); await _context.SaveChangesAsync(); }
public IActionResult ViewTrip(int trip_id, Comment comment, int comment_id, int user_id, int savedtrip_id, SavedTrip savedtrip, int country_id) { int?userID = HttpContext.Session.GetInt32("ID"); ViewBag.userID = userID; if (userID == null) { return(RedirectToAction("Index")); } Trip thisTrip = _context.Trips.SingleOrDefault(a => a.TripID == trip_id); ViewBag.thisTrip = thisTrip; List <Trip> myTrips = _context.Trips.Where(u => u.UserID == userID).ToList(); ViewBag.myTrips = myTrips; List <Comment> tripComments = _context.Comments.Where(a => a.TripID == trip_id).ToList(); ViewBag.tripComments = tripComments; Comment thisComment = _context.Comments.SingleOrDefault(c => c.CommentID == comment_id); ViewBag.thisComment = thisComment; List <SavedTrip> savedTrips = _context.SavedTrips.Where(u => u.UserID == user_id).ToList(); ViewBag.savedTrips = savedTrips; List <SavedTrip> savedTrips2 = _context.SavedTrips.ToList(); ViewBag.savedTrips2 = savedTrips2; Country Country = _context.Countries.FirstOrDefault(c => c.CountryID == country_id); var thisCountry = (int)country_id; ViewBag.ThisCountry = thisCountry; //----------------------------------- User User = _context.Users .FirstOrDefault(u => u.UserID == userID); // Trip thisTrip = _context.Trips.SingleOrDefault(a=>a.TripID == trip_id); // ViewBag.thisTrip = thisTrip; SavedTrip thisSavedTrip = _context.SavedTrips.SingleOrDefault(s => s.SavedTripID == savedtrip_id); ViewBag.thisSavedTrip = thisSavedTrip; SavedTrip newSavedTrip = new SavedTrip { SavedTripName = savedtrip.SavedTripName, UserID = (int)userID, User = savedtrip.User, TripID = (int)trip_id, Trip = thisTrip }; _context.Add(newSavedTrip); _context.SaveChanges(); return(View("ViewTrip")); }