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