public int GetTotalQuestions() { using (var db = new MysqlDataContext()) { return(db.Question.Count()); } }
public IList <Comments> GetComments() { using (var db = new MysqlDataContext()) { return(db.Comment.OrderBy(c => c.CommentCeated).ToList()); } }
public void AddMarkPost(int postid) { using (var db = new MysqlDataContext()) { //var cmds = db.MarkedPostStoredProc.FromSql("call insert_markpost({0})", postid); } }
public IList <Posts> GetAllMarkedPosts(int page, int pageSize) { using (var db = new MysqlDataContext()) { var markedid = from m in db.MarkPost select m.PostId; var post = (from p in db.Post where markedid.Contains(p.PostsId) select new Posts { PostsId = p.PostsId, Body = p.Body, creationDate = p.creationDate, Score = p.Score, PostTypeId = p.PostTypeId, OwnerUserId = p.OwnerUserId }).ToList(); var result = post .OrderBy(m => m.creationDate) .Skip(page * pageSize) .Take(pageSize) .ToList(); return(result); } }
public int GetNumberOfUsers() { using (var db = new MysqlDataContext()) { return(db.CombineUsers.Count()); } }
public int GetNumberOfMarkedPosts() { using (var db = new MysqlDataContext()) { return(db.MarkPost.Count()); } }
public Comments GetComment(int id) { using (var db = new MysqlDataContext()) { return(db.Comment.FirstOrDefault(c => c.CommentId == id)); } }
public CombinedUsers GetCombinedUserById(int id) { using (var db = new MysqlDataContext()) { return(db.CombineUsers.FirstOrDefault(c => c.CombineUserId == id)); } }
public IList <Tags> GetTagsById(int id) { using (var db = new MysqlDataContext()) { return(db.Tags.Where(c => c.PostId == id).ToList()); } }
public int GetNumberOfTags() { using (var db = new MysqlDataContext()) { return(db.Tags.Count()); } }
public int GetTotalLinkPosts() { using (var db = new MysqlDataContext()) { return(db.LinkPost.Count()); } }
public Questions GetQuestionbyId(int id) { using (var db = new MysqlDataContext()) { return(db.Question.FirstOrDefault(q => q.QuestionId == id)); } }
public int GetTotalHistory() { using (var db = new MysqlDataContext()) { var count = db.History.Count(); return(count); } }
public Posts GetPost(int id) { using (var db = new MysqlDataContext()) { var result = db.Post.FirstOrDefault(p => p.PostsId == id); return(result); } }
public History GetHistory(int id) { using (var db = new MysqlDataContext()) { return(db.History .FirstOrDefault(h => h.HistoryId == id)); } }
public int GetTotalOwnComments() { using (var db = new MysqlDataContext()) { var count = db.OwnComment.Count(); return(count); } }
public void AddOwnComment(OwnComments owncomment) { using (var db = new MysqlDataContext()) { owncomment.CommentId = db.OwnComment.Max(o => o.CommentId) + 1; db.Add(owncomment); db.SaveChanges(); } }
public int GetTotalAnswers() { using (var db = new MysqlDataContext()) { var count = db.Post.Where(p => p.PostTypeId == 2). Count(); return(count); } }
public int GetWordCloud(string word) { using (var db = new MysqlDataContext()) { var cmds = db.WrodCloudProc.FromSql("call wordranking({0})", word).Count(); //var result = cmds.Count(); return(cmds); } }
public void AddHistory(History history) { using (var db = new MysqlDataContext()) { history.HistoryId = db.History.Max(h => h.HistoryId) + 1; db.Add(history); db.SaveChanges(); } }
public IList <History> GetHistories(int page, int pageSize) { using (var db = new MysqlDataContext()) { return(db.History .Skip(page * pageSize) .Take(pageSize) .OrderBy(h => h.SearchDate).ToList()); } }
public IList <Comments> GetComments(int page, int pageSize) { using (var db = new MysqlDataContext()) { return(db.Comment .Skip(page * pageSize) .Take(pageSize) .OrderBy(c => c.CommentCeated).ToList()); } }
public int GetTotalSearchKeywordResult(string search) { using (var db = new MysqlDataContext()) { var cmds = db.SearchKeyordStoredProc.FromSql("call search_keyword({0})", search); //var list = new List<SearchKeywordStoredProc>(); var result = cmds.Count(); return(result); } }
public int GetTotalRankWord(string rankword) { using (var db = new MysqlDataContext()) { var cmds = db.RankStoredProc.FromSql("call ranking({0})", rankword); //var list = new List<RankingStoredProc>(); var result = cmds.Count(); return(result); } }
public IList <Tags> GetTags(int page, int pagesize) { using (var db = new MysqlDataContext()) { return(db.Tags .OrderBy(c => c.PostId) .Skip(page * pagesize) .Take(pagesize) .ToList()); } }
public IList <CombinedUsers> GetCombinedUsers(int page, int pagesize) { using (var db = new MysqlDataContext()) { return(db.CombineUsers .OrderBy(c => c.CombineUserId) .Skip(page * pagesize) .Take(pagesize) .ToList()); } }
public IList <Questions> GetQuestions(int page, int pageSize) { using (var db = new MysqlDataContext()) { var questions = db.Question .Skip(page * pageSize) .Take(pageSize) .ToList(); return(questions); } }
public IList <LinkPosts> GetLinkToPost(int page, int pageSize) { using (var db = new MysqlDataContext()) { return(db.LinkPost .OrderBy(c => c.PostId) .Skip(page * pageSize) .Take(pageSize) .ToList()); } }
public IList <Posts> GetPosts(int page, int pageSize) { using (var db = new MysqlDataContext()) { var post = db.Post .Where(b => b.PostTypeId == 1) .Skip(page * pageSize) .Take(pageSize) .OrderBy(p => p.creationDate) .ToList(); return(post); } }
public IList <wordcloud> Getwordcloud(string word, int page, int pageSize) { using (var db = new MysqlDataContext()) { var cmds = db.WrodCloudProc.FromSql("call wordranking({0})", word); var result = new List <wordcloud>(); foreach (var item in cmds) { result.Add(item); } return(result); } }