private ATTEmployeeSearch GetFilter() { ATTEmployeeSearch EmployeeSearch = new ATTEmployeeSearch(); if (this.txtFirstName.Text.Trim() != "") { EmployeeSearch.FirstName = this.txtFirstName.Text.Trim(); } if (this.txtMiddleName.Text.Trim() != "") { EmployeeSearch.MiddleName = this.txtMiddleName.Text.Trim(); } if (this.txtSurname.Text.Trim() != "") { EmployeeSearch.SurName = this.txtSurname.Text.Trim(); } if (this.DDLGender.SelectedIndex > 0) { EmployeeSearch.Gender = this.DDLGender.SelectedValue; } if (this.txtDOB.Text.Trim() != "") { EmployeeSearch.DOB = this.txtDOB.Text.Trim(); } EmployeeSearch.OrgID = 9; EmployeeSearch.DesType = "O"; return(EmployeeSearch); }
private ATTEmployeeSearch GetFilter() { ATTEmployeeSearch EmployeeSearch = new ATTEmployeeSearch(); if (this.txtSymbolNo.Text.Trim() != "") { EmployeeSearch.SymbolNo = this.txtSymbolNo.Text.Trim(); } if (this.txtFName.Text.Trim() != "") { EmployeeSearch.FirstName = this.txtFName.Text.Trim(); } if (this.txtMName.Text.Trim() != "") { EmployeeSearch.MiddleName = this.txtMName.Text.Trim(); } if (this.txtSurName.Text.Trim() != "") { EmployeeSearch.SurName = this.txtSurName.Text.Trim(); } if (this.ddlGender.SelectedIndex > 0) { EmployeeSearch.Gender = this.ddlGender.SelectedValue; } if (this.txtDOB.Text.Trim() != "") { EmployeeSearch.DOB = this.txtDOB.Text.Trim(); } if (this.ddlOrganization.SelectedIndex > 0) { EmployeeSearch.OrgID = int.Parse(this.ddlOrganization.SelectedValue); } return(EmployeeSearch); }
public static List <ATTEmployeeSearch> SearchEmployee(ATTEmployeeSearch objEmployee) //flag defines whether or not to load employee other attributes.0-no,1-yes { List <ATTEmployeeSearch> lstEmployee = new List <ATTEmployeeSearch>(); foreach (DataRow row in DLLEmployeeSearch.SearchEmployee(objEmployee).Rows) { ATTEmployeeSearch obj = new ATTEmployeeSearch(double.Parse(row["EMP_ID"].ToString()), ((row["SYMBOL_NO"] == System.DBNull.Value) ? "" : (string)row["SYMBOL_NO"]), ((row["FIRST_NAME"] == System.DBNull.Value) ? "" : (string)row["FIRST_NAME"]), ((row["MID_NAME"] == System.DBNull.Value) ? "" : (string)row["MID_NAME"]), ((row["SUR_NAME"] == System.DBNull.Value) ? "" : (string)row["SUR_NAME"]), ((row["GENDER"] == System.DBNull.Value) ? "" : (string)row["GENDER"]), ((row["DOB"] == System.DBNull.Value) ? "" : (string)row["DOB"]), ((row["MARTIAL_STATUS"] == System.DBNull.Value) ? "" : (string)row["MARTIAL_STATUS"])); if (row["COUNTRY_ID"] == System.DBNull.Value) { obj.CountryID = null; } else { obj.CountryID = int.Parse(row["COUNTRY_ID"].ToString()); } if (row["BIRTH_DISTRICT"] == System.DBNull.Value) { obj.BirthDistrict = null; } else { obj.BirthDistrict = int.Parse(row["BIRTH_DISTRICT"].ToString()); } if (row["RELIGION_ID"] == System.DBNull.Value) { obj.ReligionID = null; } else { obj.ReligionID = int.Parse(row["RELIGION_ID"].ToString()); } obj.IdentityMark = ((row["IDENTITY_MARK"] == System.DBNull.Value) ? "" : (string)row["IDENTITY_MARK"]); obj.DesName = ((row["DES_NAME"] == System.DBNull.Value) ? "" : (string)row["DES_NAME"]); obj.OrgName = ((row["ORG_NAME"] == System.DBNull.Value) ? "" : (string)row["ORG_NAME"]); obj.LevelName = ((row["LEVEL_NAME"] == System.DBNull.Value) ? "" : (string)row["LEVEL_NAME"]); obj.CitznNo = ((row["CIT_NO"] == System.DBNull.Value) ? "" : (string)row["CIT_NO"]); obj.PFNo = ((row["PROVIDENT_FUND_NO"] == System.DBNull.Value) ? "" : (string)row["PROVIDENT_FUND_NO"]); if (row["ORG_EMP_NO"] != System.DBNull.Value) { obj.OfficeNo = int.Parse(row["ORG_EMP_NO"].ToString()); } lstEmployee.Add(obj); } return(lstEmployee); }
private ATTEmployeeSearch GetFilter() { ATTEmployeeSearch EmployeeSearch = new ATTEmployeeSearch(); if (this.txtSymbolNo.Text.Trim() != "") { EmployeeSearch.SymbolNo = this.txtSymbolNo.Text.Trim(); } if (this.txtFName.Text.Trim() != "") { EmployeeSearch.FirstName = this.txtFName.Text.Trim(); } if (this.txtMName.Text.Trim() != "") { EmployeeSearch.MiddleName = this.txtMName.Text.Trim(); } if (this.txtSurName.Text.Trim() != "") { EmployeeSearch.SurName = this.txtSurName.Text.Trim(); } if (this.ddlGender.SelectedIndex > 0) { EmployeeSearch.Gender = this.ddlGender.SelectedValue; } if (this.txtDOB.Text.Trim() != "") { EmployeeSearch.DOB = this.txtDOB.Text.Trim(); } if (this.ddlMarStatus.SelectedIndex > 0) { EmployeeSearch.MaritalStatus = this.ddlMarStatus.SelectedValue; } if (this.ddlOrganization.SelectedIndex > 0) { EmployeeSearch.OrgID = int.Parse(this.ddlOrganization.SelectedValue); } if (this.ddlDesignation.SelectedIndex > 0) { EmployeeSearch.DesID = int.Parse(this.ddlDesignation.SelectedValue); } if (this.JudgeOrEmployeeProp == JudgeOrEmployee.Judge) { EmployeeSearch.DesType = "J"; } if (this.JudgeOrEmployeeProp == JudgeOrEmployee.OtherEmployee) { EmployeeSearch.DesType = "O"; } return(EmployeeSearch); }
private ATTEmployeeSearch GetFilter() { ATTEmployeeSearch EmployeeSearch = new ATTEmployeeSearch(); if (this.txtSymbolNo.Text.Trim() != "") { EmployeeSearch.SymbolNo = this.txtSymbolNo.Text.Trim(); } if (this.txtFName.Text.Trim() != "") { EmployeeSearch.FirstName = this.txtFName.Text.Trim(); } if (this.txtMName.Text.Trim() != "") { EmployeeSearch.MiddleName = this.txtMName.Text.Trim(); } if (this.txtSurName.Text.Trim() != "") { EmployeeSearch.SurName = this.txtSurName.Text.Trim(); } if (this.ddlGender.SelectedIndex > 0) { EmployeeSearch.Gender = this.ddlGender.SelectedValue; } if (this.txtDOB.Text.Trim() != "") { EmployeeSearch.DOB = this.txtDOB.Text.Trim(); } if (this.ddlMarStatus.SelectedIndex > 0) { EmployeeSearch.MaritalStatus = this.ddlMarStatus.SelectedValue; } if (this.ddlOrganization.SelectedIndex > 0) { EmployeeSearch.OrgID = int.Parse(this.ddlOrganization.SelectedValue); } if (this.ddlDesignation.SelectedIndex > 0) { EmployeeSearch.DesID = int.Parse(this.ddlDesignation.SelectedValue); } EmployeeSearch.IsPosting = this.rdblstPosting.SelectedValue.Trim() == "Y" ? true : false; EmployeeSearch.IniUnit = ((ATTUserLogin)Session["Login_User_Detail"]).OrgID; //EmployeeSearch.DesType = "O"; //EmployeeSearch.IniType = 3; return(EmployeeSearch); }
void LoadJudges() { ATTEmployeeSearch attEmp = new ATTEmployeeSearch(); attEmp.OrgID = orgID; attEmp.DesType = "J"; try { List <ATTEmployeeSearch> lstjudge = BLLEmployeeSearch.SearchEmployee(attEmp); grdJudge.DataSource = lstjudge; grdJudge.DataBind(); } catch (Exception ex) { lblStatusMessage.Text = ex.Message; programmaticModalPopup.Show(); } }
private ATTEmployeeSearch GetFilter() { ATTEmployeeSearch EmployeeSearch = new ATTEmployeeSearch(); if (this.txtSearchSymbolNo.Text.Trim() != "") { EmployeeSearch.SymbolNo = this.txtSearchSymbolNo.Text.Trim(); } if (this.txtFirstName.Text.Trim() != "") { EmployeeSearch.FirstName = this.txtFirstName.Text.Trim(); } if (this.txtMidName.Text.Trim() != "") { EmployeeSearch.MiddleName = this.txtMidName.Text.Trim(); } if (this.txtLastName.Text.Trim() != "") { EmployeeSearch.SurName = this.txtLastName.Text.Trim(); } if (this.ddlSex.SelectedIndex > 0) { EmployeeSearch.Gender = this.ddlSex.SelectedValue; } if (this.txtBirthDate.Text.Trim() != "") { EmployeeSearch.DOB = this.txtBirthDate.Text.Trim(); } if (this.ddlMarried.SelectedIndex > 0) { EmployeeSearch.MaritalStatus = this.ddlMarried.SelectedValue; } if (this.ddlOrganization.SelectedIndex > 0) { EmployeeSearch.OrgID = int.Parse(this.ddlOrganization.SelectedValue); } if (this.ddlDesignation.SelectedIndex > 0) { EmployeeSearch.DesID = int.Parse(this.ddlDesignation.SelectedValue); } EmployeeSearch.DesType = "O"; EmployeeSearch.IniType = 3; return(EmployeeSearch); }
public static List <ATTEmployeeSearch> SearchEmployeeForOrgUnitHead(ATTEmployeeSearch objEmployee) //flag defines whether or not to load employee other attributes.0-no,1-yes { List <ATTEmployeeSearch> lstEmployee = new List <ATTEmployeeSearch>(); foreach (DataRow row in DLLEmployeeSearch.SearchEmployeeForOrgUnitHead(objEmployee).Rows) { ATTEmployeeSearch obj = new ATTEmployeeSearch(double.Parse(row["EMP_ID"].ToString()), ((row["SYMBOL_NO"] == System.DBNull.Value) ? "" : (string)row["SYMBOL_NO"]), ((row["FIRST_NAME"] == System.DBNull.Value) ? "" : (string)row["FIRST_NAME"]), ((row["MID_NAME"] == System.DBNull.Value) ? "" : (string)row["MID_NAME"]), ((row["SUR_NAME"] == System.DBNull.Value) ? "" : (string)row["SUR_NAME"]), ((row["GENDER"] == System.DBNull.Value) ? "" : (string)row["GENDER"]), ((row["DOB"] == System.DBNull.Value) ? "" : (string)row["DOB"]), ""); obj.OrgName = ((row["ORG_NAME"] == System.DBNull.Value) ? "" : (string)row["ORG_NAME"]); obj.UnitName = ((row["UNIT_NAME"] == System.DBNull.Value) ? "" : (string)row["UNIT_NAME"]); obj.FromDate = ((row["FROM_DATE"] == System.DBNull.Value) ? "" : (string)row["FROM_DATE"]); obj.ToDate = ((row["TO_DATE"] == System.DBNull.Value) ? "" : (string)row["TO_DATE"]); obj.UnitHead = ((row["UNIT_HEAD"] == System.DBNull.Value) ? "" : (string)row["UNIT_HEAD"]); obj.OfficeHead = ((row["OFFICE_HEAD"] == System.DBNull.Value) ? "" : (string)row["OFFICE_HEAD"]); if (row["ORG_EMP_NO"] != System.DBNull.Value) { obj.OfficeNo = int.Parse(row["ORG_EMP_NO"].ToString()); } if (row["ORG_ID"] != System.DBNull.Value) { obj.OrgID = int.Parse(row["ORG_ID"].ToString()); } if (row["UNIT_ID"] != System.DBNull.Value) { obj.UnitID = int.Parse(row["UNIT_ID"].ToString()); } lstEmployee.Add(obj); } return(lstEmployee); }
private ATTEmployeeSearch GetFilter() { try { ATTEmployeeSearch EmployeeSearch = new ATTEmployeeSearch(); if (this.txtSymbolNo.Text.Trim() != "") { EmployeeSearch.SymbolNo = this.txtSymbolNo.Text.Trim(); } if (this.txtFName.Text.Trim() != "") { EmployeeSearch.FirstName = this.txtFName.Text.Trim(); } if (this.txtMName.Text.Trim() != "") { EmployeeSearch.MiddleName = this.txtMName.Text.Trim(); } if (this.txtSurName.Text.Trim() != "") { EmployeeSearch.SurName = this.txtSurName.Text.Trim(); } if (this.ddlGender.SelectedIndex > 0) { EmployeeSearch.Gender = this.ddlGender.SelectedValue; } if (this.txtdOB.Text.Trim() != "") { EmployeeSearch.DOB = this.txtdOB.Text.Trim(); } EmployeeSearch.DesType = "J"; return(EmployeeSearch); } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message.ToString(); this.programmaticModalPopup.Show(); return(null); } }
public static DataTable SearchEmployeeForOrgUnitHead(ATTEmployeeSearch objEmployee) { try { string strSelectSQL = ""; strSelectSQL = "SELECT A.* FROM VW_EMP_ORG_UNIT_HEAD A WHERE 1=1"; int i = 0; if (objEmployee.EmpID != null) { i++; } if (objEmployee.FirstName != null) { i++; } if (objEmployee.MiddleName != null) { i++; } if (objEmployee.SurName != null) { i++; } if (objEmployee.Gender != null) { i++; } if (objEmployee.DOB != null) { i++; } if (objEmployee.SymbolNo != null) { i++; } if (objEmployee.OrgID != null) { i++; } OracleParameter[] ParamArray = new OracleParameter[i]; int j = 0; if (objEmployee.EmpID != null) { strSelectSQL += " AND A.EMP_ID =:EmpID"; ParamArray[j] = Utilities.GetOraParam(":EmpID", objEmployee.EmpID, OracleDbType.Varchar2, ParameterDirection.Input); j++; } if (objEmployee.FirstName != null) { strSelectSQL += " AND A.FIRST_NAME LIKE :FName||'%'"; ParamArray[j] = Utilities.GetOraParam(":FName", objEmployee.FirstName, OracleDbType.Varchar2, ParameterDirection.Input); j++; } if (objEmployee.MiddleName != null) { strSelectSQL += " AND A.MID_NAME LIKE :MName||'%'"; ParamArray[j] = Utilities.GetOraParam(":MName", objEmployee.MiddleName, OracleDbType.Varchar2, ParameterDirection.Input); j++; } if (objEmployee.SurName != null) { strSelectSQL += " AND A.SUR_NAME LIKE :SurName||'%'"; ParamArray[j] = Utilities.GetOraParam(":SurName", objEmployee.SurName, OracleDbType.Varchar2, ParameterDirection.Input); j++; } if (objEmployee.Gender != null) { strSelectSQL += " AND A.GENDER = :Gender"; ParamArray[j] = Utilities.GetOraParam(":Gender", objEmployee.Gender, OracleDbType.Varchar2, ParameterDirection.Input); j++; } if (objEmployee.DOB != null) { strSelectSQL += " AND A.DOB = :DOB"; ParamArray[j] = Utilities.GetOraParam(":DOB", objEmployee.DOB, OracleDbType.Varchar2, ParameterDirection.Input); j++; } if (objEmployee.SymbolNo != null) { strSelectSQL += " AND A.SYMBOL_NO = :SymbolNo"; ParamArray[j] = Utilities.GetOraParam(":SymbolNo", objEmployee.SymbolNo, OracleDbType.Varchar2, ParameterDirection.Input); j++; } if (objEmployee.OrgID != null) { strSelectSQL += " AND A.ORG_ID = :OrgID"; ParamArray[j] = Utilities.GetOraParam(":OrgID", objEmployee.OrgID, OracleDbType.Int64, ParameterDirection.Input); j++; } strSelectSQL += " ORDER BY A.EMP_ID"; DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, strSelectSQL, Module.PMS, ParamArray); return((DataTable)ds.Tables[0]); } catch (OracleException oex) { PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError(); throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message)); } catch (Exception ex) { throw ex; } }