public static void AddSetsInMatch(Set set, MatchesInTournament mit) { var ctx = new CybersportDBEntities(); set.SetID = Guid.NewGuid(); set.MatchID = mit.MathID; set.MatchesInTournament = ctx.MatchesInTournaments.FirstOrDefault(t => t.MathID == set.MatchID); set.Map = ctx.Maps.FirstOrDefault(t => t.MapID == set.MapID); ctx.Sets.Add(set); ctx.SaveChanges(); }
public static void AddMatchInChamp(MatchesInTournament mit) { var ctx = new CybersportDBEntities(); mit.MathID = Guid.NewGuid(); mit.Date = DateTime.Today; mit.Tournament = ctx.Tournaments.FirstOrDefault(t => t.TournamentID == mit.TournamentID); mit.Team = ctx.Teams.FirstOrDefault(t => t.TeamID == mit.FirstTeamID); mit.Team1 = ctx.Teams.FirstOrDefault(t => t.TeamID == mit.SecondTeamID); ctx.MatchesInTournaments.Add(mit); ctx.SaveChanges(); }
public static void SetTeamResult(MatchesInTournament mit) { var ctx = new CybersportDBEntities(); var li = ctx.Sets.Where(x => x.MatchID == mit.MathID).ToList(); int firstTeamReasult = 0, secondTeamResult = 0; foreach (Set s in li) { firstTeamReasult += s.FirstTeam; secondTeamResult += s.SecondTeam; } Team t = mit.Team; Team t1 = mit.Team1; if (firstTeamReasult > secondTeamResult) { t.Wins += 1; t1.Defeats += 1; t.Rating += 10; } if (firstTeamReasult == secondTeamResult) { t.Draws += 1; t1.Draws += 1; t.Rating += 5; t1.Rating += 5; } if (firstTeamReasult < secondTeamResult) { t.Defeats += 1; t1.Wins += 1; t1.Rating += 10; } SetPlayersResults(t, firstTeamReasult); SetPlayersResults(t1, secondTeamResult); EditTeam(t); EditTeam(t1); ctx.SaveChanges(); }