public static List <EntityDers> DersListesi()
{
List <EntityDers> degerler = new List <EntityDers>();
SqlCommand komut2 = new SqlCommand("Select * From TBLDERSLER", Baglanti.bgl);
if (komut2.Connection.State != ConnectionState.Open)
{
komut2.Connection.Open();
}
SqlDataReader dr = komut2.ExecuteReader();
while (dr.Read())
{
EntityDers ent = new EntityDers();
ent.Id = Convert.ToInt32(dr["DERSID"].ToString());
ent.Dersad = dr["DERSAD"].ToString();
ent.Min = int.Parse(dr["DERSMINKONT"].ToString());
ent.Max = int.Parse(dr["DERSMAKSKONT"].ToString());
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
protected void Button1_Click1(object sender, EventArgs e)
{
EntityDers ent = new EntityDers();
ent.dersAd = txtDersAd.Text;
ent.dersUcret = Convert.ToInt32(txtDersUcret.Text);
BLL_Ders.dersEkleBLL(ent);
Response.Redirect("Ogrenciler.aspx");
}
public static int dersEkleBLL(EntityDers p)
{
if (p.dersAd != null && p.dersUcret > 0)
{
return(DAL_Ders.dersEkle(p));
}
else
{
return(-1);
}
}
public static int dersEkle(EntityDers ders)
{
Baglanti.bgl.Close();
SqlCommand komut1 = new SqlCommand("insert into tbl_Ders (dersAD,dersUcret) values (@p1,@p2)", Baglanti.bgl);
if (komut1.Connection.State != ConnectionState.Open)
{
komut1.Connection.Open();
}
komut1.Parameters.AddWithValue("@p1", ders.dersAd);
komut1.Parameters.AddWithValue("@p2", ders.dersUcret);
return(komut1.ExecuteNonQuery());
}
public static List <EntityDers> DersListesi()
{
Baglanti bgl = new Baglanti();
List <EntityDers> DersListesi = new List <EntityDers>();
SqlCommand komut1 = new SqlCommand("Select * from Tbl_Dersler", bgl.baglanti());
SqlDataReader oku1 = komut1.ExecuteReader();
while (oku1.Read())
{
EntityDers ent = new EntityDers();
ent.DersAd = oku1["DersAd"].ToString();
ent.Max = int.Parse(oku1["DersMaxKont"].ToString());
ent.Min = int.Parse(oku1["DersMinKont"].ToString());
ent.Id = int.Parse(oku1["DersId"].ToString());
DersListesi.Add(ent);
}
bgl.baglanti().Close();
return(DersListesi);
}
public static List <EntityDers> DersListesi()
{
List <EntityDers> degerler = new List <EntityDers>();
SqlCommand cmd = new SqlCommand("select *from TBLDERSLER", Baglanti.bgl);
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
EntityDers ent = new EntityDers();
ent.ID = Convert.ToInt32(dr["DERSID"].ToString());
ent.DERSAD = dr["DERSAD"].ToString();
ent.MIN = Convert.ToInt32(dr["DERSMINKONT"].ToString());
ent.MAX = Convert.ToInt32(dr["DERSMAKSKONT"].ToString());
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
public static List <EntityDers> DersListesi()
{
List <EntityDers> degerler = new List <EntityDers>();
SqlCommand komut2 = new SqlCommand("Select * from Tbl_Dersler", Baglanti.bgl);
if (komut2.Connection.State != ConnectionState.Open)
{
komut2.Connection.Open();
}
SqlDataReader dr = komut2.ExecuteReader();
while (dr.Read())
{
EntityDers ent = new EntityDers();
ent.DERSID = Convert.ToInt32(dr["Dersid"].ToString());
ent.DERSAD = dr["DersAd"].ToString();
ent.MIN = int.Parse(dr["DersMinKontenjan"].ToString());
ent.MAX = int.Parse(dr["DersMaxKontenjan"].ToString());
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
public static List <EntityDers> DersListesi()
{
List <EntityDers> degerler = new List <EntityDers>();
SqlCommand cmd = new SqlCommand("SELECT * FROM TBL_DERSLER", DBHelper.bgl);
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
EntityDers ders = new EntityDers();
ders.DersId = Convert.ToInt32(dr["DersID"].ToString());
ders.DersAd = dr["DersAd"].ToString();
ders.DersMinKontenjan = int.Parse(dr["DersMinKontenjan"].ToString());
ders.DersMaxKontenjan = int.Parse(dr["DersMaxKontenjan"].ToString());
degerler.Add(ders);
}
dr.Close();
return(degerler);
}
public static List <EntityDers> dersListele()
{
List <EntityDers> degerler = new List <EntityDers>();
SqlCommand komut = new SqlCommand("Select * from tbl_Ders", Baglanti.bgl);
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
EntityDers ent = new EntityDers();
ent.dersID = Convert.ToInt32(dr["dersID"].ToString());
ent.dersAd = dr["dersAD"].ToString();
ent.dersUcret = Convert.ToInt32(dr["dersUcret"].ToString());
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
