public ActionResult SubmitRoute(SubmitRouteViewModel submitRouteViewModel) { /* * //De serialize Review again * IFormatter formatter = new BinaryFormatter(); * Stream streamB = new FileStream("MyFile.bin", * FileMode.Open, * FileAccess.Read, * FileShare.Read); * Review review = (Review)formatter.Deserialize(streamB); * streamB.Close(); * // * * //De serialize again * //IFormatter formatter = new BinaryFormatter(); * Stream stream2 = new FileStream("MyFile.bin", * FileMode.Open, * FileAccess.Read, * FileShare.Read); * Route route = (Route)formatter.Deserialize(stream2); * stream2.Close(); * // */ Route route = TmpRouteObject; Review review = TmpReviewObject; context.Routes.Add(route); context.SaveChanges(); context.Reviews.Add(review); context.SaveChanges(); User getUser = context.Users.Single(u => u.Email == (HttpContext.Session.GetString("_Email"))); getUser.TrailsBlazed += 1; getUser.ReviewsMade += 1; context.SaveChanges(); IList <RouteReview> existingItems = context.RouteReviews .Where(rr => rr.ReviewID == review.ID) .Where(rr => rr.RouteID == route.ID).ToList(); if (existingItems.Count == 0) { //var userID = saveFavoriteRouteViewModel.UserID; //var routeID = saveFavoriteRouteViewModel.RouteID; RouteReview routeReview = new RouteReview { Review = context.Reviews.Single(r => r.ID == review.ID),/// May not work if not in database yet!!!!************************************* Route = context.Routes.Single(r => r.ID == route.ID) }; context.RouteReviews.Add(routeReview); context.SaveChanges(); } TempData["Alert"] = "The Ride Route has been added to Database!"; return(Redirect("/User")); }
public ActionResult SubmitRoute(SubmitRouteViewModel submitRouteViewModel) { //De serialize again IFormatter formatter = new BinaryFormatter(); Stream stream2 = new FileStream("MyFile.bin", FileMode.Open, FileAccess.Read, FileShare.Read); Route route = (Route)formatter.Deserialize(stream2); stream2.Close(); // context.Routes.Add(route); context.SaveChanges(); TempData["Alert"] = "The Ride Route has been added to Database!"; return(Redirect("/User")); }