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)); }