public static List<string> GetKeywords(string prefixText)
{
try
{
DataTable dt = new DataTable();
SearchJSBAL search = new SearchJSBAL();
dt = search.GetTechnicalskillBAL(prefixText);
List<string> skillname = new List<string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
skillname.Add(dt.Rows[i][1].ToString());
}
return skillname;
}
catch (Exception)
{
throw;
}
}
public static List<string> GetCity(string prefixText)
{
try
{
DataTable dt = new DataTable();
SearchJSBAL search = new SearchJSBAL();
dt = search.GetCityBAL(prefixText);
List<string> cityname = new List<string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
cityname.Add(dt.Rows[i][0].ToString());
}
return cityname;
}
catch (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;
}
}