public async Task <List <QcResult> > GetQCRules(DataQCParameters qcParms) { List <QcResult> qcResult = new List <QcResult>(); ConnectParameters connector = await GetConnector(qcParms.DataConnector); RuleManagement rules = new RuleManagement(_azureConnectionString); IndexAccess idxAccess = new IndexAccess(); string jsonString = await rules.GetActiveQCRules(connector.SourceName); qcResult = JsonConvert.DeserializeObject <List <QcResult> >(jsonString); foreach (QcResult qcItem in qcResult) { string query = $" where QC_STRING like '%{qcItem.RuleKey};%'"; qcItem.Failures = idxAccess.IndexCountByQuery(query, connector.ConnectionString); } return(qcResult); }
public async Task <List <PredictionCorrection> > GetPredictions(string source) { List <PredictionCorrection> predictionResults = new List <PredictionCorrection>(); ConnectParameters connector = await GetConnector(source); RuleManagement rules = new RuleManagement(_azureConnectionString); string jsonString = await rules.GetActivePredictionRules(source); predictionResults = JsonConvert.DeserializeObject <List <PredictionCorrection> >(jsonString); IndexAccess idxAccess = new IndexAccess(); foreach (PredictionCorrection predItem in predictionResults) { string query = $" where QC_STRING like '%{predItem.RuleKey};%'"; predItem.NumberOfCorrections = idxAccess.IndexCountByQuery(query, connector.ConnectionString); } return(predictionResults); }