Retrieves a collection of Contacts from the database using the supplied SQL FROM and WHERE criteria and parameters. The starting SQL is: SELECT Name.* FROM Name {0} WHERE 1 = 1 {1}. 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.

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,
	SqlParameter[] parameters
)
Visual Basic (Declaration)
Public Shared Function GetContacts ( _
	user As IiMISUser, _
	additionalFrom As String, _
	where As String, _
	parameters As SqlParameter() _
) As CContact()
Visual C++
public:
static array<CContact^>^ GetContacts(
	IiMISUser^ user, 
	String^ additionalFrom, 
	String^ where, 
	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.
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