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