public void PersonelGorevGetir(ComboBox cb)
{
cb.Items.Clear();
SqlConnection con = new SqlConnection(gnl.conString);
SqlCommand cmd = new SqlCommand("Select * from personelGorevleri", con);
SqlDataReader dr = null;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
dr = cmd.ExecuteReader();
int sayac = 0;
while (dr.Read())
{
cPersonelGorevler nesne = new cPersonelGorevler();
nesne._PersonelGorevID = Convert.ToInt32(dr["ID"].ToString());
nesne._Tanim = dr["GOREV"].ToString();
cb.Items.Add(nesne);
sayac++;
}
}
catch (SqlException ex)
{
string hata = ex.Message;
}
finally
{ dr.Close(); con.Dispose(); con.Close(); }
}
private void frmAyarlar_Load(object sender, EventArgs e)
{
cPersoneller p = new cPersoneller();
cPersonelGorevler g = new cPersonelGorevler();
string gorev = g.PersonelGorevTanim(cGenel.personelId);
if (gorev == "Müdür")
{
p.PersonelleriGetir(cmbPersonelAd);
g.PersonelGorevGetir(cmbGorev);
p.PersonelBilgileriGetirFormIdLv(lvPersoneller);
btnYeni.Enabled = true;
btnSil.Enabled = false;
btnDegis.Enabled = false;
btnEkle.Enabled = false;
groupBox1.Visible = true;
groupBox2.Visible = true;
groupBox3.Visible = false;
groupBox4.Visible = true;
txtSifre.ReadOnly = true;
txtSifreTekrar.ReadOnly = true;
bilgi.Text = p.PersonelBilgisiGetirİsim(cGenel.personelId);
}
else
{
groupBox1.Visible = false;
groupBox2.Visible = false;
groupBox3.Visible = true;
groupBox4.Visible = false;
bilgi.Text = p.PersonelBilgisiGetirİsim(cGenel.personelId);
}
}
private void cmbGorev_SelectedIndexChanged(object sender, EventArgs e)
{
cPersonelGorevler c = (cPersonelGorevler)cmbGorev.SelectedItem;
txtGörevId.Text = Convert.ToString(c.PersonelGorevID);
}
