// Visar upp den första athelten som finns i databasen.
public static async Task <Athlete> ShowFirstAthelte()
{
var cont = new SnowboardAppContext();
var result = await cont.Athletes.FirstAsync <Athlete>();
return(result);
}
public static void UpdateMany()
{
{
var context = new SnowboardAppContext();
string contestEventName = "OS";
var contests = _context.Contests.Where(c => c.EventName.StartsWith(contestEventName)).ToList();
contests.ForEach(c => c.StartDate = new DateTime(2018, 04, 11));
contests.ForEach(c => c.EndDate = new DateTime(2018, 04, 12));
_context.SaveChanges();
}
}
public static void AddAthleteHomeResort()
{
var context = new SnowboardAppContext();
AthleteHomeResort athleteHomeResort1 = new AthleteHomeResort()
{
AthleteId = 1,
HomeResortId = 1
};
context.AthleteHomeResort.Add(athleteHomeResort1);
context.SaveChanges();
}
public static void AddAthleteToContest()
{
var context = new SnowboardAppContext();
AthleteContest athleteContest = new AthleteContest
{
AthleteId = 3,
ContestId = 1,
};
_context.AthleteContest.Add(athleteContest);
_context.SaveChanges();
}
public static void AddHomeResort()
{
var _context = new SnowboardAppContext();
HomeResort homeResort1 = new HomeResort
{
Name = "Oslo Tryvann Vinterpark",
Country = "Norway",
VerticalMeters = 1470
};
_context.HomeResorts.Add(homeResort1);
_context.SaveChanges();
}
private static void AddManyToManyObject()
{
var context = new SnowboardAppContext();
var athlete = new Athlete {
FirstName = "Torsten", LastName = "Horgmo", Age = 28, BirthCountry = "Norway",
};
var contest = context.Contests.Find(1);
context.Add(athlete);
context.Add(new AthleteContest {
Athlete = athlete, Contest = contest
});
context.SaveChanges();
}
public static void AddSnowboard()
{
var _context = new SnowboardAppContext();
Snowboard snowboard1 = new Snowboard
{
Brand = "Rome",
Name = "Ståle pro",
Length = 155,
AthelteId = 12,
};
_context.Snowboards.Add(snowboard1);
_context.SaveChanges();
}
public static void AddAthletes()
{
var _context = new SnowboardAppContext();
Athlete athlete1 = new Athlete {
FirstName = "Ståle", LastName = "Sandbeck", Age = 25, BirthCountry = "Norway"
};
Athlete athlete2 = new Athlete {
FirstName = "Xavier", LastName = "Delarue", Age = 32, BirthCountry = "France",
};
_context.Athletes.AddRange(athlete1, athlete2);
_context.SaveChanges();
}
private static void AddSnowboardsToAthelte()
{
var context = new SnowboardAppContext();
var snowboard = new Snowboard {
Brand = "Rome", Length = 150, Name = "SKS", AthelteId = 14
};
context.Add(snowboard);
context.SaveChanges();
var snowboard1 = new Snowboard {
Brand = "Brädan1337", Length = 1337, Name = "ELIT", AthelteId = 14
};
context.Add(snowboard1);
context.SaveChanges();
}
public static void AddContest()
{
var _context = new SnowboardAppContext();
Contest contest1 = new Contest
{
StartDate = new DateTime(2018 - 01 - 12),
EndDate = new DateTime(2018 - 01 - 16),
EventLocation = "Italy",
EventName = "Nine Knights",
FirstPlace = "Ståle Sandbeck",
SecondPlace = "Mark McMorris",
ThirdPlace = "Travis Rice"
};
_context.Contests.Add(contest1);
_context.SaveChanges();
}
public static void FindAthleteContest()
{
var context = new SnowboardAppContext();
var contests = context.Contests
.Include(c => c.Athletes)
.ThenInclude(ct => ct.Athlete)
.ToList();
foreach (var contest in contests)
{
Console.WriteLine(contest.EventName);
foreach (var athlete in contest.Athletes)
{
Console.WriteLine(athlete.Athlete.LastName);
}
}
}
