public ActionResult Edit(Models.VenueBooking booking) { try { var db = new CodeFirst.CodeFirst(); var adjBooking = db.Venue_Booking_Line.Where(v => v.BookingID == booking.BookingID).FirstOrDefault(); adjBooking.EndTime = booking.EndTime; adjBooking.UserID = booking.UserID; adjBooking.ProjectID = booking.ProjectID; db.SaveChanges(); return(Json(new { ResultValue = "Success" })); } catch { return(Json(new { ResultValue = "Error" })); } }
public ActionResult Add(Models.VenueBooking booking) { try { var db = new CodeFirst.CodeFirst(); db.Venue_Booking.Add(new CodeFirst.Venue_Booking { VenueBookingID = booking.BookingID }); db.Venue_Booking_Line.Add(new CodeFirst.Venue_Booking_Line { BookingID = booking.BookingID, VenueBookingID = booking.BookingID, VenueID = globalVenueID, NumberofPeople = booking.NumberofPeople, DateBooked = DateTime.ParseExact(booking.DateBooked, "MM/dd/yyyy", CultureInfo.InvariantCulture), StartTime = booking.StartTime, EndTime = booking.EndTime, UserID = booking.UserID, BuildingID = db.Venues.Where(v => v.VenueID == globalVenueID).FirstOrDefault().BuildingID, ProjectID = booking.ProjectID }); db.SaveChanges(); return(Json(new { ResultValue = "Success" })); } catch { return(Json(new { ResultValue = "Error" })); } }