public IQueryable <QCEvent> GetQueryableQCEventForUpdate( QCEventQueryOptions options, QCEventQueryFilter filter = null, QCEventQuerySort sort = null, QCEventQueryPaging paging = null) { var query = QCEvents; if (filter != null) { query = query.Filter(filter); } if (!options.single_only) { if (paging != null && (!options.load_all || !QCEventQueryOptions.IsLoadAllAllowed)) { if (sort != null) { query = query.Sort(sort); } query = query.SelectPage(paging.page, paging.limit); } } return(query); }
public async Task <QueryResult <IDictionary <string, object> > > QueryQCEventDynamic( QCEventQueryProjection projection, QCEventQueryOptions options, QCEventQueryFilter filter = null, QCEventQuerySort sort = null, QCEventQueryPaging paging = null, string folderPath = null) { var fileService = provider.GetRequiredService <IFileService>(); var query = QCEvents; #region General if (filter != null) { query = query.Filter(filter); } query = query.Project(projection); int?totalCount = null; if (options.count_total) { totalCount = query.Count(); } #endregion if (!options.single_only) { #region List query if (sort != null) { query = query.Sort(sort); } if (paging != null && (!options.load_all || !QCEventQueryOptions.IsLoadAllAllowed)) { query = query.SelectPage(paging.page, paging.limit); } #endregion } if (options.single_only) { var single = query.SingleOrDefault(); if (single == null) { return(null); } var singleResult = GetQCEventDynamic(single, projection, options, folderPath, fileService); return(new QueryResult <IDictionary <string, object> >() { Single = singleResult }); } var entities = query.ToList(); var list = GetQCEventDynamic(entities, projection, options, folderPath, fileService); var result = new QueryResult <IDictionary <string, object> >(); result.List = list; if (options.count_total) { result.Count = totalCount; } return(result); }
public static IQueryable <QCEvent> Filter( this IQueryable <QCEvent> query, QCEventQueryFilter filter) { if (filter.id != null) { query = query.Where(o => o.Id == filter.id); } if (filter.ids != null && filter.ids.Length > 0) { query = query.Ids(filter.ids); } if (filter.defect_type != null) { query = query.Where(o => o.Details.Any(e => e.DefectTypeCode == filter.defect_type)); } if (filter.from_time != null) { query = query.FromTime(filter.from_time); } if (filter.to_time != null) { query = query.ToTime(filter.to_time); } if (filter.seen != null) { query = query.Where(o => o.Seen == filter.seen); } if (filter.latest && State.Instance.LastEventTime != null) { query = query.FromTime(State.Instance.LastEventTime, true); } return(query); }
public ValidationData ValidateUpdateSeenStatus( ClaimsPrincipal principal, QCEventQueryFilter filter, QCEventQuerySort sort, QCEventQueryPaging paging, QCEventQueryOptions options) { return(new ValidationData()); }
public ValidationData ValidateGetQCEvents( ClaimsPrincipal principal, QCEventQueryFilter filter, QCEventQuerySort sort, QCEventQueryProjection projection, QCEventQueryPaging paging, QCEventQueryOptions options) { return(new ValidationData()); }
public async Task <QueryResult <QCEvent> > QueryQCEvent( QCEventQueryProjection projection, QCEventQueryOptions options, QCEventQueryFilter filter = null, QCEventQuerySort sort = null, QCEventQueryPaging paging = null) { var query = QCEvents; #region General if (filter != null) { query = query.Filter(filter); } query = query.Project(projection); int?totalCount = null; if (options.count_total) { totalCount = query.Count(); } #endregion if (!options.single_only) { #region List query if (sort != null) { query = query.Sort(sort); } if (paging != null && (!options.load_all || !QCEventQueryOptions.IsLoadAllAllowed)) { query = query.SelectPage(paging.page, paging.limit); } #endregion } if (options.single_only) { var single = query.SingleOrDefault(); if (single == null) { return(null); } return(new QueryResult <QCEvent>() { Single = single }); } var result = new QueryResult <QCEvent>(); result.List = query.ToList(); if (options.count_total) { result.Count = totalCount; } return(result); }
public IActionResult UpdateSeenStatus([FromQuery][QueryObject] QCEventQueryFilter filter, [FromQuery] QCEventQuerySort sort, [FromQuery] QCEventQueryPaging paging, [FromQuery] QCEventQueryOptions options) { var validationData = _service.ValidateUpdateSeenStatus( User, filter, sort, paging, options); if (!validationData.IsValid) { return(BadRequest(AppResult.FailValidation(data: validationData))); } var query = _service.GetQueryableQCEventForUpdate(options, filter, sort, paging); var updated = _service.UpdateEventsSeenStatus(query, true); return(Ok(AppResult.Success(updated))); }
public IActionResult Count([FromQuery][QueryObject] QCEventQueryFilter filter, [FromQuery] QCEventQuerySort sort, [FromQuery] QCEventQueryPaging paging, [FromQuery] QCEventQueryOptions options) { var validationData = _service.ValidateCountQCEvents( User, filter, sort, paging, options); if (!validationData.IsValid) { return(BadRequest(AppResult.FailValidation(data: validationData))); } var query = _service.GetQueryableQCEvent(options, filter, sort, paging); var count = query.Count(); return(Ok(AppResult.Success(count))); }
public static IQueryable <QCEvent> Filter( this IQueryable <QCEvent> query, QCEventQueryFilter filter) { if (filter.id != null) { query = query.Where(o => o.Id == filter.id); } if (filter.ids != null && filter.ids.Length > 0) { query = query.Ids(filter.ids); } if (filter.batch_id != null) { query = query.Where(o => o.ProductionBatchId == filter.batch_id); } if (filter.seen != null) { query = query.Where(o => o.Seen == filter.seen); } return(query); }
public async Task <IActionResult> Get([FromQuery][QueryObject] QCEventQueryFilter filter, [FromQuery] QCEventQuerySort sort, [FromQuery] QCEventQueryProjection projection, [FromQuery] QCEventQueryPaging paging, [FromQuery] QCEventQueryOptions options) { var validationData = _service.ValidateGetQCEvents( User, filter, sort, projection, paging, options); if (!validationData.IsValid) { return(BadRequest(AppResult.FailValidation(data: validationData))); } var result = await _service.QueryQCEventDynamic( projection, options, Settings.Instance.QCEventImageFolderPath, filter, sort, paging); if (options.single_only && result == null) { return(NotFound(AppResult.NotFound())); } return(Ok(AppResult.Success(result))); }