private void button1_Click(object sender, EventArgs e) { connection.Open(); SqlCommand guncelle = new SqlCommand("update Kasa set kasa_alinan='" + textBox3.Text + "' , kasa_aciklama='" + textBox5.Text + "' , kasa_yetkili='" + textBox2.Text + "' , kasa_tarihi='" + dateTimePicker1.Text + "' where kasa_id='" + _ID + "'", connection); guncelle.ExecuteNonQuery(); connection.Close(); System.Windows.Forms.MessageBox.Show("Kayıt Güncellendi"); this.Close(); anasayfa a = System.Windows.Forms.Application.OpenForms["anasayfa"] as anasayfa; a.kasaListele(); }
private void btnEtkinlikKaydet_Click(object sender, EventArgs e) { if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "") { System.Windows.Forms.MessageBox.Show("LÜTFEN YILDIZLI ALANLARI DOLDURUNUZ"); } else { int kalanbutce = 0; connection.Open(); SqlCommand bul = new SqlCommand("select kalan_butce FROM Kasa WHERE kasa_id=(select TOP 1 kasa_id from Kasa ORDER BY kasa_id DESC )", connection); SqlDataReader drEd = bul.ExecuteReader(); if (drEd.Read()) { kalanbutce = Convert.ToInt32(drEd["kalan_butce"]); } drEd.Close(); SqlCommand cekle = new SqlCommand("insert into Kasa (kasa_turu,kasa_tutar,kasa_alinan,kasa_aciklama,kasa_yetkili,kasa_tarihi,kalan_butce) values (@prmtr2,@prmtr3,@prmtr4,@prmtr5,@prmtr6,@prmtr7,@prmtr8)", connection); kalanbutce -= Convert.ToInt32(textBox1.Text); cekle.Parameters.AddWithValue("@prmtr2", "HARCAMA"); cekle.Parameters.AddWithValue("@prmtr3", textBox1.Text); cekle.Parameters.AddWithValue("@prmtr4", textBox3.Text); cekle.Parameters.AddWithValue("@prmtr5", textBox5.Text); cekle.Parameters.AddWithValue("@prmtr6", textBox2.Text); cekle.Parameters.AddWithValue("@prmtr7", dateTimePicker1.Text); cekle.Parameters.AddWithValue("@prmtr8", kalanbutce); cekle.ExecuteNonQuery(); connection.Close(); System.Windows.Forms.MessageBox.Show("Kayıt Başarılı", "Bilgi"); this.Close(); anasayfa a = System.Windows.Forms.Application.OpenForms["anasayfa"] as anasayfa; a.kasaListele(); } }