} //-------------------------- #endregion #region Programmer-Defined Function Procedures //this function gets the selected employee public DataTable GetSelectedEmployeeInformation(ClientExchange.EmployeeSearchFilter searchFilter) { DataTable employeeTable = RemoteClient.ProcStatic.GetEmployeeInformationFilterStatusAndType(searchFilter, _classDataSet.Tables["EmployeeInformationTable"]); DataTable newTable = new DataTable("EmployeeSearchByEmployeeNameIdCardNumberTable"); newTable.Columns.Add("employee_id", System.Type.GetType("System.String")); newTable.Columns.Add("card_number", System.Type.GetType("System.String")); newTable.Columns.Add("employee_name", System.Type.GetType("System.String")); searchFilter.StringSearch = searchFilter.StringSearch.Replace("*", "").Replace("%", "").Replace("'", "''"); String strFilter = "(employee_id LIKE '%" + searchFilter.StringSearch + "%' OR " + "employee_name LIKE '%" + searchFilter.StringSearch + "%' OR " + "card_number LIKE '%" + searchFilter.StringSearch + "%')"; DataRow[] selectRow = employeeTable.Select(strFilter.Trim("*".ToCharArray()), "employee_name ASC"); foreach (DataRow empRow in selectRow) { DataRow newRow = newTable.NewRow(); newRow["employee_id"] = empRow["employee_id"].ToString(); newRow["card_number"] = empRow["card_number"].ToString(); newRow["employee_name"] = empRow["employee_name"].ToString(); newTable.Rows.Add(newRow); } newTable.AcceptChanges(); return(newTable); } //-------------------------------
} //------------------------------------- //#########################################END CLASS LoanRemittanceEmployeeSearchList EVENTS########################################## #endregion #region Programmer-Defined Void Procedures //this procedure shows the search result private void ShowSearchResultDialog() { try { this.Cursor = Cursors.WaitCursor; String queryString = RemoteClient.ProcStatic.TrimStartEndString(ctlManager.GetSearchString); if (!String.IsNullOrEmpty(queryString)) { if (_forLoanType) { _frmLoanTypeSearch.DataSource = _loanManager.GetSearchedLoanTypeInformation(queryString); } else { ClientExchange.EmployeeSearchFilter searchFilter = new ClientExchange.EmployeeSearchFilter(); searchFilter.StringSearch = queryString; _frmEmpSearch.DataSource = _loanManager.GetSelectedEmployeeInformation(searchFilter); } } } catch (Exception ex) { RemoteClient.ProcStatic.ShowErrorDialog(ex.Message, "Error Retrieving Data"); } finally { this.ctlManager.SetFocusOnSearchTextBox(); this.Cursor = Cursors.Arrow; } } //--------------------------
//###########################################CLASS EmployeeManager EVENTS############################################# //event is raised when the class is loaded private void ClassLoad(object sender, EventArgs e) { try { _empManager = new EmployeeLogic(_userInfo); _searchFilter = new ClientExchange.EmployeeSearchFilter(); _frmSearch = new EmployeeSearchList(); _frmSearch.OnDoubleClickEnter += new SearchListDataGridDoubleClickEnter(_frmSearchOnDoubleClickEnter); _frmSearch.LocationPoint = new Point(50, 300); _frmSearch.AdoptGridSize = true; _frmSearch.MdiParent = this; lblRecordDate.Text = "Record Date: " + DateTime.Parse(_empManager.ServerDateTime).ToString(); if (!(RemoteServerLib.ProcStatic.IsSystemAccessAdmin(_userInfo) || RemoteServerLib.ProcStatic.IsSystemAccessVpOfFinance(_userInfo) || RemoteServerLib.ProcStatic.IsSystemAccessPayrollMaster(_userInfo))) { throw new Exception("You are not authorized to access this module."); } } catch (Exception ex) { RemoteClient.ProcStatic.ShowErrorDialog("\n" + ex.Message, "Error Authenticating"); this.Close(); } }//------------------------------
} //----------------------------- //this procedure gets the selected employee information for deduction public DataTable GetSelectedEmployeeForDeduction(ClientExchange.EmployeeSearchFilter searchFilter) { if (!searchFilter.IncludePartTime && !searchFilter.IncludeProbationary && !searchFilter.IncludeRegular) { searchFilter.IncludePartTime = true; searchFilter.IncludeProbationary = true; searchFilter.IncludeRegular = true; } DataTable employeeTable = RemoteClient.ProcStatic.GetEmployeeInformationFilterStatusAndType(searchFilter, _classDataSet.Tables["EmployeeInformationTable"]); using (DataTable newTable = new DataTable("EmployeeSearchByEmployeeNameIdCardNumberTable")) { newTable.Columns.Add("sysid_employee", System.Type.GetType("System.String")); newTable.Columns.Add("employee_id", System.Type.GetType("System.String")); newTable.Columns.Add("employee_name", System.Type.GetType("System.String")); searchFilter.StringSearch = searchFilter.StringSearch.Replace("*", "").Replace("%", "").Replace("'", "''"); String strFilter = "(employee_id LIKE '%" + searchFilter.StringSearch + "%' OR " + "employee_name LIKE '%" + searchFilter.StringSearch + "%')"; DataRow[] selectRow = employeeTable.Select(strFilter.Trim("*".ToCharArray()), "employee_name ASC"); foreach (DataRow empRow in selectRow) { DataRow newRow = newTable.NewRow(); newRow["sysid_employee"] = empRow["sysid_employee"].ToString(); newRow["employee_id"] = empRow["employee_id"].ToString(); newRow["employee_name"] = empRow["employee_name"].ToString(); newTable.Rows.Add(newRow); } newTable.AcceptChanges(); _empTableBySearch = newTable; } return(_empTableBySearch); } //---------------------------
} //-------------------------------------------- //###############################################END BUTTON btnApply EVENTS####################################################### #endregion #region Programmer-Defined Void Procedures //this procedure shows the search result private void ShowSearchResultDialog() { ClientExchange.EmployeeSearchFilter searchFilter = new ClientExchange.EmployeeSearchFilter(); searchFilter.StringSearch = String.IsNullOrEmpty(ctlManager.GetSearchString) ? "" : ctlManager.GetSearchString; searchFilter.IncludePartTime = ctlManager.IncludePartTime; searchFilter.IncludeProbationary = ctlManager.IncludeProbationary; searchFilter.IncludeRegular = ctlManager.IncludeRegular; searchFilter.IncludeLayOff = false; searchFilter.IncludeGraduateSchoolFaculty = ctlManager.IncludeGraduateSchoolFaculty; searchFilter.IncludeGraduateSchoolCollegeFaculty = ctlManager.IncludeGraduateSchoolCollegeFaculty; searchFilter.IncludeGraduateSchoolHighSchoolFaculty = ctlManager.IncludeGraduateSchoolHighSchoolFaculty; searchFilter.IncludeGraduateSchoolGradeKinderFaculty = ctlManager.IncludeGraduateSchoolGradeSchoolKinderFaculty; searchFilter.IncludeCollegeFaculty = ctlManager.IncludeCollegeFaculty; searchFilter.IncludeHighSchoolFaculty = ctlManager.IncludeHighSchoolFaculty; searchFilter.IncludeGradeKinderFaculty = ctlManager.IncludeGradeKinderFaculty; searchFilter.IncludeStaff = ctlManager.IncludeStaff; searchFilter.IncludeAcademic = ctlManager.IncludeAcademic; searchFilter.IncludeMaintenance = ctlManager.IncludeMaintenance; this.SetEmployeeCheckedListBox(_decManager.GetSelectedEmployeeForDeduction(searchFilter), "employee_name"); this.ctlManager.SetFocusOnSearchTextBox(); } //--------------------------