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