public void GetsAllClubsFromDatabase() { var options = new DbContextOptionsBuilder <OlympicGamesDBContext>() .UseInMemoryDatabase(databaseName: "GetsAllClubsFromDatabaseDB") .Options; var data = new List <Clubs>() { new Clubs { Id = 1, Name = "Club1" }, new Clubs { Id = 2, Name = "Club2" }, new Clubs { Id = 3, Name = "Club3" }, }.AsQueryable(); using (OlympicGamesDBContext context = new OlympicGamesDBContext(options)) { ClubsBusiness business = new ClubsBusiness(context); data.ToList().ForEach(c => business.AddClub(c)); Assert.AreEqual(data.ToList(), business.GetAllClubs()); } }
public void DeleteClub() { var options = new DbContextOptionsBuilder <OlympicGamesDBContext>() .UseInMemoryDatabase(databaseName: "DeleteClubDB") .Options; IQueryable <Clubs> data = new List <Clubs>() { new Clubs { Id = 1, Name = "Club1" }, new Clubs { Id = 2, Name = "Club2" }, new Clubs { Id = 3, Name = "Club3" }, new Clubs { Id = 22, Name = "SektantiVegani" }, }.AsQueryable(); using (OlympicGamesDBContext context = new OlympicGamesDBContext(options)) { ClubsBusiness business = new ClubsBusiness(context); data.ToList().ForEach(club1 => business.AddClub(club1)); business.DeleteClubById(22); Assert.AreEqual(3, business.GetAllClubs().Count); } }
/// <summary> /// "Calls" method "GetAllTowns" from ClubsBusiness. /// Then it shows all clubs in table Clubs. /// </summary> public void GetAllClubs() { Console.WriteLine("Clubs:"); List <Clubs> clubs = clubsBusiness.GetAllClubs(); if (clubs.Count == 0) { Console.WriteLine("There are no clubs in the table!"); } else { Console.WriteLine("Id" + new string(' ', 4)//6 + "ClubName" + new string(' ', 36)); Console.WriteLine(new string('-', 50)); foreach (var club in clubs) { string output = $"{club.Id}" + new string(' ', 6 - club.Id.ToString().Length) + $"{club.Name}" + new string(' ', 44 - club.Name.Length); Console.WriteLine(output); } Console.WriteLine(new string('-', 50)); } }