public IEnumerable <Reservation> GetReservationsByRoom(int roomId) { using (var data = new RoomReservationEntities()) { return(data.Reservations.AsNoTracking().Where(r => r.RoomId == roomId).Include(r => r.MeetingRoom).ToList()); } }
public IEnumerable <MeetingRoom> GetMeetingRooms() { using (var data = new RoomReservationEntities()) { return(data.MeetingRooms.AsNoTracking().ToList()); } }
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(); } }