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