public async Task <IActionResult> Putker_reftab(long id, ker_reftab ker_reftab)
{
if (id != ker_reftab.id)
{
return(BadRequest());
}
_context.Entry(ker_reftab).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ker_reftabExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
var lMsg = new ServerUpdateHubMsg(_entity, ServerUpdateHubMsg.TOperation.UPDATE, id);
var lJson = JsonConvert.SerializeObject(lMsg);
await _hubContext.Clients.All.SendAsync(lMsg.entity, lJson);
return(NoContent());
}
public async Task <ActionResult <iot_sample> > Postiot_sample(iot_sample iot_sample)
{
// if timestamp is not provided, default it to Now
if (iot_sample.timestamp == DateTime.MinValue)
{
iot_sample.timestamp = DateTime.Now;
}
// calculate or validate calendarday
String lTimestampDay = iot_sample.timestamp.ToString("yyyy-MM-dd");
// start of hack (as I am not able to call another controller
//var iot_calendarday = await iot_calendardayController.Getiot_calendarday_getorcreatebydate(lTimestampDay);
var iot_calendarday = await _context.iot_calendarday.Where(cd => cd.date == lTimestampDay).FirstOrDefaultAsync();
if (iot_calendarday == null)
{
iot_calendarday = new iot_calendarday {
date = lTimestampDay
};
_context.iot_calendarday.Add(iot_calendarday);
await _context.SaveChangesAsync();
var lMsg2 = new ServerUpdateHubMsg("iot_calendarday", ServerUpdateHubMsg.TOperation.INSERT, iot_calendarday.id);
var lJson2 = JsonConvert.SerializeObject(lMsg2);
await _hubContext.Clients.All.SendAsync(lMsg2.entity, lJson2);
}
// end of the hack
if (iot_calendarday == null)
{
return(NotFound());
}
if (iot_sample.calendardayid == null)
{
iot_sample.calendardayid = iot_calendarday.id;
}
else
if (iot_sample.calendardayid != iot_calendarday.id)
{
return(BadRequest());
}
_context.iot_sample.Add(iot_sample);
await _context.SaveChangesAsync();
iot_sample.device = null;
iot_sample.calendarday = null;
var lMsg = new ServerUpdateHubMsg(_entity, ServerUpdateHubMsg.TOperation.INSERT, iot_sample.id);
var lJson = JsonConvert.SerializeObject(lMsg);
await _hubContext.Clients.All.SendAsync(lMsg.entity, lJson);
return(CreatedAtAction("Getiot_sample", new { id = iot_sample.id }, iot_sample));
}
public async Task <ActionResult <ker_reftab> > Postker_reftab(ker_reftab ker_reftab)
{
_context.ker_reftab.Add(ker_reftab);
await _context.SaveChangesAsync();
var lMsg = new ServerUpdateHubMsg(_entity, ServerUpdateHubMsg.TOperation.INSERT, ker_reftab.id);
var lJson = JsonConvert.SerializeObject(lMsg);
await _hubContext.Clients.All.SendAsync(lMsg.entity, lJson);
return(CreatedAtAction("Getker_reftab", new { id = ker_reftab.id }, ker_reftab));
}
public async Task <ActionResult <iot_calendarday> > Postiot_calendarday(iot_calendarday iot_calendarday)
{
_context.iot_calendarday.Add(iot_calendarday);
await _context.SaveChangesAsync();
var lMsg = new ServerUpdateHubMsg(_entity, ServerUpdateHubMsg.TOperation.INSERT, iot_calendarday.id);
var lJson = JsonConvert.SerializeObject(lMsg);
await _hubContext.Clients.All.SendAsync(lMsg.entity, lJson);
return(CreatedAtAction("Getiot_calendarday", new { id = iot_calendarday.id }, iot_calendarday));
}
public async Task <ActionResult <pcm_calevent> > Postpcm_calevent(pcm_calevent pcm_calevent)
{
_context.pcm_calevent.Add(pcm_calevent);
await _context.SaveChangesAsync();
var lMsg = new ServerUpdateHubMsg(_entity, ServerUpdateHubMsg.TOperation.INSERT, pcm_calevent.id);
var lJson = JsonConvert.SerializeObject(lMsg);
await _hubContext.Clients.All.SendAsync(lMsg.entity, lJson);
return(CreatedAtAction("Getpcm_calevent", new { id = pcm_calevent.id }, pcm_calevent));
}
public async Task <ActionResult <iot_device> > Postiot_device(iot_device iot_device)
{
_context.iot_device.Add(iot_device);
await _context.SaveChangesAsync();
//await _hubContext.Clients.All.SendAsync("broadcastMessage", "name", "message from controller");
var lMsg = new ServerUpdateHubMsg(_entity, ServerUpdateHubMsg.TOperation.INSERT, iot_device.id);
var lJson = JsonConvert.SerializeObject(lMsg);
await _hubContext.Clients.All.SendAsync(lMsg.entity, lJson);
return(CreatedAtAction("Getiot_device", new { id = iot_device.id }, iot_device));
}
public async Task <IActionResult> Putiot_task_failed(long id, iot_task iot_task)
{
if (id != iot_task.id)
{
return(BadRequest());
}
_context.Entry(iot_task).State = EntityState.Modified;
try
{
if (iot_task.completed.HasValue)
{
await _context.Database.ExecuteSqlRawAsync(
"UPDATE iot_task SET " +
" completed={1}, " +
" taskstatusnm='FAILED' " +
" WHERE id={0}",
parameters : new[] { iot_task.id.ToString(), iot_task.completed.ToString() });
}
else
{
await _context.Database.ExecuteSqlRawAsync(
"UPDATE iot_task SET " +
" completed=null, " +
" taskstatusnm='FAILED' " +
" WHERE id={0}",
parameters : iot_task.id);
}
}
catch (DbUpdateConcurrencyException)
{
if (!iot_taskExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
var lMsg = new ServerUpdateHubMsg(_entity, ServerUpdateHubMsg.TOperation.UPDATE, id);
var lJson = JsonConvert.SerializeObject(lMsg);
await _hubContext.Clients.All.SendAsync(lMsg.entity, lJson);
return(NoContent());
}
public async Task <ActionResult <ker_reftab> > Deleteker_reftab(long id)
{
var ker_reftab = await _context.ker_reftab.FindAsync(id);
if (ker_reftab == null)
{
return(NotFound());
}
_context.ker_reftab.Remove(ker_reftab);
await _context.SaveChangesAsync();
var lMsg = new ServerUpdateHubMsg(_entity, ServerUpdateHubMsg.TOperation.DELETE, id);
var lJson = JsonConvert.SerializeObject(lMsg);
await _hubContext.Clients.All.SendAsync(lMsg.entity, lJson);
return(ker_reftab);
}
public async Task <ActionResult <iot_calendarday> > Deleteiot_calendarday(long id)
{
var iot_calendarday = await _context.iot_calendarday.FindAsync(id);
if (iot_calendarday == null)
{
return(NotFound());
}
_context.iot_calendarday.Remove(iot_calendarday);
await _context.SaveChangesAsync();
var lMsg = new ServerUpdateHubMsg(_entity, ServerUpdateHubMsg.TOperation.DELETE, id);
var lJson = JsonConvert.SerializeObject(lMsg);
await _hubContext.Clients.All.SendAsync(lMsg.entity, lJson);
return(iot_calendarday);
}
public async Task <ActionResult <pcm_calevent> > Deletepcm_calevent(long id)
{
var pcm_calevent = await _context.pcm_calevent.FindAsync(id);
if (pcm_calevent == null)
{
return(NotFound());
}
_context.pcm_calevent.Remove(pcm_calevent);
await _context.SaveChangesAsync();
var lMsg = new ServerUpdateHubMsg(_entity, ServerUpdateHubMsg.TOperation.DELETE, id);
var lJson = JsonConvert.SerializeObject(lMsg);
await _hubContext.Clients.All.SendAsync(lMsg.entity, lJson);
return(pcm_calevent);
}
public async Task <ActionResult <iot_device> > Copyiot_device(long sourceid, long?masterdeviceid)
{
var sourcedevice = await _context.iot_device.FindAsync(sourceid);
if (sourcedevice == null)
{
return(NotFound());
}
var subdevices = await _context.iot_device.Where(d => d.masterdeviceid == sourcedevice.id).ToListAsync();
var newdevice = new iot_device();
sourcedevice.CopyAllPropertiesTo(newdevice);
newdevice.id = 0;
newdevice.code = sourcedevice.code + "_(1)";
newdevice.name = sourcedevice.name + " (1)";
newdevice.masterdevice = null;
newdevice.masterdeviceid = (masterdeviceid == 0)?null:masterdeviceid;
newdevice.iot_sample = null;
newdevice.iot_subdevice = null;
newdevice.iot_task = null;
/*
* var lResult=await Postiot_device(iot_device);
* iot_device newdevice = (ObjectResult)lResult.Result;
*/
_context.iot_device.Add(newdevice);
await _context.SaveChangesAsync();
var lMsg = new ServerUpdateHubMsg(_entity, ServerUpdateHubMsg.TOperation.INSERT, newdevice.id);
var lJson = JsonConvert.SerializeObject(lMsg);
await _hubContext.Clients.All.SendAsync(lMsg.entity, lJson);
for (int i = 0; i < subdevices.Count; i++)
{
await Copyiot_device(subdevices[i].id, newdevice.id);
}
// return lResult;
return(CreatedAtAction("Getiot_device", new { id = newdevice.id }, newdevice));
}
public async Task <ActionResult <pcm_calevent> > Getpcm_calevent(long id)
{
var pcm_calevent = await _context.pcm_calevent.FindAsync(id);
// var pcm_calevent = await _context.pcm_calevent
// .Include(d => d.customer)
// .SingleOrDefaultAsync(d => d.id == id);
if (pcm_calevent == null)
{
return(NotFound());
}
var lMsg = new ServerUpdateHubMsg(_entity, ServerUpdateHubMsg.TOperation.UPDATE, id);
var lJson = JsonConvert.SerializeObject(lMsg);
await _hubContext.Clients.All.SendAsync(lMsg.entity, lJson);
return(pcm_calevent);
}
public async Task <IActionResult> Putiot_sample(long id, iot_sample iot_sample)
{
if (id != iot_sample.id)
{
return(BadRequest());
}
if (iot_sample.importance == null)
{
iot_sample.importance = 0;
}
_context.Entry(iot_sample).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!iot_sampleExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
var lMsg = new ServerUpdateHubMsg(_entity, ServerUpdateHubMsg.TOperation.UPDATE, id);
var lJson = JsonConvert.SerializeObject(lMsg);
await _hubContext.Clients.All.SendAsync(lMsg.entity, lJson);
return(NoContent());
}
