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));
}
}
