public ActionResult ViewBookings() { var booking = _context.MakeBooking; var book = new ViewBooking { ListBooking = booking.ToList() }; return(View(book)); }
public ActionResult ViewBookings(int id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } List <ViewBooking> vm = new List <ViewBooking>(); var list = (from a in db.Booking2 join b in db.UserCaterings on a.BookingStatusId equals b.BookingStatusId join c in db.UserDecors on b.BookingStatusId equals c.BookingStatusId join d in db.Payments on c.BookingStatusId equals d.BookingStatusId join e in db.BookingStatus on d.BookingStatusId equals e.BookingStatusId where a.BookingStatusId == id select new { a.Venue.VenueName, a.Date, a.TotalNumberOfGuests, a.OccasionType, b.Catering.CateringPackage, b.Catering.CateringPrice , c.Decor.DecorColourOne, c.Decor.DecorPrice, d.TotalCost, e.Status, a.Venue.VenuePrice }).ToList(); foreach (var item in list) { ViewBooking vnm = new ViewBooking() { date = item.Date, VenueName = item.VenueName, VenueCost = item.VenuePrice, Capacity = item.TotalNumberOfGuests, eventType = item.OccasionType, CateringType = item.CateringPackage, cateringCost = item.CateringPrice * item.TotalNumberOfGuests, DecorType = item.DecorColourOne, decorCost = item.DecorPrice * item.TotalNumberOfGuests, totalCost = item.TotalCost, Status = item.Status }; vm.Add(vnm); } return(View(vm)); }