public IHttpActionResult Put(int id, Sensor value) { IHttpActionResult ret = null; using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; var sensor = db.Sensors.Find(id); sensor.LowerLimit = value.LowerLimit; sensor.UpperLimit = value.UpperLimit; if (value.DeviceID != 0) { sensor.DeviceID = value.DeviceID; } if (value.UnitID != 0) { sensor.UnitID = value.UnitID; } sensor.UpdateDate = DateTime.Now; db.SaveChanges(); ret = Ok(sensor); } return(ret); }
public IEnumerable <object> GetFilterSensor(string searchInput) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { //db.Configuration.ProxyCreationEnabled = false; db.Configuration.LazyLoadingEnabled = false; List <SpGetSensors_Result> items; if (searchInput.Equals("*")) { items = db.SpGetSensors().ToList(); } else { items = db.SpGetSensors() .Where(x => x.Equipment.ToLower().Contains(searchInput.ToLower()) || x.Group.ToLower().Contains(searchInput.ToLower()) || x.Unit.ToLower().Contains(searchInput.ToLower())) .ToList(); } return(items); } }
private async void CheckAlarm(Record record) { using (var context = new EnergyMonitoringContext()) { DateTime dt = DateTime.Now; if ((int)dt.DayOfWeek == Config.AuditDayOfWeek) { if (dt.TimeOfDay >= Config.AuditTimeStart && dt.TimeOfDay <= Config.AuditTimeEnd) { if (record.Value < record.Sensor.LowerLimit || record.Value > record.Sensor.UpperLimit) { Alarm alarm = new Alarm(); alarm.RecordId = record.RecordId; alarm.CreateDate = DateTime.Now; _logger.LogInformation($"Alarm: {record.Equipment.Name};"); context.Alarm.Add(alarm); await context.SaveChangesAsync(); } } } } }
private List <string> GetSensorsFromDB() { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { var items = (from s in db.Sensors join d in db.Devices on s.DeviceID equals d.DeviceID join u in db.Units on s.UnitID equals u.UnitID where d.Active == true select new { Sensor = s, Device = d, }).ToList(); List <string> result = new List <string>(); foreach (var item in items) { result.Add(String.Format("Sensor={0}, Device={1}", item.Sensor, item.Device.Name)); } return(result); } }
public IEnumerable <object> GetAvgFlowEquipments(int year, int week, int weekday, TimeSpan startTime, TimeSpan endTime) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { var item = db.SpGetAvgFlowEquipments(year, week, weekday, startTime, endTime).ToList(); return(item); } }
public IEnumerable <object> GetEquipmentsCountPerWeekday(int year, int weekday) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { var item = db.SpGetEquipmentsCount(year, weekday).ToList(); return(item); } }
// GET: api/Records public IEnumerable <Record> GetRecord() { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; return(db.Records.Take(1000).ToList()); } }
// GET: api/Equipments public IEnumerable <Equipment> GetEquipment() { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; return(db.Equipments.ToList()); } }
public IEnumerable <object> GetFilterRecordsAvg(DateTime startDate, DateTime endDate, int groupId, int equipmentId) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { var item = db.SpGetFilterRecordsAvg(startDate, endDate, groupId, equipmentId).ToList(); return(item); } }
// GET: api/Groups public IEnumerable <Group> GetGroup() { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; return(db.Groups.OrderBy(x => x.Name).ToList()); } }
public IEnumerable <object> GetMaxValues(DateTime startDate, DateTime endDate) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { var item = db.SpGetMaxValues(startDate, endDate).ToList(); return(item); } }
public IEnumerable <Activity> GetActivity() { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; return(db.Activity.ToList()); } }
// GET: api/Configs public IEnumerable <Config> Get() { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; var items = db.Configs.ToList(); return(items); } }
public IEnumerable <object> GetFilterAlarms(DateTime startDate, DateTime endDate) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; var items = db.SpGetFilterAlarms(startDate, endDate).ToList(); return(items); } }
// GET: api/Configs/5 public Config Get(int id) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; var item = db.Configs.Find(id); return(item); } }
public int GetRecordsCount() { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { int count = db.Records.Count(); var sql = "SELECT COUNT(*) FROM Record"; var item = db.Database.SqlQuery <int>(sql).Single(); return(item); } }
//[Route("api/activities/{id}")] public Activity Get(int id) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; Activity activity = db.Activity.Find(id); return(activity); } }
public IEnumerable <Sensor> GetSensorsFromDevice(int DeviceId) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; var items = db.Sensors.Where(x => x.DeviceID == DeviceId) .Include(x => x.Unit) .ToList(); return(items); } }
public IEnumerable <Sensor> GetSensor() { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { //db.Configuration.ProxyCreationEnabled = false; db.Configuration.LazyLoadingEnabled = false; var items = db.Sensors.ToList(); return(items); } }
// GET: api/Sensors/5 public Sensor Get(int id) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { //db.Configuration.ProxyCreationEnabled = false; db.Configuration.LazyLoadingEnabled = false; var item = db.Sensors.Find(id); return(item); } }
public IEnumerable <Activity> GetActivitiesByEquipment(int equipmentId) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; var items = db.Activity .Where(x => x.EquipmentID == equipmentId) .OrderByDescending(x => x.CreateDate).ToList(); return(items); } }
// GET: api/Devices public IEnumerable <Device> GetDevice() { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; var items = db.Devices //.Include(x => x.Sensors.Select(y => y.Unit)) .Include(x => x.Equipment) .ToList(); return(items); } }
public IEnumerable <Equipment> GetEquipmentsByGroup(int GroupId) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; var items = db.Equipments.Where(x => x.GroupID == GroupId) .Include(x => x.Group) .Include(x => x.Devices.Select(d => d.Sensors)) .ToList(); return(items); } }
public IEnumerable <object> GetFilterActivities(DateTime startDate, DateTime endDate) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; var items = db.Activity.Include(x => x.Equipment) .Where(x => DbFunctions.TruncateTime(x.CreateDate) >= DbFunctions.TruncateTime(startDate) && DbFunctions.TruncateTime(x.CreateDate) <= DbFunctions.TruncateTime(endDate)) .OrderByDescending(x => x.Date).ToList(); return(items); } }
public int GetEquipmentsCount() { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; //int count = db.Equipments.Count(); var sql = "SELECT COUNT(*) FROM Equipment"; var item = db.Database.SqlQuery <int>(sql).Single(); return(item); } }
// GET: api/Alarms public IEnumerable <Alarm> Get() { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; var items = db.Alarms .Include(x => x.Record.Sensor.Unit) .Include(x => x.Record.Equipment.Group) .ToList().Take(10); return(items); } }
// POST: api/Sensors public async Task <IHttpActionResult> PostSensor(Sensor sensor) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { sensor.CreateDate = DateTime.Now; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Sensors.Add(sensor); await db.SaveChangesAsync(); } return(CreatedAtRoute("DefaultApi", new { id = sensor.SensorID }, sensor)); }
public IEnumerable <Record> GetRecordsByDevice(int deviceId, DateTime startDate, DateTime endDate) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; var items = db.Records .Where(x => x.Sensor.DeviceID == deviceId) .Where(x => DbFunctions.TruncateTime(x.CreateDate) >= DbFunctions.TruncateTime(startDate) && DbFunctions.TruncateTime(x.CreateDate) <= DbFunctions.TruncateTime(endDate)).OrderBy(x => x.CreateDate) .ToList(); return(items); } }
public async Task <IHttpActionResult> GetEquipment(int id) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; Equipment equipment = await db.Equipments.FindAsync(id); if (equipment == null) { return(NotFound()); } return(Ok(equipment)); } }
public async Task <IHttpActionResult> GetGroup(int id) { using (EnergyMonitoringContext db = new EnergyMonitoringContext()) { db.Configuration.LazyLoadingEnabled = false; Group group = await db.Groups.FindAsync(id); if (group == null) { return(NotFound()); } return(Ok(group)); } }