public IQueryable <RawReport> GetRawReportsWithDataCollectorQuery(ReportsFilter filters) => _nyssContext.RawReports .FilterByTrainingMode(filters.IsTraining) .FromKnownDataCollector() .FilterByArea(filters.Area) .FilterByDataCollectorType(filters.DataCollectorType) .FilterByProject(filters.ProjectId) .FilterReportsByNationalSociety(filters.NationalSocietyId) .FilterByDate(filters.StartDate.Date, filters.EndDate.Date) .FilterByHealthRisk(filters.HealthRiskId);
public IQueryable <Report> GetHealthRiskEventReportsQuery(ReportsFilter filters) => GetSuccessReportsQuery(filters) .Where(r => r.ProjectHealthRisk.HealthRisk.HealthRiskType != HealthRiskType.Activity);
public IQueryable <Report> GetSuccessReportsQuery(ReportsFilter filters) => GetRawReportsWithDataCollectorQuery(filters) .AllSuccessfulReports() .Select(r => r.Report) .Where(r => !r.MarkedAsError);