//// GET: api/StationProcesses
//public IEnumerable<string> Get()
//{
// return new string[] { "value1", "value2" };
//}
// GET: api/StationProcesses/5
public IHttpActionResult Get(int id)
{
using (testeftEntities db = new testeftEntities())
{
//var occurrences = db.occurrences.Where(o => o.station_id == id).Select(o => new
//{
// o.id,
// o.occurred_when
//}).ToList();
var latestProcesses = db.occurrences
.Where(c => c.station_id == id)
.ToList()
.LastOrDefault()
.processes
.Select(p => new
{
p.id,
p.name
});
if (latestProcesses.Count() == 0)
{
return(NotFound());
}
return(Ok(latestProcesses));
}
}
// GET: api/Occurrence
//public IEnumerable<string> Get()
//{
// return new string[] { "value1", "value2" };
//}
//// GET: api/Occurrence/5
//public string Get(int id)
//{
// return "value";
//}
// POST: api/Occurrence
public IHttpActionResult Post([FromBody] dynamic value)
{
using (testeftEntities db = new testeftEntities())
{
occurrences o = new occurrences();
o.station_id = value.station_id;
o.occurred_when = value.occurred_when;
foreach (var proc in value.proc)
{
processes p = new processes();
p.name = proc;
o.processes.Add(p);
}
db.occurrences.Add(o);
db.SaveChanges();
return(Ok(o.id));
}
}
// DELETE: api/Station/5
public IHttpActionResult Delete(int id)
{
using (testeftEntities db = new testeftEntities())
{
db.stations.Remove(db.stations.Find(id));
db.SaveChanges();
return(Ok());
}
}
// PUT: api/Station/5
public IHttpActionResult Put(int id, [FromBody] dynamic value)
{
using (testeftEntities db = new testeftEntities())
{
stations s = db.stations.Find(id);
s.is_active = value.is_active;
db.SaveChanges();
return(Ok());
}
}
// GET: api/Config
public IHttpActionResult Get()
{
using (testeftEntities db = new testeftEntities())
{
var c = db.configurations.FirstOrDefault();
if (c == null)
{
return(NotFound());
}
return(Ok(c));
}
}
// POST: api/Station
public IHttpActionResult Post([FromBody] dynamic value)
{
using (testeftEntities db = new testeftEntities())
{
stations s = new stations();
s.cnpj = value.cnpj;
s.company_name = value.company_name;
s.is_active = true;
db.stations.Add(s);
db.SaveChanges();
return(Ok(s.id));
}
}
// GET: api/OccurrencesByStation
//public IHttpActionResult Get()
//{
// return NotFound();
//}
// GET: api/OccurrencesByStation/5
public IHttpActionResult Get(int id)
{
using (testeftEntities db = new testeftEntities())
{
var occurrences = db.occurrences.Where(o => o.station_id == id).Select(o => new
{
o.id,
o.occurred_when
}).ToList();
if (occurrences.Count == 0)
{
return(NotFound());
}
//var lastOccurrence = db.occurrences.Where(c => c.station_id == id).ToList().LastOrDefault().processes;
return(Ok(occurrences));
}
}
// GET: api/Station/5
public IHttpActionResult Get(int id)
{
using (testeftEntities db = new testeftEntities())
{
dynamic oneStation = db.stations.Where(s => s.id == id).Select(s => new
{
s.id,
s.company_name,
s.cnpj,
s.is_active
}).FirstOrDefault();
if (oneStation == null)
{
return(NotFound());
}
return(Ok(oneStation));
}
}
// GET: api/Station
public IHttpActionResult Get()
{
using (testeftEntities db = new testeftEntities())
{
dynamic allStations = db.stations.Select(s => new
{
s.id,
s.company_name,
s.cnpj,
s.is_active
}).ToList();
if (allStations.Count == 0)
{
return(NotFound());
}
return(Ok(allStations));
}
}
