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