public static void InsertOrUpdateGameResult1(int gameID, int profileDI, int score) { GameResult rs = (from grs in All().ToList() where grs.GameID == gameID && Profile.Single(p => p.AccountID == grs.AccountID).ProfileID== profileDI select grs).SingleOrDefault(); if (rs != null) // Update { if (rs.GameScores < score) { rs.GameScores = score; UpdateGameResult(rs); } } else // Insert { rs = new GameResult(); rs.GameScores = score; rs.GameID = gameID; rs.AccountID = Profile.Single(profileDI).AccountID; InsertGameResult(rs); } }
public static void InsertOrUpdateGameResult(int gameID, int UserID, int score) { GameResult rs = (from grs in All().ToList() where grs.GameID == gameID && grs.AccountID== UserID select grs).SingleOrDefault(); if (rs != null) // Update { if (rs.GameScores < score) { rs.GameScores = score; UpdateGameResult(rs); } } else // Insert { rs = new GameResult(); rs.GameScores = score; rs.GameID = gameID; rs.AccountID =UserID; InsertGameResult(rs); } }
public static void DeleteGameResult(GameResult gameResult) { Delete(gameResult.GameResultID); }
public static void UpdateGameResult(GameResult gr) { Update(gr); }
public static void InsertGameResult(GameResult gameResult) { Add(gameResult); }