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