public bool CheckDuplicateArticles(string articleId) { using (var db = new SportsblogContext()) { var findArticleByIdQuery = db.Articles.Where(ar => ar.ArticleId == articleId); return(findArticleByIdQuery.Count() > 0); } }
public void WhenANewArticleIsAdded_TheNumberOfArticlesIncreasesBy1() { using (var db = new SportsblogContext()) { var numberOfArticlesBefore = db.Articles.Count(); _articleManager.Create("Test", "Test Article", "Dylan Lewis", "This article is a test"); var numberOfArticlesAfter = db.Articles.Count(); Assert.AreEqual(numberOfArticlesBefore + 1, numberOfArticlesAfter); } }
public void Delete(string articleId, string title, string authorName, string content) { using (var db = new SportsblogContext()) { if (SelectedArticle != null) { db.Articles.RemoveRange(SelectedArticle); SelectedArticle = null; } db.SaveChanges(); } }
public void WhenCreatingAnArticleWithADuplicateId_SystemThrowsAnError() { using (var db = new SportsblogContext()) { _articleManager.Create("Test", "Test Article", "Dylan Lewis", "This article is a test article."); bool expected = true; bool result = _articleManager.CheckDuplicateArticles("Test"); Assert.AreEqual(expected, result); } }
public void Create(string articleId, string title, string authorName, string content) { var newArt = new Article() { ArticleId = articleId, Title = title, AuthorName = authorName, Content = content }; using (var db = new SportsblogContext()) { db.Articles.Add(newArt); db.SaveChanges(); } }
public void TearDown() { using (var db = new SportsblogContext()) { var SelectedArticle = from ar in db.Articles where ar.ArticleId == "Test" select ar; db.Articles.RemoveRange(SelectedArticle); db.SaveChanges(); } }
public void Update(string articleId, string title, string authorName, string content) { using (var db = new SportsblogContext()) { if (SelectedArticle != null) { SelectedArticle = db.Articles.Where(a => a.ArticleId == articleId).FirstOrDefault(); SelectedArticle.Title = title; SelectedArticle.AuthorName = authorName; SelectedArticle.Content = content; } db.SaveChanges(); } }
public void WhenTheSelectedArticleAuthorIsChanged_TheDatabaseIsUpdated() { using (var db = new SportsblogContext()) { _articleManager.Create("Test", "Test Article", "Dylan Lewis", "This article is a test"); if (_articleManager.SelectedArticle != null) { _articleManager.Update("Test", "Test Article", "John Walker", "This article is a test"); var updatedArticle = db.Articles.Find("Test"); Assert.AreEqual("John Walker", updatedArticle.AuthorName); } } }
public void WhenTheSelectedArticleIsChanged_TheDatabaseIsUpdated() { using (var db = new SportsblogContext()) { _articleManager.Create("Test", "Test Article", "Dylan Lewis", "This article is a test"); if (_articleManager.SelectedArticle != null) { _articleManager.Update("Test", "Test Article", "Dylan Lewis", "This article is a test that has been updated."); var updatedArticle = db.Articles.Find("Test"); Assert.AreEqual("This article is a test that has been updated.", updatedArticle.Content); } } }
public void Setup() { _articleManager = new ArticleManager(); // remove test entry in DB if present using (var db = new SportsblogContext()) { var SelectedArticle = from ar in db.Articles where ar.ArticleId == "Test" select ar; db.Articles.RemoveRange(SelectedArticle); db.SaveChanges(); } }
public void WhenANewArticleIsDeleted_TheNumberOfArticlesDecreasesBy1() { using (var db = new SportsblogContext()) { _articleManager.Create("Test", "Test Article", "Dylan Lewis", "This article is a test"); var numberOfArticlesBefore = db.Articles.Count(); if (_articleManager.SelectedArticle != null) { _articleManager.Delete("Test", "Test Article", "Dylan Lewis", "This article is a test"); var numberOfArticlesAfter = db.Articles.Count(); Assert.AreEqual(numberOfArticlesBefore - 1, numberOfArticlesAfter); } } }
public List <Author> RetrieveAuthorName() { using (var db = new SportsblogContext()) return(db.Authors.ToList()); }
public List <Article> RetrieveAll() { using (var db = new SportsblogContext()) return(db.Articles.ToList()); }