public void Create(Models.Tag tag)
{
using (var context = new ArticlesContext())
{
context.Tags.Add(tag);
context.SaveChanges();
}
}
public void Create(Question question)
{
using (var context = new ArticlesContext())
{
context.Questions.Add(question);
context.SaveChanges();
}
}
public void Create(Models.Article article)
{
using (var context = new ArticlesContext())
{
context.Articles.Add(article);
context.SaveChanges();
}
}
public void CreateAccount(Account account)
{
using (var context = new ArticlesContext())
{
account.Points = 0;
context.Accounts.Add(account);
context.SaveChanges();
}
}
public void QuestionAnswered(string username, int questionID)
{
AnsweredQuestion answeredQuestion = new AnsweredQuestion(username, questionID);
using (var context = new ArticlesContext())
{
context.AnsweredQuestions.Add(answeredQuestion);
context.SaveChanges();
}
}
public void AddScore(Account account, int points)
{
using (var context = new ArticlesContext())
{
var dbUser = context.Accounts.Single(a => a.AccountID == account.AccountID);
dbUser.Points = dbUser.Points + points;
context.SaveChanges();
}
}
public void Delete(int id)
{
using (var context = new ArticlesContext())
{
try {
var tag = context.Tags.Single(a => a.TagId == id);
context.Tags.Attach(tag);
context.Tags.Remove(tag);
context.SaveChanges();
}
catch
{
return;
}
}
}
public void Update(Models.Article article)
{
using (var context = new ArticlesContext())
{
var dbArticle = context.Articles.Single(a => a.ArticleId == article.ArticleId);
dbArticle.Author = article.Author;
dbArticle.Summary = article.Summary;
dbArticle.Tag = article.Tag;
dbArticle.Title = article.Title;
dbArticle.HeaderImage = article.HeaderImage;
dbArticle.Content = article.Content;
context.SaveChanges();
}
}
public void DeleteArticle(int id)
{
using (var context = new ArticlesContext())
{
try {
var article = context.Articles.Single(a => a.ArticleId == id);
context.Articles.Attach(article);
context.Articles.Remove(article);
context.SaveChanges();
}
catch
{
return;
}
}
}