public async Task <IActionResult> GetByIdAsync(string id) { try { if (string.IsNullOrWhiteSpace(id)) { throw new ArgumentNullException("id"); } var metadata = await _repository.GetByIdAsync(id); if (metadata == null) { return(NotFound()); } return(Ok(DetectionProcessors.ToDetection(metadata))); } catch (ArgumentNullException ex) { var details = new ProblemDetails() { Detail = ex.Message }; return(BadRequest(details)); } catch (Exception ex) { var details = new ProblemDetails() { Title = ex.GetType().ToString(), Detail = ex.Message }; return(StatusCode(StatusCodes.Status500InternalServerError, details)); } }
public IActionResult GetSystemMetrics([FromQuery] MetricsFilterDTO queryParameters) { try { if (string.IsNullOrWhiteSpace(queryParameters.Timeframe)) { throw new ArgumentNullException("Timeframe"); } var metrics = new Metrics(); metrics.Timeframe = queryParameters.Timeframe; // Build base queryable var queryable = BuildQueryableAsync(queryParameters.Timeframe); // If not metrics to return if (queryable == null || queryable.Count() == 0) { return(NoContent()); } var results = queryable .Select(x => DetectionProcessors.ToDetection(x)).ToList(); // Pull reviewed/unreviewed metrics from querable var reviewed = DetectionProcessors.GetReviewed(results); metrics.Reviewed = reviewed.ReviewedCount; metrics.Unreviewed = reviewed.UnreviewedCount; // Pull results metrics from queryable var detections = DetectionProcessors.GetResults(results); metrics.ConfirmedDetection = detections.ConfirmedCount; metrics.FalseDetection = detections.FalseCount; metrics.UnknownDetection = detections.UnknownCount; // Pull comments from queryable metrics.ConfirmedComments = DetectionProcessors.GetComments(results, "yes"); metrics.UnconfirmedComments = DetectionProcessors.GetComments(results, "no"); metrics.UnconfirmedComments.AddRange(DetectionProcessors.GetComments(results, "don't know")); metrics.UnconfirmedComments = metrics.UnconfirmedComments.OrderByDescending(x => x.Timestamp).ToList(); // Pull tags from queryable metrics.Tags = DetectionProcessors.GetTags(results); return(Ok(metrics)); } catch (ArgumentNullException ex) { var details = new ProblemDetails() { Detail = ex.Message }; return(BadRequest(details)); } catch (Exception ex) { var details = new ProblemDetails() { Title = ex.GetType().ToString(), Detail = ex.Message }; return(StatusCode(StatusCodes.Status500InternalServerError, details)); } }
public async Task <IActionResult> Put(string id, [FromBody] DetectionUpdate detectionUpdate) { try { if (string.IsNullOrWhiteSpace(id)) { throw new ArgumentNullException("id"); } if (detectionUpdate == null) { throw new ArgumentNullException("postedDetection"); } var metadata = await _repository.GetByIdAsync(id); if (metadata == null) { return(NotFound()); } metadata.comments = detectionUpdate.Comments; metadata.moderator = detectionUpdate.Moderator; metadata.dateModerated = detectionUpdate.Moderated.ToUniversalTime().ToString("yyyy-MM-ddTHH:mm:ssZ"); metadata.reviewed = detectionUpdate.Reviewed; metadata.SRKWFound = (string.IsNullOrWhiteSpace(detectionUpdate.Found)) ? "no" : detectionUpdate.Found.ToLower(); // Normalize the tags if (!string.IsNullOrWhiteSpace(detectionUpdate.Tags)) { var working = detectionUpdate.Tags.Replace(",", ";"); var tagList = new List <string>(); tagList.AddRange(working.Split(';').ToList().Select(x => x.Trim())); metadata.tags = string.Join(";", tagList); } else { metadata.tags = string.Empty; } await _repository.CommitAsync(); return(Ok(DetectionProcessors.ToDetection(metadata))); } catch (ArgumentNullException ex) { var details = new ProblemDetails() { Detail = ex.Message }; return(BadRequest(details)); } catch (Exception ex) { var details = new ProblemDetails() { Title = ex.GetType().ToString(), Detail = ex.Message }; return(StatusCode(StatusCodes.Status500InternalServerError, details)); } }
public IActionResult GetUnknowns([FromQuery] DetectionQueryParameters queryParameters) { try { if (string.IsNullOrWhiteSpace(queryParameters.Timeframe)) { throw new ArgumentNullException("Timeframe"); } if (queryParameters.DateFrom > queryParameters.DateTo) { throw new Exception("From Date should be less than To date"); } if (string.IsNullOrWhiteSpace(queryParameters.SortBy)) { throw new ArgumentNullException("SortBy"); } if (string.IsNullOrWhiteSpace(queryParameters.SortOrder)) { throw new ArgumentNullException("SortOrder"); } if (string.IsNullOrWhiteSpace(queryParameters.Location)) { throw new ArgumentNullException("Location"); } if (queryParameters.Page == 0) { throw new ArgumentNullException("Page"); } if (queryParameters.RecordsPerPage == 0) { throw new ArgumentNullException("RecordsPerPage"); } // start with all records var queryable = _repository.GetAll(); // apply desired status MetadataFilters.ApplyReviewedFilter(ref queryable, true); // apply desired found state MetadataFilters.ApplyFoundFilter(ref queryable, "don't know"); // apply timeframe filter MetadataFilters.ApplyTimeframeFilter(ref queryable, queryParameters.Timeframe, queryParameters.DateFrom, queryParameters.DateTo); // apply location filter if (queryParameters.Location.ToLower() != "all") { MetadataFilters.ApplyLocationFilter(ref queryable, queryParameters.Location); } // If no detections found if (queryable == null || queryable.Count() == 0) { return(NoContent()); } // total number of records double recordCount = queryable.Count(); var results = queryable .Select(x => DetectionProcessors.ToDetection(x)).ToList(); // apply sort filter if (queryParameters.SortBy.ToLower() == "confidence") { DetectionFilters.ApplyConfidenceSortFilter(ref results, queryParameters.SortOrder); } else if (queryParameters.SortBy.ToLower() == "timestamp") { DetectionFilters.ApplyTimestampSortFilter(ref results, queryParameters.SortOrder); } // apply pagination filter DetectionFilters.ApplyPaginationFilter(ref results, queryParameters.Page, queryParameters.RecordsPerPage); // set page count headers SetHeaderCounts(recordCount, (queryParameters.RecordsPerPage > 0 ? queryParameters.RecordsPerPage : MetadataFilters.DefaultRecordsPerPage)); // map to returnable data type and return return(Ok(results)); } catch (ArgumentNullException ex) { var details = new ProblemDetails() { Detail = ex.Message }; return(BadRequest(details)); } catch (Exception ex) { var details = new ProblemDetails() { Title = ex.GetType().ToString(), Detail = ex.Message }; return(StatusCode(StatusCodes.Status500InternalServerError, details)); } }
public IActionResult GetUnreviewed([FromQuery] DetectionQueryParameters queryParameters) { try { if (string.IsNullOrWhiteSpace(queryParameters.Timeframe)) { throw new ArgumentNullException("Timeframe"); } if (queryParameters.DateFrom > queryParameters.DateTo) { throw new Exception("From Date should be less than To date"); } if (string.IsNullOrWhiteSpace(queryParameters.SortBy)) { throw new ArgumentNullException("SortBy"); } if (string.IsNullOrWhiteSpace(queryParameters.SortOrder)) { throw new ArgumentNullException("SortOrder"); } if (string.IsNullOrWhiteSpace(queryParameters.Location)) { throw new ArgumentNullException("Location"); } if (queryParameters.Page == 0) { throw new ArgumentNullException("Page"); } if (queryParameters.RecordsPerPage == 0) { throw new ArgumentNullException("RecordsPerPage"); } // start with all records var queryable = _repository.GetAll(); // apply reviewed status MetadataFilters.ApplyReviewedFilter(ref queryable, false); // apply location filter if (queryParameters.Location.ToLower() != "all") { MetadataFilters.ApplyLocationFilter(ref queryable, queryParameters.Location); } // apply timeframe filter MetadataFilters.ApplyTimeframeFilter(ref queryable, queryParameters.Timeframe, queryParameters.DateFrom, queryParameters.DateTo); // If no detections found if (queryable == null || queryable.Count() == 0) { return(NoContent()); } // total number of records double recordCount = queryable.Count(); var results = queryable .Select(x => DetectionProcessors.ToDetection(x)).ToList(); // NOTE: Have to apply SortBy timestamp and pagination filter after // executing the select because of how EF for Cosmos deals with DateTime. // Had to convert from string (how stored in Cosmos) to DateTime in order to apply the // select, but that messed up the SortBy since Cosmos is expecting a string. // apply sort filter if (queryParameters.SortBy.ToLower() == "confidence") { DetectionFilters.ApplyConfidenceSortFilter(ref results, queryParameters.SortOrder); } else if (queryParameters.SortBy.ToLower() == "timestamp") { DetectionFilters.ApplyTimestampSortFilter(ref results, queryParameters.SortOrder); } // apply pagination filter DetectionFilters.ApplyPaginationFilter(ref results, queryParameters.Page, queryParameters.RecordsPerPage); // set page count headers SetHeaderCounts(recordCount, (queryParameters.RecordsPerPage > 0 ? queryParameters.RecordsPerPage : MetadataFilters.DefaultRecordsPerPage)); // map to returnable data type and return return(Ok(results)); } catch (ArgumentNullException ex) { var details = new ProblemDetails() { Detail = ex.Message }; return(BadRequest(details)); } catch (Exception ex) { var details = new ProblemDetails() { Title = ex.GetType().ToString(), Detail = ex.Message }; return(StatusCode(StatusCodes.Status500InternalServerError, details)); } }