public async Task Put(int id, [FromBody] MonitorsEntry value) { var old = await _db.Monitors.FindAsync(id); _db.Entry(old).CurrentValues.SetValues(value); await _db.SaveChangesAsync(); }
public async Task Put(int id, [FromBody] MonitorsEntry value) { var entry = await _db.Monitors.FindAsync(id); entry = value; await _db.SaveChangesAsync(); }
public async Task Post([FromBody] MonitorsEntry value) { await _db.Monitors.AddAsync(value); await _db.SaveChangesAsync(); ; }
public int getFirstID() { MonitorsController _controller = getController(); Task <ActionResult <MonitorsEntry> > item = _controller.Get(1); ActionResult <MonitorsEntry> item2 = item.Result; MonitorsEntry item3 = item2.Value; return(item3.Id); }
public void item() { MonitorsController _controller = getController(); Task <ActionResult <MonitorsEntry> > item = _controller.Get(1); ActionResult <MonitorsEntry> item2 = item.Result; MonitorsEntry item3 = item2.Value; Console.WriteLine(item3.Id); }
public async Task Post([FromBody] InputSensor values) { if (values.valueIn == 0 && values.valueOut != 0) { MonitorsEntry mon = await _db.Monitors.FindAsync(values.IdIn); MonitorsEntry old = await _db.Monitors.FindAsync(values.IdIn); mon.Status = "faulty"; mon.FaultCount = mon.FaultCount + 1; _db.Entry(old).CurrentValues.SetValues(mon); await _db.SaveChangesAsync(); var sensorHistory = await _db.SensorHistory .Where(h => h.SensorId == mon.Id) .OrderByDescending(h => h.FaultDate) .FirstOrDefaultAsync(); if (sensorHistory == null) { SensorHistoryEntry history = new SensorHistoryEntry(); history.SensorId = values.IdIn; history.SensorType = EnumSensorType.WATER_FLOW_SENSOR; history.SensorResolved = EnumResolveStatus.UNRESOLVED; history.FaultDate = DateTime.Now; history.EmailSentDate = DateTime.Now; history.AttendedDate = DateTime.MinValue; await _db.SensorHistory.AddAsync(history); } else { var updatedHistory = sensorHistory; updatedHistory.SensorResolved = EnumResolveStatus.UNRESOLVED; updatedHistory.EmailSentDate = DateTime.Now; _db.Entry(sensorHistory).CurrentValues.SetValues(updatedHistory); await _db.SaveChangesAsync(); } } else if (values.valueOut == 0 && values.valueIn != 0 || values.valueOut > values.valueIn) { MonitorsEntry mon = await _db.Monitors.FindAsync(values.IdOut); MonitorsEntry old = await _db.Monitors.FindAsync(values.IdOut); mon.Status = "faulty"; mon.FaultCount = mon.FaultCount + 1; _db.Entry(old).CurrentValues.SetValues(mon); await _db.SaveChangesAsync(); var sensorHistory = await _db.SensorHistory .Where(h => h.SensorId == mon.Id) .OrderByDescending(h => h.FaultDate) .FirstOrDefaultAsync(); if (sensorHistory == null) { SensorHistoryEntry history = new SensorHistoryEntry(); history.SensorId = values.IdOut; history.SensorType = EnumSensorType.WATER_FLOW_SENSOR; history.SensorResolved = EnumResolveStatus.UNRESOLVED; history.FaultDate = DateTime.Now; history.EmailSentDate = DateTime.Now; history.AttendedDate = DateTime.MinValue; await _db.SensorHistory.AddAsync(history); } else { var updatedHistory = sensorHistory; updatedHistory.SensorResolved = EnumResolveStatus.UNRESOLVED; updatedHistory.EmailSentDate = DateTime.Now; _db.Entry(sensorHistory).CurrentValues.SetValues(updatedHistory); await _db.SaveChangesAsync(); } } ReadingsEntry reading = new ReadingsEntry(); ReadingsEntry reading2 = new ReadingsEntry(); reading.TimesStamp = DateTime.Now; reading2.TimesStamp = DateTime.Now; reading.Value = (values.valueIn) * Globals.MinuteToHour; reading2.Value = (values.valueOut) * Globals.MinuteToHour; reading.MonitorsId = values.IdIn; reading2.MonitorsId = values.IdOut; await _db.Readings.AddAsync(reading); await _db.SaveChangesAsync(); await _db.Readings.AddAsync(reading2); await _db.SaveChangesAsync(); Procedures procedure = new Procedures(_db, _config); await procedure.TriggerInsert(reading); }