/// <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();
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);
return(elevator);
}
}
/// <summary>
/// Get All Elevator as Iquerable
/// </summary>
/// <returns></returns>
public IQueryable <Domain.Entities.Elevator> All()
{
using (var context = new ElevatorContext())
{
var elevators = context.Elevators;
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();
return(elevators);
}
}
/// <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 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>
/// 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>
/// 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();
return(true);
}
}
/// <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>
/// 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);
}
}
