public List <Teams> GetTeams()
{
var db = new SportContext();
var teams = db.Teams.ToList();
return(teams);
}
public List <Sports> GetSports()
{
var db = new SportContext();
var sports = db.Sports.ToList();
return(sports);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory,
SportContext sportContext)
{
loggerFactory.AddConsole();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
sportContext.EnsureSeedDataForContext();
AutoMapper.Mapper.Initialize(cfg => {
cfg.CreateMap <Entities.Activity, Model.Activity>();
cfg.CreateMap <Model.ActivityForCreationAndUpdate, Entities.Activity>();
cfg.CreateMap <Model.ClientActivityForCreation, Entities.ClientActivity>();
cfg.CreateMap <Entities.ClientActivity, Model.ClientActivity>();
});
app.UseIdentityServerAuthentication(new IdentityServerAuthenticationOptions
{
/*Authority = "http://localhost:5001",
*
* ApiName = "postman_api",
* AllowedScopes = {"postman_api"},
*
* RequireHttpsMetadata = false*/
Authority = "https://localhost:44382/",
RequireHttpsMetadata = true,
ApiName = "sportapi"
});
app.UseMvc();
}
public List <Games> GetGames()
{
var db = new SportContext();
var games = db.Games.ToList();
return(games);
}
public async Task Invoke(HttpContext context, SportContext dbContext)
{
string path = context.Request.Path.Value.ToLower();
object data = null;
if (path == "/")
{
data = dbContext.Visitors.Last();
}
if (path == "/home/Index")
{
data = dbContext.Visitors.Last();
}
if (path == "/home/instructor")
{
data = dbContext.Instructors.Last();
}
if (path == "/home/group")
{
data = dbContext.Groups.Last();
}
if (path == "/home/timetable")
{
data = dbContext.Timetables.Last();
}
var dataTmp = data;
if (!_memoryCache.TryGetValue(path, out dataTmp))
{
_memoryCache.Set(path, data, new MemoryCacheEntryOptions().SetAbsoluteExpiration(TimeSpan.FromSeconds(272)));
}
await _next.Invoke(context);
}
public LeagueController(LeagueContext context, SportContext sportContext, TeamContext teamContext, MatchContext matchContext)
{
_context = context;
_sportContext = sportContext;
_teamContext = teamContext;
_matchContext = matchContext;
}
public async Task <long> GetPlayersForTeam(int teamId)
{
return(await Task.Run(() =>
{
Stopwatch watch = new Stopwatch();
watch.Start();
using (SportContext context = new SportContext())
{
var players = context.Teams.Where(x => x.Id == teamId).SelectMany(y => y.Players).Select(p => new PlayerDTO()
{
Id = p.Id,
FirstName = p.FirstName,
DateOfBirth = p.DateOfBirth,
LastName = p.LastName,
Kids = p.Kids.Select(k => new KidDTO()
{
PlayerId = p.Id,
DateOfBirth = k.DateOfBirth,
FirstName = k.FirstName,
LastName = k.LastName,
Id = k.Id
}).ToList()
}).ToList();
}
watch.Stop();
return watch.ElapsedMilliseconds;
}));
}
public async Task <long> GetPlayerByID(int id)
{
return(await Task.Run(() =>
{
Stopwatch watch = new Stopwatch();
watch.Start();
using (SportContext context = new SportContext())
{
var player = context.Players.Select(p => new PlayerDTO()
{
Id = p.Id,
FirstName = p.FirstName,
DateOfBirth = p.DateOfBirth,
LastName = p.LastName,
Kids = p.Kids.Select(k => new KidDTO()
{
PlayerId = p.Id,
DateOfBirth = k.DateOfBirth,
FirstName = k.FirstName,
LastName = k.LastName,
Id = k.Id
}).ToList()
}).FirstOrDefault(x => x.Id == id);
}
watch.Stop();
return watch.ElapsedMilliseconds;
}));
}
public static void Reset()
{
using (SportContext context = new SportContext())
{
context.Database.Initialize(true);
}
}
public ActionResult Index(int id)
{
var sportContext = new SportContext();
var model = sportContext.Sports.Single(sport => sport.Id == id);
return(View(model));
}
public static void AddSports(List <Sport> teams)
{
using (SportContext sc = new SportContext())
{
sc.Sports.AddRange(teams);
sc.SaveChanges();
}
}
public static void AddPlayers(List <Player> players)
{
using (SportContext sc = new SportContext())
{
sc.Players.AddRange(players);
sc.SaveChanges();
}
}
public void Dispose()
{
if (_db != null)
{
_db.Dispose();
_db = null;
}
}
public static void Reset()
{
using (SportContext context = new SportContext())
{
context.Database.ExecuteSqlCommand("TRUNCATE TABLE Player");
context.Database.ExecuteSqlCommand("TRUNCATE TABLE Team");
context.Database.ExecuteSqlCommand("TRUNCATE TABLE Sport");
}
}
public static void Reset()
{
using (SportContext context = new SportContext())
{
context.Database.ExecuteSqlCommand("DELETE FROM Player");
context.Database.ExecuteSqlCommand("DELETE FROM Team");
context.Database.ExecuteSqlCommand("DELETE FROM Sport");
}
}
protected override IQueryable <Game> GetQuery(SportContext context)
{
return(context.Games
.Include(x => x.HomeTeam)
.ThenInclude(x => x.Tournament)
.Include(x => x.GuestTeam)
.ThenInclude(x => x.Tournament)
.Include(x => x.Result)
.Include(x => x.Round));
}
public long GetPlayersForTeam(int teamId)
{
Stopwatch watch = new Stopwatch();
watch.Start();
using (SportContext context = new SportContext())
{
var players = context.Players.Where(x => x.TeamId == teamId).ToList();
}
watch.Stop();
return(watch.ElapsedMilliseconds);
}
public long GetTeamsForSport(int sportId)
{
Stopwatch watch = new Stopwatch();
watch.Start();
using (SportContext context = new SportContext())
{
var players = context.Teams.Include(x => x.Players).Where(x => x.SportId == sportId).ToList();
}
watch.Stop();
return(watch.ElapsedMilliseconds);
}
public long GetPlayerByID(int id)
{
Stopwatch watch = new Stopwatch();
watch.Start();
using (SportContext context = new SportContext())
{
var player = context.Players.Where(x => x.Id == id).First();
}
watch.Stop();
return(watch.ElapsedMilliseconds);
}
private static void AddSports(List <SportDTO> sports)
{
using (SportContext context = new SportContext())
{
List <Sport> sportsMapped = new List <Sport>();
foreach (var sport in sports)
{
sportsMapped.Add(new Sport()
{
Id = sport.Id,
Name = sport.Name
});
}
context.BulkInsert(sportsMapped);
}
}
private static void AddSports(List <SportDTO> sports)
{
using (SportContext context = new SportContext())
{
foreach (var sport in sports)
{
context.Sports.Add(new Sport()
{
Id = sport.Id,
Name = sport.Name
});
}
context.SaveChanges();
}
}
private static void AddSports(List <SportDTO> sports)
{
using (SportContext context = new SportContext())
{
var list = new List <Sport>(sports.Count);
foreach (var sport in sports)
{
list.Add(new Sport()
{
Id = sport.Id,
Name = sport.Name
});
}
context.Sports.AddRange(list);
context.SaveChanges();
}
}
private static void AddTeams(List <TeamDTO> teams)
{
using (SportContext context = new SportContext())
{
List <Team> teamsMapped = new List <Team>();
foreach (var team in teams)
{
teamsMapped.Add(new Team()
{
Name = team.Name,
Id = team.Id,
SportId = team.SportId,
FoundingDate = team.FoundingDate
});
}
context.BulkInsert(teamsMapped);
}
}
public async Task <long> GetPlayerByID(int id)
{
return(await Task.Run(() =>
{
Stopwatch watch = new Stopwatch();
watch.Start();
using (SportContext context = new SportContext())
{
var player = context.Players
.Include(x => x.Kids)
.Include(x => x.Teams)
.AsNoTracking()
.FirstOrDefault(x => x.Id == id);
}
watch.Stop();
return watch.ElapsedMilliseconds;
}));
}
public async Task <long> GetTeamsForSport(int sportId)
{
return(await Task.Run(() =>
{
Stopwatch watch = new Stopwatch();
watch.Start();
using (SportContext context = new SportContext())
{
var players =
context.Teams
.Include(x => x.Players.Select(y => y.Kids))
.AsNoTracking()
.Where(x => x.SportId == sportId).ToList();
}
watch.Stop();
return watch.ElapsedMilliseconds;
}));
}
private static void AddTeams(List <TeamDTO> teams)
{
using (SportContext context = new SportContext())
{
foreach (var team in teams)
{
context.Teams.Add(new Team()
{
Name = team.Name,
Id = team.Id,
SportId = team.SportId,
FoundingDate = team.FoundingDate
});
}
context.SaveChanges();
}
}
public async Task <long> GetPlayersForTeam(int teamId)
{
return(await Task.Run(() =>
{
Stopwatch watch = new Stopwatch();
watch.Start();
using (SportContext context = new SportContext())
{
var players = context.Teams.Where(x => x.Id == teamId)
.SelectMany(x => x.Players)
.Include(x => x.Kids)
.Include(x => x.Teams)
.AsNoTracking()
.ToList();
}
watch.Stop();
return watch.ElapsedMilliseconds;
}));
}
private static void AddPlayers(List <PlayerDTO> players)
{
using (SportContext context = new SportContext())
{
foreach (var player in players)
{
context.Players.Add(new Player()
{
FirstName = player.FirstName,
LastName = player.LastName,
DateOfBirth = player.DateOfBirth,
TeamId = player.TeamId,
Id = player.Id
});
}
context.SaveChanges();
}
}
public static void EnsureSeedDataForContext(this SportContext context)
{
if (context.Activities.Any())
{
return;
}
var activities = new List <Activity>()
{
new Activity()
{
Name = "Yoga",
Beginning = new DateTime(2017, 12, 3, 15, 0, 0),
Ending = new DateTime(2017, 12, 3, 16, 0, 0),
TrainerId = "1"
}
};
context.Activities.AddRange(activities);
context.SaveChanges();
}
private static void AddKids(List <KidDTO> kids)
{
using (SportContext context = new SportContext())
{
var list = new List <Kid>(kids.Count);
foreach (var kid in kids)
{
list.Add(new Kid()
{
FirstName = kid.FirstName,
LastName = kid.LastName,
DateOfBirth = kid.DateOfBirth,
PlayerId = kid.PlayerId,
Id = kid.Id,
});
}
context.Kids.AddRange(list);
context.SaveChanges();
}
}
