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