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); }