public SmartMeterDto MapToSmartMeterDto(SmartMeter smartmeter)
{
if (smartmeter != null)
{
var smartmeterDto = new SmartMeterDto
{
Id = smartmeter.Id,
UserProfileId = smartmeter.UserProfileId,
Balance = smartmeter.Balance,
Capacity = smartmeter.Capacity,
Date = smartmeter.Date,
GeneratedPower = smartmeter.GeneratedPower,
Load = smartmeter.Load,
SMID = smartmeter.SMID,
SerialNumber = smartmeter.SerialNumber,
CreateDate = smartmeter.CreateDate,
ModifiedDate = smartmeter.ModifiedDate,
IsDeleted = smartmeter.IsDeleted
};
return(smartmeterDto);
}
return(new SmartMeterDto());
}
public async Task <IActionResult> PutSmartMeter([FromRoute] long id, [FromBody] SmartMeter smartMeter)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != smartMeter.SmartMeterId)
{
return(BadRequest());
}
_context.Entry(smartMeter).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SmartMeterExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public IHttpActionResult PutSmartMeter(int id, SmartMeter smartMeter)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != smartMeter.SmartMeterId)
{
return(BadRequest());
}
db.Entry(smartMeter).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!SmartMeterExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IHttpActionResult> GetSmartMeter(int id)
{
SmartMeter smartMeter = await db.SmartMeters.FindAsync(id);
if (smartMeter == null)
{
return(NotFound());
}
return(Ok(smartMeter));
}
public async Task <IActionResult> PostSmartMeter([FromBody] SmartMeter smartMeter)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.SmartMeter.Add(smartMeter);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetSmartMeter", new { id = smartMeter.SmartMeterId }, smartMeter));
}
public IHttpActionResult PostSmartMeter(SmartMeter smartMeter)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.SmartMeters.Add(smartMeter);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = smartMeter.SmartMeterId }, smartMeter));
}
public async Task <IHttpActionResult> PostSmartMeter(SmartMeter smartMeter)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.SmartMeters.Add(smartMeter);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = smartMeter.Id }, smartMeter));
}
public async Task <IHttpActionResult> DeleteSmartMeter(int id)
{
SmartMeter smartMeter = await db.SmartMeters.FindAsync(id);
if (smartMeter == null)
{
return(NotFound());
}
db.SmartMeters.Remove(smartMeter);
await db.SaveChangesAsync();
return(Ok(smartMeter));
}
public IHttpActionResult DeleteSmartMeter(int id)
{
SmartMeter smartMeter = db.SmartMeters.Find(id);
if (smartMeter == null)
{
return(NotFound());
}
db.Adresses.Remove(smartMeter.Adress);
db.SmartMeters.Remove(smartMeter);
db.SaveChanges();
return(Ok(smartMeter));
}
public async Task <IHttpActionResult> DeleteSmartMeter(string id)
{
SmartMeter smartMeter = await db.SmartMeters.FindAsync(id);
if (smartMeter == null)
{
return(NotFound());
}
db.Connections.RemoveRange(smartMeter.Connections);
db.SmartMeters.Remove(smartMeter);
await _uow.SaveAsync();
//await db.SaveChangesAsync();
return(Ok(smartMeter));
}
protected override Task ExecuteAsync(CancellationToken stoppingToken)
{
using (db = new SensorCloudContext(configuration))
{
Dictionary <DateTime, DataPacket> measurementLookup = new Dictionary <DateTime, DataPacket>();
db.sensordata
.Where(d => d.nodeid == 0 && (d.type == "power1" || d.type == "power2" || d.type == "gas"))
.OrderByDescending(d => d.id)
.Take(10000)
.ToList().ForEach(m =>
{
if (!measurementLookup.ContainsKey(m.stamp))
{
measurementLookup[m.stamp] = new DataPacket();
}
if (m.type == "gas")
{
measurementLookup[m.stamp].GasUsage = (Decimal)m.value;
}
if (m.type == "power1")
{
measurementLookup[m.stamp].PowerConsumptionTariff1 = (Decimal)m.value;
}
if (m.type == "power2")
{
measurementLookup[m.stamp].PowerConsumptionTariff2 = (Decimal)m.value;
}
});
measurementLookup.Where(k => k.Value.IsValid).ToList().ForEach(k => measurements.Add(new Measurement()
{
time = k.Key,
data = k.Value
}));
measurements.Sort((m1, m2) => m1.time.CompareTo(m2.time));
}
meter = new SmartMeter();
meter.OnData += OnData;
meter.Connect(config.serial);
return(Task.CompletedTask);
}
public void DeleteSmartMeter(SmartMeter person)
{
_context.SmartMeters.Remove(person);
_context.SaveChanges();
}
public void UpdateSmartMeter(SmartMeter person)
{
_context.SmartMeters.Update(person);
_context.SaveChanges();
}
public void SaveSmartMeter(SmartMeter person)
{
_context.SmartMeters.Add(person);
_context.SaveChanges();
}
