public async Task <IActionResult> GetMany([FromQuery(Name = "name")] string name = null) { var query = "SELECT VALUE c FROM c WHERE c['@type'] = @Type and (NOT IS_DEFINED(c.deleted) or c.deleted = false)"; var parameters = new CosmosDb.SqlParameterCollection() { new CosmosDb.SqlParameter("@Type", typeof(Customer).Name), }; if (name != null) { name = name.Trim(); } if (!string.IsNullOrEmpty(name)) { query = $"{query} and CONTAINS(LOWER(c.name), @Name)"; parameters.Add(new CosmosDb.SqlParameter("@Name", name.ToLower())); } var response = await _customerDbAccess.SearchQueryAsync(query, parameters); if (response == null) { return(BadRequest(new Error("The customers do not exist or you don't have permission to view them"))); } return(Ok(response)); }
public async Task <IActionResult> GetMany([FromQuery(Name = "customer_id")] string customerId = null) { var query = "SELECT VALUE c FROM c WHERE c['@type'] = @Type and (NOT IS_DEFINED(c.deleted) or c.deleted = false)"; var parameters = new CosmosDb.SqlParameterCollection() { new CosmosDb.SqlParameter("@Type", typeof(Order).Name), }; if (customerId != null) { customerId = customerId.Trim(); } if (!string.IsNullOrEmpty(customerId)) { query = $"{query} and c.customer.id = @CustomerId"; parameters.Add(new CosmosDb.SqlParameter("@CustomerId", customerId)); } var response = await _orderDbAccess.SearchQueryAsync(query, parameters); if (response == null) { return(BadRequest(new Error("The orders do not exist or you don't have permission to view them"))); } return(Ok(response)); }