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