private void button1_Click(object sender, EventArgs e)
{
if (textBoxnamecomplete.Text.Equals("") ||
textBoxnameuser.Text.Equals("") ||
textBoxpassword.Text.Equals(""))
{
MessageBox.Show("No se pueden dejar campos vacios");
}
else
{
try
{
ConnectionBD.ExecuteNonQuery($"INSERT INTO APPUSER(fullname,username,password,usertype,activo) VALUES( " +
$"'{textBoxnamecomplete.Text.ToString()}' ," +
$"'{textBoxnameuser.Text.ToString()}'," +
$"'{textBoxpassword.Text.ToString()}', " +
$"'{comboBoxadmi.SelectedItem.ToString()}' , " +
$"{true})");
MessageBox.Show("Usuario guardado exitosamente");
}
catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un error");
}
}
}
private void button1agregar_Click(object sender, EventArgs e)
{
if (textBoxnombreproduct.Text.Equals(""))
{
MessageBox.Show("No se pueden dejar campos vacios");
}
else
{
try
{
string query = $"SELECT B.idBusiness FROM BUSINESS B WHERE B.name='{comboBoxempresa.Text.ToString()}' ";
var dt2 = ConnectionBD.ExecuteQuery(query);
var dr2 = dt2.Rows[0];
var idBusiness = dr2[0].ToString();
ConnectionBD.ExecuteNonQuery($"INSERT INTO PRODUCT(idBusiness,name) VALUES( " +
$"'{idBusiness}' ," +
$"'{textBoxnombreproduct.Text.ToString()}') ");
MessageBox.Show("Producto guardado exitosamente");
}
catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un error");
}
}
}
// Crear jugador en la base de datos
public static bool CreatePlayer(string username)
{
var dt = ConnectionBD.ExecuteQuery($"SELECT * FROM PLAYER WHERE username = '******'");
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
ConnectionBD.ExecuteNonQuery("INSERT INTO PLAYER(username) VALUES" +
$"('{username}')");
return(false);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBoxuser.Text.Equals("") ||
textBoxdireccion.Text.Equals(""))
{
MessageBox.Show("No se pueden dejar campos vacios");
}
else
{
try
{
DateTime fecha = new DateTime();
string sfecha = fecha.ToString("MM/dd/yyyy");
string query2 = $"SELECT idproduct FROM product WHERE name='{comboBoxmenu.Text.ToString()}' ";
var dt2 = ConnectionBD.ExecuteQuery(query2);
var dr2 = dt2.Rows[0];
var idProduct = dr2[0].ToString();
string query3 = $"SELECT iduser FROM appuser WHERE username='******' ";
var dt3 = ConnectionBD.ExecuteQuery(query2);
var dr3 = dt3.Rows[0];
var idUSER = dr3[0].ToString();
string query = $"SELECT a.idaddress FROM ADDRESS a, APPUSER U WHERE U.iduser=a.iduser and a.address='{textBoxdireccion.Text.ToString()}' ";
var dt = ConnectionBD.ExecuteQuery(query);
var dr = dt.Rows[0];
var idAddres = dr[0].ToString();
ConnectionBD.ExecuteNonQuery($"INSERT INTO ADDORDER(createdate,idproduct,idaddress,activo) VALUES( " +
$"'{sfecha}' , " +
$"{idProduct} , " +
$"{idAddres}, " +
$"{true} ");
ConnectionBD.ExecuteNonQuery($"INSERT INTO ADDRESS(iduser,address,activo)VALUES({idUSER},'{textBoxdireccion.Text.ToString()}' , " +
$"{true} ) ");
MessageBox.Show("Pedido guardado exitosamente");
}
catch (Exception ex)
{
MessageBox.Show("Pedido guardado exitosamente");
}
}
}
private void buttoneliminar_Click(object sender, EventArgs e)
{
if (textBoxID.Text.Equals(""))
{
MessageBox.Show("No se puede dejar datos vacios");
}
else
{
try
{
ConnectionBD.ExecuteNonQuery($"UPDATE APPORDER set activo={false}" +
$" WHERE idOrder='{textBoxID.Text.ToString()}' ");
MessageBox.Show("Orden eliminada exitosamente");
}
catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un problema");
}
}
}
private void buttoneliminar_Click(object sender, EventArgs e)
{
ConnectionBD.ExecuteNonQuery($"UPDATE APPUSER set activo='false' WHERE username='******' ");
MessageBox.Show("Usuario eliminado exitosamente");
}
// Agregar score al jugador cuando ha ganado el juego
public static void CreateNewScore(string player, int score)
{
ConnectionBD.ExecuteNonQuery(string.Format("insert into score(score, playerid) select {0}, pl.playerid from player pl where pl.username = '******' ", score, player));
}