public void GetClubByName() { var options = new DbContextOptionsBuilder <OlympicGamesDBContext>() .UseInMemoryDatabase(databaseName: "GetClubByNameDB") .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.GetClubByName("Club1"); Assert.AreEqual("Club1", c.Name); } }
/// <summary> /// After the user has inputed idname the program "Calls" method "GetClubById" from ClubsBusiness. /// Shows the Club who has this name. /// </summary> public void GetClubByName() { Console.Write("Enter Club Name to fetch: "); string name = Console.ReadLine(); Clubs club = clubsBusiness.GetClubByName(name); if (club != null) { PrintClub(club); } else { Console.WriteLine($"There is no club with name = {name} in the table!"); } }
private Competitors CreateCompetitor(Competitors competitor) { Console.Write("Enter Competitor Full Name: "); competitor.FullName = Console.ReadLine(); Console.Write("Enter Competitor Birth Date: "); competitor.BirthDate = Console.ReadLine(); Console.Write("Enter Competitor Age: "); competitor.Age = int.Parse(Console.ReadLine()); Console.Write("Enter Competitor Gender: "); competitor.Gender = Console.ReadLine(); Console.Write("Enter Competitor Weight: "); competitor.Weight = Console.ReadLine(); Console.Write("Enter Competitor Town Name: "); string townName = Console.ReadLine(); if (townsBusiness.GetTownByName(townName) == null) { Console.WriteLine($"There is no town with the name {townName}"); Console.WriteLine("Do you want to create new town?"); Console.WriteLine("1. Yes" + "\n" + "2. No"); if (int.Parse(Console.ReadLine()) == 1) { townsDisplay.AddTown(); } else { Console.Write("Enter existing town: "); townName = Console.ReadLine(); } } competitor.TownId = townsBusiness.GetTownByName(townName).Id; Console.WriteLine("Do your competitor have a club?" + "\n" + "1.Yes" + "\n" + "2.No"); if (int.Parse(Console.ReadLine()) == 1) { Console.Write("Enter Competitor Club Name: "); string clubName = Console.ReadLine(); if (clubsBusiness.GetClubByName(clubName) == null) { Console.WriteLine($"There is no club with the name {clubName}"); Console.WriteLine("Do you want to create new club?"); Console.WriteLine("1. Yes" + "\n" + "2. No"); if (int.Parse(Console.ReadLine()) == 1) { clubsDisplay.AddClub(); } else { Console.WriteLine("Enter existing club: "); clubName = Console.ReadLine(); } } competitor.ClubId = clubsBusiness.GetClubByName(clubName).Id; } else { competitor.ClubId = null; } Console.WriteLine("Do your competitor have a coach?" + "\n" + "1.Yes" + "\n" + "2.No"); if (int.Parse(Console.ReadLine()) == 1) { Console.Write("Enter Competitor Coach Name: "); string coachName = Console.ReadLine(); if (coachesBusiness.GetCoachByName(coachName) == null) { Console.WriteLine($"There is no coach with the name {coachName}"); Console.WriteLine("Do you want to create new coach?"); Console.WriteLine("1. Yes" + "\n" + "2. No"); if (int.Parse(Console.ReadLine()) == 1) { coachesDisplay.AddCoach(); } else { Console.WriteLine("Enter existing coach: "); coachName = Console.ReadLine(); } } competitor.CoachId = coachesBusiness.GetCoachByName(coachName).Id; } else { competitor.CoachId = null; } Console.Write("Enter Competitor Sport Name: "); string sportName = Console.ReadLine(); competitor.SportId = sportsBusiness.GetSportByName(sportName).Id; return(competitor); }