private void RegistrarCompra_Load(object sender, EventArgs e)
{
listaProductos = new List <ProductAccount>();
listaProveedores = new List <providerAccount>();
carrito = new List <ProductAccount>();
MySqlConnection conexion = Connection.GetConnection();
MySqlCommand cm = new MySqlCommand("SELECT id_prov, name_prov FROM provider", conexion);
MySqlDataReader consultar = cm.ExecuteReader();
while (consultar.Read())
{
providerAccount proveedor = new providerAccount();
proveedor.id_prov = consultar.GetInt32(0);
proveedor.name_prov = consultar.GetString(1);
listaProveedores.Add(proveedor);
ComboBoxItem item = new ComboBoxItem();
item.Text = $"{proveedor.id_prov} - {proveedor.name_prov}";
item.Value = proveedor.id_prov;
comboBox1.Items.Add(item);
comboBox1.SelectedIndex = 0;
}
}
private void Button1_Click(object sender, EventArgs e)
{
providerAccount newProviderAccount = new providerAccount();
newProviderAccount.name_prov = name_textbox.Text.Trim();
newProviderAccount.email_prov = textBox2.Text.Trim();
newProviderAccount.tel_prov = textBox1.Text.Trim();
newProviderAccount.location_prov = textBox3.Text.Trim();
if (string.IsNullOrEmpty(name_textbox.Text) || string.IsNullOrEmpty(textBox2.Text) || string.IsNullOrEmpty(textBox1.Text) || string.IsNullOrEmpty(textBox3.Text))
{
MessageBox.Show("Los campos no pueden quedar vacios", "Registro Proveedor", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MySqlConnection conexion = Connection.GetConnection();
MySqlCommand newProvider = new MySqlCommand();
newProvider.CommandText = "SELECT * FROM provider WHERE name_prov ";
newProvider.Parameters.AddWithValue("@newProviderAccount.name_prov", newProviderAccount.name_prov);
newProvider.Parameters.AddWithValue("@newProviderAccount.email_prov", newProviderAccount.email_prov);
newProvider.Parameters.AddWithValue("@newProvideraAccount.tel_prov", newProviderAccount.tel_prov);
newProvider.Parameters.AddWithValue("@newProviderAccount.location_prov", newProviderAccount.location_prov);
newProvider.Connection = conexion;
MySqlDataReader leer = newProvider.ExecuteReader();
if (leer.Read())
{
MessageBox.Show("El usuario ya existe", "Registro", MessageBoxButtons.OK, MessageBoxIcon.Error);
conexion.Close();
}
else
{
int resultado = RegisterNewProvider.agregar(newProviderAccount);
if (resultado > 0)
{
MessageBox.Show("Proveedor Registrado con Exito!", "Registro", MessageBoxButtons.OK, MessageBoxIcon.Information);
Elegir ToElegir = new Elegir();
this.Hide();
ToElegir.Show();
}
else
{
MessageBox.Show("No se pudo guardar a el Proveedor", "Registro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void button4_Click(object sender, EventArgs e)
{
if (comboBox2.Text != "" && numericUpDown1.Value != 0)
{
listaProductos[comboBox2.SelectedIndex].items = Convert.ToInt32(numericUpDown1.Value);
//agregamos al carrito
carrito.Add(listaProductos[comboBox2.SelectedIndex]);
ProductAccount producto = listaProductos[comboBox2.SelectedIndex];
providerAccount proveedor = listaProveedores[comboBox1.SelectedIndex];
double total = producto.purchasePrice_prod * Convert.ToDouble(numericUpDown1.Value);
Console.WriteLine(total);
//mostrar en datagrid
int n = dataGridView1.Rows.Add();
dataGridView1.Rows[n].Cells[0].Value = producto.id_prod;
dataGridView1.Rows[n].Cells[1].Value = producto.name_prod;
dataGridView1.Rows[n].Cells[2].Value = proveedor.name_prov;
dataGridView1.Rows[n].Cells[3].Value = producto.purchasePrice_prod;
dataGridView1.Rows[n].Cells[4].Value = total;
sumarTotal(total);
}
}
