public static List <Bolum> BolumDoldur(int yeni)
{
SqlConnection conn = DbConncection.GetSqlConnection();
var cmd = new SqlCommand();
cmd.CommandText = "SELECT BolumId,Bolum FROM Ahmet_Bolum WHERE Ahmet_Bolum.FakulteId=@FakulteId";
cmd.Parameters.AddWithValue("@FakulteId", yeni);
cmd.Connection = conn;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
List <Bolum> bolumler = new List <Bolum>();
while (reader.Read())
{
Bolum bolum = new Bolum();
{
bolum.BolumId = reader.GetInt32(0);
bolum.Bolumm = reader.GetString(1);
bolumler.Add(bolum);
}
}
conn.Close();
return(bolumler);
}
private void BolumDoldur()//2 tane
{
SqlConnection conn = DbConncection.GetSqlConnection();
Fakulte secilen = (Fakulte)cmbFakulte.SelectedItem;
var cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM Ahmet_Bolum WHERE FakulteId=@fakulteId ";
cmd.Parameters.AddWithValue("@fakulteId", secilen.FakulteId);
cmd.Connection = conn;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Bolum bolum = new Bolum();
{
bolum.BolumId = reader.GetInt32(0);
bolum.Bolumm = reader.GetString(1);
}
cmbBolum.Items.Add(bolum);
}
conn.Close();
}
private void cmbFakulte_SelectedIndexChanged(object sender, EventArgs e)
{
//BolumDoldur();
secilen = (Fakulte)cmbFakulte.SelectedItem;
List <Bolum> bolumler = Bolum.BolumDoldur(secilen.FakulteId);
cmbBolum.DisplayMember = "Bolum";
cmbBolum.ValueMember = "BolumId";
cmbBolum.DataSource = bolumler;
}
private void DersleriGetir()
{
int bolumid = Bolum.BolumIdBul();
int sinif = Bolum.SinifiBul();
SqlConnection conn = DbConncection.GetSqlConnection();
var cmd = new SqlCommand();
cmd.CommandText = "SELECT DerslerId,DersAdi FROM Ahmet_Dersler WHERE Ahmet_Dersler.BolumId=@BolumId and Ahmet_Dersler.Sinif=@Sinif ";
cmd.Parameters.AddWithValue("@BolumId", bolumid);
cmd.Parameters.AddWithValue("@Sinif", sinif);
cmd.Connection = conn;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Dersler dersler = new Dersler();
{
dersler.DerslerId = reader.GetInt32(0);
dersler.DersAdi = reader.GetString(1);
}
int a = 0;
foreach (Dersler item in lsbSecilenDersler.Items)
{
if (dersler.DerslerId == item.DerslerId)
{
a = 1;
}
}
if (a != 1)
{
lsbTumDersler.Items.Add(dersler);
}
}
conn.Close();
}
