public static List <DAL.Job.keywordSearch> GetDegreeList(String Keyword)
{
List <DAL.Job.keywordSearch> list = new List <DAL.Job.keywordSearch>();
String connstring = Connection.GetConnectionString();
String sql_select = String.Format("Select DegreeName from Degree where DegreeName like '%{0}%' ", Keyword);
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(sql_select, dbCon))
{
dbCom.CommandType = CommandType.Text;
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
var OBJ = new keywordSearch()
{
Keyword = Convert.ToString(wizReader["DegreeName"]),
};
list.Add(OBJ);
}
}
}
}
return(list);
}
public static List <DAL.Job.keywordSearch> FetchKeywordAutocompleteData(String Keyword)
{
List <DAL.Job.keywordSearch> list = new List <DAL.Job.keywordSearch>();
String connstring = Connection.GetConnectionString();
String sql_select = String.Format("Select keyword from (SELECT Keyword from KEYWORD union select [Subject] from [Subject] union select [DegreeName] from [Degree] ) as result where KEYWORD like '%{0}%' ", Keyword);
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(sql_select, dbCon))
{
dbCom.CommandType = CommandType.Text;
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
var OBJ = new keywordSearch()
{
Keyword = Convert.ToString(wizReader["keyword"]),
};
list.Add(OBJ);
}
}
}
}
return(list);
}
