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