static void Main(string[] args)
{
var context = new FootballEntities();
var teamName = context.Teams.Select(t => t.TeamName);
foreach (var name in teamName)
{
Console.WriteLine(name);
}
}
static void Main()
{
var context = new FootballEntities();
var leagues = context.Leagues.OrderBy(l => l.LeagueName).Select(l => new
{
Name = l.LeagueName,
LeagueTeams = l.Teams.OrderBy(t => t.TeamName).Select(t => t.TeamName)
}).ToList();
var json = new JavaScriptSerializer().Serialize(leagues);
System.IO.File.WriteAllText("../../leagues-and-teams.json", json);
//Console.WriteLine(json);
}
static void Main()
{
var context = new FootballEntities();
var internationalMatches = context.InternationalMatches
.OrderBy(im => im.MatchDate)
.ThenBy(im => im.CountriesHome.CountryName)
.ThenBy(im => im.CountriesAway.CountryName)
.Select(im => new
{
HomeScore = im.HomeGoals,
AwayScore = im.AwayGoals,
HomeCodeCountry = im.HomeCountryCode,
AwayCodecountry = im.AwayCountryCode,
Date = im.MatchDate,
HomeCountryName = im.CountriesHome.CountryName,
AwayCountryname = im.CountriesAway.CountryName,
matchleagueName = im.Leagues.LeagueName
}).ToList();
XElement matches = new XElement("matches");
foreach (var match in internationalMatches)
{
XElement xmlMatch = new XElement("match",
new XElement("home-country",
new XAttribute("code", match.HomeCodeCountry),
match.HomeCountryName
),
new XElement("away-country",
new XAttribute("code", match.AwayCodecountry),
match.AwayCountryname
)
);
if (match.matchleagueName != null)
{
xmlMatch.Add(new XElement("league", match.matchleagueName));
}
if (match.HomeScore != null && match.AwayScore != null)
{
xmlMatch.Add(new XElement("score",
match.HomeScore + "-" + match.AwayScore));
}
if (match.Date != null)
{
DateTime dateTime;
DateTime.TryParse(match.Date.ToString(), out dateTime);
if (dateTime.TimeOfDay.TotalSeconds == 0)
{
xmlMatch.Add(new XAttribute("date", dateTime.ToString("dd-MMM-yyyy")));
}
else
{
xmlMatch.Add(new XAttribute("date-time", dateTime.ToString("dd-MMM-yyyy hh:mm")));
}
}
matches.Add(xmlMatch);
}
Console.WriteLine(matches.ToString());
matches.Save("../../international-matches.xml");
}
