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