public override QueryComposerResponseDTO Execute(QueryComposerRequestDTO request, bool viewSQL) { SummarySqlQueryAdapter sql = new SummarySqlQueryAdapter(); var result = sql.Execute(request, _settings, viewSQL); return(result); }
public override IEnumerable <QueryComposerResponseQueryResultDTO> Execute(QueryComposerQueryDTO query, bool viewSQL) { SummarySqlQueryAdapter sql = new SummarySqlQueryAdapter(); var result = sql.Execute(query, _settings, viewSQL); return(new[] { result }); }
public override DTO.QueryComposer.QueryComposerResponseDTO Execute(DTO.QueryComposer.QueryComposerRequestDTO request, bool viewSQL) { IQueryAdapter queryAdapter = null; if (request.Where.Criteria.First().Terms.Any(t => t.Type == Lpp.QueryComposer.ModelTermsFactory.SqlDistributionID)) { logger.Debug("Sql Distribution term found, creating SummarySqlQueryAdapter."); SummarySqlQueryAdapter sql = new SummarySqlQueryAdapter(); var result = sql.Execute(request, _settings, viewSQL); _currentResponse = result; return(result); } if (request.Select.Fields.Any(t => t.Type == ModelTermsFactory.ICD9DiagnosisCodes3digitID)) { logger.Debug("ICD-9 Diagnoses Codes term found, creating IncidenceICD9DiagnosisQueryAdapter."); queryAdapter = new IncidenceICD9DiagnosisQueryAdapter(_settings); } else if (request.Select.Fields.Any(t => t.Type == ModelTermsFactory.DrugNameID) || request.Select.Fields.Any(t => t.Type == ModelTermsFactory.DrugClassID)) { if (request.Select.Fields.Any(t => t.Type == ModelTermsFactory.DrugNameID)) { logger.Debug("Pharmacy dispensing generic drug name term found, creating IncidencePharmaDispensingQueryAdapter."); } else { logger.Debug("Pharmacy dispensing drug class term found, creating IncidencePharmaDispensingQueryAdapter."); } queryAdapter = new IncidencePharmaDispensingQueryAdapter(_settings); } if (queryAdapter == null) { throw new InvalidOperationException("Unable to determine the query adapter to use based on the primary criteria terms."); } using (queryAdapter) { var qcResponseDTO = queryAdapter.Execute(request, viewSQL); qcResponseDTO.LowCellThrehold = _lowThresholdValue; _currentResponse = qcResponseDTO; return(qcResponseDTO); } }
public override DTO.QueryComposer.QueryComposerResponseDTO Execute(DTO.QueryComposer.QueryComposerRequestDTO request, bool viewSQL) { IQueryAdapter queryAdapter = null; if (request.Where.Criteria.First().Terms.Any(t => t.Type == Lpp.QueryComposer.ModelTermsFactory.SqlDistributionID)) { logger.Debug("Sql Distribution term found, creating SummarySqlQueryAdapter."); SummarySqlQueryAdapter sql = new SummarySqlQueryAdapter(); var result = sql.Execute(request, _settings, viewSQL); _currentResponse = result; return(result); } if (request.Select.Fields.Any(t => t.Type == ModelTermsFactory.DrugNameID) || request.Select.Fields.Any(t => t.Type == ModelTermsFactory.DrugClassID)) { if (request.Select.Fields.Any(t => t.Type == ModelTermsFactory.DrugNameID)) { logger.Debug("Pharmacy dispensing generic drug name term found, creating PrevalencePharmaDispensingQueryAdapter."); } else { logger.Debug("Pharmacy dispensing drug class term found, creating PrevalencePharmaDispensingQueryAdapter."); } queryAdapter = new PrevalencePharmaDispensingQueryAdapter(_settings); } else if (request.Select.Fields.Any(t => t.Type == ModelTermsFactory.CoverageID)) { logger.Debug("Coverage term found, creating PrevalenceEnrollmentQueryAdapter."); queryAdapter = new PrevalenceEnrollmentQueryAdapter(_settings); } else if (request.Select.Fields.Any(t => t.Type == ModelTermsFactory.HCPCSProcedureCodesID)) { logger.Debug("HCPCS procedure codes term found, creating PrevalenceHCPCSProceduresQueryAdapter."); queryAdapter = new PrevalenceHCPCSProceduresQueryAdapter(_settings); } else if (request.Select.Fields.Any(f => CodeQueryTermIDs.Contains(f.Type))) { Guid termID = Guid.Empty; if (request.Select.Fields.Any(t => t.Type == ModelTermsFactory.ICD9ProcedureCodes3digitID)) { termID = ModelTermsFactory.ICD9ProcedureCodes3digitID; logger.Debug("ICD9 Procedure Codes (3 digit) term found, creating PrevalenceICD9QueryAdapter."); } else if (request.Select.Fields.Any(t => t.Type == ModelTermsFactory.ICD9ProcedureCodes4digitID)) { termID = ModelTermsFactory.ICD9ProcedureCodes4digitID; logger.Debug("ICD9 Procedure Codes (4 digit) term found, creating PrevalenceICD9QueryAdapter."); } else if (request.Select.Fields.Any(t => t.Type == ModelTermsFactory.ICD9DiagnosisCodes3digitID)) { termID = ModelTermsFactory.ICD9DiagnosisCodes3digitID; logger.Debug("ICD9 Diagnosis Codes (3 digit) term found, creating PrevalenceICD9QueryAdapter."); } else if (request.Select.Fields.Any(t => t.Type == ModelTermsFactory.ICD9DiagnosisCodes4digitID)) { termID = ModelTermsFactory.ICD9DiagnosisCodes4digitID; logger.Debug("ICD9 Diagnosis Codes (4 digit) term found, creating PrevalenceICD9QueryAdapter."); } else if (request.Select.Fields.Any(t => t.Type == ModelTermsFactory.ICD9DiagnosisCodes5digitID)) { termID = ModelTermsFactory.ICD9DiagnosisCodes5digitID; logger.Debug("ICD9 Diagnosis Codes (5 digit) term found, creating PrevalenceICD9QueryAdapter."); } queryAdapter = new PrevalenceICD9QueryAdapter(_settings, termID); } if (queryAdapter == null) { throw new InvalidOperationException("Unable to determine the query adapter to use based on the primary criteria terms."); } using (queryAdapter) { var qcResponseDTO = queryAdapter.Execute(request, viewSQL); qcResponseDTO.LowCellThrehold = _lowThresholdValue; _currentResponse = qcResponseDTO; return(qcResponseDTO); } }
public override IEnumerable <DTO.QueryComposer.QueryComposerResponseQueryResultDTO> Execute(DTO.QueryComposer.QueryComposerQueryDTO query, bool viewSQL) { Guid termID = Guid.Empty; IQueryAdapter queryAdapter = null; if (query.Where.Criteria.First().Terms.Any(t => t.Type == Lpp.QueryComposer.ModelTermsFactory.SqlDistributionID)) { logger.Debug("Sql Distribution term found, creating SummarySqlQueryAdapter."); SummarySqlQueryAdapter sql = new SummarySqlQueryAdapter(); var result = sql.Execute(query, _settings, viewSQL); return(new[] { result }); } if (query.Select.Fields.Any(f => CodeQueryTermIDs.Contains(f.Type))) { if (query.Select.Fields.Any(f => f.Type == ModelTermsFactory.HCPCSProcedureCodesID)) { termID = ModelTermsFactory.HCPCSProcedureCodesID; logger.Debug("HCPCS Procedure Codes selector found, creating MFUCodesQueryAdapter."); } else if (query.Select.Fields.Any(f => f.Type == ModelTermsFactory.ICD9DiagnosisCodes3digitID)) { termID = ModelTermsFactory.ICD9DiagnosisCodes3digitID; logger.Debug("ICD9 Diagnosis Codes (3 digit) selector found, creating MFUCodesQueryAdapter."); } else if (query.Select.Fields.Any(f => f.Type == ModelTermsFactory.ICD9DiagnosisCodes4digitID)) { termID = ModelTermsFactory.ICD9DiagnosisCodes4digitID; logger.Debug("ICD9 Diagnosis Codes (4 digit) term found, creating MFUCodesQueryAdapter."); } else if (query.Select.Fields.Any(f => f.Type == ModelTermsFactory.ICD9DiagnosisCodes5digitID)) { termID = ModelTermsFactory.ICD9DiagnosisCodes5digitID; logger.Debug("ICD9 Diagnosis Codes (5 digit) selector found, creating MFUCodesQueryAdapter."); } else if (query.Select.Fields.Any(f => f.Type == ModelTermsFactory.ICD9ProcedureCodes3digitID)) { termID = ModelTermsFactory.ICD9ProcedureCodes3digitID; logger.Debug("ICD9 Procedure Codes (3 digit) selector found, creating MFUCodesQueryAdapter."); } else if (query.Select.Fields.Any(f => f.Type == ModelTermsFactory.ICD9ProcedureCodes4digitID)) { termID = ModelTermsFactory.ICD9ProcedureCodes4digitID; logger.Debug("ICD9 Procedure Codes (4 digit) selector found, creating MFUCodesQueryAdapter."); } queryAdapter = new MostFrequentlyUsedCodesQueryAdapter(_settings, termID); } else if (query.Select.Fields.Any(f => f.Type == ModelTermsFactory.DrugClassID || f.Type == ModelTermsFactory.DrugNameID)) { if (query.Select.Fields.Any(f => f.Type == ModelTermsFactory.DrugClassID)) { termID = ModelTermsFactory.DrugClassID; logger.Debug("Pharamcy dispensing drug class selector found, creating MFUPharmaQueryAdapter."); } else if (query.Select.Fields.Any(f => f.Type == ModelTermsFactory.DrugNameID)) { termID = ModelTermsFactory.DrugNameID; logger.Debug("Pharamcy dispensing generic drug selector found, creating MFUPharmaQueryAdapter."); } queryAdapter = new MostFrequentlyUsedPharmaDispensingQueryAdapter(_settings, termID); } if (queryAdapter == null) { throw new InvalidOperationException("Unable to determine the query adapter to use based on the primary criteria terms."); } using (queryAdapter) { var qcResponseDTO = queryAdapter.Execute(query, viewSQL); foreach (var r in qcResponseDTO) { r.LowCellThrehold = _lowThresholdValue; } return(qcResponseDTO); } }