static void TeamExistanceCheck(FootballEntities context, string teamName, string countryName)
{
if (!context.Teams.Any(t => t.TeamName == teamName && t.Country.CountryName == countryName))
{
context.Teams.Add(new Team()
{
TeamName = teamName,
Country = context.Countries.Where(c => c.CountryName == countryName).FirstOrDefault()
});
context.SaveChanges();
Console.WriteLine("Created team: {0} ({1})", teamName,
(countryName == null ? "no country" : countryName));
}
else
{
Console.WriteLine("Existing team: {0} ({1})", teamName,
(countryName == null ? "no country" : countryName));
}
}
static void TeamInLeagueExistanceCheck(FootballEntities context, string leagueName, string teamCountryName, string teamName)
{
var currentLeague = context.Leagues.Where(l => l.LeagueName == leagueName).FirstOrDefault();
if (currentLeague != null)
{
if (teamCountryName != null)
{
if (!currentLeague.Teams.Any(t => t.TeamName == teamName && t.Country.CountryName == teamCountryName))
{
currentLeague.Teams.Add(
context.Teams.Where(t => t.TeamName == teamName && t.Country.CountryName == teamCountryName).FirstOrDefault());
Console.WriteLine("Added team to league: {0} to league {1}", teamName, leagueName);
}
else
{
Console.WriteLine("Existing team in league: {0} belongs to {1}", teamName, leagueName);
}
}
else
{
if (!currentLeague.Teams.Any(t => t.TeamName == teamName))
{
currentLeague.Teams.Add(
context.Teams.Where(t => t.TeamName == teamName).FirstOrDefault());
context.SaveChanges();
Console.WriteLine("Added team to league: {0} to league {1}", teamName, leagueName);
}
else
{
Console.WriteLine("Existing team in league: {0} belongs to {1}", teamName, leagueName);
}
}
}
}
static void LeagueExistanceCheck(FootballEntities context, string leagueName)
{
if (!context.Leagues.Any(l => l.LeagueName == leagueName))
{
context.Leagues.Add(new League()
{
LeagueName = leagueName
});
context.SaveChanges();
Console.WriteLine("Created league: {0}", leagueName);
}
else
{
Console.WriteLine("Existing league: {0}", leagueName);
}
}
