public IList <SearchResult> GetProcedureList(int page, int pageSize, string word1, string word2, string word3, bool questionSearch)
{
List <SearchResult> results = new List <SearchResult>();
using (SovaContext db = new SovaContext())
{
if (questionSearch)
{
var resultOfQuestionSearch = db.Set <SearchResult>()
.FromSql("call questionSearch({0},{1},{2})", new[] { word1, word2, word3 })
.Skip(page * pageSize)
.Take(pageSize);
foreach (var data in resultOfQuestionSearch)
{
SearchResult tmp = new SearchResult {
};
tmp.PostId = data.PostId;
tmp.PostTitle = data.PostTitle;
tmp.PostScore = data.PostScore;
tmp.PostText = data.PostText;
tmp.Rank = data.Rank;
results.Add(tmp);
}
}
else
{
var resultOfAnswerSearch = db.Set <SearchResult>()
.FromSql("call answerSearch({0},{1},{2})", new[] { word1, word2, word3 })
.Skip(page * pageSize)
.Take(pageSize);
foreach (var data in resultOfAnswerSearch)
{
SearchResult tmp = new SearchResult {
};
tmp.PostId = data.PostId;
tmp.PostTitle = data.PostTitle;
tmp.PostScore = data.PostScore;
tmp.PostText = data.PostText;
tmp.Rank = data.Rank;
results.Add(tmp);
}
}
return(results);
}
}
public IList <FrequentWord> GetProcedureList(int page, int pageSize, string word1, string word2, string word3, bool questionSearch)
{
List <FrequentWord> results = new List <FrequentWord>();
using (SovaContext db = new SovaContext())
{
if (questionSearch)
{
var something = db.Set <FrequentWord>()
.FromSql("call relevantQuestionWords({0},{1},{2})", new[] { word1, word2, word3 })
.Skip(page * pageSize)
.Take(pageSize);
foreach (var data in something)
{
FrequentWord tmp = new FrequentWord {
};
tmp.Frequency = data.Frequency;
tmp.Word = data.Word;
results.Add(tmp);
}
}
else
{
var something = db.Set <FrequentWord>()
.FromSql("call relevantAnswerWords({0},{1},{2})", new[] { word1, word2, word3 })
.Skip(page * pageSize)
.Take(pageSize);
foreach (var data in something)
{
FrequentWord tmp = new FrequentWord {
};
tmp.Frequency = data.Frequency;
tmp.Word = data.Word;
results.Add(tmp);
}
}
return(results);
}
}