private void gridTeslimAlma_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == gridTeslimAlma.Columns["btnTeslim"].Index) { if (baglanti.baglan.State == ConnectionState.Closed) { baglanti.baglan.Open(); } komut = new OracleCommand("UPDATE ODUNC SET DONUS_TARIHI=TO_DATE('" + DateTime.Now.ToShortDateString() + "','DD/MM/YYYY') WHERE ODUNCID =" + gridTeslimAlma.CurrentRow.Cells[2].Value.ToString() + " ", baglanti.baglan); komut.ExecuteNonQuery(); komut = new OracleCommand("UPDATE KITAP SET DURUMID=1 WHERE KITAPID=" + gridTeslimAlma.CurrentRow.Cells[15].Value.ToString() + "", baglanti.baglan); komut.ExecuteNonQuery(); MessageBox.Show("Teslim Alma Başarılı.", "BAŞARI", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); TeslimAlma teslimAlma = new TeslimAlma(); teslimAlma.Show(); } else if (e.ColumnIndex == gridTeslimAlma.Columns["btnSil"].Index) { komut = new OracleCommand("DELETE FROM ODUNC WHERE ODUNCID =" + gridTeslimAlma.CurrentRow.Cells[2].Value.ToString() + " ", baglanti.baglan); komut.ExecuteNonQuery(); MessageBox.Show("Silme İşlemi Başarılı", "BAŞARI", MessageBoxButtons.OK, MessageBoxIcon.Information); komut = new OracleCommand("SELECT * FROM ODUNC O INNER JOIN KULLANICI KU ON O.KULLANICIID = KU.KULLANICIID INNER JOIN KITAP K ON O.KITAPID = K.KITAPID WHERE O.DONUS_TARIHI IS NOT NULL", baglanti.baglan); da = new OracleDataAdapter(); dt = new DataTable(); da.SelectCommand = komut; da.Fill(dt); gridTeslimAlma.DataSource = dt; GridDuzenle(); gridTeslimAlma.Columns[1].Visible = true; } }
private void btnTeslimAlma_Click(object sender, EventArgs e) { TeslimAlma teslimAlma = new TeslimAlma(); teslimAlma.Show(); }