public List <DriverWorkstate> FindDriverWorkStates(int driverId)
{
using (var hosDbContext = new HosDBContext(_connectionString))
{
return(hosDbContext.DriverWorkstates.Where(dw => dw.DriverId == driverId).ToList());
}
}
public DriverWorkstate SaveDriverWorkstate(DriverWorkstate driverWorkstate)
{
try
{
using (var hosDbContext = new HosDBContext(_connectionString))
{
if (driverWorkstate.DriverWorkStateId != 0)
{
hosDbContext.DriverWorkstates.Attach(driverWorkstate);
hosDbContext.Entry(driverWorkstate).State = EntityState.Modified;
}
else
{
hosDbContext.DriverWorkstates.Add(driverWorkstate);
}
hosDbContext.SaveChanges();
}
return(driverWorkstate);
}
catch (Exception exception)
{
throw exception;
}
}
public List <DriverSummary> FindLatestDriverSummaries(int numberOfSummaries)
{
using (var hosDbContext = new HosDBContext(_connectionString))
{
return(hosDbContext.DriverSummaries.OrderByDescending(dw => dw.DriverId).Take(numberOfSummaries).ToList());
}
}
public DriverSummary SaveDriverSummary(DriverSummary driverSummary)
{
try
{
using (var hosDbContext = new HosDBContext(_connectionString))
{
var tempDriverSummary =
hosDbContext.DriverSummaries.FirstOrDefault(
ds => ds.DriverId == driverSummary.DriverId && ds.WorkStateId == driverSummary.WorkStateId);
if (tempDriverSummary == null)
{
hosDbContext.DriverSummaries.Add(driverSummary);
}
else
{
tempDriverSummary.TotalSeconds = driverSummary.TotalSeconds;
}
hosDbContext.SaveChanges();
}
return(driverSummary);
}
catch (Exception exception)
{
throw exception;
}
}
public List <DriverSummary> AllDriverSummariesForDrivers()
{
using (var hosDbContext = new HosDBContext(_connectionString))
{
return(hosDbContext.DriverSummaries
.OrderBy(ds => ds.DriverId).ToList());
}
}
public List <DriverWorkstate> FindDriverWorkStates(int driverId, DateTime from, DateTime to)
{
using (var hosDbContext = new HosDBContext(_connectionString))
{
return
(hosDbContext.DriverWorkstates.Where(
dw => dw.DriverId == driverId && dw.Timestamp > from && dw.Timestamp < to).ToList());
}
}
public DriverSummary FindDriverSummary(int driverId, int workstateId)
{
using (var hosDbContext = new HosDBContext(_connectionString))
{
return
(hosDbContext.DriverSummaries.FirstOrDefault(
ds => ds.DriverId == driverId && ds.WorkStateId == workstateId));
}
}
public List <DriverSummary> FindDriverSummariesForDrivers(IEnumerable <int> driverIds)
{
using (var hosDbContext = new HosDBContext(_connectionString))
{
return(hosDbContext.DriverSummaries
.Where(ds => driverIds
.Contains(ds.DriverId))
.OrderBy(ds => ds.DriverId).ToList());
}
}
public DriverWorkstate LastDriverWorkStateBefore(int driverId, int workStateId, DateTime before)
{
using (var hosDbContext = new HosDBContext(_connectionString))
{
return
(hosDbContext
.DriverWorkstates
.Where(dw => dw.DriverId == driverId &&
dw.WorkStateId == workStateId &&
dw.Timestamp < before)
.OrderByDescending(dw => dw.Timestamp)
.FirstOrDefault());
}
}
