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