private void btnGo_Click(object sender, EventArgs e)
{
if (txtQuery.Text == "")
{
return;
}
var dbCon = DBConnetion.Instance();
dbCon.DatabaseName = "ugc";
if (dbCon.IsConnect())
{
string query = txtQuery.Text; //" call clients_all()";//"SELECT * FROM tiers";
var cmd = new MySql.Data.MySqlClient.MySqlCommand(query, dbCon.Connection);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
int id = reader.GetInt16("id");
string code = (reader.IsDBNull(1)) ? "" : reader.GetString("code");
string famille = (reader.IsDBNull(2)) ? "" : reader.GetString("famille");
string raison = (reader.IsDBNull(3)) ? "" : reader.GetString("raison");
//raison = reader.GetString("raison");
decimal solde = reader.GetDecimal("solde");
string fixe = (reader.IsDBNull(5)) ? "" : reader.GetString("fixe");
string mobile = (reader.IsDBNull(6)) ? "" : reader.GetString("mobile");
string email = (reader.IsDBNull(7)) ? "" : reader.GetString("email");
string fax = (reader.IsDBNull(8)) ? "" : reader.GetString("fax");
decimal chiffre_affaire = reader.GetDecimal("chiffre_affaire");
string ville = (reader.IsDBNull(10)) ? "" : reader.GetString("ville");
string modereglement = (reader.IsDBNull(11)) ? "" : reader.GetString("modereglement");
string type = (reader.IsDBNull(12)) ? "" : reader.GetString("type");
string adresse = (reader.IsDBNull(13)) ? "" : reader.GetString("adresse");
txtResult.Text += id + "\t" + code + "\t" + raison + "\t"
+ fixe + "\t" + mobile + "\t" + fax + "\t" + email + "\t"
+ famille + "\t" + solde + "\t" + chiffre_affaire + "\t"
+ ville + "\t" + modereglement + "\t" + type + "\t" + adresse + "\r\n";
/*
* Console.WriteLine(id + "\t" + code + "\t" + raison + "\t"
+ fixe + "\t" + mobile + "\t" + fax + "\t" + email + "\t"
+ famille + "\t" + solde + "\t" + chiffre_affaire + "\t"
+ ville + "\t" + modereglement + "\t" + type + "\t" + adresse
+ );
*/
}
Console.WriteLine(reader.GetSchemaTable().TableName);
reader.Close();
// dbCon.Close();
}
}
//Funcion encargada de generar todos los loads del juego
private void Loading()
{
//Instanciacion del ArkanoidControl
ac = new ArkanoidControl
{
Dock = DockStyle.Fill,
Width = Width,
Height = Height
};
//Action GameEnded que vuelve al menu al terminar el juego
ac.GameEnded = () =>
{
MessageBox.Show("PERDISTE");
var menuForm = new Menu();
menuForm.Show();
Dispose();
};
//Action GameWon que vuelve al menu al ganar la partida y guarda los datos del ganador
ac.GameWon = () =>
{
var id = DBConnetion.RealizarConsulta($"select id from users where name='{TxtName.Text}'").Rows[0][0].
ToString();
var maximo = DBConnetion.RealizarConsulta($"select attempt from attempts" +
$" where id_user = '******' ORDER BY attempt DESC FETCH FIRST 1 ROWS ONLY");
int val;
if (maximo.Rows.Count == 0)
{
val = 1;
}
else
{
val = Convert.ToInt32(maximo.Rows[0][0].ToString()) + 1;
}
DBConnetion.RealizarAccion($"INSERT into ATTEMPTS(id_user,attempt,score) VALUES('{Convert.ToInt32(id)}', {val},{GameData.score})");
MessageBox.Show("GANASTE LA PARTIDA");
var menuForm = new Menu();
menuForm.Show();
Dispose();
};
}
private void openDbAnsBind()
{
var dbCon = DBConnetion.Instance();
dbCon.DatabaseName = "ugc";
if (dbCon.IsConnect())
{
MySqlDataAdapter Da = new MySqlDataAdapter();
string query = "Call clients_all()";
Da.SelectCommand = new MySqlCommand(query, dbCon.Connection);
DataTable table = new DataTable();
Da.Fill(table);
BindingSource bsource = new BindingSource();
bsource.DataSource = table;
dgClients.DataSource = bsource;
// dgClients.DataBindingComplete();
}
}
//funcion tipo Datatable que se encarga de obetener el top 10 de la base de datos
public static DataTable GetTopTen(ref List <string> headers)
{
List <ScoreModel> TopTen = new List <ScoreModel>();
DataTable TableScore = DBConnetion.RealizarConsulta($"select users.name as usuario, t.attempt as intento, t.score as puntaje from " +
$"(SELECT distinct on (id_user) id_user, attempt, score from attempts ORDER BY id_user, score DESC) as t " +
$"inner join users on t.id_user = users.id ORDER BY t.score desc fetch first 10 rows only");
foreach (DataColumn dc in TableScore.Columns)
{
headers.Add(dc.ColumnName);
}
foreach (DataRow dr in TableScore.Rows)
{
TopTen.Add(new ScoreModel(
dr[0].ToString(),
dr[1].ToString(),
dr[2].ToString()
));
}
return(TableScore);
}
//Evento el cual se encarga de cargar el ArkanoidControl y de cominar el nombre entre
//este Form y el ArkanoidContro
private void BtnPlay_Click(object sender, EventArgs e)
{
try
{
//se manda a llamar el InitializeGame para que se actualicen los datos al volver a jugar
GameData.InitializeGame();
//se cargan los Action y propiedades del ArkanoidControl
Loading();
//se invoca el delegate
gn?.Invoke(TxtName.Text);
string nombre = TxtName.Text;
//variable tipo data table
var consultar = DBConnetion.RealizarConsulta($"SELECT * FROM USERS " +
$"where name = '{nombre}'");
string agregar = $"INSERT into USERS(name) VALUES('{nombre}')";
//hacemos uso del delegate para comunicar el nombre entre este form y el arkanoud control
gn = nick =>
{
switch (TxtName.Text)
{
case string aux when aux.Length > 16:
throw new ExceededMaxCharactersException(
"No se puede ingresar un alias de mas de 16 caracteres");
case string aux when aux.Trim().Length == 0:
throw new EmpyNicknameException("Debe ingresar un nombre de usuario");
default: //en caso de que no se cumpla ningun caso de excepcion, se corre el juego
//verifiica si el usuario ya existe en la base de datos
if (consultar.Rows.Count == 1)
{
MessageBox.Show($"Bienvenido de nuevo {nick}", "Game");
tableLayoutPanel1.Hide();
Text = "Arkanoid";
}
//si no existe lo agrega
else
{
//Agregando User a DB
DBConnetion.RealizarAccion(agregar);
MessageBox.Show($"Gracias por registrarte {nick} \n Presiona OK para comenzar a jugar");
//Cambiando el control del tableLayout por ArkanoidControl
tableLayoutPanel1.Hide();
Text = "Arkanoid";
}
Controls.Add(ac);
break;
}
};
}
catch (ExceededMaxCharactersException ex)
{
MessageBox.Show(ex.Message);
}
catch (EmpyNicknameException ex)
{
MessageBox.Show(ex.Message);
}
}
