// GET: Bookings/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ViewBookingsModel mymodel = new ViewBookingsModel(); mymodel.bookingId = (int)id; mymodel.seatId = db.Bookings.Find(id).SeatId; mymodel.tripId = db.Bookings.Find(id).TripID; mymodel.tripName = db.Trips.Find(db.Bookings.Find(id).TripID).Departure + " - " + db.Trips.Find(db.Bookings.Find(id).TripID).Destination; mymodel.Time = db.Trips.Find(db.Bookings.Find(id).TripID).Departure_Time; if (mymodel == null) { return(HttpNotFound()); } return(View(mymodel)); }
// GET: Bookings public ActionResult Index() { List <ViewBookingsModel> data = new List <ViewBookingsModel>(); if (User.IsInRole("admin")) { foreach (var bing in db.Bookings.ToList()) { ViewBookingsModel mymodel = new ViewBookingsModel(); mymodel.bookingId = bing.BookingID; mymodel.tripId = bing.TripID; mymodel.seatId = bing.SeatId; mymodel.Name = udb.Users.Find(bing.UserId).Name; mymodel.tripName = db.Trips.Find(bing.TripID).Departure + " - " + db.Trips.Find(bing.TripID).Destination; mymodel.Time = db.Trips.Find(bing.TripID).Departure_Time; data.Add(mymodel); } } else { string id = User.Identity.GetUserId(); foreach (var bing in db.Bookings.Where(booking => booking.UserId == id).ToList()) { ViewBookingsModel mymodel = new ViewBookingsModel(); mymodel.bookingId = bing.BookingID; mymodel.tripId = bing.TripID; mymodel.seatId = bing.SeatId; mymodel.Name = udb.Users.Find(bing.UserId).Name; mymodel.tripName = db.Trips.Find(bing.TripID).Departure + " - " + db.Trips.Find(bing.TripID).Destination; mymodel.Time = db.Trips.Find(bing.TripID).Departure_Time; data.Add(mymodel); } } return(View(data.ToList())); }