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