// opret booking public static void OpretBooking() { Console.Clear(); using (var context = new HotelContext()) { Console.WriteLine(" Book ny gæst \n"); Booking newBooking = new Booking(); Console.Write("Insert Guest nr: "); newBooking.Guest_No = int.Parse(Console.ReadLine()); Console.Write("Insert Hotel nr: "); newBooking.Hotel_No = int.Parse(Console.ReadLine()); Console.Write("Start Date"); newBooking.Date_From = DateTime.Parse(Console.ReadLine()); Console.Write("End Date"); newBooking.Date_To = DateTime.Parse( Console.ReadLine()); Console.Write("Insert Room nr: "); newBooking.Room_No = int.Parse(Console.ReadLine()); context.Bookings.Add(newBooking); context.SaveChanges(); } Console.ReadLine(); Console.Clear(); }
public static void InsertNewGuest() { Console.Clear(); using (var context = new HotelContext()) { Console.WriteLine(" Book en ny gæst \n"); Guest newGuest = new Guest(); // database does not auto set gæst nr, the next 3 lines selects the gæst entries // and order them by descending and selects the last one + 1 for new nr. var selectGuest = context.Guests.Select(x => x).ToList(); var lastGuestNr = selectGuest.Select(x => x.Guest_No).OrderByDescending(y => y).First(); int newGuestNr = lastGuestNr + 1; Console.Write("Guest name: "); newGuest.Name = Console.ReadLine(); Console.Write("Guest adress: "); newGuest.Address = Console.ReadLine(); newGuest.Guest_No = newGuestNr; context.Guests.Add(newGuest); context.SaveChanges(); Console.WriteLine("\nDen følgende gæst er blevet tilføjet\n"); Console.WriteLine(newGuest); } Console.ReadLine(); Console.Clear(); }
// takes user input and .finds hotel which is equal to that, then takes that var and uses it to edit htoel specified by user input. public static void EditHotelInfo() { Console.Clear(); using (var context = new HotelContext()) { var allHotels = context.Hotels; Console.WriteLine(" \n Select Hotel nr to Edit \n"); foreach (var item in allHotels) { Console.WriteLine($"{item.Hotel_No}, {item.Name}"); } int input1 = int.Parse(Console.ReadLine()); var original = context.Hotels.Find(input1); Console.WriteLine("\n" + original + "\n"); Console.WriteLine("\n1. Change Hotel Adress\n2. Change Hotel Name"); string input2 = Console.ReadLine(); switch (input2) { case "1": Console.WriteLine("\n Change Adress to "); string adress = Console.ReadLine(); original.Address = adress; break; case "2": Console.WriteLine("\n Change Hotel Name to "); string name = Console.ReadLine(); original.Name = name; break; default: break; } context.SaveChanges(); } Console.ReadLine(); Console.Clear(); }
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(); }