public void TestUpdateClubs()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "TestUpdateClubsDB")
.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));
Clubs c = business.GetClubById(2); c.Name = "Club22";
business.UpdateClub(c);
Assert.AreEqual("Club22", business.GetClubById(2).Name);
}
}
/// <summary>
/// After the user has inputed id, the program "Calls" method "GetClubById" from ClubsBusiness.
/// Shows the Club who has this id.
/// </summary>
public void GetClubById()
{
Console.Write("Enter Club ID to fetch: ");
int id = int.Parse(Console.ReadLine());
Clubs club = clubsBusiness.GetClubById(id);
if (club != null)
{
PrintClub(club);
}
else
{
Console.WriteLine($"There is no club with ID = {id} in the table!");
}
}
private string GetClubAndCoachNames(Competitors competitor, string name)
{
if (name == "club")
{
string clubName = "";
if (competitor.ClubId != null)
{
clubName = clubsBusiness.GetClubById(competitor.ClubId).Name;
}
return(clubName);
}
else
{
string coachName = "";
if (competitor.CoachId != null)
{
coachName = coachesBusiness.GetCoachById(competitor.CoachId).Name;
}
return(coachName);
}
}
public void GetClubById()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "GetClubByIdDB")
.Options;
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
ClubsBusiness business = new ClubsBusiness(context);
business.AddClub(new Clubs {
Id = 1, Name = "Club1"
});
business.AddClub(new Clubs {
Id = 2, Name = "Club2"
});
business.AddClub(new Clubs {
Id = 3, Name = "Club3"
});
Clubs c = business.GetClubById(1);
Assert.AreEqual(1, c.Id);
}
}
