/// <summary> /// Get jobs from search dal /// </summary> /// <param name="searchEntity">AdvanceSearchDetailsEntity</param> /// <returns>DataSet</returns> public DataSet JobSearchDAL(AdvanceSearchDetailsEntity searchEntity) { DataSet ds = new DataSet(); try { SqlCommand cmd = new SqlCommand(Constants.sp_JS_JobSearch, Connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@keywordTechnical", searchEntity.KeySkill); cmd.Parameters.AddWithValue("@locationCity", searchEntity.City); cmd.Parameters.AddWithValue("@experience", searchEntity.WorkExp); cmd.Parameters.AddWithValue("@salary", searchEntity.MaxSalary); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); } catch (Exception) { throw; } return ds; }
/// <summary> /// Get job from search bal /// </summary> /// <param name="searchEntity">AdvanceSearchDetailsEntity</param> /// <returns>DataSet</returns> public DataSet JobSearchBAL(AdvanceSearchDetailsEntity searchEntity) { SearchJSDAL searchDal = new SearchJSDAL(); return searchDal.JobSearchDAL(searchEntity); }
public DataSet GetSearch(AdvanceSearchDetailsEntity advanceSearchEntity) { try { AdvanceSearchDAL advancesearchDAL = new AdvanceSearchDAL(); return advancesearchDAL.Search(advanceSearchEntity); } catch (System.Exception) { throw; } }
/// <summary> /// Bind data to rptrJobPost control /// </summary> private void BindRepeater() { try { AdvanceSearchDetailsEntity advanceSearchEntity = new AdvanceSearchDetailsEntity(); SearchJSBAL searchBal = new SearchJSBAL(); // Check if txtKeywords is equal to null if (txtKeywords.Text == "") { advanceSearchEntity.KeySkill = null; } else { advanceSearchEntity.KeySkill = txtKeywords.Text.Trim(); } // Check if txtLocation is equal to null if (txtLocation.Text == "") { advanceSearchEntity.City = null; } else { advanceSearchEntity.City = txtLocation.Text.Trim(); } // Check if ddlExperience is equal to null if (ddlExperience.SelectedValue == "" || ddlExperience.Text == "Experience") { advanceSearchEntity.WorkExp = null; } else { advanceSearchEntity.WorkExp = ddlExperience.SelectedValue.Trim(); } // Check if ddlSalary is equal to null if (ddlSalary.SelectedValue == "" || ddlSalary.Text == "Salary") { advanceSearchEntity.MaxSalary = null; } else { advanceSearchEntity.MaxSalary = ddlSalary.SelectedValue.Trim(); } DataSet dsSearch = new DataSet(); dsSearch = searchBal.JobSearchBAL(advanceSearchEntity); // Check if dsSearch is not null if (dsSearch != null) { // Set the datasource of the repeater rptrJobPost.DataSource = dsSearch; rptrJobPost.DataBind(); } } catch (Exception) { throw; } }