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();
}
private void detach_VoteHistories(VoteHistory entity)
{
this.SendPropertyChanging();
entity.UserInfo = null;
}
partial void DeleteVoteHistory(VoteHistory instance);
partial void UpdateVoteHistory(VoteHistory instance);
partial void InsertVoteHistory(VoteHistory instance);
private void attach_VoteHistories(VoteHistory entity)
{
this.SendPropertyChanging();
entity.Article = this;
}
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();
}