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