//cancel a room
public static bool cancelBook(int idBook)
{
using (var context = new ValaisBookingEntities())
{
Booking book = (Booking)context.Booking.Where(b => b.IdBooking == idBook).Single();
context.Booking.Remove(book);
context.SaveChanges();
return(true);
}
}
//Book a room
public static void book(DateTime checkin, DateTime checkout, String firstname, String lastname, decimal price, DateTime date, Room room)
{
using (var context = new ValaisBookingEntities())
{
Booking book = new Booking();
book.CheckIn = checkin;
book.CheckOut = checkout;
book.Firstname = firstname;
book.Lastname = lastname;
book.Price = price;
book.Date = date;
book.IdRoom = room.IdRoom;
context.Booking.Add(book);
context.SaveChanges();
}
}