Retrieves a collection of Contacts from the database using the supplied SQL FROM and WHERE criteria, ORDER BY clause and parameters. The starting SQL is: SELECT Name.* FROM Name {0} WHERE 1 = 1 {1} ORDER BY {2}. So any additional FROM criteria should look something like: ", Name_Note" or "INNER JOIN Name_Note ON Name.ID = Name_Note.ID" etc. Any additional WHERE criteria should start with AND, like: "AND Name.ID = Name_Note.ID" etc. The ORDER BY should look like: "Name.LAST_NAME" or "Name.LAST_NAME DESC" etc.

Namespace:  Asi.iBO.ContactManagement
Assembly:  Asi.iBO (in Asi.iBO.dll) Version: 15.1.2.0

Syntax

C#
public static CContact[] GetContacts(
	IiMISUser user,
	string additionalFrom,
	string where,
	string orderBy,
	SqlParameter[] parameters
)
Visual Basic (Declaration)
Public Shared Function GetContacts ( _
	user As IiMISUser, _
	additionalFrom As String, _
	where As String, _
	orderBy As String, _
	parameters As SqlParameter() _
) As CContact()
Visual C++
public:
static array<CContact^>^ GetContacts(
	IiMISUser^ user, 
	String^ additionalFrom, 
	String^ where, 
	String^ orderBy, 
	array<SqlParameter^>^ parameters
)

Parameters

user
Type: Asi.iBO..::.IiMISUser
The IiMISUser object providing the security credentials of the logged in user.
additionalFrom
Type: System..::.String
Any additional FROM criteria tacked onto "FROM Name ", or string.Empty if no additional tables are required.
where
Type: System..::.String
Any additional WHERE criteria tacked onto "WHERE 1 = 1 ", or string.Empty if no additional WHERE criteria is required.
orderBy
Type: System..::.String
A ORDER BY clause will be tacked onto "ORDER BY"
parameters
Type: array< System.Data.SqlClient..::.SqlParameter >[]()[]
Bind variables for the WHERE criteria. Using bind variables is preferred over strings imbedded in the where criteria. Send NULL if no bind variables are needed.

Return Value

A Hahtable of contacts that match the supplied criteria.

See Also