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)); }