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(); } }