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