} //----------------------
//this function will get searched employee student information
public DataTable GetSearchedEmployeeStudentInformation(CommonExchange.SysAccess userInfo, String queryString, Boolean isNewQuery)
{
if (isNewQuery)
{
using (RemoteClient.RemCntCampusAccessManager remClient = new RemoteClient.RemCntCampusAccessManager())
{
_studentEmployeeTable = remClient.SelectForCampusAccessStudentEmployeeInformation(userInfo, queryString);
}
}
DataTable newTable = new DataTable("EmployeeStudentSearchByNameID");
newTable.Columns.Add("student_employee_id", System.Type.GetType("System.String"));
newTable.Columns.Add("student_employee_name", System.Type.GetType("System.String"));
newTable.Columns.Add("card_number", System.Type.GetType("System.String"));
if (_studentEmployeeTable != null)
{
foreach (DataRow row in _studentEmployeeTable.Rows)
{
DataRow newRow = newTable.NewRow();
newRow["student_employee_id"] = RemoteServerLib.ProcStatic.DataRowConvert(row, "student_employee_id", "");
newRow["student_employee_name"] = RemoteClient.ProcStatic.GetCompleteNameMiddleInitial(row, "last_name", "first_name", "middle_name");
newRow["card_number"] = RemoteServerLib.ProcStatic.DataRowConvert(row, "card_number", "");
newTable.Rows.Add(newRow);
}
}
newTable.AcceptChanges();
return(newTable);
}//-------------------------
}//-----------------------------
//this procedure will select student employee information
public void SelectForCampusAccessStudentEmployeeInformation(CommonExchange.SysAccess userInfo)
{
using (RemoteClient.RemCntCampusAccessManager remClient = new RemoteClient.RemCntCampusAccessManager())
{
_studentEmployeeTable = remClient.SelectForCampusAccessStudentEmployeeInformation(userInfo, "*");
}
}//--------------------------
