}//------------------------- //this function will get searched campus access details information public DataTable GetSearchedCampusAccessDetails(CommonExchange.SysAccess userInfo, String personSysIdList, String dateStart, String dateEnd) { DataTable newTable = new DataTable("TemporaryTable"); newTable.Columns.Add("access_date_time", System.Type.GetType("System.String")); newTable.Columns.Add("access_description", System.Type.GetType("System.String")); DataTable tempTable; using (RemoteClient.RemCntCampusAccessManager remClient = new RemoteClient.RemCntCampusAccessManager()) { tempTable = remClient.SelectByPersonSysIDListDateStartEndCampusAccessDetails(userInfo, personSysIdList, dateStart, dateEnd); } if (tempTable != null) { foreach (DataRow accessRow in tempTable.Rows) { DataRow newRow = newTable.NewRow(); DateTime accessDate = DateTime.MinValue; newRow["access_date_time"] = DateTime.TryParse(RemoteServerLib.ProcStatic.DataRowConvert(accessRow, "access_date_time", String.Empty), out accessDate) ? accessDate.ToLongDateString() + " - " + accessDate.ToLongTimeString() : String.Empty; newRow["access_description"] = RemoteServerLib.ProcStatic.DataRowConvert(accessRow, "access_description", String.Empty); newTable.Rows.Add(newRow); } } return(newTable); }//-------------------------
} //---------------------- //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 insert campuss access details update to database public void InsertCampusAccessDetails(CommonExchange.SysAccess userInfo) { try { if (File.Exists(Application.StartupPath + @"\campusaccessdetails.xml")) { DataSet xmlDataSet = new DataSet(); xmlDataSet.ReadXml(Application.StartupPath + @"\campusaccessdetails.xml"); DataTable campusAccessDetailsTable = new DataTable("CampusAccessTable"); campusAccessDetailsTable = xmlDataSet.Tables["CampusAccessTable"]; xmlDataSet.Dispose(); if (campusAccessDetailsTable != null) { using (RemoteClient.RemCntCampusAccessManager remClient = new RemoteClient.RemCntCampusAccessManager()) { remClient.InsertCampusAccessDetails(userInfo, campusAccessDetailsTable); campusAccessDetailsTable = new DataTable("CampusAccessTable"); campusAccessDetailsTable.WriteXml(Application.StartupPath + @"\campusaccessdetails.xml"); } } } } catch { } }//--------------------------
}//----------------------------- //this procedure will select student employee information public void SelectForCampusAccessStudentEmployeeInformation(CommonExchange.SysAccess userInfo) { using (RemoteClient.RemCntCampusAccessManager remClient = new RemoteClient.RemCntCampusAccessManager()) { _studentEmployeeTable = remClient.SelectForCampusAccessStudentEmployeeInformation(userInfo, "*"); } }//--------------------------
//this procedure will initialize the class private void InitializeClass(CommonExchange.SysAccess userInfo) { //set data set using (RemoteClient.RemCntCampusAccessManager remClient = new RemoteClient.RemCntCampusAccessManager()) { _classDataSet = remClient.GetDataSetForCampusAccess(userInfo); } //set serverdate and time using (RemoteClient.RemCntBaseManager remClient = new RemoteClient.RemCntBaseManager()) { _serverDateTime = remClient.GetServerDateTime(userInfo); } //initialize tables _campusAccessDetailsTable = new DataTable("CampusAccessTable"); _campusAccessDetailsTable.Columns.Add("sysid_person", System.Type.GetType("System.String")); _campusAccessDetailsTable.Columns.Add("access_date_time", System.Type.GetType("System.DateTime")); _campusAccessDetailsTable.Columns.Add("access_point_id", System.Type.GetType("System.String")); //------------------------------ }//-------------------------