public void SendMessage(Sensor sensor)
{
LoriotDTO msg = new LoriotDTO();
msg.cmd = "tx";
msg.EUI = sensor.sensorEUID;
msg.data = sensor.servoSetting;
msg.port = 3;
msg.confirmed = false;
clientWS.Send(JsonConvert.SerializeObject(msg));
Console.WriteLine("Message sent");
var log = new SensorLog();
sensor = _context.Sensor.AsQueryable().First(s => s.sensorEUID == sensor.sensorEUID);
log.servoSetting = sensor.servoSetting;
log.timestamp = DateTime.Now;
log.sensorID = sensor.sensorID;
slc.PostSensorLog(log).Wait();
_context.SaveChanges();
}
public void LoadData()
{
DateTime NewLoadDate = DateTime.Now;
DateTime FutureDate = DateTime.MaxValue;
var factData = _context.Sensor.ToList();
foreach (var fact in factData)
{
var data = _context.Data.FirstOrDefault(r => r.sensorID == fact.sensorID);
if (data != null)
{
var Fact = new DWFactTable
{
Servosetting = fact.servoSetting,
Humidity = data.humidity,
CO2 = data.CO2,
Temperature = data.temperature,
ValidFrom = NewLoadDate,
ValidTo = FutureDate
};
_context.DWFactTable.Add(Fact);
}
}
_context.SaveChanges();
}
public static void Initialize(DataWebserviceContext context)
{
context.Database.EnsureCreated();
// Look for any Rooms.
if (context.Room.Any())
{
return; // DB has been seeded
}
var rooms = new Room[]
{
new Room {
roomID = 1, roomName = "420"
},
new Room {
roomID = 2, roomName = "69"
},
new Room {
roomID = 3, roomName = "123"
},
new Room {
roomID = 4, roomName = "987"
},
new Room {
roomID = 5, roomName = "500"
},
new Room {
roomID = 6, roomName = "600"
},
new Room {
roomID = 7, roomName = "700"
}
};
foreach (Room r in rooms)
{
context.Room.Add(r);
}
//Cannot insert explicit value for identity column in table 'Room' when IDENTITY_INSERT is set to OFF
context.SaveChanges();
}
