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