public List <Sensor> GetAllSensors() { using (var dc = new traffichookContext()) { List <Sensor> result = dc.Sensors.ToList(); return(result); } }
public Sensor GetSensorById(int key) { using (var dc = new traffichookContext()) { Sensor result = dc.Sensors.Where(i => i.KeyExt == key).FirstOrDefault(); return(result); } }
/// <summary> /// Добавление новых даннах о проезде автомобиля /// </summary> /// <param name="model"></param> public static void Add(VehicleDatum model) { using (var dc = new traffichookContext()) { dc.VehicleData.Add(model); dc.SaveChanges(); } }
public List <VehicleDatum> GetAllVhicleData() { using (var dc = new traffichookContext()) { var result = dc.VehicleData.ToList(); return(result); } }
/// <summary> /// Добавление Датчика /// </summary> /// <param name="id"></param> public static void Add(int id) { using (var dc = new traffichookContext()) { dc.Sensors.Add(new Sensor() { KeyExt = id }); dc.SaveChanges(); } }
public List <VehicleDatum> GetAllVhicleDataWithDate(DateTime firstDate, DateTime secondDate) { if (firstDate == null) { throw new Exception("Не введена нижняя граница даты"); } if (secondDate == null) { throw new Exception("Не введена верхняя граница даты"); } using (var dc = new traffichookContext()) { var result = dc.VehicleData.Where(i => i.Date >= firstDate && i.Date <= secondDate).ToList(); return(result); } }
public List <VehicleDatum> GetAllVhicleDataForSensor(int key, DateTime firstDate, DateTime secondDate) { if (key == 0) { throw new Exception("Не заполнен ключ датчика"); } using (var dc = new traffichookContext()) { List <VehicleDatum> result = null; if (firstDate == null || secondDate == null) { result = dc.VehicleData.Where(i => i.SensorId == key).ToList(); } else { result = dc.VehicleData.Where(i => i.Date >= firstDate && i.Date <= secondDate && i.SensorId == key).ToList(); } return(result); } }