public void GetCoachByName() { var options = new DbContextOptionsBuilder <OlympicGamesDBContext>() .UseInMemoryDatabase(databaseName: "GetCoachByNameDB") .Options; var data = new List <Coaches>() { new Coaches { Id = 1, Name = "Coach1" }, new Coaches { Id = 2, Name = "Coach2" }, new Coaches { Id = 3, Name = "Coach3" }, }.AsQueryable(); using (OlympicGamesDBContext context = new OlympicGamesDBContext(options)) { CoachesBusiness business = new CoachesBusiness(context); data.ToList().ForEach(c => business.AddCoach(c)); Coaches c = business.GetCoachByName("Coach1"); Assert.AreEqual("Coach1", c.Name); } }
/// <summary> /// After the user has inputed name, the program "Calls" method "GetCoachById" from CoachesBusiness. /// Shows the Coach who has this name. /// </summary> public void GetCoachByName() { Console.Write("Enter Coach Name to fetch: "); string name = Console.ReadLine(); var coach = coachesBusiness.GetCoachByName(name); var sport = sportsBusiness.GetSportById(coach.SportId); if (coach != null) { PrintCoach(coach, sport); } else { Console.WriteLine($"There is no coach 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); }