public Bulletin RemoveBulletin(Bulletin bulletin) { Bulletin bulletinRemoved = db.Bulletins.Remove(bulletin).Entity; db.SaveChanges(); return(bulletinRemoved); }
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 AddCharacterToAccount(ApplicationUser user, CharacterDetails character) { CharacterDetails exists = GetCharacter(character.CharacterID); if (exists == null) { character.AccountID = user.Id; db.CharacterDetails.Add(character); db.SaveChanges(); } else { throw new CharacterAlreadyAssignedException(); } }
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()); } }