public SensorlessRoom GetSensorLessRoom(int id)
{
using (BuildingDbContext context = new BuildingDbContext())
{
var tempRoom = context.Rooms.Where(r => r.Id == id).OfType<SensorlessRoom>()
.Include(r => r.Coordinates);
return tempRoom.First();
}
}
public Building GetBuilding(String buildingName)
{
using (BuildingDbContext context = new BuildingDbContext())
{
var tempBuilding = context.Buildings.Where(b => b.Name == buildingName)
.Include(b => b.Endpoints)
.Include(b => b.Floors)
.Include(b => b.Floors.Select( f => f.Endpoints))
.Include(b => b.Floors.Select(f => f.Rooms));
return tempBuilding.First();
}
}
public void SaveBuilding(Building building)
{
using (BuildingDbContext context = new BuildingDbContext())
{
context.Buildings.AddOrUpdate(building);
context.SaveChanges();
}
foreach (var floor in building.Floors)
{
//SaveFloor(floor);
}
}
public LiveRoom GetLiveRoom(int id)
{
using (BuildingDbContext context = new BuildingDbContext())
{
var tempRoom = context.Rooms.Where(r => r.Id == id).OfType<LiveRoom>()
.Include(r => r.Corners)
.Include(r => r.Corners.BottomLeftCorner)
.Include(r => r.Corners.BottomRightCorner)
.Include(r => r.Corners.TopLeftCorner)
.Include(r => r.Corners.TopRightCorner)
.Include(r => r.Endpoints);
return tempRoom.First();
}
}
private void SaveFloor(LiveFloor floor)
{
using (BuildingDbContext context = new BuildingDbContext())
{
context.Floors.AddOrUpdate(floor);
context.SaveChanges();
}
foreach (Room room in floor.Rooms)
{
if (room.GetType() == typeof(LiveRoom))
{
SaveLiveRoom((LiveRoom)room);
}
else if (room.GetType() == typeof(SensorlessRoom))
{
SaveSensorlessRoom((SensorlessRoom)room);
}
}
}
private void SaveSensorlessRoom(SensorlessRoom sensorlessRoom)
{
using (BuildingDbContext context = new BuildingDbContext())
{
context.SensorlessRoom.AddOrUpdate(sensorlessRoom);
context.SaveChanges();
}
foreach (Coordinates coordinates in sensorlessRoom.Coordinates)
{
SaveCoordinates(coordinates);
}
}
private void SaveSmapEndpoints(Endpoints endpoints)
{
using (BuildingDbContext context = new BuildingDbContext())
{
context.Endpoints.AddOrUpdate(endpoints);
context.SaveChanges();
}
}
private void SaveCorners(Corners corners)
{
using (BuildingDbContext context = new BuildingDbContext())
{
context.Corners.AddOrUpdate(corners);
context.SaveChanges();
}
}
private void SaveLiveRoom(LiveRoom liveRoom)
{
using (BuildingDbContext context = new BuildingDbContext())
{
context.SensorRoom.AddOrUpdate(liveRoom);
context.SaveChanges();
}
SaveCorners(liveRoom.Corners);
if (liveRoom.Endpoints != null)
SaveSmapEndpoints(liveRoom.Endpoints);
}
