public static void DelBookOrUser() { Console.Clear(); Console.WriteLine(""); using (var context = new HotelContext()) { Console.WriteLine("\n1. Slet gæst \n2. Delete Booking"); int input1 = int.Parse(Console.ReadLine()); switch (input1) { case 1: // delete gæst var hotelContext = context.Hotels; var guestContext = context.Guests; foreach (var hotelObj in hotelContext) { Console.WriteLine($"Hotel nr. {hotelObj.Hotel_No}, {hotelObj.Name}, {hotelObj.Address}"); } Console.Write("\n Vælg hotel nr: "); int input2 = int.Parse(Console.ReadLine()); var selectedHotel = context.Hotels.Find(input2); var infoBooking = context.Bookings.Where(x => x.Hotel_No == selectedHotel.Hotel_No); var allGuests = infoBooking.Select(x => x); foreach (var item in allGuests) { Console.WriteLine($"Gæst Nr. {item.Guest_No}, Værelse Nr. {item.Room_No}"); } Console.Write("\n Vælg gæst nr. Som skal slettes: "); int delGuest = int.Parse(Console.ReadLine()); var originalGæst = context.Guests.Find(delGuest); guestContext.Remove(originalGæst); break; case 2: var allBookings = context.Bookings; foreach (var item in allBookings) { Console.WriteLine($"ID: {item.Booking_id}, Guest nr. {item.Guest_No}"); } Console.Write("\nVælg ID som skal slettes: "); int delBooking = int.Parse(Console.ReadLine()); var originalBooking = context.Bookings.Find(delBooking); allBookings.Remove(originalBooking); break; default: break; } context.SaveChanges(); } Console.ReadLine(); Console.Clear(); }