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