public SensorModels Get(int id)
{
try
{
using (SensorEntities _entity = new SensorEntities())
{
sensorRetorno = (from tp in _entity.Sensor
join rg in _entity.Regiao on
tp.idRegiao equals rg.Id
join pg in _entity.Pais on
tp.idPais equals pg.Id
where (tp.Id == id)
select new
{
valSensor = tp,
valRegiao = rg,
valPais = pg
})
.AsEnumerable()
.Select(tp => new SensorModels
{
Id = tp.valSensor.Id,
Nome = tp.valSensor.Nome,
PaisModels = new PaisModels(tp.valPais.Id, tp.valPais.Nome),
RegiaoModels = new RegiaoModels(tp.valRegiao.Id, tp.valRegiao.Nome)
})
.FirstOrDefault();
}
}
catch (Exception e)
{
throw new ArgumentNullException(e.Message, Mensagem.HOUVEUMERRONAEXECUCAO.GetStringValue());
}
return(sensorRetorno);
}
public SensorModels Add(SensorModels item)
{
try
{
using (SensorEntities _entity = new SensorEntities())
{
Sensor sensor = new Sensor
{
Id = item.Id,
Nome = item.Nome,
idPais = item.PaisModels.Id,
idRegiao = item.RegiaoModels.Id
};
_entity.Entry(sensor).State = !_entity.Sensor.Any(f => f.Id == item.Id) ? EntityState.Added : EntityState.Modified;
_entity.SaveChanges();
item.Id = sensor.Id;
}
}
catch (Exception e)
{
throw new ArgumentNullException(e.Message, Mensagem.HOUVEUMERRONAEXECUCAO.GetStringValue());
}
return(item);
}
public List <object> ListAll(Boolean dtTable = true)
{
List <object> iDados = new List <object>();
DataTable dt = new DataTable();
if (dtTable)
{
dt.Columns.Add("Pais", System.Type.GetType("System.String"));
dt.Columns.Add("Valor", System.Type.GetType("System.Int32"));
}
using (SensorEntities _entity = new SensorEntities())
{
var lst = (from tp in _entity.Regiao
join sn in _entity.Sensor on
tp.Id equals sn.idRegiao
join pgn in _entity.Pais on
sn.idPais equals pgn.Id
join snv in _entity.Sensor_valor on
sn.Id equals snv.IdSensor
group tp by pgn.Nome into gr
select new { Nome = gr.Key, Valor = gr.Count() })
.ToList();
if (dtTable)
{
foreach (var value in lst)
{
DataRow dr = dt.NewRow();
dr["Pais"] = value.Nome;
dr["Valor"] = value.Valor;
dt.Rows.Add(dr);
}
foreach (DataColumn dc in dt.Columns)
{
List <object> x = new List <object>();
x = (from DataRow drr in dt.Rows select drr[dc.ColumnName]).ToList();
iDados.Add(x);
}
}
else
{
iDados.Add(lst);
}
}
return(iDados);
}
public long Count()
{
int count = 0;
try
{
using (SensorEntities _entity = new SensorEntities())
{
count = _entity.Pais.Count();
}
}
catch (Exception e)
{
throw new ArgumentNullException(e.Message, Mensagem.HOUVEUMERRONAEXECUCAO.GetStringValue());
}
return(count);
}
public List <object> ListAll(Boolean dtTable = true)
{
List <object> iDados = new List <object>();
using (SensorEntities _entity = new SensorEntities())
{
var lst = (from sn in _entity.Sensor
join snv in _entity.Sensor_valor on
sn.Id equals snv.IdSensor
group sn by sn.Nome into gr
select new { Nome = gr.Key, Valor = gr.Sum(s => s.Sensor_valor.Sum(x => x.Valor)) })
.Select(gr => new
{
Nome = gr.Nome,
Valor = gr.Valor
})
.ToList();
iDados.Add(lst);
}
return(iDados);
}
public PaisModels Get(string nome)
{
try
{
using (SensorEntities _entity = new SensorEntities())
{
paisRetorno = (from tp in _entity.Pais
select new { tp.Nome, tp.Id, tp.Ativo })
.Select(tp => new PaisModels
{
Id = tp.Id,
Nome = tp.Nome
})
.Where(wh => wh.Nome.Contains(nome == "" ? wh.Nome : nome))
.FirstOrDefault();
}
}
catch (Exception e)
{
throw new ArgumentNullException(e.Message, Mensagem.HOUVEUMERRONAEXECUCAO.GetStringValue());
}
return(paisRetorno);
}
public RegiaoModels Get(int id)
{
try
{
using (SensorEntities _entity = new SensorEntities())
{
regiaoRetorno = (from tp in _entity.Regiao
select new { tp.Nome, tp.Id, tp.Ativo })
.Select(tp => new RegiaoModels
{
Id = tp.Id,
Nome = tp.Nome
})
.Where(wh => wh.Id == id)
.FirstOrDefault();
}
}
catch (Exception e)
{
throw new ArgumentNullException(e.Message, Mensagem.HOUVEUMERRONAEXECUCAO.GetStringValue());
}
return(regiaoRetorno);
}
public PaisModels Add(PaisModels item)
{
try
{
using (SensorEntities _entity = new SensorEntities())
{
Pais pais = new Pais
{
Id = item.Id,
Nome = item.Nome,
Ativo = "1"
};
_entity.Entry(pais).State = !_entity.Pais.Any(f => f.Id == item.Id) ? EntityState.Added : EntityState.Modified;
_entity.SaveChanges();
item.Id = pais.Id;
}
}
catch (Exception e)
{
throw new ArgumentNullException(e.Message, Mensagem.HOUVEUMERRONAEXECUCAO.GetStringValue());
}
return(item);
}
public SensorValorModels Add(SensorValorModels item)
{
try
{
using (SensorEntities _entity = new SensorEntities())
{
Sensor_valor sensorValor = new Sensor_valor
{
Id = item.Id,
IdSensor = item.SensorModels.Id,
TimesTamp = item.Timestamp,
Valor = item.Valor,
DataCadastrado = DateTime.Now
};
_entity.Entry(sensorValor).State = !_entity.Sensor.Any(f => f.Id == item.Id) ? EntityState.Added : EntityState.Modified;
_entity.SaveChanges();
}
}
catch (Exception e)
{
throw new ArgumentNullException(e.Message, Mensagem.HOUVEUMERRONAEXECUCAO.GetStringValue());
}
return(item);
}
