public Int32 Execute(Entities.GamePlayer player)
{
using (DbCommand cmd = _db.GetStoredProcCommand("GamePlayer_Insert"))
{
_db.AddInParameter(cmd, "@GameID", DbType.Int32, player.GameID);
_db.AddInParameter(cmd, "@UserId", DbType.Int32, player.User.UserId);
_db.AddInParameter(cmd, "@JoinDate", DbType.DateTime, DateTime.UtcNow);
_db.AddInParameter(cmd, "@Type", DbType.Int32, player.PlayerType);
_db.AddInParameter(cmd, "@IdlePlayCount", DbType.Int32, player.IdlePlayCount);
_db.AddOutParameter(cmd, "@TotalPlayers", DbType.Int32, sizeof(Int32));
_db.AddOutParameter(cmd, "@Points", DbType.Int32, sizeof(Int32));
_db.ExecuteScalar(cmd);
player.Points = Int32.Parse(_db.GetParameterValue(cmd, "Points").ToString());
return Int32.Parse(_db.GetParameterValue(cmd, "TotalPlayers").ToString());
}
}