public void DeleteReservation(Reservation reservation)
 {
     using (var data = new RoomReservationEntities())
     {
         data.Reservations.Remove(reservation);
         data.SaveChanges();
     }
 }
 public void AddReservation(Reservation reservation)
 {
     using (var data = new RoomReservationEntities())
     {
         data.Reservations.Add(reservation);
         data.SaveChanges();
     }
 }
 public void UpdateReservation(Reservation reservation)
 {
     using (var data = new RoomReservationEntities())
     {
         data.Reservations.Attach(reservation);
         data.Entry(reservation).State = EntityState.Modified;
         data.SaveChanges();
     }
 }