public void GetBulletins_Should_Return_SpecifiedCount()
{
int expectedCount = 5;
var options = new DbContextOptionsBuilder <EveCMContext>()
.UseInMemoryDatabase(databaseName: "GetBulletins_Specific_Count")
.Options;
using (var context = new EveCMContext(options))
{
int count = 10;
for (int i = 1; i < count - 1; i++)
{
context.Bulletins.Add(new Bulletin()
{
Id = i,
AuthorId = i.ToString(),
Content = $"This is some content: {i}",
Title = $"This is some title: {i}",
CreatedDate = DateTime.Now.AddDays(i - 1)
});
context.SaveChanges();
}
}
using (var context = new EveCMContext(options))
{
IBulletinRepository repository = new BulletinRepository(context);
var result = repository.GetBulletins(out int total, expectedCount);
Assert.AreEqual(expectedCount, result.Count());
}
}
public void SaveBulletin_Should_SaveToDatabase()
{
var options = new DbContextOptionsBuilder <EveCMContext>()
.UseInMemoryDatabase(databaseName: "GetBulletin_Order")
.Options;
Bulletin bulletin = new Bulletin()
{
AuthorId = "1",
Content = "TestContent",
CreatedDate = DateTime.Now,
Id = 1234,
Title = "TestTitle"
};
using (var context = new EveCMContext(options))
{
IBulletinRepository bulletinRepository = new BulletinRepository(context);
bulletinRepository.SaveBulletin(bulletin);
}
using (var context = new EveCMContext(options))
{
Bulletin savedBulletin = context.Bulletins.Where(x => x.Id == bulletin.Id).First();
Assert.AreEqual(bulletin.Id, savedBulletin.Id);
}
}
//
// GET: /Bulletins/Delete/5
public ActionResult Delete(int id)
{
IRepository <Models.Bulletin> repo = new BulletinRepository();
repo.Delete(repo.GetById(id));
return(RedirectToAction("Index"));
}
// GET api/bulletins/5
public Bulletin Get(int id)
{
var repository = new BulletinRepository();
var bulletin = repository.GetById(id);
if (bulletin == null)
{
throw new HttpResponseException(HttpStatusCode.NotFound); // embrace the HTTP
}
return(bulletin);
}
public ActionResult Delete(int id, FormCollection collection)
{
try
{
IRepository <Models.Bulletin> repo = new BulletinRepository();
repo.Delete(repo.GetById(id));
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public void GetBulletins_Should_OrderByRecent()
{
var options = new DbContextOptionsBuilder <EveCMContext>()
.UseInMemoryDatabase(databaseName: "GetBulletins_Order")
.Options;
int entityCount = 10;
using (var context = new EveCMContext(options))
{
for (int i = entityCount - 1; i >= 0; i--)
{
context.Bulletins.Add(new Bulletin()
{
//allow for id = 0
Id = i + 1,
AuthorId = i.ToString(),
Content = $"This is some content: {i}",
Title = $"This is some title: {i}",
//add dates in past
CreatedDate = DateTime.Now.AddDays(i * -1)
});
context.SaveChanges();
}
}
using (var context = new EveCMContext(options))
{
IBulletinRepository repository = new BulletinRepository(context);
var result = repository.GetBulletins(out int total);
Assert.AreEqual(entityCount, result.Count());
Assert.AreEqual(DateTime.Now.ToShortDateString(), result.First().CreatedDate.ToShortDateString());
Assert.AreEqual(DateTime.Now.AddDays((entityCount - 1) * -1).ToShortDateString(), result.Last().CreatedDate.ToShortDateString());
}
}
// GET api/bulletins
public IEnumerable <Bulletin> Get()
{
var repository = new BulletinRepository();
return(repository.GetAll());
}
//
// GET: /Bulletins/
public ActionResult Index()
{
IRepository <Models.Bulletin> repo = new BulletinRepository();
return(View(repo.GetAll()));
}