/// <summary>
///
/// </summary>
/// <param name="htmlHelper"></param>
/// <param name="takeCount"></param>
/// <returns></returns>
public static IEnumerable<TB_News> GetNewsItemsOrderByDesc(this HtmlHelper htmlHelper, int takeCount)
{
using (var db = new NewsRepository())
{
return db.Find<TB_News>(s => s.IsDelete == false)
.OrderByDescending(desc => desc.PostDateTime)
.Take(takeCount).ToList();
}
}
public void TestAddValidNewsToDb()
{
var news = new News
{
Title = "Test News",
Content = "This is very important"
};
newsRepo.Add(news);
newsRepo.SaveChanges();
var newsFromDb = newsRepo.Find(news.Id);
Assert.IsNotNull(newsFromDb);
Assert.AreEqual(news.Title, newsFromDb.Title);
Assert.AreEqual(news.Content, newsFromDb.Content);
Assert.AreEqual(news.PublishDate, newsFromDb.PublishDate);
Assert.IsTrue(newsFromDb.Id != 0);
}
public void DeleteNews_WhenNewsIsValid_ShouldDeleteNews()
{
var repo = new NewsRepository(new NewsEntities());
var news = repo.All().Where(n => n.Title == "News1").FirstOrDefault();
repo.Delete(news);
repo.SaveChanges();
var newsFromRepo = repo.Find(news.Id);
Assert.AreEqual(null, newsFromRepo);
}
public void UpdateNews_WhenNewsIsValid_ShouldUpdateNews()
{
var repo = new NewsRepository(new NewsEntities());
var news = repo.All().Where(n => n.Title == "News1").FirstOrDefault();
news.Title = "Azis e...folkpevets";
repo.Update(news);
repo.SaveChanges();
var newsFromRepo = repo.Find(news.Id);
Assert.AreEqual(newsFromRepo.Title, "Azis e...folkpevets");
}
public void ModifyExistingNewsWithCorrectData()
{
var repo = new NewsRepository(new NewsContext());
var newsFromDb = repo.Find(1);
newsFromDb.Title = "Edited Title";
newsFromDb.Content = "Some new content";
repo.SaveChanges();
Assert.IsNotNull(newsFromDb);
Assert.AreEqual(newsFromDb.Title, "Edited Title");
Assert.AreEqual(newsFromDb.Content, "Some new content");
Assert.AreEqual(1, newsFromDb.Id);
}
public void GetAllNewsReturnNewsShouldReturnCorrectly()
{
var repo = new NewsRepository(new NewsContext());
var news = new News
{
Title = "Test Title",
Content = "Some test content.",
PublishedDate = DateTime.Now
};
repo.Add(news);
repo.SaveChanges();
var newsDb = repo.Find(news.Id);
Assert.IsNotNull(newsDb);
Assert.AreEqual(news.Title, newsDb.Title);
Assert.AreEqual(news.Content, newsDb.Content);
Assert.AreEqual(news.PublishedDate, newsDb.PublishedDate);
}
public void InsertNews_WhenInsertedCorrectly_ShouldReturnNews()
{
var repo = new NewsRepository(new NewsEntities());
var news = new News.Models.News()
{
Title = "TestNews",
Content = "TestNewsContent",
PublishDate = new DateTime(2015, 05, 10)
};
repo.Add(news);
repo.SaveChanges();
var newsFromDb = repo.Find(news.Id);
Assert.AreEqual(4, repo.All().Count());
Assert.AreEqual(news.Title, newsFromDb.Title);
Assert.AreEqual(news.Content, newsFromDb.Content);
Assert.AreEqual(news.PublishDate.ToShortDateString(),
newsFromDb.PublishDate.ToShortDateString());
Assert.AreNotEqual(0, newsFromDb.Id);
}
public void ModifyExistingNewsWithIncorrectData()
{
var repo = new NewsRepository(new NewsContext());
var newsFromDb = repo.Find(1);
newsFromDb.Title = null;
repo.SaveChanges();
}
public void TryToDeleteNonExistingNews()
{
var repo = new NewsRepository(new NewsContext());
var newsFromDb = repo.Find(5);
repo.Delete(newsFromDb);
}
public void DeleteExistingNews()
{
var repo = new NewsRepository(new NewsContext());
var newsFromDb = repo.Find(1);
repo.Delete(newsFromDb);
repo.SaveChanges();
Assert.IsNull(repo.Find(1));
}
public void CreateNews_WhenNewsIsAddedToDbWithCorrectData_ShouldReturnNews()
{
// Arrange -> prapare the objects
var repo = new NewsRepository(new NewsContext());
var news = new Models.News()
{
Title = "Sample New News",
PublishDate = DateTime.Now,
Content = "Sample New News Content"
};
// Act -> perform some logic
repo.Add(news);
repo.SaveChanges();
// Assert -> validate the results
var newsFromDb = repo.Find(news.Id);
Assert.IsNotNull(newsFromDb);
Assert.AreEqual(news.Title, newsFromDb.Title);
Assert.AreEqual(news.Content, newsFromDb.Content);
Assert.AreEqual(news.PublishDate, newsFromDb.PublishDate);
Assert.IsTrue(newsFromDb.Id != 0);
}
public void ModifyNews_WhenModifingNonExistingNews_ShouldThrowException()
{
var context = new NewsContext();
context.News.Delete();
context.SaveChanges();
var repo = new NewsRepository(context);
var newsToChange = repo.Find(1);
newsToChange.Title = "New title";
repo.SaveChanges();
}
public void ModifyNews_WhenExistingNewsIsModifiedWithIncorrectData_ShouldThrowException()
{
var context = new NewsContext();
context.News.Delete();
var news = new Models.News()
{
Title = "Murder",
Content = "A man was slaughterd in Sofia last night.",
PublishDate = DateTime.Now
};
context.News.Add(news);
context.SaveChanges();
var repo = new NewsRepository(context);
var newsToChange = repo.Find(news.Id);
newsToChange.Title = null;
repo.SaveChanges();
}
public void ModifyNews_WhenExistingNewsIsModifiedWithCorrectData_ShouldReturnNews()
{
var context = new NewsContext();
context.News.Delete();
var news = new Models.News()
{
Title = "Murder",
Content = "A man was slaughterd in Sofia last night.",
PublishDate = DateTime.Now
};
context.News.Add(news);
context.SaveChanges();
var repo = new NewsRepository(context);
var newsToChange = repo.Find(news.Id);
newsToChange.Title = "Murder committed last night";
repo.SaveChanges();
var newsFromDb = repo.Find(news.Id);
Assert.IsNotNull(newsFromDb);
Assert.AreEqual(newsToChange.Title, newsFromDb.Title);
Assert.AreEqual(news.Content, newsFromDb.Content);
Assert.AreEqual(news.PublishDate, newsFromDb.PublishDate);
Assert.IsTrue(newsFromDb.Id != 0);
}
public void ModifyNonExistingNewsShouldTrhowException()
{
var repo = new NewsRepository(new NewsContext());
var newsFromDb = repo.Find(5);
newsFromDb.Title = "NonExisting entity";
}
public NewsDto GetNews(long id)
{
return(newsRepository.Find(x => x.Id == id).FirstOrDefault().ToModel <NewsDto>());
}
public void DeleteNews_WhenDeletingNonExistingNews_ShouldThrowException()
{
var context = new NewsContext();
context.News.Delete();
context.SaveChanges();
var repo = new NewsRepository(context);
var newsToDelete = repo.Find(1);
repo.Delete(newsToDelete);
repo.SaveChanges();
}