protected void OnContextDisposing(object sender, EntityDataSourceContextDisposingEventArgs e)
{
if (data != null)
{
data.Dispose();
data = null;
}
}
protected void OnContextCreating(object sender, EntityDataSourceContextCreatingEventArgs e)
{
if (data == null)
{
data = new RoomReservationEntities();
}
e.Context = data;
}
public void UpdateReservation(Reservation reservation)
{
using (RoomReservationEntities data = new RoomReservationEntities())
{
data.Reservations.Attach(reservation);
data.ObjectStateManager.ChangeObjectState(reservation, EntityState.Modified);
data.SaveChanges();
}
}
public IEnumerable <MeetingRoom> MeetingRooms()
{
IEnumerable <MeetingRoom> rooms;
using (RoomReservationEntities data = new RoomReservationEntities())
{
rooms = data.MeetingRooms.ToList();
}
return(rooms);
}
public IEnumerable <Reservation> GetReservationsByRoom(int roomId)
{
IEnumerable <Reservation> reservations;
using (RoomReservationEntities data = new RoomReservationEntities())
{
reservations = data.Reservations.Where(r => r.RoomId == roomId).ToList();
}
return(reservations);
}