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