private void KayitGeriB_Click(object sender, EventArgs e)
{
Close();
var x = new Giris();
x.Visible = true;
}
private void AdminGeriB_Click(object sender, EventArgs e)
{
Close();
var t = new Giris();
t.Visible = true;
}
private void KayitBT_Click(object sender, EventArgs e)
{
con.Open();
Int64 SelectedBolumId = (OgrBolumTB.SelectedItem as dynamic).Value;
Int64 SelectedOdaId = (OgrOdaNoTB.SelectedItem as dynamic).Value;
OracleCommand comkayit = con.CreateCommand();
comkayit.CommandText = ("INSERT INTO YOGRENCI (OGRAD, OGRSOYAD, OGRTC, OGRTELEFON, OGRDOGUM, OgrBolumId, OgrOdaId, OGRPASS, OGRVELIADSOYAD, OGRVELITELEFON, OgrVeliAdres)" +
" VALUES (:OGRAD, :OGRSOYAD, :OGRTC, :OGRTELEFON, :OgrBolumId, :OGRDOGUM, :OgrOdaId,:OGRPASS, :OGRVELIADSOYAD, :OGRVELITELEFON, :OgrVeliAdres) ");
comkayit.Parameters.Add(new OracleParameter("OGRAD", OgrAdTB.Text));
comkayit.Parameters.Add(new OracleParameter("OGRSOYAD", OgrSoyadTB.Text));
comkayit.Parameters.Add(new OracleParameter("OGRTC", OgrTCTB.Text));
comkayit.Parameters.Add(new OracleParameter("OGRTELEFON", OgrTelTB.Text));
comkayit.Parameters.Add(new OracleParameter("OGRDOGUM", OgrDogumTB.Text));
comkayit.Parameters.Add(new OracleParameter("OgrBolumId", SelectedBolumId));
comkayit.Parameters.Add(new OracleParameter("OgrOdaId", SelectedOdaId));
comkayit.Parameters.Add(new OracleParameter("OGRPASS", OgrPassTB.Text));
comkayit.Parameters.Add(new OracleParameter("OGRVELIADSOYAD", OgrVeliadTB.Text));
comkayit.Parameters.Add(new OracleParameter("OGRVELITELEFON", OgrVeliTelTB.Text));
comkayit.Parameters.Add(new OracleParameter("OgrVeliAdres", OgrAdresTB.Text));
try
{
comkayit.ExecuteNonQuery();
odaDoldur();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
MessageBox.Show("Kayit basarili!");
con.Close();
Close();
var b = new Giris();
b.Visible = true;
}