public ActionResult <IEnumerable <PositionDto> > Get([FromQuery] PositionSearch positionSearch) { try { var positions = _getPositions.Execute(positionSearch); return(Ok(positions)); } catch (Exception) { return(StatusCode(500, "An error has occured.")); } }
public IEnumerable <PositionDto> Execute(PositionSearch request) { var query = Context.Positions.AsQueryable(); if (request.Name != null) { var keyword = request.Name.ToLower(); query = query.Where(p => p.Name.ToLower().Contains(keyword)); } return(query.Include(p => p.Players).Where(p => p.IsDeleted == false).Select(p => new PositionDto { Id = p.Id, Name = p.Name, PlayersId = p.Players.Select(pl => pl.Id) })); }
public IHttpActionResult Search([FromUri] PositionSearchFilter filter) { string accessType = "Position_ViewAll"; ThrowIfUserCannotAccess(accessType); if (filter == null) { throw new KairosException("Missing search filter parameter"); } using (var positionSearch = new PositionSearch(Db)) { var data = positionSearch.GetDataByFilter(filter); return(Ok(new SuccessResponse(data))); } }
public PositionListDataProvider(GlobalSolusindoDb db, tblM_User user, PositionSearch positionSearch) : base(db, user) { this.positionSearch = positionSearch; }