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