public Article GetArticle(int id)
{
using (DBContextDataContext context = new DBContextDataContext(_connectionString))
{
return(context.Articles.FirstOrDefault(A => A.Id == id));
}
}
public User GetUserByEmail(string email)
{
using (DBContextDataContext context = new DBContextDataContext(_connectionString))
{
return(context.Users.FirstOrDefault(U => U.Email == email));
}
}
public void AddComment(Comment comment)
{
using (DBContextDataContext context = new DBContextDataContext(_connectionString))
{
context.Comments.InsertOnSubmit(comment);
context.SubmitChanges();
}
}
public void InsertLike(Like like)
{
using (DBContextDataContext context = new DBContextDataContext(_connectionString))
{
context.Likes.InsertOnSubmit(like);
context.SubmitChanges();
}
}
public void AddArticle(Article article)
{
using (DBContextDataContext context = new DBContextDataContext(_connectionString))
{
context.Articles.InsertOnSubmit(article);
context.SubmitChanges();
}
}
public List <Comment> Comments(int id)
{
using (DBContextDataContext context = new DBContextDataContext(_connectionString))
{
var LoadOptions = new DataLoadOptions();
LoadOptions.LoadWith <Comment>(C => C.User);
LoadOptions.LoadWith <Comment>(C => C.Article);
context.LoadOptions = LoadOptions;
return(context.Comments.Where(C => C.ArticleId == id).ToList());
}
}
public List <ArticlePlus> GetAllArticls()
{
using (DBContextDataContext context = new DBContextDataContext(_connectionString))
{
var LoadOptions = new DataLoadOptions();
LoadOptions.LoadWith <Article>(A => A.User);
LoadOptions.LoadWith <Article>(A => A.Likes);
LoadOptions.LoadWith <Article>(A => A.Comments);
context.LoadOptions = LoadOptions;
IEnumerable <Article> articles = context.Articles;
List <ArticlePlus> ArticleWithVoteCount = GetArticlesWithVoteCount(context.Articles.ToList());
return(ArticleWithVoteCount);
}
}
public string AddUser(User user)
{
if (GetUserByEmail(user.Email) != null)
{
return(null);
}
//this was done in controller
//user.PasswordSalt = PasswordHelper.GenerateSalt();
//user.PasswordHash = PasswordHelper.HashPassword(password, user.PasswordSalt);
using (DBContextDataContext context = new DBContextDataContext(_connectionString))
{
context.Users.InsertOnSubmit(user);
context.SubmitChanges();
return("User Added");
}
}