public static void ModifyMatch(int id, int tournamentId, int homeTeamId, int awayTeamId, DateTime date, string type, int?homeScore, int?awayScore, bool isComfired) { using (var db = new EC2016CodeFirst()) { Match match = db.Matches.Where(m => m.Id == id).First(); match.TournamentId = tournamentId; match.HomeTeamId = homeTeamId; match.AwayTeamId = awayTeamId; match.Date = date; match.Type = type; match.HomeScore = homeScore; match.AwayScore = awayScore; match.isConfirmed = isComfired; var entry = db.Entry(match); entry.Property(e => e.TournamentId).IsModified = true; entry.Property(e => e.HomeTeamId).IsModified = true; entry.Property(e => e.AwayTeamId).IsModified = true; entry.Property(e => e.Date).IsModified = true; entry.Property(e => e.Type).IsModified = true; entry.Property(e => e.HomeScore).IsModified = true; entry.Property(e => e.AwayScore).IsModified = true; entry.Property(e => e.isConfirmed).IsModified = true; db.SaveChanges(); } }
public static void ModifyGuess(string userId, int matchId, int homeScore, int awayScore) { using (var db = new EC2016CodeFirst()) { Guess guess = db.Guesses.Where(g => g.UserId == userId && g.MatchId == matchId).First(); guess.HomeScore = homeScore; guess.AwayScore = awayScore; db.Guesses.Attach(guess); var entry = db.Entry(guess); entry.Property(e => e.HomeScore).IsModified = true; entry.Property(e => e.AwayScore).IsModified = true; db.SaveChanges(); } }
public static int AddResultForMatch(int matchId, int homeScore, int awayScore) { using (var db = new EC2016CodeFirst()) { Match match = db.Matches.Where(m => m.Id == matchId).First(); match.HomeScore = homeScore; match.AwayScore = awayScore; db.Matches.Attach(match); var entry = db.Entry(match); entry.Property(e => e.HomeScore).IsModified = true; entry.Property(e => e.AwayScore).IsModified = true; return(match.Id); } }