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