Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 1st, 2012  |  syntax: None  |  size: 1.68 KB  |  hits: 19  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Linq to SQL Row Not Found or Changed Exception on Insert Operation Ajax Postback in MVC3
  2. at System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode failureMode)
  3.    at System.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)
  4.    at System.Data.Linq.DataContext.SubmitChanges()
  5.    at ManageMAT.Controllers.FieldTripController.RouteAdd(Int32 id, FormCollection collection)
  6.        
  7. [HttpPost]
  8.         public ActionResult RouteAdd(int id, FormCollection collection)
  9.         {
  10.             FieldTrip trip = context.FieldTrips.Single(ft => ft.ID == id);
  11.  
  12.             if (trip == null) return Json(new { success = false, message = "Field trip not found." }); ;
  13.  
  14.             try
  15.             {
  16.  
  17.                 FieldTripRoute tripRoute = new FieldTripRoute();
  18.  
  19.                 tripRoute.FieldTripID = trip.ID;                
  20.                 tripRoute.Date = DateTime.Parse(collection["Date"]);
  21.                 tripRoute.ArrivalTime = DateTime.Parse(collection["ArrivalTime"] + " " + DateTime.Now.ToShortDateString());
  22.                 tripRoute.DepartureTime = DateTime.Parse(collection["DepartureTime"] + " " + DateTime.Now.ToShortDateString());
  23.                 tripRoute.Destination = collection["Destination"];
  24.                 tripRoute.PickupLocation = collection["PickupLocation"];
  25.                 tripRoute.RouteID = Convert.ToInt32(collection["RouteID"]);          
  26.  
  27.                 context.FieldTripRoutes.InsertOnSubmit(tripRoute);
  28.                 context.SubmitChanges();
  29.  
  30.                 return Json(new { success = true, message = "Success!" });
  31.             }
  32.             catch (Exception ex)
  33.             {
  34.                 return Json(new { success = false, message = ex.Message });
  35.             }
  36.         }