private ChartDataModel GetData(ChartDataModel data)
{
var from = data?.TimeInterval.From; //sets minimum
var to = data?.TimeInterval.To; //sets maximum
var result = new ChartDataModel();
using (var db = new TemperatureContext())
{
var all = db.TemperatureData.ToList();
result.Temps = all
.Where(temperatureData => temperatureData.Date >= from && temperatureData.Date <= to)
.OrderBy(temperatureData => temperatureData.Date)
.Select(temperatureData => new DataPointModel {
Date = temperatureData.Date, Y = temperatureData.Temperature
})
.ToList();
result.Hums = all
.Where(temperatureData => temperatureData.Date >= from && temperatureData.Date <= to)
.OrderBy(temperatureData => temperatureData.Date)
.Select(temperatureData => new DataPointModel {
Date = temperatureData.Date, Y = temperatureData.Humidity
})
.ToList();
}
return(result);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory)
{
loggerFactory.AddConsole(Configuration.GetSection("Logging"));
loggerFactory.AddDebug();
app.UseStaticFiles();
TemperatureContext temperatureContext = app.ApplicationServices.GetRequiredService <TemperatureContext>();
if (!env.IsProduction())
{
app.UseDeveloperExceptionPage();
app.UseDatabaseErrorPage();
temperatureContext.Seed(false);
}
else if (!temperatureContext.TemperatureReads.Any())
{
temperatureContext.Seed(true);
}
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Temp}/{action=Index}");
});
}
private static TemperatureContext CreateTemperatureContext()
{
var options = new DbContextOptionsBuilder <TemperatureContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
var temperatureContext = new TemperatureContext(options);
return(temperatureContext);
}
public TemperatureController(TemperatureContext context)
{
_context = context;
if (_context.TemperatureItems.Count() == 0)
{
_context.TemperatureItems.Add(new TemperatureItem {
Location = "London", Date = new DateTime(2018, 1, 1), Temperature = 6
});
_context.TemperatureItems.Add(new TemperatureItem {
Location = "London", Date = new DateTime(2018, 1, 2), Temperature = 8
});
_context.TemperatureItems.Add(new TemperatureItem {
Location = "London", Date = new DateTime(2018, 1, 3), Temperature = 4
});
_context.TemperatureItems.Add(new TemperatureItem {
Location = "New York", Date = new DateTime(2018, 1, 2), Temperature = 1
});
_context.TemperatureItems.Add(new TemperatureItem {
Location = "New York", Date = new DateTime(2018, 1, 3), Temperature = 3
});
_context.TemperatureItems.Add(new TemperatureItem {
Location = "Johannesburg", Date = new DateTime(2018, 1, 4), Temperature = 20
});
_context.TemperatureItems.Add(new TemperatureItem {
Location = "Johannesburg", Date = new DateTime(2018, 1, 3), Temperature = 20
});
_context.TemperatureItems.Add(new TemperatureItem {
Location = "Johannesburg", Date = new DateTime(2018, 1, 6), Temperature = 23
});
_context.TemperatureItems.Add(new TemperatureItem {
Location = "Johannesburg", Date = new DateTime(2018, 1, 5), Temperature = 22
});
_context.SaveChanges();
}
}
private bool SaveData(TemperatureRestData value)
{
try
{
using (var db = new TemperatureContext())
{
var data = new TemperatureData()
{
Date = value.Date,
Humidity = value.Humidity,
Location = value.Location,
Temperature = value.Temperature
};
db.TemperatureData.Add(data);
db.SaveChanges();
}
}
catch (Exception)
{
return(false);
}
return(true);
}
public LocationRepository(TemperatureContext temperatureContext) : base(temperatureContext)
{
}
public TemperatureController(TemperatureContext context)
{
_context = context; // Apagar em breve
_process = new TemperatureProcess(_context);
}
public DeviceController(TemperatureContext context)
{
_context = context;
}
public WebClientController(ICachingService cachingService, TemperatureContext temperatureContext)
{
_cachingService = cachingService ?? throw new ArgumentNullException(nameof(cachingService));
_temperatureContext = temperatureContext ?? throw new ArgumentNullException(nameof(temperatureContext));
}
public TempDataController(TemperatureContext context)
{
_context = context;
}
public TemperatureProcess(TemperatureContext context)
{
_context = context;
_service = new OpenWeatherMapService();
}
public static void SeedTestData(TemperatureContext context)
{
if (context.Devices.Any())
{
return;
}
var devices = new Device[]
{
new Device {
Location = "Garage", Name = "bt1234"
},
new Device {
Location = "Living Room", Name = "burglgrub"
},
new Device {
Location = "Stairs", Name = "BOULder4"
},
};
foreach (var d in devices)
{
context.Devices.Add(d);
}
context.SaveChanges();
var temperatureItems = new TemperatureItem[]
{
new TemperatureItem {
Temperature = 12.34, Device = devices[0], Timestamp = DateTime.Parse("2017-12-01 12:34:56")
},
new TemperatureItem {
Temperature = 13.34, Device = devices[1], Timestamp = DateTime.Parse("2017-12-01 12:35:56")
},
new TemperatureItem {
Temperature = 14.34, Device = devices[2], Timestamp = DateTime.Parse("2017-12-01 12:36:56")
},
new TemperatureItem {
Temperature = 15.34, Device = devices[0], Timestamp = DateTime.Parse("2017-12-01 12:37:56")
},
new TemperatureItem {
Temperature = 16.34, Device = devices[1], Timestamp = DateTime.Parse("2017-12-01 12:38:56")
},
new TemperatureItem {
Temperature = 17.34, Device = devices[2], Timestamp = DateTime.Parse("2017-12-01 12:39:56")
},
new TemperatureItem {
Temperature = 18.34, Device = devices[0], Timestamp = DateTime.Parse("2017-12-01 12:40:56")
},
new TemperatureItem {
Temperature = 19.34, Device = devices[1], Timestamp = DateTime.Parse("2017-12-01 12:41:56")
},
new TemperatureItem {
Temperature = 20.34, Device = devices[2], Timestamp = DateTime.Parse("2017-12-01 12:42:56")
},
};
foreach (var t in temperatureItems)
{
context.TemperatureItems.Add(t);
}
context.SaveChanges();
}
public DeviceRepository(TemperatureContext temperatureContext) : base(temperatureContext)
{
}
public SensorRepository(TemperatureContext temperatureContext) : base(temperatureContext)
{
}
