public IActionResult Reserve()
        {
            ViewData["Message"] = "Your application description page.";

            var dbguests      = _context.Guest.ToList();
            var dbreservation = _context.Reservation.ToList();



            GetAllGV mygetall = new GetAllGV();

            mygetall.guests.AddRange(dbguests);
            mygetall.reservations.AddRange(dbreservation);


            return(View(mygetall));
        }
        // GET: Reservations/Details/5

        public async Task <IActionResult> Details(int?id)
        {
            if (id == null)
            {
                return(NotFound());
            }

            var reservation = await _context.Reservation
                              .SingleOrDefaultAsync(m => m.ID == id);

            GetAllGV       mygetall       = new GetAllGV();
            myReservations myReservations = new myReservations();

            DatabaseManager.GuestID = reservation.GuestId;

            myReservations.GuestId     = reservation.GuestId;
            myReservations.ID          = reservation.ID;
            myReservations.NumGuests   = reservation.NumGuests;
            myReservations.DateTime    = reservation.DateTime;
            myReservations.SeatingType = reservation.SeatingType;


            if (reservation == null)
            {
                return(NotFound());
            }

            var allguests = _context.Guest.ToList();

            mygetall.guests = allguests;


            mygetall.myReservation = myReservations;

            return(View(mygetall));
        }