namespace WindowsFormsApplication6
{
    public partial class Form9 : Form
    {
        public Form9()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            int cod = 0;
            int quant = 0;
            string cs = "data source=localhost; database=produtos; user id=root; pwd=''";
            MySqlConnection liga = new MySqlConnection(cs);
            string query = "update produto set quant = ?m where cod=?n";
            string query2 = "select * from produto where cod =?n";
            try
            {
                MySqlCommand cmd = new MySqlCommand(query, liga);
                MySqlCommand cmd2 = new MySqlCommand(query2, liga);
                cmd2.Parameters.AddWithValue("?n", textBox1.Text);
                liga.Open();
                MySqlDataReader leitor = cmd2.ExecuteReader();
                while (leitor.Read())
                {
                     cod = Convert.ToInt32(leitor.GetString("cod"));
                     quant = Convert.ToInt32(leitor.GetString("quant"));
                }
                leitor.Close();
                cmd.Parameters.AddWithValue("?n", cod);
                cmd.Parameters.AddWithValue("?m", quant + Convert.ToInt32(textBox2.Text));
                cmd.ExecuteNonQuery();

            }
            catch (MySqlException ex)
            {
                MessageBox.Show(ex.Message);
            }

            finally
            {
                liga.Close();
            }
        }

        private void button3_Click(object sender, EventArgs e)
        {
            /*int cod = 0;
            int quant = 0;
            int valor = 0;
            string cs = "data source=localhost; database=produtos; user id=root; pwd=''";
            MySqlConnection liga = new MySqlConnection(cs);
            string query = "insert into venda (cod, quant, custo) values (?n, ?m, ?c)";
            string query2 = "select * from produto where cod =?n";
            try
            {
                MySqlCommand cmd = new MySqlCommand(query, liga);
                MySqlCommand cmd2 = new MySqlCommand(query2, liga);
                cmd2.Parameters.AddWithValue("?n", textBox1.Text);
                liga.Open();
                MySqlDataReader leitor = cmd2.ExecuteReader();
                while (leitor.Read())
                {
                    cod = Convert.ToInt32(leitor.GetString("cod"));
                    quant = Convert.ToInt32(leitor.GetString("quant"));
                    valor = Convert.ToInt32(leitor.GetString("valor"));
                }
                leitor.Close();
                cmd.Parameters.AddWithValue("?n", cod);
                cmd.Parameters.AddWithValue("?m", Convert.ToInt32(textBox2.Text));
                cmd.Parameters.AddWithValue("?c", valor * quant);
                cmd.ExecuteNonQuery();

            }
            catch (MySqlException ex)
            {
                MessageBox.Show(ex.Message);
            }

            finally
            {
                liga.Close();
            }*/
        }

        private void button2_Click(object sender, EventArgs e)
        {
            int cod = 0;
            int quant = 0;
            int valor = 0;
            string cs = "data source=localhost; database=produtos; user id=root; pwd=''";
            MySqlConnection liga = new MySqlConnection(cs);
            string query = "update produto set quant = ?m where cod=?n";
            string query2 = "select * from produto where cod =?n";
            string query3 = "insert into venda (cod, quant, custo) values (?n, ?m, ?c)";

            try
            {
                MySqlCommand cmd = new MySqlCommand(query, liga);
                MySqlCommand cmd2 = new MySqlCommand(query2, liga);
                MySqlCommand cmd3 = new MySqlCommand(query3, liga);
                cmd2.Parameters.AddWithValue("?n", textBox1.Text);
                liga.Open();
                MySqlDataReader leitor = cmd2.ExecuteReader();
                while (leitor.Read())
                {
                    cod = Convert.ToInt32(leitor.GetString("cod"));
                    quant = Convert.ToInt32(leitor.GetString("quant"));
                    valor = Convert.ToInt32(leitor.GetString("valor"));
                }
                leitor.Close();
                if (quant > Convert.ToInt32(textBox2.Text))
                {
                cmd.Parameters.AddWithValue("?n", cod);
                cmd.Parameters.AddWithValue("?m", quant - Convert.ToInt32(textBox2.Text));
                cmd.ExecuteNonQuery();
                cmd3.Parameters.AddWithValue("?n", cod);
                cmd3.Parameters.AddWithValue("?m", Convert.ToInt32(textBox2.Text));
                cmd3.Parameters.AddWithValue("?c", valor * Convert.ToInt32(textBox2.Text));
                cmd3.ExecuteNonQuery();
                } else MessageBox.Show("Query falhada!");
            }
            catch (MySqlException ex)
            {
                MessageBox.Show(ex.Message);
            }

            finally
            {
                liga.Close();
            }
        }
    }
}