private ATTGroupPersonSearch GetFilter() { ATTGroupPersonSearch SearchPerson = new ATTGroupPersonSearch(); SearchPerson.Gender = ""; SearchPerson.MaritalStatus = ""; SearchPerson.IniType = ""; SearchPerson.PostName = ""; if (this.txtSymbolNo.Text.Trim() != "") { SearchPerson.SymbolNo = txtSymbolNo.Text.ToString().Trim(); } SearchPerson.FirstName = this.txtFName.Text.Trim(); SearchPerson.MiddleName = this.txtMName.Text.Trim(); SearchPerson.SurName = this.txtSurName.Text.Trim(); if (this.ddlGender.SelectedIndex > 0) { SearchPerson.Gender = this.ddlGender.SelectedValue; } SearchPerson.DOB = this.txtDOB.Text.Trim(); if (this.ddlMarStatus.SelectedIndex > 0) { SearchPerson.MaritalStatus = this.ddlMarStatus.SelectedValue; } if (this.ddlOrganization.SelectedIndex > 0) { SearchPerson.IniType = this.ddlOrganization.SelectedValue; } if (this.ddlDesignation.SelectedIndex > 0) { SearchPerson.PostName = this.ddlDesignation.SelectedValue; } if (this.ddlCommittee.SelectedIndex > 0) { SearchPerson.GroupID = int.Parse(this.ddlCommittee.SelectedValue); } if (this.ddlCommitteePost.SelectedIndex > 0) { SearchPerson.GMPositionID = int.Parse(this.ddlCommitteePost.SelectedValue); } return(SearchPerson); }
public static List <ATTGroupPersonSearch> GetEmployeeFromWorkDistribution(ATTGroupPersonSearch person, string applicationlst) { List <ATTGroupPersonSearch> lst = new List <ATTGroupPersonSearch>(); try { foreach (DataRow row in DLLGroupPersonSearch.GetEmployeeFromWorkDistribution(person, applicationlst).Rows) { ATTGroupPersonSearch obj = new ATTGroupPersonSearch(); obj.PersonID = double.Parse(row["emp_id"].ToString()); obj.FirstName = row["first_name"].ToString(); obj.MiddleName = row["mid_name"].ToString(); obj.SurName = row["sur_name"].ToString(); obj.Gender = row["gender"].ToString(); obj.DOB = row["DOB"].ToString(); //obj.MaritalStatus = row["MARTIAL_STATUS"].ToString(); obj.MaritalStatus = ""; //obj.District = row["ENG_DISTNAME"].ToString(); obj.District = ""; obj.IniType = row["org_name"].ToString(); obj.PostName = row["des_name"].ToString(); obj.UnitID = int.Parse(row["org_unit_id"].ToString()); obj.UnitName = row["unit_name"].ToString(); obj.UnitFromDate = row["unit_from_date"].ToString(); //obj.ApplicationID = int.Parse(row["INI_TYPE"].ToString()); obj.OrgID = row["org_id"].ToString() == "" ? 0 : int.Parse(row["org_id"].ToString()); obj.DesID = row["des_id"].ToString() == "" ? 0 : int.Parse(row["des_id"].ToString()); obj.CreatedDate = row["created_date"].ToString(); obj.PostID = row["post_id"].ToString() == "" ? 0 : int.Parse(row["post_id"].ToString()); obj.PostFromDate = row["from_date"].ToString(); if (person.GroupID > 0 || person.GMPositionID > 0) { obj.GroupName = row["group_name"].ToString(); obj.GMPositionName = row["gm_position"].ToString(); } lst.Add(obj); } return(lst); } catch (Exception ex) { throw ex; } }
private ATTGroupPersonSearch GetFilterGeneral() { ATTGroupPersonSearch SearchPerson = new ATTGroupPersonSearch(); SearchPerson.Gender = ""; SearchPerson.MaritalStatus = ""; SearchPerson.IniType = ""; SearchPerson.PostName = ""; SearchPerson.FirstName = this.txtSFname.Text.Trim(); SearchPerson.MiddleName = this.txtSMname.Text.Trim(); SearchPerson.SurName = this.txtSLname.Text.Trim(); if (this.ddlSSex.SelectedIndex > 0) { SearchPerson.Gender = this.ddlSSex.SelectedValue; } SearchPerson.DOB = this.txtSDob.Text.Trim(); if (this.ddlSMaritalStatus.SelectedIndex > 0) { SearchPerson.MaritalStatus = this.ddlSMaritalStatus.SelectedValue; } if (this.ddlSOrg.SelectedIndex > 0) { SearchPerson.IniType = this.ddlSOrg.SelectedValue; } if (this.ddlSDesgination.SelectedIndex > 0) { SearchPerson.PostName = this.ddlSDesgination.SelectedValue; } if (this.ddlUnit.SelectedIndex > 0) { SearchPerson.UnitID = int.Parse(this.ddlUnit.SelectedValue); } return(SearchPerson); }
public static DataTable GetEmployeeWithPosting(ATTGroupPersonSearch person, string applicationlst) { string tbl = "VW_EMPLOYEE_WITH_POSTING"; if (person.GroupID > 0 || person.GMPositionID > 0) { tbl = "VW_GROUP_MEMBER_INFO"; } string SQL = "select * from " + tbl + " WHERE 1 = 1"; List <OracleParameter> paramArray = new List <OracleParameter>(); if (person.SymbolNo != "") { SQL = SQL + " AND symbol_no = :symbolno"; paramArray.Add(Utilities.GetOraParam(":symbolno", person.SymbolNo, OracleDbType.Varchar2, ParameterDirection.Input)); } if (person.FirstName.Trim() != "") { SQL = SQL + " AND UPPER(FIRST_NAME) LIKE :FName||'%'"; paramArray.Add(Utilities.GetOraParam(":FName", person.FirstName.ToUpper(), OracleDbType.Varchar2, ParameterDirection.Input)); } if (person.MiddleName.Trim() != "") { SQL = SQL + " AND UPPER(MID_NAME) LIKE :MName||'%'"; paramArray.Add(Utilities.GetOraParam(":MName", person.MiddleName.ToUpper(), OracleDbType.Varchar2, ParameterDirection.Input)); } if (person.SurName.Trim() != "") { SQL = SQL + " AND UPPER(SUR_NAME) LIKE :SName||'%'"; paramArray.Add(Utilities.GetOraParam(":SName", person.SurName.ToUpper(), OracleDbType.Varchar2, ParameterDirection.Input)); } if (person.Gender != "") { SQL = SQL + " AND GENDER= :Gender"; paramArray.Add(Utilities.GetOraParam(":Gender", person.Gender, OracleDbType.Varchar2, ParameterDirection.Input)); } if (person.DOB != "") { SQL = SQL + " AND DOB= :DOBX"; paramArray.Add(Utilities.GetOraParam(":DOBX", person.DOB, OracleDbType.Varchar2, ParameterDirection.Input)); } if (person.MaritalStatus != "") { SQL = SQL + " AND MARTIAL_STATUS= :MStatus"; paramArray.Add(Utilities.GetOraParam(":MStatus", person.MaritalStatus, OracleDbType.Varchar2, ParameterDirection.Input)); } if (person.IniType != "") { SQL = SQL + " AND ORG_ID= :ORGID"; paramArray.Add(Utilities.GetOraParam(":ORGID", int.Parse(person.IniType), OracleDbType.Int32, ParameterDirection.Input)); } if (person.PostName != "") { SQL = SQL + " AND DES_ID= :DES_ID"; paramArray.Add(Utilities.GetOraParam(":DES_ID", int.Parse(person.PostName), OracleDbType.Int32, ParameterDirection.Input)); } if (person.GroupID > 0) { SQL = SQL + " AND G_ORG_ID=:gorg_id AND GROUP_ID=:GRP_ID"; paramArray.Add(Utilities.GetOraParam(":gorg_id", int.Parse(person.IniType), OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":GRP_ID", person.GroupID, OracleDbType.Int32, ParameterDirection.Input)); } if (person.GMPositionID > 0) { SQL = SQL + " AND POSITION_ID=:pos_id"; paramArray.Add(Utilities.GetOraParam(":pos_id", person.GMPositionID, OracleDbType.Int32, ParameterDirection.Input)); } SQL = SQL + " AND INI_TYPE IN (" + applicationlst + ")"; SQL = SQL + " order by p_id"; try { return(SqlHelper.ExecuteDataset(CommandType.Text, SQL, Module.OAS, paramArray.ToArray()).Tables[0]); } catch (Exception ex) { throw ex; } }