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