public void TestUpdateTowns()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "TestUpdateTownsDB")
.Options;
var data = new List <Towns>()
{
new Towns {
Id = 1, Name = "Town1"
},
new Towns {
Id = 2, Name = "Town2"
},
new Towns {
Id = 3, Name = "Town3"
},
}.AsQueryable();
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
TownsBusiness business = new TownsBusiness(context);
data.ToList().ForEach(c => business.AddTown(c));
Towns c = business.GetTownById(2); c.Name = "Town22";
business.UpdateTown(c);
Assert.AreEqual("Town22", business.GetTownById(2).Name);
}
}
/// <summary>
/// After the user has inputed id, the program "Calls" method "GetTownById" from TownsBusiness.
/// Shows the Town who has this id.
/// </summary>
public void GetTownById()
{
Console.WriteLine("Enter Town Id to fetch: ");
int id = int.Parse(Console.ReadLine());
Towns town = townsBusiness.GetTownById(id);
if (town != null)
{
PrintTown(town);
}
else
{
Console.WriteLine($"There is no town with id = {id} in the table!");
}
}
/// <summary>
/// "Calls" method "GetAllCompetitors" from CompetitorsBusiness.
/// Then it shows all competitors in table Competitors.
/// </summary>
public void GetAllCompetitors()
{
Console.WriteLine("Competitors: ");
List <Competitors> competitors = competitorsBusiness.GetAllCompetitors();
if (competitors.Count == 0)
{
Console.WriteLine("There are no competitors in the table!");
}
else
{
Console.WriteLine(new string(' ', 2) + "Id" + new string(' ', 2) //6
+ new string(' ', 13) + "FullName" + new string(' ', 13) //34
+ new string(' ', 5) + "BirthDate" + new string(' ', 5) //19
+ new string(' ', 2) + "Age" + new string(' ', 2) //8
+ new string(' ', 2) + "Gender" + new string(' ', 2) //10
+ new string(' ', 2) + "Weight" + new string(' ', 2) //10
+ new string(' ', 10) + "TownName" + new string(' ', 10) //28
+ new string(' ', 18) + "ClubName" + new string(' ', 18) //44
+ new string(' ', 10) + "CoachName" + new string(' ', 10) //29
+ new string(' ', 6) + "SportName" + new string(' ', 6)); //21
Console.WriteLine(new string('-', 210));
foreach (var competitor in competitors)
{
var town = townsBusiness.GetTownById(competitor.TownId);
string clubName = GetClubAndCoachNames(competitor, "club");
string coachName = GetClubAndCoachNames(competitor, "coach");
var sport = sportsBusiness.GetSportById(competitor.SportId);
string output = $"{competitor.Id}" + new string(' ', 6 - competitor.Id.ToString().Length)
+ $"{competitor.FullName}" + new string(' ', 34 - competitor.FullName.Length)
+ $"{competitor.BirthDate}" + new string(' ', 19 - competitor.BirthDate.Length)
+ new string(' ', 2) + $"{competitor.Age}" + new string(' ', 2)
+ new string(' ', 3) + $"{competitor.Gender}" + new string(' ', 8 - competitor.Gender.Length)
+ new string(' ', 3) + $"{competitor.Weight}" + new string(' ', 9 - competitor.Weight.Length)
+ $"{town.Name}" + new string(' ', 28 - town.Name.Length)
+ $"{clubName}" + new string(' ', 44 - clubName.Length)
+ $"{coachName}" + new string(' ', 29 - coachName.Length)
+ $"{sport.Name}" + new string(' ', 21 - sport.Name.Length);
Console.WriteLine(output);
}
Console.WriteLine(new string('-', 210));
}
}
public void GetTownById()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "GetTownByIdDB")
.Options;
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
TownsBusiness business = new TownsBusiness(context);
business.AddTown(new Towns {
Id = 1, Name = "Town1"
});
business.AddTown(new Towns {
Id = 2, Name = "Town2"
});
business.AddTown(new Towns {
Id = 3, Name = "Town3"
});
Towns c = business.GetTownById(1);
Assert.AreEqual(1, c.Id);
}
}