Retrieves a collection of Events from the database using the supplied SQL FROM and WHERE criteria and parameters. The starting SQL is: SELECT Meet_Master.* FROM Meet_Master {0} WHERE 1 = 1 {1}. So any additional FROM criteria should look something like: ", Product" or "INNER JOIN Product ON Meet_Master.MEETING = Product.PRODUCT_CODE" etc. Any additional WHERE criteria should start with AND, like: "AND Meet_Master.MEETING = Product.PRODUCT_CODE" etc.

Namespace: Asi.iBO.Events
Assembly: Asi.iBO (in Asi.iBO.dll) Version: 15.1.3.0

Syntax

C#
public static CEvent[] GetEvents(
	IiMISUser user,
	string additionalFrom,
	string where,
	SqlParameter[] parameters
)
Visual Basic
Public Shared Function GetEvents ( _
	user As IiMISUser, _
	additionalFrom As String, _
	where As String, _
	parameters As SqlParameter() _
) As CEvent()
Visual C++
public:
static array<CEvent^>^ GetEvents(
	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 Meet_Master ", 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

An array of CEvent objects that match the supplied criteria, sorted by start date.

See Also