internal async Task <IEnumerable <dynamic> > GetDocuments(CosmosDbQuery cosmosDbQuery, string containerName) { _cosmosDbSettings.ContainerName = containerName; ICosmosRepository cosmosRepository = new CosmosRepository(_cosmosDbSettings); IEnumerable <dynamic> queryResults = await cosmosRepository .DynamicQuery(cosmosDbQuery); return(queryResults); }
public async Task <IEnumerable <DatasetDefinationByFundingStream> > GetDatasetDefinitionsByFundingStreamId(string fundingStreamId) { CosmosDbQuery cosmosDbQuery = new CosmosDbQuery { QueryText = @"SELECT d.id AS id, d.content.name AS name, d.content.description as description, d.content.fundingStreamId as fundingStreamId FROM datasets d WHERE d.deleted = false AND d.documentType = ""DatasetDefinition"" AND d.content.fundingStreamId = @FundingStreamId", Parameters = new[] { new CosmosDbQueryParameter("@FundingStreamId", fundingStreamId) } }; IEnumerable <dynamic> results = await _cosmosRepository.DynamicQuery(cosmosDbQuery, 1000); IList <DatasetDefinationByFundingStream> datasetDefinitions = new List <DatasetDefinationByFundingStream>(); if (results.IsNullOrEmpty()) { return(datasetDefinitions); } foreach (dynamic result in results) { datasetDefinitions.Add(new DatasetDefinationByFundingStream { Id = result.id, Name = result.name, Description = result.description }); } return(datasetDefinitions); }