public string countCustomers(string serverName, string databaseName)
{
CompanyIdentifier companyIdentifier = session.LookupCompanyIdentifier(serverName, databaseName);
connectionStatus = session.RequestAccess(companyIdentifier);
Console.WriteLine("Result {0}", connectionStatus.ToString());
if (connectionStatus == AuthorizationResult.Granted)
{
Company company = session.Open(companyIdentifier);
Console.WriteLine("Company {0}", company.CompanyIdentifier.CompanyName);
var customers = company.Factories.CustomerFactory.List();
FilterExpression filter = FilterExpression.Equal(
FilterExpression.Property("Customer.IsInactive"),
FilterExpression.Constant(false));
LoadModifiers modifiers = LoadModifiers.Create();
modifiers.Filters = filter;
customers.Load(modifiers);
int count = customers.Count;
session.Close(company);
return("{\"count\":\"" + count + "\"}");
}
return("{\"error\":\"Access: " + connectionStatus.ToString() + "\"}");
}
