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