public bool DoesInteractionResourceExistAndBelongToCustomer(Guid interactionId, Guid customerId) { var collectionUri = DocumentDBHelper.CreateInteractionDocumentCollectionUri(); var client = DocumentDBClient.CreateDocumentClient(); if (client == null) { return(false); } try { var query = client.CreateDocumentQuery <long>(collectionUri, new SqlQuerySpec() { QueryText = "SELECT VALUE COUNT(1) FROM interactions i " + "WHERE i.id = @interactionId " + "AND i.CustomerId = @customerId", Parameters = new SqlParameterCollection() { new SqlParameter("@interactionId", interactionId), new SqlParameter("@customerId", customerId) } }).AsEnumerable().FirstOrDefault(); return(Convert.ToBoolean(Convert.ToInt16(query))); } catch (DocumentQueryException) { return(false); } }
public bool DoesInteractionResourceExist(Guid interactionId) { var collectionUri = _documentDbHelper.CreateInteractionDocumentCollectionUri(); var client = _databaseClient.CreateDocumentClient(); if (client == null) { return(false); } var interactionQuery = client.CreateDocumentQuery <Document>(collectionUri, new FeedOptions() { MaxItemCount = 1 }); return(interactionQuery.Where(x => x.Id == interactionId.ToString()).Select(x => x.Id).AsEnumerable().Any()); }