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;
}
}
