public async Task <IActionResult> Edit(int id, [Bind("Id,SelectDate,AvgTemp,AvgHum,MouldRisk")] InformationTableOutdoor informationTableOutdoor)
{
if (id != informationTableOutdoor.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(informationTableOutdoor);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!InformationTableOutdoorExists(informationTableOutdoor.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(informationTableOutdoor));
}
public List <InformationTableOutdoor> GetDataOutdoor()
{
var OutdoorModel = new List <InformationTableOutdoor>();
var dates = new List <DateTime>();
foreach (var item in _context.AvgTempAndHumidities.ToList())
{
if (item.Plats == "Ute")
{
dates.Add(item.SelectDate);
}
else
{
continue;
}
}
var OrderedDates = dates.OrderByDescending(x => x).ToList();
var firstDate = OrderedDates.Last();
var lastDate = OrderedDates.First();
for (DateTime date = firstDate; date <= lastDate; date = date.AddDays(1))
{
var TempHum = (from t in _context.AvgTempAndHumidities
where t.SelectDate == date
where t.Plats == "Ute"
select t).ToList();
var Mould = (from m in _context.MouldRisks
where m.SelectDate == date
where m.Place == "Ute"
select m).ToList();
double avgTemp = 0;
double avgHum = 0;
string mouldRisk = "";
int mouldRank = 0;
if (TempHum.Count() > 0)
{
avgTemp = double.Parse((TempHum[0].AverageTemperature).ToString());
avgHum = double.Parse((TempHum[0].AverageHumidity).ToString());
}
if (Mould.Count() > 0)
{
mouldRisk = Mould[0].RiskForMould.ToString();
mouldRank = Mould[0].MouldIndex;
}
var line = new InformationTableOutdoor
{
SelectDate = new DateTime(date.Year, date.Month, date.Day),
AvgHum = Math.Round(avgHum, 2),
AvgTemp = Math.Round(avgTemp, 2),
MouldRisk = mouldRisk,
MouldRank = mouldRank
};
OutdoorModel.Add(line);
}
return(OutdoorModel);
}
public async Task <IActionResult> Create([Bind("Id,SelectDate,AvgTemp,AvgHum,MouldRisk")] InformationTableOutdoor informationTableOutdoor)
{
if (ModelState.IsValid)
{
_context.Add(informationTableOutdoor);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(informationTableOutdoor));
}
