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"); } } }
private void AddProduct_Load(object sender, EventArgs e) { var name = ConnectionBD.ExecuteQuery("SELECT name FROM BUSINESS "); var nameCombo = new List <string>(); foreach (DataRow dr in name.Rows) { nameCombo.Add(dr[0].ToString()); } comboBoxempresa.DataSource = nameCombo; }
private void EliminateUser_Load(object sender, EventArgs e) { var user = ConnectionBD.ExecuteQuery("SELECT username FROM APPUSER where activo='true'"); var userCombo = new List <string>(); foreach (DataRow dr in user.Rows) { userCombo.Add(dr[0].ToString()); } comboBoxusuarios.DataSource = userCombo; }
// 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 buttonverpedido_Click(object sender, EventArgs e) { if (textBoxusuario.Text.Equals("")) { MessageBox.Show("No se puede dejar datos vacios"); } else { try { var dt = ConnectionBD.ExecuteQuery("select o.idOrder,p.name,o.createdate,b.name,a.address from address a,apporder o,business b,product p,APPUSER u " + $"\n\twhere a.idAddress=o.idOrder \n\tand o.idProduct=p.idProduct\n\tand p.idBusiness=b.idBusiness\n\tand a.idUser=u.idUser " + $" \n\tand u.username= '******' and o.activo=true"); dataGridView1.DataSource = dt; MessageBox.Show("Datos obtenidos exitosamente"); } catch (Exception ex) { MessageBox.Show("Ha ocurrido un problema"); } } }