public IActionResult GetDays()
{
weatherContext db = new weatherContext();
var days = db.Days.ToList();
return(View(days));
}
public async Task <string> SetDeviceStatus(int status)
{
try
{
weatherContext _db = new weatherContext();
var deviceStatus = _db.DeviceStatus.FirstOrDefault();
if (deviceStatus != null)
{
if (status == 1)
{
deviceStatus.Fan = true;
await _db.SaveChangesAsync();
return("включить");
}
else
if (status == 0)
{
deviceStatus.Fan = false;
await _db.SaveChangesAsync();
return("выключить");
}
}
return("Получен невалидный аргумент");
}
catch (System.Exception)
{
throw;
}
}
public IActionResult GetMinutes()
{
weatherContext db = new weatherContext();
var minutes = db.Minutes.ToList();
return(View(minutes));
}
public IActionResult GetHours()
{
weatherContext db = new weatherContext();
var hours = db.Hours.ToList();
return(View(hours));
}
public async Task <String> CreateData(double t, double h)
{
weatherContext _db = new weatherContext();
var row_id = _db.Meterings
.ToList().Count() + 1;
Meterings metering1 = new Meterings()
{
Id = row_id,
SensorId = 0,
Date = DateTime.UtcNow,
Value = t,
MeteringTypeId = 0,
UserId = 0
};
Meterings metering2 = new Meterings()
{
Id = row_id + 1,
SensorId = 1,
Date = DateTime.UtcNow,
Value = h,
MeteringTypeId = 0,
UserId = 0
};
_db.Meterings.Add(metering1);
_db.Meterings.Add(metering2);
_db.SaveChanges();
return("sc");
}
public IActionResult GetSeconds()
{
weatherContext db = new weatherContext();
var seconds = db.Seconds.ToList();
return(View(seconds));
}
public async Task <string> GetDays()
{
weatherContext _db = new weatherContext();
var days = _db.Days.ToList();
string result = "";
foreach (var day in days)
{
result = result + "id = " + day.Id + " Date = " + day.Date + " T* = " + day.Temperature + " H = " + day.Humidity + '\n';
}
return(result);
}
public async Task <string> GetHours()
{
weatherContext _db = new weatherContext();
var hours = _db.Hours.ToList();
string result = "";
foreach (var hour in hours)
{
result = result + "id = " + hour.Id + " Date = " + hour.Date + " T* = " + hour.Temperature + " H = " + hour.Humidity + '\n';
}
return(result);
}
public async Task <string> GetMinutes()
{
weatherContext _db = new weatherContext();
var minutes = _db.Minutes.ToList();
string result = "";
foreach (var minute in minutes)
{
result = result + "id = " + minute.Id + " Date = " + minute.Date + " T* = " + minute.Temperature + " H = " + minute.Humidity + '\n';
}
return(result);
}
public async Task <string> GetSeconds()
{
weatherContext _db = new weatherContext();
var seconds = _db.Seconds.ToList();
string result = "";
foreach (var second in seconds)
{
result = result + "id = " + second.Id + " Date = " + second.Date + " T* = " + second.Temperature + " H = " + second.Humidity + '\n';
}
return(result);
}
public IActionResult Index(DeviceDTO dto)
{
if (dto != null)
{
weatherContext db = new weatherContext();
var device = db.Devices.Where(d => d.Id == dto.Id).FirstOrDefault();
if (device != null)
{
device.Status = !device.Status;
db.Devices.Update(device);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
public async Task <String> GetData()
{
weatherContext _db = new weatherContext();
// var meterings = _db.Meterings
// .ToList().OrderByDescending(x => x.Id);
// var check = meterings.FirstOrDefault().Value /*+ "/" + meterings.Skip(1).FirstOrDefault().Value*/;
// String result = "false";
// if (check > 10) result = "true";
var deviceStatus = _db.Devices.FirstOrDefault();
if (deviceStatus.Status == true)
{
return("true");
}
else
{
return("false");
}
}
public WeatherForecastController(weatherContext weather)
{
this._weather = weather;
}
public IActionResult Index()
{
weatherContext db = new weatherContext();
var userId = 0;
MainPageDTO mainPageDTO = new MainPageDTO();
List <MeteringDTO> meteringDTOs = new List <MeteringDTO>();
List <SensorDTO> sensorDTOs = new List <SensorDTO>();
List <DeviceDTO> deviceDTOs = new List <DeviceDTO>();
var userDevices = db.UserDevices.Where(e => e.UserId == userId).ToList();
List <Devices> devices = new List <Devices>();
foreach (var userDevice in userDevices)
{
var device = db.Devices.Where(d => d.Id == userDevice.DeviceId).FirstOrDefault();
if (device != null)
{
DeviceDTO deviceDTO = new DeviceDTO()
{
Id = device.Id,
Name = device.Name,
Status = device.Status
};
deviceDTOs.Add(deviceDTO);
}
}
var userSensors = db.UserSensors.Where(e => e.UserId == userId).ToList();
List <Sensors> sensors = new List <Sensors>();
foreach (var userSensor in userSensors)
{
var sensor = db.Sensors.Where(d => d.Id == userSensor.SensorId).FirstOrDefault();
if (sensor != null)
{
var meteringTypes = db.MeteringTypes.ToList();
List <AvereageValueDTO> avereageValues = new List <AvereageValueDTO>();
foreach (var meteringType in meteringTypes)
{
var metering = db.Meterings.Where(m => m.MeteringTypeId == meteringType.Id && m.SensorId == sensor.Id)
.OrderByDescending(m => m.Date)
.FirstOrDefault();
if (metering != null)
{
AvereageValueDTO avereageValueDTO = new AvereageValueDTO()
{
Value = metering.Value
};
avereageValues.Add(avereageValueDTO);
}
}
SensorDTO sensorDTO = new SensorDTO()
{
Id = sensor.Id,
Name = sensor.Name,
AvereageValues = avereageValues
};
sensorDTOs.Add(sensorDTO);
}
}
var userMeterings = db.Meterings
.Where(m => m.UserId == userId)
.ToList();
foreach (var userMetering in userMeterings)
{
MeteringDTO meteringDTO = new MeteringDTO()
{
Id = userMetering.Id,
SensorId = userMetering.SensorId,
Date = userMetering.Date,
Value = userMetering.Value,
MeteringTypeId = userMetering.MeteringTypeId,
UserId = userMetering.Id
};
meteringDTOs.Add(meteringDTO);
}
mainPageDTO.devices = deviceDTOs;
mainPageDTO.sensors = sensorDTOs;
mainPageDTO.meterings = meteringDTOs;
return(View(mainPageDTO));
}
