public void SubmitArticle(string url, string title, string owner) { Article arr = new Article() { URL = url, Title = title, Diggers = owner, submittedDate = DateTime.Now }; RedditCloneDataContext dc = new RedditCloneDataContext(); dc.Articles.InsertOnSubmit(arr); dc.SubmitChanges(); var article = (from arr1 in dc.Articles where arr1.URL== url orderby arr1.submittedDate descending select arr1); Article arrNew = article.ToList()[0]; VoteHistory vHis = new VoteHistory() { articleID = arrNew.id, diggers = owner, voteChoice=(int)VoteChoiceEnum.UpVote }; // RedditCloneDataContext dc1= new RedditCloneDataContext(); dc.VoteHistories.InsertOnSubmit(vHis); dc.SubmitChanges(); }
public List<Article> GetSubmittedArticles(string username) { RedditCloneDataContext dc = new RedditCloneDataContext(); var articles = from p in dc.Articles where p.Diggers == username select p; return articles.ToList(); }
public List<Article> GetNewestArticles() { RedditCloneDataContext dc = new RedditCloneDataContext(); var articles = from p in dc.Articles orderby p.submittedDate descending select p; return articles.ToList<Article>(); }
public List<VoteHistory> GetArticleHistory(string articleName) { RedditCloneDataContext dc = new RedditCloneDataContext(); var res = from g in dc.Articles where g.Title == articleName select g.id; var res1 = from aa in dc.VoteHistories where res.Contains(aa.articleID) orderby aa.diggers ascending select aa; return res1.ToList(); }
public void AddUser(string userName, string password, string email) { RedditCloneDataContext dc = new RedditCloneDataContext(); UserInfo uif = new UserInfo() { Diggers = userName, password = password, }; dc.UserInfos.InsertOnSubmit(uif); dc.SubmitChanges(); }
public void DeleteArticle(int id) { RedditCloneDataContext dc = new RedditCloneDataContext(); var arr = from p in dc.Articles where p.id == id select p; dc.Articles.DeleteAllOnSubmit(arr); var vHis = from vH in dc.VoteHistories where vH.articleID == id select vH; dc.VoteHistories.DeleteAllOnSubmit(vHis); dc.SubmitChanges(); }
public VoteHistory GetLatestVoteHistory(string url, string voter) { RedditCloneDataContext dc = new RedditCloneDataContext(); var articleIDs = from vH in dc.Articles where vH.URL==url orderby vH.submittedDate descending select vH; List<Article> articleIDList = articleIDs.ToList<Article>(); var vHistory = from vH in dc.VoteHistories where vH.articleID == articleIDList[0].id && vH.diggers == voter select vH; return vHistory.ToList<VoteHistory>()[0]; }
public List<VoteHistory> GetVoteHistory(int articleID) { RedditCloneDataContext dc = new RedditCloneDataContext(); var vHistory = from vHis in dc.VoteHistories where vHis.articleID == articleID select vHis; return vHistory.ToList<VoteHistory>(); }
// public GetUpVote(string ) public List<Article> SearchURL(string url) { RedditCloneDataContext dc = new RedditCloneDataContext(); var articles = from p in dc.Articles where p.URL == url select p; return articles.ToList<Article>(); }
public Article GetArticleID(int id) { RedditCloneDataContext dc = new RedditCloneDataContext(); return dc.Articles.Single<Article>(a => a.id == id); }
public List<Article> GetHotArticles() { RedditCloneDataContext dc = new RedditCloneDataContext(); return dc.Articles.ToList<Article>(); }
private void CastVote(int id, string digger, int voteChoice1) { RedditCloneDataContext dc = new RedditCloneDataContext(); VoteHistory vHis = dc.VoteHistories.SingleOrDefault(prop => (prop.diggers == digger && prop.articleID == id)); if (vHis == null) { VoteHistory vh = new VoteHistory() { articleID = id, diggers = digger, voteChoice = voteChoice1 }; dc.VoteHistories.InsertOnSubmit(vh); } else { vHis.voteChoice = voteChoice1; } dc.SubmitChanges(); }
public UserInfo GetUserInfo(string userName) { RedditCloneDataContext dc = new RedditCloneDataContext(); return dc.UserInfos.SingleOrDefault<UserInfo>(uit => uit.Diggers == userName); }