private void button3_Click(object sender, EventArgs e) {// yonetici girisi baglanti.Open(); string sql = "SELECT \"KullaniciAdi\", \"Sifre\" , \"KullaniciTuru\" , \"KullaniciID\" FROM \"Kullanici\""; cmd = new OdbcCommand(sql, baglanti); OdbcDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { if (dr[0].ToString() == textBox1.Text && dr[1].ToString() == textBox2.Text && dr[2].ToString() == "Y") { kID = dr[3].ToString(); Yonetici yon = new Yonetici(); yon.Show(); Hide(); durum = true; break; } } if (durum == false) { MessageBox.Show("Hatalı Kullanıcı Adı/Şifre", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error); } baglanti.Close(); }
private void button2_Click(object sender, EventArgs e) { Yonetici yonetici = new Yonetici(); Hide(); yonetici.Show(); }
private void button1_Click(object sender, EventArgs e) { OdbcConnection baglanti = new OdbcConnection("DSN=PostgreSQL35W"); string sql = "INSERT INTO \"public\".\"Rapor\" ( \"Konu\", \"Metin\", \"YoneticiID\") VALUES ( '" + textBox2.Text + "', '" + textBox1.Text + "', '" + Giris.kID + "' );"; try { baglanti.Open(); OdbcCommand cmd = new OdbcCommand(sql, baglanti); cmd.ExecuteNonQuery(); baglanti.Close(); MessageBox.Show("Rapor Başarıyla Gönderildi", "Başarılı", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { baglanti.Close(); MessageBox.Show(ex.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error); throw; } Yonetici yonetici = new Yonetici(); yonetici.Show(); Hide(); }