private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { cPersoneller p = (cPersoneller)cbKullanici.SelectedItem; cGenel._personelId = p.PersonelId; cGenel._gorevId = p.PersonelGorevId; }
public void personelGetbyInformation(ComboBox cbKullanici) { cbKullanici.Items.Clear(); NpgsqlConnection con = new NpgsqlConnection(gnl.connString); string query = "select * from \"personeller\""; NpgsqlCommand cmd = new NpgsqlCommand(query, con); if (con.State == ConnectionState.Closed) { con.Open(); } NpgsqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { cPersoneller p = new cPersoneller(); p._PersonelId = Convert.ToInt32(dr["ID"]); p._PersonelGorevId = Convert.ToInt32(dr["GOREVID"]); p._PersonelAd = Convert.ToString(dr["AD"]); p._PersonelSoyad = Convert.ToString(dr["SOYAD"]); p._PersonelParola = Convert.ToString(dr["PAROLA"]); p._PersonelKullaniciAdi = Convert.ToString(dr["KULLANICIADI"]); // p._PersonelDurum = Convert.ToBoolean(dr["DURUM"]); cbKullanici.Items.Add(p); } dr.Close(); con.Close(); }
private void button1_Click(object sender, EventArgs e) { cGenel gnl = new cGenel(); cPersoneller p = new cPersoneller(); bool result = p.personelEntryControl(txtSifre.Text, cGenel._personelId); if (result) { cPersonelHareketleri ch = new cPersonelHareketleri(); ch.PersonelId = cGenel._personelId; ch.Islem = "giriş yaptı"; ch.Tarih = DateTime.Now; ch.PersonelActionSave(ch); this.Hide(); frmMenu menu = new frmMenu(); menu.Show(); } else { MessageBox.Show("şifreniz yanlış", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Stop); } }
private void Form1_Load(object sender, EventArgs e) { cPersoneller p = new cPersoneller(); p.personelGetbyInformation(cbKullanici); }