public async Task UpdateTest() { using (var myContext = CreateMagasinDbContext()) { var repo = new ArticleEFRepository(myContext); var article = new Article { Id = 1, Libelle = "Chargeur", SKU = "785625", DateSortie = DateTime.Now, PrixInitial = 129, Poids = 76 }; repo.Update(article); await repo.Save(); } using (var myContext = CreateMagasinDbContext()) { var repo = new ArticleEFRepository(myContext); var elements = await repo.GetAll(); elements.Should().HaveCount(4); elements.Any(e => e.Id == 1).Should().BeTrue(); elements.Any(e => e.Libelle == "Chargeur").Should().BeTrue(); elements.Any(e => e.Libelle == "Tablette").Should().BeFalse(); } }
public void ExistsTest() { using var myContext = CreateMagasinDbContext(); var repo = new ArticleEFRepository(myContext); var exists = repo.Exists(1); exists.Should().BeTrue(); }
public async Task GetAllTest() { using var myContext = CreateMagasinDbContext(); var repo = new ArticleEFRepository(myContext); var allArticles = await repo.GetAll(); allArticles.Should().HaveCount(4); }
public void GetAveragePriceBySecteurTest() { using var myContext = CreateMagasinDbContext(); var repo = new ArticleEFRepository(myContext); var average = repo.GetAveragePriceBySecteur(1); average.Should().Be(399); }
public void GetAllBySecteurTest() { using var myContext = CreateMagasinDbContext(); var repo = new ArticleEFRepository(myContext); var allArticles = repo.GetAllBySecteur(1); allArticles.Should().HaveCount(2); }
public async Task FindByIdTest() { using var myContext = CreateMagasinDbContext(); var repo = new ArticleEFRepository(myContext); var article = await repo.FindById(3); article.Libelle.Should().Be("PC"); article.Id.Should().Be(3); }
public async Task RemoveTest() { using (var myContext = CreateMagasinDbContext()) { var repo = new ArticleEFRepository(myContext); var article = await repo.FindById(4); repo.Remove(article); await repo.Save(); } using (var myContext = CreateMagasinDbContext()) { var repo = new ArticleEFRepository(myContext); var elements = await repo.GetAll(); elements.Should().HaveCount(3); elements.Any(e => e.Id == 4).Should().BeFalse(); } }
public async Task InsertTest() { using (var myContext = CreateMagasinDbContext()) { var repo = new ArticleEFRepository(myContext); var newArticle = new Article { Id = 5, Libelle = "Clavier", SKU = "854765", DateSortie = DateTime.Now, PrixInitial = 249, Poids = 250, PositionMagasin = new List <PositionsMagasin> { new PositionsMagasin { ArticleId = 5, EtagereId = 2, Quantite = 10 }, new PositionsMagasin { ArticleId = 5, EtagereId = 1, Quantite = 42 } } }; repo.Insert(newArticle); await(repo.Save()); } using (var myContext = CreateMagasinDbContext()) { var repo = new ArticleEFRepository(myContext); var elements = await repo.GetAll(); elements.Should().HaveCount(5); elements.Any(e => e.Id == 5).Should().BeTrue(); elements.Any(e => e.Libelle == "Clavier").Should().BeTrue(); } }