// 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();
}
