private DataTable GetResultsData()
{
USTTISessionCollection SessionList = SessionManager.getSessionList();
String sql = "select * from ad_hoc_status ";
sql = sql + " where 1 = 1 ";
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Last"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("First"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Applicant ID"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Country"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Course Num"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Title"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Year"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Gender"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Participat"));
sql = sql + UtilManager.addMultipleStmtToWhereClause(SessionList.Get("Years"));
sql = sql + GetSortExpression();
USTTIDataAccess data = new USTTIDataAccess();
DataTable dt = data.Fill(sql);
return(dt);
}
private DataTable GetResultsData()
{
USTTISessionCollection SessionList = SessionManager.getSessionList();
String sql = "select * from ad_hoc_sponsors ";
sql = sql + " where 1 = 1 ";
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Course"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Course Num"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Sponsor"));
sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Year"));
sql = sql + UtilManager.addMultipleStmtToWhereClause(SessionList.Get("Years"));
sql = sql + GetSortExpression();
USTTIDataAccess data = new USTTIDataAccess();
DataTable dt = data.Fill(sql);
return(dt);
}