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();
while (dr.Read())
{
cPersonelGorev c = new cPersonelGorev();
c._personelGorevId = Convert.ToInt32(dr["ID"].ToString());
c._tanim = dr["GOREV"].ToString();
cb.Items.Add(c);
}
}
catch (SqlException ex)
{
string hata = ex.Message;
throw;
}
dr.Close();
con.Close();
}
private void frmAyarlar_Load(object sender, EventArgs e)
{
cPersoneller cp = new cPersoneller();
cPersonelGorev cpg = new cPersonelGorev();
string gorev = cpg.PersonelGorevTanim(cGenel._gorevId);
if (gorev == "Şef")
{
cpg.PersonelGorevGetir(cbGorevi);
cp.personelBilgileriniGetirLv(lvPersoneller);
btnSil.Enabled = false;
btnBilgiDegistir.Enabled = true;
lblBilgi.Text = "Mevki : ŞEF / Yetki Sınırsız / Kullanıcı :" + cp.personelBilgiGetirIsim(cGenel._personelId);
panel1.Visible = false;
}
else
{
lblBilgi.Text = "Yetki Sınırlı / Kullanıcı :" + cp.personelBilgiGetirIsim(cGenel._personelId);
panel2.Visible = false;
panel3.Visible = false;
}
}
private void cbGorevi_SelectedIndexChanged(object sender, EventArgs e)
{
cPersonelGorev c = (cPersonelGorev)cbGorevi.SelectedItem;
txtGorevId2.Text = Convert.ToString(c.PersonelGorevId);
}