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