private void button4_Click(object sender, EventArgs e)
        {
            if (validation() == 0)
            {
                errorProvider1.Clear();


                con.Open();
                SqlCommand cmd = con.CreateCommand();
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = "insert into sale_order values ('" + textBox8.Text + "','" + textBox11.Text + "','" + textBox2.Text + "','" + this.dateTimePicker1.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox10.Text + "')";
                //cmd.CommandText = "update vehicle set v_quantity = v_quantity - '" + textBox6.Text + "' where v_id = '" + textBox2.Text + "'";
                cmd.ExecuteNonQuery();
                con.Close();


                con.Open();
                SqlCommand cmd1 = con.CreateCommand();
                cmd1.CommandType = CommandType.Text;
                //cmd.CommandText = "insert into sale_order values ('" + textBox8.Text + "','" + textBox11.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox10.Text + "')";
                cmd1.CommandText = "update vehicle set v_quantity = v_quantity - '" + textBox6.Text + "' where v_id = '" + textBox2.Text + "'";
                cmd1.ExecuteNonQuery();
                con.Close();



                MessageBox.Show("Added to cart !");
                diplay_data();
                this.Close();
                sale_order so = new sale_order();
                so.Show();
            }
        }
Exemplo n.º 2
0
        private void saleOrderToolStripMenuItem_Click(object sender, EventArgs e)
        {
            sale_order sm = new sale_order();

            sm.Show();
        }