}//eom public void RecordGame(Game item) { if (item.HomeTeamID == item.VisitingTeamID) { throw new Exception("Home and Visiting teams cannot be be the same."); } using (var context = new FSISContext()) { context.Games.Add(item); Team hometeam = (from x in context.Teams where x.TeamID == item.HomeTeamID select x).FirstOrDefault(); Team visitingteam = (from x in context.Teams where x.TeamID == item.VisitingTeamID select x).FirstOrDefault(); if (item.HomeTeamScore > item.VisitingTeamScore) { hometeam.Wins += 1; visitingteam.Losses += 1; context.Entry(hometeam).Property(y => y.Wins).IsModified = true; context.Entry(visitingteam).Property(y => y.Losses).IsModified = true; } else { hometeam.Losses += 1; visitingteam.Wins += 1; context.Entry(hometeam).Property(y => y.Losses).IsModified = true; context.Entry(visitingteam).Property(y => y.Wins).IsModified = true; } context.SaveChanges(); } }
public int Update(Player item) { using (var context = new FSISContext()) { context.Entry(item).State = System.Data.Entity.EntityState.Modified; return(context.SaveChanges()); } }
public void Player_Update(Player info) { using (var context = new FSISContext()) { DbEntityEntry <Player> existing = context.Entry(info); existing.State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }