private void UpdatePlayer(int playerID, Player player) { const string updateCommand = "UPDATE [PLAYER] SET [Nickname] = @Nickname, [LastTimePlayedChanged] = @CurrentDate, [LastChanged] = @CurrentDate WHERE [ID] = @ID"; DateTime now = DateTime.Now; SqlHelper.ExecuteNonQuery(updateCommand, "CurrentDate", now, "Nickname", player.Nickname, "ID", playerID); IPlayerSerializable playerSerializable = player; playerSerializable.LastTimePlayedChanged = now; playerSerializable.LastChanged = now; }
private static void AssignPlayerFromDataRow(Player player, DataRow row) { player.Nickname = Convert.ToString(row["Nickname"]); player.Login = Convert.ToString(row["Login"]); IPlayerSerializable playerSerializable = player; playerSerializable.ID = Convert.ToInt32(row["ID"]); playerSerializable.Created = Convert.ToDateTime(row["Created"]); playerSerializable.LastChanged = row["LastChanged"] == DBNull.Value ? null : (DateTime?)Convert.ToDateTime(row["LastChanged"]); playerSerializable.LastTimePlayedChanged = Convert.ToDateTime(row["LastTimePlayedChanged"]); playerSerializable.Wins = Convert.ToUInt32(row["Wins"]); playerSerializable.TimePlayed = TimeSpan.FromMilliseconds(Convert.ToInt64(row["TimePlayed"])); }
public void CreateOrUpdate(Player player) { if (player == null) { throw new ArgumentNullException("player"); } if (player.Login.IsNullOrTimmedEmpty()) { throw new ArgumentException("Login is null or empty."); } if (player.Nickname.IsNullOrTimmedEmpty()) { throw new ArgumentException("Nickname is null or empty."); } Dictionary <string, object> parameters = new Dictionary <string, object> { { "Login", player.Login.Trim() }, { "Nickname", player.Nickname.Trim() } }; DataTable resultTable = SqlHelper.ExecuteDataTable("Player_CreateOrUpdate", parameters); if (resultTable.Rows.Count > 0) { IPlayerSerializable playerSerializable = player; DataRow row = resultTable.Rows[0]; playerSerializable.ID = Convert.ToInt32(row["ID"]); playerSerializable.Created = Convert.ToDateTime(row["Created"]); playerSerializable.LastChanged = row["LastChanged"] == DBNull.Value ? null : (DateTime?)Convert.ToDateTime(row["LastChanged"]); playerSerializable.LastTimePlayedChanged = Convert.ToDateTime(row["LastTimePlayedChanged"]); playerSerializable.Wins = Convert.ToUInt32(row["Wins"]); playerSerializable.TimePlayed = TimeSpan.FromMilliseconds(Convert.ToInt64(row["TimePlayed"])); } }