public List <SearchResult> GetQuestionAnswerByQuery(string query)
{
try
{
using (CONEINFOContext entities = new CONEINFOContext())
{
//return entities.Searches.Where(r => r.Keyword.name.Contains(query)).Select(r => r.answer).ToList();
List <SearchResult> searchResults = new List <SearchResult>();
var search = from r in entities.Searches
// where (r.Keyword.name.Contains(query) || r.question.Contains(query))
where r.Keyword.name.Contains(query)
select new SearchResult
{
question = r.question,
answer = r.answer
};
foreach (var a in search)
{
SearchResult searchResult = new SearchResult();
searchResult.question = a.question;
searchResult.answer = a.answer;
searchResults.Add(searchResult);
}
return(searchResults);
}
}
catch (Exception ex)
{
throw new FaultException("GetQuestionAnswerByQuery went wrong: " + ex.GetBaseException());
}
}
public List <SearchResult> GetTopTenAll()
{
try
{
using (CONEINFOContext entities = new CONEINFOContext())
{
List <SearchResult> searchResults = new List <SearchResult>();
var search = from r in entities.Searches
where r.top10 != 0
orderby r.top10
select new SearchResult
{
question = r.question,
answer = r.answer,
};
foreach (var a in search)
{
SearchResult searchResult = new SearchResult();
searchResult.question = a.question;
searchResult.answer = a.answer;
searchResults.Add(searchResult);
}
return(searchResults);
}
}
catch (Exception ex)
{
throw new FaultException("GetQuestionAnswerByQuery went wrong: " + ex.GetBaseException());
}
}
public string GetKeywordById(int id)
{
try
{
using (CONEINFOContext entities = new CONEINFOContext())
{
return(entities.Keywords.Where(r => r.type == id).Select(r => r.name).Single().ToString());
}
}
catch (Exception ex)
{
throw new FaultException("GetKeywordById went wrong: " + ex.GetBaseException());
}
}
public List <string> GetKeywordByQuery(string query)
{
try
{
using (CONEINFOContext entities = new CONEINFOContext())
{
return(entities.Keywords.Where(r => r.name.Contains(query)).Select(r => r.name).ToList());
}
}
catch (Exception ex)
{
throw new FaultException("GetKeywordByQuery went wrong: " + ex.GetBaseException());
}
}
public List <string> GetKeywordNameAll()
{
try
{
using (CONEINFOContext entities = new CONEINFOContext())
{
return(entities.Keywords.Select(r => r.name).ToList());
}
}
catch (Exception ex)
{
throw new FaultException("GetKeywordNameAll went wrong: " + ex.GetBaseException());
}
}
public List <string> GetQuestionAnswerByTopTen(int id)
{
try
{
using (CONEINFOContext entities = new CONEINFOContext())
{
return(entities.Searches.Where(r => r.top10 == id).Select(r => r.question).ToList());
}
}
catch (Exception ex)
{
throw new FaultException("GetQuestionAnswerByTopTen went wrong: " + ex.GetBaseException());
}
}
