public ActionResult DeleteTrip(string TripID)
{
PlanItDBEntities ORM = new PlanItDBEntities();
Trip Found = ORM.Trips.Find(TripID);
if (Found != null)
{
List <Food> foundFoods = ORM.Foods.Where(c => c.TripID.Contains(TripID)).ToList();
List <Lodge> foundLodges = ORM.Lodges.Where(c => c.TripID.Contains(TripID)).ToList();
foreach (var restauarant in foundFoods)
{
ORM.Foods.Remove(restauarant);
}
foreach (var hotel in foundLodges)
{
ORM.Lodges.Remove(hotel);
}
ORM.Trips.Remove(Found);
ORM.SaveChanges();
return(RedirectToAction("TripList"));
}
else
{
ViewBag.Message = "Trip Not Found";
return(View("Error"));
}
}
public ActionResult DeleteRestaurant(string Restaurant)
{
PlanItDBEntities ORM = new PlanItDBEntities();
Food Found = ORM.Foods.Find(Restaurant);
if (Found != null)
{
Trip currentTrip = ORM.Trips.Find(Found.TripID);
ORM.Foods.Remove(Found);
ORM.SaveChanges();
TempData["currentTrip"] = currentTrip;
TempData["currentTrip"] = TempData["currentTrip"];
return(RedirectToAction("../Home/TripSummary"));
}
else
{
TempData["currentTrip"] = TempData["currentTrip"];
ViewBag.Message = "Restaurant Not Found";
return(View("Error"));
}
}
public ActionResult SaveCarOption()
{
PlanItDBEntities ORM = new PlanItDBEntities();
Trip Found = (Trip)TempData["currentTrip"];
if (Found != null)
{
string Car = TempData["VehicleSelection"].ToString();
Found.Car = Double.Parse(Car);
//ORM.Entry(Found).State = System.Data.Entity.EntityState.Modified;
ORM.SaveChanges();
TempData["currentTrip"] = Found;
TempData["currentTrip"] = TempData["currentTrip"];
TempData["VehicleSelection"] = TempData["VehicleSelection"];
return(RedirectToAction("../Home/TripBudgetCalculator"));
}
else
{
TempData["currentTrip"] = TempData["currentTrip"];
TempData["VehicleSelection"] = TempData["VehicleSelection"];
return(View("Error"));
}
}
public ActionResult SaveUpdateRestaurant(Food EditRestaurantDetails)
{
PlanItDBEntities ORM = new PlanItDBEntities();
Food OldRestaurantRecord = ORM.Foods.Find(EditRestaurantDetails.Restaurant);
if (OldRestaurantRecord != null && ModelState.IsValid)
{
OldRestaurantRecord.Restaurant = EditRestaurantDetails.Restaurant;
OldRestaurantRecord.Price = EditRestaurantDetails.Price;
OldRestaurantRecord.NumberOfMeals = EditRestaurantDetails.NumberOfMeals;
OldRestaurantRecord.Address = EditRestaurantDetails.Address;
OldRestaurantRecord.City = EditRestaurantDetails.City;
OldRestaurantRecord.State = EditRestaurantDetails.State;
OldRestaurantRecord.PostalCode = EditRestaurantDetails.PostalCode;
OldRestaurantRecord.PhoneNumber = EditRestaurantDetails.PhoneNumber;
OldRestaurantRecord.URL = EditRestaurantDetails.URL;
OldRestaurantRecord.TripID = EditRestaurantDetails.TripID;
ORM.Entry(OldRestaurantRecord).State = System.Data.Entity.EntityState.Modified;
ORM.SaveChanges();
TempData["currentTrip"] = ORM.Trips.Find(OldRestaurantRecord.TripID);
TempData["currentTrip"] = TempData["currentTrip"];
return(RedirectToAction("../Home/TripSummary"));
}
else
{
TempData["currentTrip"] = TempData["currentTrip"];
ViewBag.Message = "Restaurant Not Found";
return(View("Error"));
}
}
public ActionResult SaveUpdateHotel(Lodge EditHotelDetails)
{
PlanItDBEntities ORM = new PlanItDBEntities();
Lodge OldHotelRecord = ORM.Lodges.Find(EditHotelDetails.Lodging);
if (OldHotelRecord != null && ModelState.IsValid)
{
OldHotelRecord.Lodging = EditHotelDetails.Lodging;
OldHotelRecord.Price = EditHotelDetails.Price;
OldHotelRecord.NumberOfNights = EditHotelDetails.NumberOfNights;
OldHotelRecord.Address = EditHotelDetails.Address;
OldHotelRecord.City = EditHotelDetails.City;
OldHotelRecord.State = EditHotelDetails.State;
OldHotelRecord.PostalCode = EditHotelDetails.PostalCode;
OldHotelRecord.PhoneNumber = EditHotelDetails.PhoneNumber;
OldHotelRecord.URL = EditHotelDetails.URL;
OldHotelRecord.TripID = EditHotelDetails.TripID;
ORM.Entry(OldHotelRecord).State = System.Data.Entity.EntityState.Modified;
ORM.SaveChanges();
TempData["currentTrip"] = ORM.Trips.Find(EditHotelDetails.TripID);
TempData["currentTrip"] = TempData["currentTrip"];
return(RedirectToAction("../Home/TripSummary"));
}
else
{
TempData["currentTrip"] = TempData["currentTrip"];
ViewBag.Message = "Hotel Not Found";
return(View("Error"));
}
}
public ActionResult SaveUpdateUserTrip(Trip EditTripDetails)
{
PlanItDBEntities ORM = new PlanItDBEntities();
// string userID = User.Identity.GetUserId();
//ORM.AspNetUsers.Find(userID).Trips.ToList();
Trip OldTripRecord = ORM.Trips.Find(EditTripDetails.TripID);
if (OldTripRecord != null && ModelState.IsValid)
{
OldTripRecord.TripID = EditTripDetails.TripID;
OldTripRecord.StartDate = EditTripDetails.StartDate;
OldTripRecord.EndDate = EditTripDetails.EndDate;
OldTripRecord.StartCity = EditTripDetails.StartCity;
OldTripRecord.EndCity = EditTripDetails.EndCity;
OldTripRecord.Price = EditTripDetails.Price;
ORM.Entry(OldTripRecord).State = System.Data.Entity.EntityState.Modified;
ORM.SaveChanges();
return(RedirectToAction("TripList"));
}
else
{
TempData["currentTrip"] = OldTripRecord;
TempData["currentTrip"] = TempData["currentTrip"];
return(RedirectToAction("EditTripDetails"));
}
}
public ActionResult TripBudgetCalculator(string VehicleSelection, string TripID, string hotelPricePoint, string HotelSelection, string NumberOfNights, string restaurantPricePoint, string RestaurantSelection, string NumberOfMeals)
{
#region This Trip
PlanItDBEntities ORM = new PlanItDBEntities();
Trip currentTrip = ORM.Trips.Find(TripID);
if (currentTrip is null && TempData["currentTrip"] is null)
{
ViewBag.error = "Please go back and select trip";
return(View("Error"));
}
public ActionResult SaveRestaurantOption()
{
PlanItDBEntities ORM = new PlanItDBEntities();
Trip currentTrip = (Trip)TempData["currentTrip"];
string thisRestaurant = (string)TempData["RestaurantSelection"];
string numberOfMeals = (string)TempData["NumberOfMeals"];
string restaurantPricePoint = (string)TempData["restaurantPricePoint"];
JObject currentRestaurant = JObject.Parse(thisRestaurant);
string restaurantName = currentRestaurant["name"].ToString();
Food newRestaurant = new Food();
Food Found = ORM.Foods.Find(restaurantName);
if (Found != null)
{
TempData["restaurantPricePoint"] = null;
TempData["restaurantSelection"] = null;
TempData["NumberOfMeals"] = null;
ViewBag.DuplicateRestaurant = "The restaurant you chose is already on your list";
TempData["currentTrip"] = TempData["currentTrip"];
return(View("Error"));
}
else
{
newRestaurant.Restaurant = (string)currentRestaurant["name"];
newRestaurant.Price = int.Parse(restaurantPricePoint);
newRestaurant.NumberOfMeals = int.Parse(numberOfMeals);
newRestaurant.Address = (string)currentRestaurant["location"]["address1"];
newRestaurant.City = (string)currentRestaurant["location"]["city"];
newRestaurant.State = (string)currentRestaurant["location"]["state"];
newRestaurant.PostalCode = (string)currentRestaurant["location"]["zip_code"];
newRestaurant.PhoneNumber = (string)currentRestaurant["display_phone"];
newRestaurant.URL = (string)currentRestaurant["url"];
newRestaurant.TripID = currentTrip.TripID;
ORM.Foods.Add(newRestaurant);
ORM.SaveChanges();
Trip thisTrip = ORM.Trips.Find(newRestaurant.TripID);
TempData["currentTrip"] = thisTrip;
TempData["currentTrip"] = TempData["currentTrip"];
return(RedirectToAction("../Home/TripSummary"));
}
}
public ActionResult SaveHotelOption()
{
PlanItDBEntities ORM = new PlanItDBEntities();
Trip currentTrip = (Trip)TempData["currentTrip"];
string thisHotel = (string)TempData["HotelSelection"];
string NumberOfNights = (string)TempData["NumberOfNights"];
string hotelPricePoint = (string)TempData["hotelPricePoint"];
JObject currentHotel = JObject.Parse(thisHotel);
string hotelName = currentHotel["name"].ToString();
Lodge newHotel = new Lodge();
Lodge Found = ORM.Lodges.Find(hotelName);
if (Found != null)
{
TempData["hotelPricePoint"] = null;
TempData["HotelSelection"] = null;
TempData["NumberOfNights"] = null;
ViewBag.DuplicateHotel = "The hotel you chose is already on your list";
TempData["currentTrip"] = TempData["currentTrip"];
return(View("Error"));
}
else
{
newHotel.Lodging = (string)currentHotel["name"];
newHotel.Price = int.Parse(hotelPricePoint);
newHotel.NumberOfNights = int.Parse(NumberOfNights);
newHotel.Address = (string)currentHotel["location"]["address1"];
newHotel.City = (string)currentHotel["location"]["city"];
newHotel.State = (string)currentHotel["location"]["state"];
newHotel.PostalCode = (string)currentHotel["location"]["zip_code"];
newHotel.PhoneNumber = (string)currentHotel["display_phone"];
newHotel.URL = (string)currentHotel["url"];
newHotel.TripID = currentTrip.TripID;
ORM.Lodges.Add(newHotel);
ORM.SaveChanges();
Trip editedTrip = ORM.Trips.Find(newHotel.TripID);
TempData["currentTrip"] = editedTrip;
TempData["currentTrip"] = TempData["currentTrip"];
return(RedirectToAction("../Home/TripSummary"));
}
}
public ActionResult TripList()
{
PlanItDBEntities ORM = new PlanItDBEntities();
if (User.Identity.GetUserId() != null)
{
string userID = User.Identity.GetUserId();
ViewBag.userTrips = ORM.AspNetUsers.Find(userID).Trips.ToList();
return(View("../Home/TripList"));
}
else
{
ViewBag.ErrorMessage = "Please log in to see your trips.";
return(View("Error"));
}
}
public ActionResult EditCarOption()
{
PlanItDBEntities ORM = new PlanItDBEntities();
Trip Found = (Trip)TempData["currentTrip"];
if (Found != null)
{
TempData["VehicleSelection"] = TempData["VehicleSelection"];
TempData["currentTrip"] = TempData["currentTrip"];
return(RedirectToAction("SaveCarOption"));
}
else
{
ViewBag.Message = "Select a trip to add a car to.";
return(View("Error"));
}
}
public ActionResult CreateNewTrip(Trip newTrip)
{
if (newTrip.StartDate > newTrip.EndDate)
{
ViewBag.Error = "End date should be greater than Start date";
return(View("../Home/TripCreation"));
}
PlanItDBEntities ORM = new PlanItDBEntities();
newTrip.UserID = User.Identity.GetUserId();
ORM.Trips.Add(newTrip);
ORM.SaveChanges();
return(RedirectToAction("TripList"));
}
public ActionResult EditRestaurantDetails(string Restaurant)
{
PlanItDBEntities ORM = new PlanItDBEntities();
Food Found = ORM.Foods.Find(Restaurant);
Trip currentTrip = (Trip)TempData["currentTrip"];
ViewBag.DayDiff = HomeController.NumOfDays(currentTrip);
TempData["currentTrip"] = TempData["currentTrip"];
if (Found != null)
{
return(View("EditRestaurantDetails", Found));
}
else
{
ViewBag.ErrorMessage = "Restaurant Not Found";
return(View("Error"));
}
}
public ActionResult EditHotelDetails(string Lodging)
{
PlanItDBEntities ORM = new PlanItDBEntities();
Lodge Found = ORM.Lodges.Find(Lodging);
Trip currentTrip = (Trip)TempData["currentTrip"];
ViewBag.DayDiff = HomeController.NumOfDays(currentTrip);
TempData["currentTrip"] = TempData["currentTrip"];
if (Found != null)
{
return(View("EditHotelDetails", Found));
}
else
{
ViewBag.ErrorMessage = "Hotel Not Found";
return(View("Error"));
}
}
public ActionResult EditTripDetails(string TripID)
{
PlanItDBEntities ORM = new PlanItDBEntities();
Trip Found;
if (TripID is null)
{
Found = (Trip)TempData["currentTrip"];
}
else
{
Found = ORM.Trips.Find(TripID);
}
//string userID = User.Identity.GetUserId();
//ViewBag.userTrips = ORM.AspNetUsers.Find(userID).Trips.ToList();
if (Found != null)
{
if (Found.StartDate > Found.EndDate)
{
ViewBag.Error = "End date should be greater than Start date";
return(View("../Home/UpdateUserTrip", Found));
}
TempData["currentTrip"] = Found;
TempData["currentTrip"] = TempData["currentTrip"];
return(View("../Home/UpdateUserTrip", Found));
}
else
{
ViewBag.ErrorMessage = "Tasks Not Found";
return(View("Error"));
}
}
public ActionResult DeleteHotel(string Lodging)
{
PlanItDBEntities ORM = new PlanItDBEntities();
Lodge Found = ORM.Lodges.Find(Lodging);
Trip currentTrip = ORM.Trips.Find(Found.TripID);
if (Found != null)
{
ORM.Lodges.Remove(Found);
ORM.SaveChanges();
TempData["currentTrip"] = currentTrip;
TempData["currentTrip"] = TempData["currentTrip"];
return(RedirectToAction("../Home/TripSummary"));
}
else
{
TempData["currentTrip"] = TempData["currentTrip"];
ViewBag.Message = "Hotel Not Found";
return(View("Error"));
}
}
