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());
}