public static List <EntityDersler> DersListesi()
{
List <EntityDersler> degerler = new List <EntityDersler>();
SqlCommand komut = new SqlCommand("Select * From Tbl_Dersler", Baglanti.bgl);
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
EntityDersler entityDersler = new EntityDersler
{
DersId = Convert.ToInt32(dr[0]),
DersAd = dr[1].ToString(),
DersMinKon = Convert.ToInt32(dr[2]),
DersMaxKon = Convert.ToInt32(dr[3])
};
degerler.Add(entityDersler);
}
dr.Close();
return(degerler);
}
//ders listeleme işlemi
public static List <EntityDersler> DersListesi()
{
List <EntityDersler> degerler = new List <EntityDersler>();
SqlCommand komut1 = new SqlCommand("select * from Tbldersler", Baglanti.bgl);
if (komut1.Connection.State != ConnectionState.Open)
{
komut1.Connection.Open();//eğer bağlantı kapalıysa bağlantıyı aç
}
SqlDataReader dr = komut1.ExecuteReader();
while (dr.Read())
{
EntityDersler ent = new EntityDersler();
ent.Dersadi = dr["dersadi"].ToString();
ent.Dersid = Convert.ToInt32(dr["dersid"].ToString());
ent.Dersmaxkontenjan = Convert.ToInt32(dr["dersmaxkontenjan"].ToString());
ent.Dersminkontenjan = Convert.ToInt32(dr["dersminkontenjan"].ToString());
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
