public IHttpActionResult PostTourEventView(TourEventView tourEventView) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.TourEventViews.Add(tourEventView); try { db.SaveChanges(); } catch (DbUpdateException) { if (TourEventViewExists(tourEventView.EventMonth)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = tourEventView.EventMonth }, tourEventView)); }
public IHttpActionResult PutTourEventView(string id, TourEventView tourEventView) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tourEventView.EventMonth) { return(BadRequest()); } db.Entry(tourEventView).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!TourEventViewExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
private void dgrTourEvents_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { if (dgrTourEvents.SelectedItem != null) { selectedTourEventView = (TourEventView)dgrTourEvents.SelectedItem; } var bookingsList = from c in allClients join b in allBookings on c.ClientID equals b.ClientID where b.EventID == selectedTourEventView.EventID select new { c.FirstName, c.LastName, c.Gender, b.DateBooked, b.Payment }; dgrTourEventBookings.ItemsSource = bookingsList; } catch (Exception ex) { logger.Fatal("Unknown error."); MessageBox.Show(ex.Message); } }
public IHttpActionResult GetTourEventView(string id) { TourEventView tourEventView = db.TourEventViews.Find(id); if (tourEventView == null) { return(NotFound()); } return(Ok(tourEventView)); }
public IHttpActionResult DeleteTourEventView(string id) { TourEventView tourEventView = db.TourEventViews.Find(id); if (tourEventView == null) { return(NotFound()); } db.TourEventViews.Remove(tourEventView); db.SaveChanges(); return(Ok(tourEventView)); }