} //---------------------- //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, "*"); } }//--------------------------