public static ParaEntityList<Customer> getCustomersByStatus(long statusID)
{
var customerQuery = new CustomerQuery();
customerQuery.RetrieveAllRecords = true;
customerQuery.AddStaticFieldFilter(CustomerQuery.CustomerStaticFields.Status, ParaEnums.QueryCriteria.Equal, statusID.ToString());
var customers = Service.GetList<Customer>(customerQuery);
return customers;
}
public static ParaEntityList<Customer> getCustomersByEmail(string email)
{
var customerQuery = new CustomerQuery();
customerQuery.RetrieveAllRecords = true;
customerQuery.AddStaticFieldFilter(CustomerQuery.CustomerStaticFields.CustomerEmail, ParaEnums.QueryCriteria.Equal, email);
var customers = Service.GetList<Customer>(customerQuery);
return customers;
}
public static ParaEntityList<Customer> getCustomersAndOrderByLastName()
{
var customerQuery = new CustomerQuery();
customerQuery.RetrieveAllRecords = true;
customerQuery.AddSortOrder(CustomerQuery.CustomerStaticFields.LastName, ParaEnums.QuerySortBy.Asc);
var customers = Service.GetList<Customer>(customerQuery);
return customers;
}
//Customers by account and date
public static ParaEntityList<Customer> getCustomersByAccountAndDate(long acccountID, DateTime date)
{
var customerQuery = new CustomerQuery();
customerQuery.RetrieveAllRecords = true;
customerQuery.AddStaticFieldFilter(CustomerQuery.CustomerStaticFields.AccountID, ParaEnums.QueryCriteria.Equal, acccountID.ToString());
//Use a custom filter if correct enums aren't available
customerQuery.AddCustomFilter(String.Format("Date_Created_max_={0}/{1}/{2}", date.Month, date.Day, date.Year));
var customers = Service.GetList<Customer>(customerQuery);
return customers;
}