public void AddToDabase2()
{
string ConnectionString = "server=atr.eng.utah.edu;database=cs3500_schacher;uid=cs3500_schacher;password='******'";
Cube cube = new Cube(2, 4455, 454, 778, 9879879, "Joe", 4854, false, false);
cube.maxMass = 654656;
cube.startOfCube = DateTime.Now;
cube.deathOfCube = DateTime.Now;
cube.timeAlive = cube.deathOfCube - cube.startOfCube;
cube.countOfEatenCubes = 5;
cube.highestRank = 5;
using (MySqlConnection connect = new MySqlConnection(ConnectionString))
{
try
{
connect.Open();
SQLDatabase.AddPlayerToDatabase(cube);
string PlayerReadText = "SELECT ID FROM Players WHERE Name = @Name";
MySqlCommand PlayerReadCommand = connect.CreateCommand();
PlayerReadCommand.CommandText = PlayerReadText;
PlayerReadCommand.Parameters.AddWithValue("@Name", cube.Name);
string Name = "";
using (MySqlDataReader read = PlayerReadCommand.ExecuteReader())
{
Name = read["Name"].ToString();
}
Assert.AreEqual("Joe", Name);
}
catch
{
}
}
}
