private void pictureBox4_Click(object sender, EventArgs e)
        {
            con.Open();
            OleDbCommand cmd = new OleDbCommand("insert into sipariş (tatlı,t_fiyat,toplamfiyat) values ('" + label5.Text.ToString() + "','" + Convert.ToDouble(label7.Text) + "','" + Convert.ToDouble(label7.Text) + "')", con);

            cmd.ExecuteNonQuery();
            con.Close();
            fiyat f1 = new fiyat();

            f1.Show();
            this.Hide();
        }
예제 #2
0
        private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
        {
            con.Open();
            OleDbCommand cmd = new OleDbCommand("insert into sipariş (icecek,toplamfiyat) values ('" + comboBox2.SelectedItem.ToString() + "','" + Convert.ToDouble(label11.Text) + "')", con);

            cmd.ExecuteNonQuery();
            con.Close();
            fiyat f1 = new fiyat();

            f1.Show();
            this.Hide();
        }
        private void pictureBox5_Click(object sender, EventArgs e)
        {
            idnumber();
            OleDbCommand cmd = new OleDbCommand("update sipariş set tatlı= '" + label13.Text.ToString() + "' where ID=@id", con);

            cmd.Parameters.AddWithValue("@id", (Convert.ToInt32(label12.Text)));
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            fiyat ileri = new fiyat();

            this.Hide();
            ileri.Show();
        }
예제 #4
0
        private void button1_Click(object sender, EventArgs e)
        {
            idnumber();
            toplamfiyat();
            OleDbCommand cmd = new OleDbCommand("update sipariş set tatlı= '" + "Hayır" + "',t_fiyat ='" + 0 + "',toplamfiyat = '" + (Convert.ToDouble(label20.Text) + 0) + "' where ID=@id", con);

            cmd.Parameters.AddWithValue("@id", (Convert.ToInt32(label12.Text)));
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            fiyat ileri = new fiyat();

            this.Hide();
            ileri.Show();
        }