public static List <ATTEmployeeDetailSearch> PropertyReportSearchList(ATTEmployeeDetailSearch objEmployee)
{
List <ATTEmployeeDetailSearch> lst = new List <ATTEmployeeDetailSearch>();
try
{
foreach (DataRow row in DLLEmployeeDetailSearch.PropertyReportSearch(objEmployee).Rows)
{
ATTEmployeeDetailSearch obj = new ATTEmployeeDetailSearch();
//obj.EmpID = d
obj.OrgName = row["Org_Name"].ToString();
obj.EmpID = 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.PostName = row["des_name"].ToString();
obj.LevelName = row["level_name"].ToString();
obj.PostingTypeName = row["posting_type_name"].ToString();
obj.Gender = row["Gender"].ToString();
lst.Add(obj);
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable PropertyReportSearch(ATTEmployeeDetailSearch objRptSearch)
{
GetConnection GetConn = new GetConnection();
try
{
string SearchSQL = "";
SearchSQL = QueryBuilder(objRptSearch);
OracleConnection DBConn = GetConn.GetDbConn(Module.PMS);
DataSet ds = SqlHelper.ExecuteDataset(DBConn, CommandType.Text, SearchSQL);
DataTable tbl = new DataTable();
tbl = (DataTable)ds.Tables[0];
return(tbl);
}
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;
}
finally
{
GetConn.CloseDbConn();
}
}
public static DataTable DetailSearchEmployee(ATTEmployeeDetailSearch objEmployee)
{
try
{
return(DLLEmployeeDetailSearch.DetailSearchEmployee(objEmployee));
}
catch (Exception ex)
{
throw ex;
}
}
public static string QueryBuilder(ATTEmployeeDetailSearch objEmployee)
{
try
{
string selectSQL = "";
selectSQL = "SELECT A.*,B.LEVEL_NAME,B.DES_NAME,B.ORG_NAME,B.POSTING_TYPE_NAME ";
selectSQL += "FROM VW_EMPLOYEES A,VW_EMP_POSTING B WHERE 1=1 ";
if (objEmployee.OrgID != null)
{
selectSQL += " AND B.ORG_ID=" + objEmployee.OrgID;
}
if (objEmployee.FirstName != "")
{
selectSQL += " AND upper(A.FIRST_NAME) LIKE '" + objEmployee.FirstName + "' || '%'";
}
if (objEmployee.MiddleName != "")
{
selectSQL += " AND upper(A.MID_NAME) LIKE '" + objEmployee.MiddleName + "' || '%'";
}
if (objEmployee.SurName != "")
{
selectSQL += " AND upper(A.SUR_NAME) LIKE '" + objEmployee.SurName + "' || '%'";
}
if (objEmployee.PostID != null)
{
selectSQL += " AND B.des_ID =" + objEmployee.PostID;
}
if (objEmployee.LevelID != null)
{
selectSQL += " AND B.level_ID =" + objEmployee.LevelID;
}
//selectSQL += " AND A.EMP_ID=B.EMP_ID(+)";
selectSQL += " AND A.EMP_ID=B.EMP_ID";
return(selectSQL);
}
catch (Exception ex)
{
throw (ex);
}
}
public static List <ATTEmployeeDetailSearch> DetailSearchEmployeeList(ATTEmployeeDetailSearch objEmployee)
{
List <ATTEmployeeDetailSearch> lst = new List <ATTEmployeeDetailSearch>();
try
{
foreach (DataRow row in DLLEmployeeDetailSearch.DetailSearchEmployee(objEmployee).Rows)
{
ATTEmployeeDetailSearch obj = new ATTEmployeeDetailSearch();
obj.EmpID = 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.SewaName = row["sewa_name"].ToString();
obj.SamuhaName = row["samuha_name"].ToString();
obj.UpaSamuhaName = row["upa_samuha_name"].ToString();
obj.PostName = row["des_name"].ToString();
obj.LevelName = row["level_name"].ToString();
obj.PostingTypeName = row["posting_type_name"].ToString();
obj.Gender = row["Gender"].ToString();
obj.DistrictName = row["eng_distname"].ToString();
obj.SubjectID = (row["Sub_ID"] == System.DBNull.Value) ? 0 : int.Parse(row["Sub_ID"].ToString());
obj.Training = row["subject"].ToString();
//obj.RetirementDate = row["subject"].ToString();
obj.DegreeID = (row["Deg_ID"] == System.DBNull.Value) ? 0 : int.Parse(row["Deg_ID"].ToString());
obj.QualificationName = row["DEGREE_NAME"].ToString();
obj.VisitCountryID = (row["country_ID"] == System.DBNull.Value) ? 0 : int.Parse(row["country_ID"].ToString());
obj.VisitCountryName = row["COUNTRY_ENG_NAME"].ToString();
obj.VisitPurpose = row["purpose"].ToString();
obj.VisitFromDate = row["v_from_date"].ToString();
obj.VisitToDate = row["to_date"].ToString();
obj.JoiningDate = row["p_from_date"].ToString();
obj.RetirementDate = row["retirement_date"].ToString();
lst.Add(obj);
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
ATTEmployeeDetailSearch objSearch = new ATTEmployeeDetailSearch();
if (this.ddlOrgName.SelectedIndex > 0)
{
objSearch.OrgID = int.Parse(this.ddlOrgName.SelectedValue);
}
if (this.txtFName.Text.Trim() != "")
{
objSearch.FirstName = this.txtFName.Text;
}
if (this.txtMName.Text.Trim() != "")
{
objSearch.MiddleName = this.txtMName.Text;
}
if (this.txtSName.Text.Trim() != "")
{
objSearch.SurName = this.txtSName.Text;
}
if (this.ddlPost.SelectedIndex > 0)
{
objSearch.PostID = int.Parse(this.ddlPost.SelectedValue);
}
if (this.ddlLevel.SelectedIndex > 0)
{
objSearch.LevelID = int.Parse(this.ddlLevel.SelectedValue);
}
Session["propertyReportSearch"] = BLLEmployeeDetailSearch.PropertyReportSearchList(objSearch);
List <ATTEmployeeDetailSearch> lst = (List <ATTEmployeeDetailSearch>)Session["propertyReportSearch"];
if (lst.Count > 0)
{
string count = "";
count = lst.Count.ToString().Replace("0", "०");
count = count.ToString().Replace("1", "१");
count = count.ToString().Replace("2", "२");
count = count.ToString().Replace("3", "३");
count = count.ToString().Replace("4", "४");
count = count.ToString().Replace("5", "५");
count = count.ToString().Replace("6", "६");
count = count.ToString().Replace("7", "७");
count = count.ToString().Replace("8", "८");
count = count.ToString().Replace("9", "९");
lblSearchResult.Text = count + " वटा रेकर्ड भेटिए ... ";
this.grdEmployeeSearch.DataSource = Session["propertyReportSearch"];
this.grdEmployeeSearch.DataBind();
}
else
{
lblSearchResult.Text = "कुनै पनि रेकर्ड भेटिएनन् ... ";
this.grdEmployeeSearch.DataSource = "";
this.grdEmployeeSearch.DataBind();
this.btnGenerateRpt.Visible = false;
}
}
catch (Exception ex)
{
throw(ex);
}
}
public static DataTable DetailSearchEmployee(ATTEmployeeDetailSearch objEmployee)
{
try
{
string strSelectSQL = "";
string tableName1 = "";
string colName1 = "";
string where1 = "";
string tableName2 = "";
string colName2 = "";
string where2 = "";
string tableName3 = "";
string colName3 = "";
string where3 = "";
//if (objEmployee.Training != "")
//{
tableName1 = ",TRAINING T";
colName1 = ",T.SEQ_NO as sub_id, T.subject";
where1 = " AND VW.EMP_ID=T.P_ID(+)";
//}
//if (objEmployee.QualificationList.Count > 0)
//{
tableName2 = ",QUALIFICATION Q, DEGREE D";
colName2 = ",Q.SEQ_NO AS DEG_ID,D.DEGREE_NAME";
where2 = " AND VW.EMP_ID=Q.P_ID(+) AND Q.DEGREE_ID=D.DEGREE_ID(+)";
//}
//if (objEmployee.VisitList.Count > 0)
//{
tableName3 = ",EMP_VISIT V,COUNTRY C";
colName3 = ",C.COUNTRY_ENG_NAME ,V.PURPOSE,V.FROM_DATE \"v_from_date\",V.TO_DATE, V.SEQ_NO AS COUNTRY_ID ";
where3 = " AND VW.EMP_ID=V.EMP_ID(+) AND V.COUNTRY=C.COUNTRY_ID(+)";
//}
strSelectSQL = "SELECT VW.*,fn_add_years(VW.\"P_FROM_DATE\"," + objEmployee.RetirementYear + ") as retirement_date" + colName1 + colName2 + colName3 + " FROM VW_EMP_POSTING VW" + tableName1 + tableName2 + tableName3 + " WHERE 1=1" + where1 + where2 + where3;
List <OracleParameter> paramArray = new List <OracleParameter>();
if (objEmployee.OrgID != null)
{
strSelectSQL += " AND VW.ORG_ID=:ORGID";
paramArray.Add(new OracleParameter(":ORGID", objEmployee.OrgID));
}
if (objEmployee.FirstName != "")
{
strSelectSQL += " AND upper(VW.FIRST_NAME) LIKE :FName||'%'";
paramArray.Add(new OracleParameter(":FName", objEmployee.FirstName.ToUpper()));
}
if (objEmployee.MiddleName != "")
{
strSelectSQL += " AND upper(VW.MID_NAME) LIKE :MName||'%'";
paramArray.Add(new OracleParameter(":MName", objEmployee.MiddleName.ToUpper()));
}
if (objEmployee.SurName != "")
{
strSelectSQL += " AND upper(VW.SUR_NAME) LIKE :SurName||'%'";
paramArray.Add(new OracleParameter(":SurName", objEmployee.SurName.ToUpper()));
}
if (objEmployee.SewaID != null)
{
strSelectSQL += " AND VW.SEWA_ID =:SEWAID";
paramArray.Add(new OracleParameter(":SEWAID", objEmployee.SewaID));
}
if (objEmployee.SamuhaID != null)
{
strSelectSQL += " AND VW.samuha_ID =:samuhaID";
paramArray.Add(new OracleParameter(":samuhaID", objEmployee.SamuhaID));
}
if (objEmployee.UpaSamuhaID != null)
{
strSelectSQL += " AND VW.upa_samuha_ID =:upasamuhaID";
paramArray.Add(new OracleParameter(":upasamuhaID", objEmployee.UpaSamuhaID));
}
if (objEmployee.PostID != null)
{
strSelectSQL += " AND VW.des_ID =:desID";
paramArray.Add(new OracleParameter(":desID", objEmployee.PostID));
}
if (objEmployee.LevelID != null)
{
strSelectSQL += " AND VW.level_ID =:levelID";
paramArray.Add(new OracleParameter(":levelID", objEmployee.LevelID));
}
if (objEmployee.PostingTypeID != null)
{
strSelectSQL += " AND VW.posting_type_id =:ptID";
paramArray.Add(new OracleParameter(":ptID", objEmployee.LevelID));
}
if (objEmployee.Gender != "")
{
strSelectSQL += " AND VW.GENDER = :Gender";
paramArray.Add(new OracleParameter(":Gender", objEmployee.Gender));
}
if (objEmployee.DistrictID != null)
{
strSelectSQL += " AND VW.birth_district = :distID";
paramArray.Add(new OracleParameter(":distID", objEmployee.DistrictID));
}
if (objEmployee.Training != "")
{
strSelectSQL += " AND upper(T.subject) LIKE :subjectx||'%'";
paramArray.Add(new OracleParameter(":subjectx", objEmployee.Training.ToUpper()));
}
if (objEmployee.RetirementDate != "")
{
strSelectSQL += " AND VW.\"P_FROM_DATE\"" + objEmployee.RetirementDateOperator + "fn_add_years(:rDate, -" + objEmployee.RetirementYear + ")";
paramArray.Add(new OracleParameter(":rDate", objEmployee.RetirementDate.Replace("/", ".")));
}
if (objEmployee.QualificationList != null)
{
if (objEmployee.QualificationList.Count > 0)
{
strSelectSQL += " AND Q.DEGREE_ID in(" + DLLEmployeeDetailSearch.GetWhereInQueryString(objEmployee.QualificationList) + ")";
}
}
if (objEmployee.VisitList != null)
{
if (objEmployee.VisitList.Count > 0)
{
strSelectSQL += " AND V.COUNTRY in(" + DLLEmployeeDetailSearch.GetWhereInQueryString(objEmployee.VisitList) + ")";
}
}
strSelectSQL += " ORDER BY vw.emp_id, t.SEQ_NO , q.SEQ_NO , v.SEQ_NO";
DataTable tbl = SqlHelper.ExecuteDataset(CommandType.Text, strSelectSQL, Module.PMS, paramArray.ToArray()).Tables[0];
return(tbl);
}
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;
}
}
protected void grdEmployee_RowDataBound(object sender, GridViewRowEventArgs e)
{
e.Row.Cells[0].Visible = false;
e.Row.Cells[16].Visible = false; //subject
e.Row.Cells[17].Visible = false; //degree
e.Row.Cells[18].Visible = false; //visited country
//if (e.Row.RowType == DataControlRowType.DataRow)
//e.Row.Cells[1].Text = (e.Row.RowIndex + 1).ToString();
if (e.Row.RowType == DataControlRowType.DataRow)
{
List <ATTEmployeeDetailSearch> lst = (List <ATTEmployeeDetailSearch>)Session["EmployeeDetailSearch"];
this.oTraining = lst.Find
(
delegate(ATTEmployeeDetailSearch s)
{
return(s.EmpID == double.Parse(e.Row.Cells[0].Text) &&
s.SubjectID == int.Parse(e.Row.Cells[16].Text));
}
);
//if (oTraining == null) oTraining = new ATTEmployeeDetailSearch();
this.oDegree = lst.Find
(
delegate(ATTEmployeeDetailSearch s)
{
return(s.EmpID == double.Parse(e.Row.Cells[0].Text) &&
s.DegreeID == int.Parse(e.Row.Cells[17].Text));
}
);
//if (oDegree == null) oDegree = new ATTEmployeeDetailSearch();
this.oVisit = lst.Find
(
delegate(ATTEmployeeDetailSearch s)
{
return(s.EmpID == double.Parse(e.Row.Cells[0].Text) &&
s.VisitCountryID == int.Parse(e.Row.Cells[18].Text));
}
);
//if (oVisit == null) oVisit = new ATTEmployeeDetailSearch();
if (this.EmpID == e.Row.Cells[0].Text)
{
//for (int i = 1; i <= 15; i++)
//{
// if (i != 11 && i != 14 && i != 15)
// {
// if (this.grdEmployee.Rows[empRow].Cells[i].RowSpan == 0)
// this.grdEmployee.Rows[empRow].Cells[i].RowSpan = 2;
// else
// this.grdEmployee.Rows[empRow].Cells[i].RowSpan += 1;
// e.Row.Cells[i].Visible = false;
// }
//}
if (this.oTraining.IsTrainingMerged == 1)
{
e.Row.Cells[11].Text = "";
e.Row.Cells[16].Text = "hide";
}
else
{
this.trainStr += "<br>" + lst[e.Row.RowIndex].Training + " | ";
this.grdEmployee.Rows[trainRow].Cells[11].Text = this.trainStr;
//e.Row.VerticalAlign = VerticalAlign.Middle;
this.oTraining.IsTrainingMerged = 1;
}
if (this.oDegree.IsDegreeMerged == 1)
{
e.Row.Cells[14].Text = "";
e.Row.Cells[17].Text = "hide";
}
else
{
this.quaStr += "<br>" + lst[e.Row.RowIndex].QualificationName + " | ";
this.grdEmployee.Rows[quaRow].Cells[14].Text = this.quaStr;
//e.Row.VerticalAlign = VerticalAlign.Middle;
this.oDegree.IsDegreeMerged = 1;
}
if (this.oVisit.IsVisitMerged == 1)
{
//e.Row.Cells[15].Text = "";
//e.Row.Cells[19].Text = "";
//e.Row.Cells[20].Text = "";
//e.Row.Cells[21].Text = "";
//e.Row.Cells[18].Text = "hide";
}
else
{
this.visitStr += "<br>" + lst[e.Row.RowIndex].VisitCountryName + " | ";
this.purpose += "<br>" + lst[e.Row.RowIndex].VisitPurpose + " | ";
this.fromDate += "<br>" + lst[e.Row.RowIndex].VisitFromDate + " | ";
this.toDate += "<br>" + lst[e.Row.RowIndex].VisitToDate + " | ";
this.grdEmployee.Rows[visitRow].Cells[15].Text = this.visitStr;
this.grdEmployee.Rows[visitRow].Cells[19].Text = this.purpose;
this.grdEmployee.Rows[visitRow].Cells[20].Text = this.fromDate;
this.grdEmployee.Rows[visitRow].Cells[21].Text = this.toDate;
//e.Row.VerticalAlign = VerticalAlign.Middle;
this.oVisit.IsVisitMerged = 1;
}
//if (e.Row.Cells[16].Text == "hide" && e.Row.Cells[17].Text == "hide" && e.Row.Cells[18].Text == "hide")
for (int i = 0; i <= 21; i++)
{
e.Row.Cells[i].Visible = false;
}
}
#region "Commented part"
//if (this.grdEmployee.Rows[firstRow].Cells[1].RowSpan == 0)
// this.grdEmployee.Rows[firstRow].Cells[1].RowSpan = 2;
//else
// this.grdEmployee.Rows[firstRow].Cells[1].RowSpan += 1;
//e.Row.Cells[1].Visible = false;
//if (this.grdEmployee.Rows[firstRow].Cells[2].RowSpan == 0)
// this.grdEmployee.Rows[firstRow].Cells[2].RowSpan = 2;
//else
// this.grdEmployee.Rows[firstRow].Cells[2].RowSpan += 1;
//e.Row.Cells[2].Visible = false;
//if (this.grdEmployee.Rows[firstRow].Cells[3].RowSpan == 0)
// this.grdEmployee.Rows[firstRow].Cells[3].RowSpan = 2;
//else
// this.grdEmployee.Rows[firstRow].Cells[3].RowSpan += 1;
//e.Row.Cells[3].Visible = false;
//if (this.grdEmployee.Rows[firstRow].Cells[4].RowSpan == 0)
// this.grdEmployee.Rows[firstRow].Cells[4].RowSpan = 2;
//else
// this.grdEmployee.Rows[firstRow].Cells[4].RowSpan += 1;
//e.Row.Cells[4].Visible = false;
//if (this.grdEmployee.Rows[firstRow].Cells[5].RowSpan == 0)
// this.grdEmployee.Rows[firstRow].Cells[5].RowSpan = 2;
//else
// this.grdEmployee.Rows[firstRow].Cells[5].RowSpan += 1;
//e.Row.Cells[5].Visible = false;
//if (this.grdEmployee.Rows[firstRow].Cells[6].RowSpan == 0)
// this.grdEmployee.Rows[firstRow].Cells[6].RowSpan = 2;
//else
// this.grdEmployee.Rows[firstRow].Cells[6].RowSpan += 1;
//e.Row.Cells[6].Visible = false;
//if (this.grdEmployee.Rows[firstRow].Cells[7].RowSpan == 0)
// this.grdEmployee.Rows[firstRow].Cells[7].RowSpan = 2;
//else
// this.grdEmployee.Rows[firstRow].Cells[7].RowSpan += 1;
//e.Row.Cells[7].Visible = false;
//if (this.grdEmployee.Rows[firstRow].Cells[8].RowSpan == 0)
// this.grdEmployee.Rows[firstRow].Cells[8].RowSpan = 2;
//else
// this.grdEmployee.Rows[firstRow].Cells[8].RowSpan += 1;
//e.Row.Cells[8].Visible = false;
//if (this.grdEmployee.Rows[firstRow].Cells[9].RowSpan == 0)
// this.grdEmployee.Rows[firstRow].Cells[9].RowSpan = 2;
//else
// this.grdEmployee.Rows[firstRow].Cells[9].RowSpan += 1;
//e.Row.Cells[9].Visible = false;
//if (this.grdEmployee.Rows[firstRow].Cells[10].RowSpan == 0)
// this.grdEmployee.Rows[firstRow].Cells[10].RowSpan = 2;
//else
// this.grdEmployee.Rows[firstRow].Cells[10].RowSpan += 1;
//e.Row.Cells[10].Visible = false;
////if (Training == e.Row.Cells[11].Text)
////{
// if (this.grdEmployee.Rows[firstRow].Cells[11].RowSpan == 0)
// this.grdEmployee.Rows[firstRow].Cells[11].RowSpan = 2;
// else
// this.grdEmployee.Rows[firstRow].Cells[11].RowSpan += 1;
// e.Row.Cells[11].Visible = false;
////}
//if (this.grdEmployee.Rows[firstRow].Cells[12].RowSpan == 0)
// this.grdEmployee.Rows[firstRow].Cells[12].RowSpan = 2;
//else
// this.grdEmployee.Rows[firstRow].Cells[12].RowSpan += 1;
//e.Row.Cells[12].Visible = false;
//if (this.grdEmployee.Rows[firstRow].Cells[13].RowSpan == 0)
// this.grdEmployee.Rows[firstRow].Cells[13].RowSpan = 2;
//else
// this.grdEmployee.Rows[firstRow].Cells[13].RowSpan += 1;
//e.Row.Cells[13].Visible = false;
////if (Qualification == e.Row.Cells[14].Text)
////{
// if (this.grdEmployee.Rows[firstRow].Cells[14].RowSpan == 0)
// this.grdEmployee.Rows[firstRow].Cells[14].RowSpan = 2;
// else
// this.grdEmployee.Rows[firstRow].Cells[14].RowSpan += 1;
// e.Row.Cells[14].Visible = false;
////}
////if (VisitedCoutry == e.Row.Cells[15].Text)
////{
// if (this.grdEmployee.Rows[firstRow].Cells[15].RowSpan == 0)
// this.grdEmployee.Rows[firstRow].Cells[15].RowSpan = 2;
// else
// this.grdEmployee.Rows[firstRow].Cells[15].RowSpan += 1;
// e.Row.Cells[15].Visible = false;
////}
//}
#endregion
else
{
rowCount++;
if (rowCount % 2 == 1)
{
e.Row.BackColor = System.Drawing.Color.FromName("#E7E2E2");
}
else
{
e.Row.BackColor = System.Drawing.Color.FromName("#ffffff");
}
e.Row.VerticalAlign = VerticalAlign.Middle;
for (int i = 1; i <= 21; i++)
{
e.Row.Cells[i].Style.Add("border-top", "#4F69A2 1px solid");
}
//e.Row.Cells[0].Text = (empCount++).ToString();
this.EmpID = e.Row.Cells[0].Text;
this.empRow = e.Row.RowIndex;
this.trainRow = e.Row.RowIndex;
this.quaRow = e.Row.RowIndex;
this.visitRow = e.Row.RowIndex;
this.trainStr = lst[e.Row.RowIndex].Training + " | ";
this.quaStr = lst[e.Row.RowIndex].QualificationName + " | ";
this.visitStr = lst[e.Row.RowIndex].VisitCountryName + " | ";
this.purpose = lst[e.Row.RowIndex].VisitPurpose + " | ";
this.fromDate = lst[e.Row.RowIndex].VisitFromDate + " | ";
this.toDate = lst[e.Row.RowIndex].VisitToDate + " | ";
this.oTraining.IsTrainingMerged = 1;
this.oDegree.IsDegreeMerged = 1;
this.oVisit.IsVisitMerged = 1;
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
ATTEmployeeDetailSearch search = new ATTEmployeeDetailSearch();
if (this.ddlOrganization.SelectedIndex > 0)
{
search.OrgID = int.Parse(this.ddlOrganization.SelectedValue);
}
if (this.txtFName.Text.Trim() != "")
{
search.FirstName = this.txtFName.Text;
}
if (this.txtMName.Text.Trim() != "")
{
search.MiddleName = this.txtMName.Text;
}
if (this.txtSName.Text.Trim() != "")
{
search.SurName = this.txtSName.Text;
}
if (this.ddlSewa.SelectedIndex > 0)
{
search.SewaID = int.Parse(this.ddlSewa.SelectedValue);
}
if (this.ddlSamuha.SelectedIndex > 0)
{
search.SamuhaID = int.Parse(this.ddlSamuha.SelectedValue);
}
if (this.ddlUpaSamuha.SelectedIndex > 0)
{
search.UpaSamuhaID = int.Parse(this.ddlUpaSamuha.SelectedValue);
}
if (this.ddlPost.SelectedIndex > 0)
{
search.PostID = int.Parse(this.ddlPost.SelectedValue);
}
if (this.ddlLevel.SelectedIndex > 0)
{
search.LevelID = int.Parse(this.ddlLevel.SelectedValue);
}
if (this.ddlPostingType.SelectedIndex > 0)
{
search.PostingTypeID = int.Parse(this.ddlPostingType.SelectedValue);
}
if (this.ddlSex.SelectedIndex > 0)
{
search.Gender = this.ddlSex.SelectedValue;
}
if (this.ddlDistrict.SelectedIndex > 0)
{
search.DistrictID = int.Parse(this.ddlDistrict.SelectedValue);
}
if (this.txtTraining.Text.Trim() != "")
{
search.Training = this.txtTraining.Text;
}
if (this.txtRetirementDate.Text.Trim() != "")
{
search.RetirementDate = this.txtRetirementDate.Text;
search.RetirementDateOperator = this.ddlROperator.SelectedItem.Text;
search.RetirementYear = 20;
}
search.QualificationList = this.GetCheckedValueList(this.lstQualification);
search.VisitList = this.GetCheckedValueList(this.lstVisit);
//this.grdEmployee.DataSource = BLLEmployeeDetailSearch.DetailSearchEmployee(search);
Session["EmployeeDetailSearch"] = BLLEmployeeDetailSearch.DetailSearchEmployeeList(search);
this.grdEmployee.DataSource = Session["EmployeeDetailSearch"];
this.grdEmployee.DataBind();
//foreach (GridViewRow row in this.grdEmployee.Rows)
//{
// if (row.Cells[16].Text == "hide" && row.Cells[17].Text == "hide" && row.Cells[18].Text == "hide")
// for (int i = 0; i <= 21; i++)
// {
// row.Cells[i].Visible = false;
// }
//}
this.LoadImageX.Width = new Unit(0);
this.LoadImageX.Height = new Unit(0);
}
