public void Initialize()
{
CargoDAO cargoDao = new CargoDAO();
cargo1 = CreateCargo();
cargo2 = CreateCargo();
cargo2.Type = "newtype";
cargoDao.InsertCargo(cargo1);
cargoDao.InsertCargo(cargo2);
BaseDAO bas = new BaseDAO();
newBase = new Base();
newBase.Planet = "Země";
bas.InsertBase(newBase);
PlayerDAO playerDao = new PlayerDAO();
player = CreatePlayer();
playerDao.InsertPlayer(player);
SpaceShipDAO shipDao = new SpaceShipDAO();
ship = CreateSpaceShip();
shipDao.InsertSpaceShip(ship);
}
public void ClenUp()
{
PlayerDAO dao = new PlayerDAO();
int id = dao.GetPlayerByName("player").PlayerId;
dao.RemovePlayerById(id);
}
public DataManager()
{
//sqlConn = SqlConnHelper.Connect();
userDao = new UserDAO(SqlConnHelper.Connect());
playerDAO = new PlayerDAO(SqlConnHelper.Connect());
inventoryDAO = new InventoryDAO(SqlConnHelper.Connect());
}
public static void Initialise(string str)
{
AccountDao = new AccountDAO(str);
PlayerDao = new PlayerDAO(str);
PlayerDAO.UpdatePlayerThread.Start();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
board = new GameBoard();
pdao = new PlayerDAO(ConfigurationManager.ConnectionStrings["myConn"].ConnectionString);
string playerName = pdao.GetNamebyEmail(Session["currentEmail"].ToString());
int pid = pdao.GetIdByEmail(Session["currentEmail"].ToString());
player = new ConnectPlayer(pid, playerName, Session["currentEmail"].ToString());
bot = new ConnectBot(null, null);
game = new ConnectFour(bot, player, board);
tblBoard.GridLines = GridLines.Both;
printBoard();
Session.Add("board", board);
Session.Add("player", player);
Session.Add("bot", bot);
Session.Add("game", game);
}
else
{
board = (GameBoard)Session["board"];
player = (ConnectPlayer)Session["player"];
bot = (ConnectBot)Session["bot"];
game = (ConnectFour)Session["game"];
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (txtNickname.Text.Equals(""))
{
throw new EmptyNicknameException("");
}
if (txtNickname.Text.Length > 20)
{
throw new NicknameExceedMaxLength("");
}
PlayerDAO.insertPlayer(txtNickname.Text); //Se comprueba si existe o no el nickname en la base y se agrega si no existe
GlobalNickname = txtNickname.Text;
this.Hide();
var ventana = new Menu();
ventana.playername = txtNickname.Text;
ventana.Show();
}
catch (EmptyNicknameException exception)
{
MessageBox.Show("Nose puede dejar Campos Vacios");
}
catch (NicknameExceedMaxLength exce) {
MessageBox.Show("Has superado el maximo de caracteres disponible, intente nuevamente con menos de 20 caracteres");
}
}
/// <summary>
/// On validation, new user is registered.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnRegister_Click(object sender, EventArgs e)
{
// Starting a connection with the CasinoDB for User and Record tables.
playerDAO = new PlayerDAO(connString);
recordDAO = new RecordDAO(connString);
// Condition checks for duplicate account registrations.
if (playerDAO.UserNameExists(txtUsername.Text))
{
txtUsername.Text = "Username already exists.";
if (playerDAO.UserEmailExists(txtEmail.Text))
{
txtEmail.Text = "Email already exists.";
}
}
else
{
// Creates salted hash password for new registered player.
GeneratePasswordSaltedHash(txtPass.Text);
// Sets the new registered players starting balance.
int balance = Player.STARTING_BALANCE;
// Creates new instances of Player and Record for DAO classes.
Player player = new Player(txtUsername.Text, txtFirstName.Text, txtLastName.Text, txtEmail.Text, base64Password, base64Salt, balance);
Record record = new Record(player.UserName, 0, 0, 0, 0);
// Adds a new registered Player to User table and create their new record.
playerDAO.AddPlayer(player);
recordDAO.AddNewRecord(record);
// Redirects to MainMenu page when registration is complete.
Response.Redirect("/MainMenu.aspx");
}
}
//boton para iniciar juego.
private void BttnPlay_Click(object sender, EventArgs e)
{
try
{
//Obtener datos de usuario
var player = PlayerDAO.GetPlayer(txtNickname.Text);
//Verificar si el usuario existe
if (player.nickname.Equals(""))
{
throw new UserNotFoundException("El usuario no se encuentra registrado\n Presione agregar.");
}
else
{
MessageBox.Show($"Todo listo para jugar {player.nickname}!", "Arkanoid",
MessageBoxButtons.OK);
ControlArkanoid cont = new ControlArkanoid(player);
this.ActiveControl = null;
((frmGame)this.Parent).ShowControl(cont);
}
}
//capturar excepción
catch (Exception exception)
{
MessageBox.Show(exception.Message,
"Arkanoid", MessageBoxButtons.OK);
}
}
/// <summary>
/// Uses DAO to retrieve current users ID and email, then uses those to retrieve a list of results
/// for that user. Displays the user's name and number of wins for each game.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
playerDAO = new PlayerDAO(ConfigurationManager.ConnectionStrings["myConn"].ConnectionString);
resultDAO = new ResultDAO(ConfigurationManager.ConnectionStrings["myConn"].ConnectionString);
string playerName = playerDAO.GetNamebyEmail(Context.User.Identity.Name);
lblWelcomeMsg.Text = $"Welcome back, {playerName}!";
int playerID = playerDAO.GetIdByEmail(Context.User.Identity.Name);
List <Result> allResults = resultDAO.GetAllResultsByID(playerID);
int bCount = 0, cCount = 0, allCount = 0;
foreach (Result r in allResults)
{
if (r.HumanWin == 1)
{
allCount += 1;
if (r.GameID == "BLA")
{
bCount += 1;
}
else if (r.GameID == "CON")
{
cCount += 1;
}
}
}
lblBWins.Text = $"Blackjack Wins: {bCount}";
lblCWins.Text = $"Connect Four Wins: {cCount}";
lblAllWins.Text = $"You have {allCount} total wins!";
}
public void GetPlayerByEmailTest()
{
PlayerDAO dao = new PlayerDAO();
Player returnPlayer = dao.GetPlayerByEmail("*****@*****.**");
Assert.IsTrue(returnPlayer.PlayerId == player.PlayerId);
}
void OnClick()
{
PlayerDAO player = new PlayerDAO();
player.DeletePlayer();
UIController.instance.MostrarPanelNuevoJugador();
}
public void ClenUp()
{
PlayerDAO dao = new PlayerDAO();
dao.RemovePlayerById(playerFrom.PlayerId);
dao.RemovePlayerById(playerTo.PlayerId);
}
//Constructor for assigning fields for connections
public PlayerController()
{
//setting variable equal to the SqlConnection in appConfig
string connection = ConfigurationManager.ConnectionStrings["dataSource"].ConnectionString;
//setting fields equal to new variant connections
_dataAccess = new PlayerDAO(connection);
}
private void loadObjects()
{
//Login User combobox options
cmbUser1.DataSource = null;
cmbUser1.ValueMember = "password";
cmbUser1.DisplayMember = "nickname";
cmbUser1.DataSource = PlayerDAO.getPlayers();
}
public void GetPlayersTest()
{
PlayerDAO dao = new PlayerDAO();
List <Player> players = dao.GetPlayers();
Assert.IsNotNull(players);
Assert.IsTrue(players.Count > 0);
}
public Player Update(Guid id, Player item)
{
PlayerDAO dao = _context.Players.Find(id);
dao.Username = item.Username;
return(new Player(dao.Id, dao.Username));
}
public void GetPlayerByNameTest()
{
PlayerDAO dao = new PlayerDAO();
Player player = dao.GetPlayerByName("player");
Assert.IsNotNull(player);
Assert.IsTrue(player.PlayerName == "player");
}
public void Initializace()
{
//Database.SetInitializer(new CreateDatabaseIfNotExists<SpaceTrafficContext>());
PlayerDAO dao = new PlayerDAO();
player = CreatePlayer();
dao.InsertPlayer(player);
}
public void GetPlayerByIdTest()
{
PlayerDAO dao = new PlayerDAO();
int id = dao.GetPlayerByName("player").PlayerId;
Player player = dao.GetPlayerById(id);
Assert.IsTrue(player.PlayerId == id);
Assert.IsNotNull(player);
}
//create a method that will get all my players and place them in a list named _playerlist
public List <PlayerDAO> GetAllPlayers()
{
List <PlayerDAO> _playerlist = new List <PlayerDAO>();
try
{ //esablishing the connection for the database
using (SqlConnection _connection = new SqlConnection(connectionstring))
{ //establishing the command to pass to the database and defining the command
using (SqlCommand _command = new SqlCommand("sp_ReadAllPlayer", _connection))
{
_command.CommandType = CommandType.StoredProcedure;
//connect to the database
_connection.Open();
//open the SQL data reader
using (SqlDataReader _reader = _command.ExecuteReader())
{
//loop through the dataset or command and write each element to the _playerToList using the player object class
while (_reader.Read())
{
PlayerDAO _playerToList = new PlayerDAO();
_playerToList.PlayerID = _reader.GetInt32(0);
_playerToList.FirstName = _reader.GetString(1);
_playerToList.LastName = _reader.GetString(2);
_playerToList.birthdate = _reader.GetDateTime(3);
_playerToList.Height = _reader.GetDecimal(4);
_playerToList.TeamName = _reader.GetString(5);
_playerlist.Add(_playerToList);
}
}
}
}
}
catch (Exception error)
{
string message = string.Format("Time: {0}", DateTime.Now.ToString(""));
message += Environment.NewLine;
message += "---------------------------------------------------------";
message += Environment.NewLine;
message += string.Format("message {0}", error.Message);
message += Environment.NewLine;
message += string.Format("Stack Trace {0}", error.StackTrace);
message += Environment.NewLine;
message += string.Format("Source: {0}", error.Source);
message += Environment.NewLine;
message += string.Format("TargetSite: {0}", error.TargetSite.ToString());
message += Environment.NewLine;
message += "---------------------------------------------------------";
message += Environment.NewLine;
using (StreamWriter _writer = new StreamWriter("C:\\Users\admin2\\Desktop\\error stream", true))
{
_writer.WriteLine(message);
}
}
return(_playerlist);
}
public static void Initialize(string constr)
{
accountDAO = new AccountDAO(constr);
guildDAO = new GuildDAO(constr);
inventoryDAO = new InventoryDAO(constr);
playerDAO = new PlayerDAO(constr);
questDAO = new QuestDAO(constr);
skillDAO = new SkillsDAO(constr);
}
public bool ValidarLogin(string user, string pass)
{
playerDAO = new PlayerDAO();
if (playerDAO.ValidarLogin(user, pass) != null)
{
return(true);
}
return(false);
}
public void ClenUp()
{
PlayerDAO dao = new PlayerDAO();
dao.RemovePlayerById(player.PlayerId);
BaseDAO bas = new BaseDAO();
bas.RemoveBaseById(newBase.BaseId);
}
public void MostrarDatosPantallaInicio()
{
PlayerDAO player = new PlayerDAO();
labelOro.GetComponent <UILabel> ().text = "Oro: " + player.GetPlayer().Gold;
labelNombre.GetComponent <UILabel> ().text = "Nombre: " + player.GetPlayer().Name;
PokemonOwnedDAO pokemon = new PokemonOwnedDAO();
labelPokemon.GetComponent <UILabel>().text = "Pokemon: " + pokemon.GetOwnedPokemon().ToList().Count();
}
private void DeletePlayer(int playerID)
{
if (PlayerDAO.DeletePlayer(playerID))
{
MessageBox.Show("XÓA CẦU THỦ THÀNH CÔNG", "THÔNG BÁO");
}
else
{
MessageBox.Show("XÓA CẦU THỦ THẤT BẠI", "THÔNG BÁO");
}
}
void Update()
{
PlayerDAO player = new PlayerDAO();
PokemonOwnedDAO pk = new PokemonOwnedDAO();
EggOwnedDAO egg = new EggOwnedDAO();
Player p = player.GetPlayer();
labelNombre.GetComponent <UILabel>().text = "Perfil de " + p.Name;
labelOro.GetComponent <UILabel>().text = "Oro: " + p.Gold;
labelPokemon.GetComponent <UILabel> ().text = "Pokemon: " + pk.GetOwnedPokemon().ToList().Count();
labelHuevos.GetComponent <UILabel> ().text = "Huevos: " + egg.GetNotEquippedEggs().ToList().Count();
}
private void UpdatePlayer(int playerID, int clubID, string playerName, string position, string nationality,
DateTime birthday, float height, float weight)
{
if (PlayerDAO.UpdatePlayer(playerID, clubID, playerName, position, nationality, birthday, height, weight))
{
MessageBox.Show("CẬP NHẬT CẦU THỦ THÀNH CÔNG", "THÔNG BÁO");
}
else
{
MessageBox.Show("CẬP NHẬT CẦU THỦ THẤT BẠI", "THÔNG BÁO");
}
}
/// <summary>
/// Create message
/// </summary>
/// <returns>message</returns>
private Message CreateMessage()
{
PlayerDAO player = new PlayerDAO();
Message message = new Message();
message.Body = "Text zprávy";
message.From = playerFrom.PlayerName;
message.RecipientPlayerId = playerTo.PlayerId;
message.MetaInfo = "meta-info";
message.Type = "typ";
return(message);
}
public void Guardar(int id, int fichas)
{
playerDAO = new PlayerDAO();
if (fichas > 0)//Gano
{
playerDAO.Guardar(id, fichas, true);
}
else
{
playerDAO.Guardar(id, fichas, false);
}
}
private void BtnDone_Click(object sender, EventArgs e)
{
try
{
//Si el nombre ingresado no está vacío ni sobrepasa una longitud mayor a 20 caracteres
if (!txtUsername.Text.Trim().Equals("") && !(txtUsername.Text.Length > 20))
{
Player currentPlayer = PlayerDAO.CurrentPlayer(txtUsername.Text.ToUpper().Trim());
//Si el nickname no fue encontrado en la base de datos, se registra
if (currentPlayer.PlayerId == 0)
{
MessageBox.Show("User registered successfully!", "ARKANOID", MessageBoxButtons.OK,
MessageBoxIcon.Information);
currentPlayer.PlayerId = PlayerDAO.GetId(currentPlayer.Name);
}
else
{
MessageBox.Show("Welcome back!", "ARKANOID", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
Hide();
Skin skin = new Skin(currentPlayer);
skin.Dock = DockStyle.Fill;
Parent.Controls.Add(skin);
Parent.Controls.Remove(this);
}
else
{
if (txtUsername.Text.Trim().Length != 0)
{
throw new UsernameLengthException("Nickname too long.\nMax length: 20 characters.");
}
throw new EmptyNameException("Write a nickname.");
}
}
catch (EmptyNameException ex)
{
MessageBox.Show(ex.Message, "ARKANOID", MessageBoxButtons.OK,
MessageBoxIcon.Warning);
}
catch (UsernameLengthException ex)
{
MessageBox.Show(ex.Message, "ARKANOID", MessageBoxButtons.OK,
MessageBoxIcon.Warning);
}
finally
{
// Limpia el textBox para quitar los espacios.
txtUsername.Clear();
}
}
public void RemovePlayerByIdTest()
{
PlayerDAO dao = new PlayerDAO();
Player player = CreatePlayer();
player.PlayerName = "player2";
dao.InsertPlayer(player);
int id = dao.GetPlayerByName("player2").PlayerId;
dao.RemovePlayerById(id);
Assert.IsNull(dao.GetPlayerById(id));
}
public void ABPlayer()
{
PlayerDAO DAO = new PlayerDAO();
Players player = new Players();
player.User = "******";
player.Pass = "******";
player.Nombre = "Pedro";
player.Apellido = "Otero";
player.Email = "*****@*****.**";
player.Avatar = 6;
DAO.AltaPlayer(player);
player = DAO.ValidarLogin("Pepe", "1234");
Assert.IsNotNull(player);
DAO.BajaPlayer(player);
}
public bool ValidarLogin(string user, string pass)
{
playerDAO = new PlayerDAO();
if (playerDAO.ValidarLogin(user, pass) != null)
return true;
return false;
}
public void SignUp(Player p)
{
playerDAO = new PlayerDAO();
Players player = new Players();
player.User = p.User;
player.Pass = p.Pass;
player.Nombre = p.Nombre;
player.Apellido = p.Apellido;
player.Email = p.Email;
player.Avatar = p.Avatar;
playerDAO.AltaPlayer(player);
}
public void Guardar(int id, int fichas)
{
playerDAO = new PlayerDAO();
if(fichas > 0)//Gano
playerDAO.Guardar(id, fichas, true);
else
playerDAO.Guardar(id, fichas, false);
}
public void Comprar(int id, double fichas)
{
playerDAO = new PlayerDAO();
playerDAO.Comprar(id, fichas);
}
public Player Buscar(string user, string pass)
{
playerDAO = new PlayerDAO();
Players datos = playerDAO.BuscarUsuario(user, pass);
Player player = new Player();
player.Id = datos.Id;
player.Pass = datos.Pass;
player.Nombre = datos.Nombre;
player.Apellido = datos.Apellido;
player.Efectivo = Convert.ToInt32(datos.Efectivo);
player.Email = datos.Email;
player.Fichas = Convert.ToInt32(datos.Fichas);
player.Jugadas = datos.Jugadas;
player.Victorias = datos.Victorias;
player.Avatar = datos.Avatar;
player.User = datos.User;
return player;
}
