public void InsertPlayer(DML.Player playerObject) { if (String.IsNullOrEmpty(playerObject.Name)) { throw new Exception("Nome do jogador necessário"); } IDispatcherPlayer.InsertPlayer(playerObject); }
public void Update(DML.Player oldPlayer) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.AppendLine("DECLARE @PASSWORD VARCHAR(30), @NAME VARCHAR(30), @ID INT"); stringBuilder.AppendLine($"SET @PASSWORD = '******'"); stringBuilder.AppendLine($"SET @NAME = '{oldPlayer.Name}'"); stringBuilder.AppendLine($"SET @ID = {oldPlayer.ID}"); stringBuilder.AppendLine("UPDATE USERS"); stringBuilder.AppendLine("SET NAME = @NAME,"); stringBuilder.AppendLine(" PASSWORD = @PASSWORD"); stringBuilder.AppendLine("WHERE ID @ID"); IUnitOfWork.Executar(stringBuilder.ToString()); }
public DML.Player GetPlayerInfo(int playerId) { var row = IUnitOfWork.Consulta($"SELECT * FROM USERS WITH(NOLOCK) WHERE ID = {playerId}").Tables[0].Rows[0]; var player = new DML.Player { ID = Convert.ToInt32(row["ID"]), Name = row["Name"].ToString(), Login = row["Login"].ToString(), Password = null, Code = row["Code"].ToString(), Money = Convert.ToDouble(row["Money"]) }; return(player); }
public void Update(DML.Player player) { if (player == null) { throw new ArgumentNullException("Player is required"); } var oldPlayer = FindPlayerByUserName(player.Login); if (oldPlayer == null) { throw new Exception("Player not found"); } oldPlayer.Name = player.Name ?? oldPlayer.Name; oldPlayer.Password = player.Password ?? oldPlayer.Password; IDispatcherPlayer.Update(oldPlayer); }
public void InsertPlayer(DML.Player playerObject) { IUnitOfWork.Executar(IUnitOfWork.MontaInsertPorAttributo(playerObject).ToString()); }