/// <summary>
/// Get All Elevator with search func expression
/// </summary>
/// <param name="expression"></param>
/// <returns></returns>
public List<Domain.Entities.Elevator> AllList(Expression<Func<Domain.Entities.Elevator, bool>> expression)
{
using (var context = new ElevatorContext())
{
var elevators = context.Elevators.Where(expression).ToList();
// Log call
_loggingService.Info("Elevator.Infrastructure.Data.Repositories: ElevatorRepository.AllList expression");
return elevators;
}
}
/// <summary>
/// Get All Elevator as Iquerable
/// </summary>
/// <returns></returns>
public IQueryable<Domain.Entities.Elevator> All()
{
using (var context = new ElevatorContext())
{
var elevators = context.Elevators;
// Log call
_loggingService.Info("Elevator.Infrastructure.Data.Repositories: ElevatorRepository.All");
return elevators;
}
}
/// <summary>
/// Get All Elevator as List
/// </summary>
/// <returns></returns>
public List<Domain.Entities.Elevator> AllList()
{
using (var context = new ElevatorContext())
{
var stopWatch = new Stopwatch();
stopWatch.Start();
var elevators = context.Elevators.ToList();
stopWatch.Stop();
// Log call
_loggingService.Info("Elevator.Infrastructure.Data.Repositories: ElevatorRepository.AllList, Elapsed (ms): " + stopWatch.ElapsedMilliseconds);
return elevators;
}
}
/// <summary>
/// Get Elevator by id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Domain.Entities.Elevator Get(int id)
{
using (var context = new ElevatorContext())
{
var elevator = context.Elevators.Find(id);
//log call
_loggingService.Info("Elevator.Infrastructure.Data.Repositories: ElevatorRepository.Get");
return elevator;
}
}
/// <summary>
/// Update current Elevator to db
/// </summary>
/// <param name="elevator"></param>
/// <returns></returns>
public bool Update(Domain.Entities.Elevator elevator)
{
using (var context = new ElevatorContext())
{
context.Elevators.Attach(elevator);
var entry = context.Entry(elevator);
entry.State = EntityState.Modified;
context.SaveChanges();
//log call
_loggingService.Info("Elevator.Infrastructure.Data.Repositories: ElevatorRepository.Update");
return true;
}
}
