public List <MarkPost> MarkPost(int post_id, int type) { //using (var db = new SovaDbContext()) //{ //} ////1 Good ////2 Bad //MarkPost results = db.MarkPosts.FromSql("call mark_post({0},{1})", post_id, type); //return results; using (var db = new SovaDbContext()) { List <MarkPost> listMarkPost = new List <MarkPost>(); var marks = db.MarkPosts.FromSql("call mark_post({0},{1})", post_id, type); foreach (var mark in marks) { listMarkPost.Add(mark); } return(listMarkPost); } }
public int AddSearches(string text) { using (var db = new SovaDbContext()) { var returnPosts = db.AddSearches.FromSql("call search({0})", text); return(returnPosts.Count()); } }
public marks GetMark(int id) { using (var db = new SovaDbContext()) { var mark = db.marks.FirstOrDefault(x => x.posts_id == id); return(mark); } }
public bool AddVisitedPost(int id) { using (var db = new SovaDbContext()) { var results = db.AddVisitedPost.FromSql("call add_visited_post({0})", id); return(results.Any()); } }
public posts FindPost(int id) { using (var db = new SovaDbContext()) { var post = db.posts.FirstOrDefault(x => x.id == id); return(post); } }
public int BestMatchesTotal(string text) { using (var db = new SovaDbContext()) { var returnPosts = db.BestMatches.FromSql("call bestmatch({0})", text); return(returnPosts.Count()); } }
public string TermNetworkList(string text) { using (var db = new SovaDbContext()) { var termNetworks = db.TermNetworks.FromSql("call term_network({0})", text).ToList(); return(string.Join("", termNetworks.Select(x => x.graph)).Replace(",]", "]")); } }
public posts ReturnQuestionById(int id) { posts results; using (var db = new SovaDbContext()) { results = db.posts.FirstOrDefault(x => x.id == id); } return(results); }
public List <BestmatchKeywordList> BestmatchKeywordLists(string text) { using (var db = new SovaDbContext()) { List <BestmatchKeywordList> listreturnPosts = new List <BestmatchKeywordList>(); var returnPosts = db.BestmatchKeywordLists.FromSql("call bestmatch_keyword_list({0})", text); foreach (var post in returnPosts) { listreturnPosts.Add(post); } return(listreturnPosts); } }
public List <ClosestTerm> ClosestTerms(string text) { using (var db = new SovaDbContext()) { List <ClosestTerm> listClosestTerm = new List <ClosestTerm>(); var returnclosest_terms = db.ClosestTerms.FromSql("call closest_terms({0})", text); foreach (var term in returnclosest_terms) { listClosestTerm.Add(term); } return(listClosestTerm); } }
//getting most used tags public List <PopularTags> PopularTagsList(int number) { using (var db = new SovaDbContext()) { List <PopularTags> listreturnTags = new List <PopularTags>(); var returnTags = db.PopularTags.FromSql("call count_tags_occurrences({0})", number); foreach (var tag in returnTags) { listreturnTags.Add(tag); } return(listreturnTags); } }
public List <ReturnPostTags> ReturnPostTags(int id) { using (var db = new SovaDbContext()) { List <ReturnPostTags> listReturnPostTags = new List <ReturnPostTags>(); var postTags = db.ReturnPostTags.FromSql("call return_tags({0})", id); foreach (var tag in postTags) { listReturnPostTags.Add(tag); } return(listReturnPostTags); } }
public List <ReturnNewestQuestions> ReturnNewestPosts(int amount) { using (var db = new SovaDbContext()) { List <ReturnNewestQuestions> listReturnNewestQuestions = new List <ReturnNewestQuestions>(); var newestPosts = db.ReturnNewestQuestions.FromSql("call return_newest_questions({0})", amount); foreach (var post in newestPosts) { listReturnNewestQuestions.Add(post); } return(listReturnNewestQuestions); } }
public List <ReturnGoodMarks> ReturnGoodMarks() { using (var db = new SovaDbContext()) { List <ReturnGoodMarks> listReturnGoodMarks = new List <ReturnGoodMarks>(); var marks = db.ReturnGoodMarks.FromSql("call return_good_marks()"); foreach (var mark in marks) { listReturnGoodMarks.Add(mark); } return(listReturnGoodMarks); } }
public bool DeleteMarkPost(int post_id) { using (var db = new SovaDbContext()) { var mark = db.marks.FirstOrDefault(x => x.posts_id == post_id); if (mark != null) { db.marks.Remove(mark); db.SaveChanges(); return(true); } return(false); } }
public List <ReturnSearches> ReturnSearches() { using (var db = new SovaDbContext()) { List <ReturnSearches> listSearches = new List <ReturnSearches>(); var Searches = db.ReturnSearches.FromSql("call return_searches()"); foreach (var search in Searches) { listSearches.Add(search); } return(listSearches); } }
public List <ReturnVisitedPosts> ReturnVisitedPosts() { using (var db = new SovaDbContext()) { List <ReturnVisitedPosts> listReturnVisitedPosts = new List <ReturnVisitedPosts>(); var visitedPosts = db.ReturnVisitedPosts.FromSql("call return_visited_posts()"); foreach (var post in visitedPosts) { listReturnVisitedPosts.Add(post); } return(listReturnVisitedPosts); } }
public List <ReturnLinkPosts> ReturnLinkPosts(int id) { using (var db = new SovaDbContext()) { List <ReturnLinkPosts> listReturnLinkPosts = new List <ReturnLinkPosts>(); var linkPosts = db.ReturnLinkPosts.FromSql("call return_linkposts({0})", id); foreach (var post in linkPosts) { listReturnLinkPosts.Add(post); } return(listReturnLinkPosts); } }
public Boolean UpdateAnnotation(int id, string annotation) { using (var db = new SovaDbContext()) { var marks = db.marks.FirstOrDefault(x => x.posts_id == id); if (marks != null) { marks.annotation = annotation; db.SaveChanges(); return(true); } return(false); } }
public int GetNumberOfResults(string text) { using (var db = new SovaDbContext()) { List <QuestionSearchResults> listQuestions = new List <QuestionSearchResults>(); var Questions = db.QuestionSearchResults.FromSql("call search({0})", text); foreach (var Question in Questions) { listQuestions.Add(Question); } return(listQuestions.Count()); } }
public List <comments> ReturnCommentsById(int id) { using (var db = new SovaDbContext()) { List <comments> CommentList = new List <comments>(); var comments = db.comments.Where(x => x.posts_id == id); foreach (var comment in comments) { CommentList.Add(comment); } db.QuestionSearchResults.FromSql("call add_visited_post({0})", id); return(CommentList); } }
public List <AnswersSearchResults> ReturnAnswersById(int id) { using (var db = new SovaDbContext()) { List <AnswersSearchResults> answerList = new List <AnswersSearchResults>(); var answers = db.AnswersSearchResults.FromSql("call return_answers({0})", id); foreach (var answer in answers) { answerList.Add(answer); } db.QuestionSearchResults.FromSql("call add_visited_post({0})", id); return(answerList); } }
public List <BestMatch> BestMatches(string text, int page, int pageSize) { //update Searches table AddSearches(text); using (var db = new SovaDbContext()) { List <BestMatch> listreturnPosts = new List <BestMatch>(); var returnPosts = db.BestMatches.FromSql("call bestmatch({0})", text); foreach (var post in returnPosts) { listreturnPosts.Add(post); } return(listreturnPosts .OrderBy(x => x.id) .Skip(page * pageSize) .Take(pageSize) .ToList()); } }
public List <posts> FindAllPosts(int page, int pageSize) { using (var db = new SovaDbContext()) { List <posts> listPosts = new List <posts>(); var posts = db.posts; foreach (var post in posts) { listPosts.Add(post); } return(listPosts .OrderBy(x => x.id) .Skip(page * pageSize) .Take(pageSize) .ToList()); } }
public List <QuestionSearchResults> FindQuestionByString(string text, int page, int pageSize) { using (var db = new SovaDbContext()) { List <QuestionSearchResults> listQuestions = new List <QuestionSearchResults>(); var Questions = db.QuestionSearchResults.FromSql("call search({0})", text); foreach (var Question in Questions) { listQuestions.Add(Question); } return(listQuestions .OrderBy(x => x.id) .Skip(page * pageSize) .Take(pageSize) .ToList()); } }