public async Task <IActionResult> Create([Bind("Id,AutumnStart,AutumnDateTime,WinterStart,WinterDateTime")] MeteorologicalSeason meteorologicalSeason)
{
if (ModelState.IsValid)
{
DateTime WinterCheck = new DateTime(2016, 10, 01);
DateTime AutumnCheck = new DateTime(2016, 10, 01);
var Autumn = MeteorologicalSeason.AutumnDate(_context, AutumnCheck);
var Winter = MeteorologicalSeason.WinterDate(_context, WinterCheck);
if (Autumn == null)
{
meteorologicalSeason.AutumnStart = "Hösten kom aldrig 2016";
}
if (Winter == null)
{
meteorologicalSeason.WinterStart = "Vintern kom aldrig 2016";
}
if (Winter != null)
{
meteorologicalSeason.WinterStart = "Vintern faller på detta datum 2016";
}
if (Autumn != null)
{
meteorologicalSeason.AutumnStart = "Hösten faller på detta datum 2016";
}
meteorologicalSeason.AutumnDateTime = Autumn;
meteorologicalSeason.WinterDateTime = Winter;
_context.Add(meteorologicalSeason);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(meteorologicalSeason));
}
private static async void Timer_Elapsed(object sender, ElapsedEventArgs e)
{
int interval = Convert.ToInt32(ConfigHelper.Get("Interval:Data"));
if (DateTime.Now.Minute % interval != 0)
{
return;
}
try
{
Weather weather = await GetWeatherAsync();
using WeatherContext context = new WeatherContext();
context.Add(weather);
context.SaveChanges();
if (DateTime.Now.Minute == 0 || DateTime.Now.Minute == 30)
{
await PostWeiboAsync(weather);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
public async Task <IActionResult> Create([Bind("Id,SelectDate,AvgTemp,AvgHum,MouldRisk")] InformationTableIndoor informationTableIndoor)
{
if (ModelState.IsValid)
{
_context.Add(informationTableIndoor);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(informationTableIndoor));
}
public async Task <IActionResult> Create([Bind("date,clocktime,temperature,humidity,airpressure")] Weatherinfo weatherinfo)
{
if (ModelState.IsValid)
{
_context.Add(weatherinfo);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(weatherinfo));
}
public IEnumerable <WeatherForecast> Get()
{
var weather = new WeatherForecast
{
Date = DateTime.Now.AddDays(1),
TemperatureC = 56,
Summary = Summaries[1]
};
_weatherContext.Add(weather);
//_weatherContext.SaveChangesAsync();
//var rng = new Random();
return(Enumerable.Range(1, 5).Select(index => weather)
.ToArray());
}
public void LoadWeatherData() //populate db
{
if (_context.WeatherSensors.Any())
{
return;
}
string file = System.IO.File.ReadAllText(@"C:\IT-Högskolan\Databaser\Entity Framework\Inlämningsuppgift\WeatherDataConsole\EFDataAccessLibrary\Data\tempdata.csv");
var datas = new List <WeatherData>();
var sensors = new List <WeatherSensor>();
var records = file.Split('\n');
foreach (var record in records)
{
var props = record.Split(',');
if (!sensors.Any(s => s.Location == props[1]))
{
//create sensor...
var sensor = new WeatherSensor {
Location = props[1]
};
_context.Add(sensor);
_context.SaveChanges();
sensors.Add(sensor);
}
var ws = sensors.Where(s => s.Location == props[1]).FirstOrDefault();
var data = new WeatherData
{
Collected_On = DateTime.Parse(props[0]),
Temperature = float.Parse(props[2], System.Globalization.CultureInfo.InvariantCulture),
Humidity = byte.Parse(props[3]),
WeatherSensor = ws,
WeatherSensorId = ws.Id
};
datas.Add(data);
}
_context.BulkInsert(datas);
}
public bool AddHistoricalWeather(HistoricalWeatherDto historicalWeatherDto)
{
try
{
//var historicalWeather = _mapper.Map<HistoricalWeather>(historicalWeatherDto);
var historicalWeather = new HistoricalWeather
{
ThermalSensation = historicalWeatherDto.ThermalSensation,
Temperature = historicalWeatherDto.Temperature,
City = _context.City.FirstOrDefault(x => x.Id == historicalWeatherDto.City.Id),
Country = _context.Country.FirstOrDefault(x => x.Id == historicalWeatherDto.Country.Id),
};
_context.Add <HistoricalWeather>(historicalWeather);
_context.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine("Error al guardar el historico");
return(false);
}
return(true);
}
