public static bool CreateDatabase(bool addsampledata = false)
{
try
{
using (var db = new IoTDbContext())
{
db.Database.EnsureDeleted();
var result = db.Database.EnsureCreated();
if (addsampledata)
{
db.Add(new Models.TemperatureSensorDescriptor(new string[] { "Temperature", "0", "0", "Window", "Left Sensor", "20.0", "C" }));
db.Add(new Models.PressureSensorDescriptor(new string[] { "Pressure", "0", "0", "Window", "Left Sensor", "1024.0", "mb" }));
db.SaveChanges();
}
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
}
public static bool ExistsDatabase()
{
try
{
using (var db = new IoTDbContext())
{
return(db.Database.CanConnect());
}
}
catch
{
return(false);
}
}
public static void InsertData(object sensor)
{
using (var db = new IoTDbContext())
{
try
{
db.Add(sensor);
db.SaveChanges();
}
catch (Exception ex)
{
Debug.WriteLine($"Error in DataService.InsertData {ex.Message}");
}
}
}
